base de datos
CREATE DATABASE pet_adoption_center;
base de datos creada
\c pet_adoption_center;
Tabla para almacenar la información de los animales
CREATE TABLE Animals (
animal_id SERIAL PRIMARY KEY,
species VARCHAR(50) NOT NULL,
breed VARCHAR(50),
age INT,
gender CHAR(1) CHECK (gender IN ('M', 'F')),
medical_history TEXT,
photo_url TEXT,
special_needs TEXT
);
Tabla para almacenar la información de las familias
CREATE TABLE Families (
family_id SERIAL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
address TEXT,
phone VARCHAR(15),
email VARCHAR(100),
family_composition TEXT,
lifestyle TEXT
);
Tabla para registrar el proceso de adopción
CREATE TABLE Adoptions (
adoption_id SERIAL PRIMARY KEY,
request_date DATE NOT NULL,
adoption_date DATE,
animal_id INT REFERENCES Animals(animal_id),
family_id INT REFERENCES Families(family_id),
status VARCHAR(20) CHECK (status IN ('Requested', 'Approved', 'Rejected', 'Completed'))
);
Tabla para registrar la salud y cuidados de los animales
CREATE TABLE HealthRecords (
record_id SERIAL PRIMARY KEY,
animal_id INT REFERENCES Animals(animal_id),
record_date DATE NOT NULL,
description TEXT,
vaccination_status TEXT,
next_checkup DATE
);
AGREGAR UN ANIMAL NUEVO
INSERT INTO Animals (species, breed, age, gender, medical_history, photo_url, special_needs)
VALUES ('Dog', 'Labrador', 3, 'M', 'Healthy', 'http://example.com/photo.jpg', 'None');
REGISTRAR UNA NUEVA FAMILIA
INSERT INTO Families (name, address, phone, email, family_composition, lifestyle)
VALUES ('John Doe', '123 Elm St', '555-1234', 'john@example.com', '2 adults, 1 child', 'Active lifestyle');
REGISTRAR UNA ADOPCION
INSERT INTO Adoptions (request_date, adoption_date, animal_id, family_id, status)
VALUES ('2024-09-15', '2024-09-20', 1, 1, 'Completed');
HISTORIAL DE SALUD DEL ANIMAL
INSERT INTO HealthRecords (animal_id, record_date, description, vaccination_status, next_checkup)
VALUES (1, '2024-09-15', 'Routine checkup. All vaccinations up to date.', 'Up to date', '2025-03-15');
base de datos CREATE DATABASE pet_adoption_center;
base de datos creada \c pet_adoption_center;
Tabla para almacenar la información de los animales CREATE TABLE Animals ( animal_id SERIAL PRIMARY KEY, species VARCHAR(50) NOT NULL, breed VARCHAR(50), age INT, gender CHAR(1) CHECK (gender IN ('M', 'F')), medical_history TEXT, photo_url TEXT, special_needs TEXT );
Tabla para almacenar la información de las familias CREATE TABLE Families ( family_id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL, address TEXT, phone VARCHAR(15), email VARCHAR(100), family_composition TEXT, lifestyle TEXT );
Tabla para registrar el proceso de adopción CREATE TABLE Adoptions ( adoption_id SERIAL PRIMARY KEY, request_date DATE NOT NULL, adoption_date DATE, animal_id INT REFERENCES Animals(animal_id), family_id INT REFERENCES Families(family_id), status VARCHAR(20) CHECK (status IN ('Requested', 'Approved', 'Rejected', 'Completed')) );
Tabla para registrar la salud y cuidados de los animales CREATE TABLE HealthRecords ( record_id SERIAL PRIMARY KEY, animal_id INT REFERENCES Animals(animal_id), record_date DATE NOT NULL, description TEXT, vaccination_status TEXT, next_checkup DATE );
AGREGAR UN ANIMAL NUEVO INSERT INTO Animals (species, breed, age, gender, medical_history, photo_url, special_needs) VALUES ('Dog', 'Labrador', 3, 'M', 'Healthy', 'http://example.com/photo.jpg', 'None');
REGISTRAR UNA NUEVA FAMILIA INSERT INTO Families (name, address, phone, email, family_composition, lifestyle) VALUES ('John Doe', '123 Elm St', '555-1234', 'john@example.com', '2 adults, 1 child', 'Active lifestyle');
REGISTRAR UNA ADOPCION INSERT INTO Adoptions (request_date, adoption_date, animal_id, family_id, status) VALUES ('2024-09-15', '2024-09-20', 1, 1, 'Completed');
HISTORIAL DE SALUD DEL ANIMAL INSERT INTO HealthRecords (animal_id, record_date, description, vaccination_status, next_checkup) VALUES (1, '2024-09-15', 'Routine checkup. All vaccinations up to date.', 'Up to date', '2025-03-15');