PetFinder
Tables (4)
OWNER
- owner_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- address — VARCHAR(200)
- created_at — DATE
PET
- pet_id — INT — Primary key — NOT NULL
- owner_id — INT — Foreign key → OWNER.owner_id — NOT NULL
- shelter_id — INT — Foreign key → SHELTER.shelter_id
- name — VARCHAR(50) — NOT NULL
- species — VARCHAR(30)
- breed — VARCHAR(50)
- age — INT
- color — VARCHAR(50)
- features — VARCHAR(300)
- missing_date — DATE
- missing_area — VARCHAR(100)
- status — VARCHAR(20)
SHELTER
- shelter_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(200)
- shelter_type — VARCHAR(20)
SIGHTING
- sighting_id — INT — Primary key — NOT NULL
- pet_id — INT — Foreign key → PET.pet_id — NOT NULL
- reporter_name — VARCHAR(50) — NOT NULL
- reporter_phone — VARCHAR(20)
- location — VARCHAR(200)
- sighting_date — DATE
- description — VARCHAR(1000)
- sighting_type — VARCHAR(20)
- status — VARCHAR(20)