123

Tables (6)

adopter

  • adopid — INT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • age — INT
  • contnum — VARCHAR(50)
  • email — VARCHAR(50)
  • address — VARCHAR(100)
  • applidate — DATE
  • marital — VARCHAR(50)
  • numchild — INT
  • numdog — INT
  • pastdog — INT
  • homestruc — VARCHAR(50)
  • progid — INT — Foreign key → training_program.progid
  • sheltid — INT — Foreign key → shelter.sheltid — NOT NULL

adoption_application

  • applyid — INT — Primary key — NOT NULL
  • adopid — INT — Foreign key → adopter.adopid — NOT NULL
  • dogid — INT — Foreign key → dog.dogid — NOT NULL
  • sheltid — INT — Foreign key → shelter.sheltid — NOT NULL
  • applidate — DATE
  • status — VARCHAR(50)

adoption_records

  • adopreid — INT — Primary key — NOT NULL
  • adopid — INT — Foreign key → adopter.adopid — NOT NULL
  • dogid — INT — Foreign key → dog.dogid — NOT NULL
  • sheltid — INT — Foreign key → shelter.sheltid — NOT NULL
  • date — DATE
  • status — VARCHAR(50)

dog

  • dogid — INT — Primary key — NOT NULL
  • sheltid — INT — Foreign key → shelter.sheltid — NOT NULL
  • name — VARCHAR(50)
  • breed — VARCHAR(50)
  • age — INT
  • gender — VARCHAR(50)
  • color — VARCHAR(50)
  • health — VARCHAR(100)
  • temper — VARCHAR(100)
  • available — BOOLEAN
  • rehome — BOOLEAN
  • vaccin — BOOLEAN
  • neuter — BOOLEAN

shelter

  • sheltid — INT — Primary key — NOT NULL
  • shelname — VARCHAR(50)
  • location — VARCHAR(100)
  • continfo — VARCHAR(50)
  • manager — VARCHAR(50)

training_program

  • progid — INT — Primary key — NOT NULL
  • sheltid — INT — Foreign key → shelter.sheltid — NOT NULL
  • name — VARCHAR(20)
  • descrip — VARCHAR(100)
  • duration — VARCHAR(20)
  • cost — DECIMAL(10, 2)