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)