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)