(수정)유기동물 입양 매칭 시스템 DB Design
테이블 (9)
Adoption_Applications
- application_id — VARCHAR(50)
- user_id — VARCHAR(50) — 외래 키 → Users.user_id
- animal_id — VARCHAR(50) — 외래 키 → Animals.animal_id
- shelter_id — VARCHAR(50) — 외래 키 → Shelters.shelter_id
- status — VARCHAR(20)
- apply_date — DATE
Adoption_History
- history_id — VARCHAR(50)
- animal_id — VARCHAR(50) — 외래 키 → Animals.animal_id
- user_id — VARCHAR(50) — 외래 키 → Users.user_id
- adoption_date — DATE
Animals
- animal_id — VARCHAR(50)
- shelter_id — VARCHAR(50) — 외래 키 → Shelters.shelter_id
- name — VARCHAR(50) — NOT NULL
- species — VARCHAR(50)
- gender — VARCHAR(10)
- age — NUMBER
- photo_path — VARCHAR(255)
Interested_Animals
- user_id — VARCHAR(50) — 외래 키 → Users.user_id
- animal_id — VARCHAR(50) — 외래 키 → Animals.animal_id
Managers
- manager_id — VARCHAR(50)
- name — VARCHAR(50)
- shelter_id — VARCHAR(50) — 외래 키 → Shelters.shelter_id
QnA_Board
- post_id — VARCHAR(50)
- user_id — VARCHAR(50) — 외래 키 → Users.user_id
- title — VARCHAR(200) — NOT NULL
- content — CLOB
- reg_date — DATE
Shelters
- shelter_id — VARCHAR(50)
- shelter_name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(255)
- owner_id — VARCHAR(50)
Users
- user_id — VARCHAR(50)
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100)
- role — VARCHAR(20)
- join_date — DATE
Vaccination_Records
- vaccine_record_id — VARCHAR(50)
- animal_id — VARCHAR(50) — 외래 키 → Animals.animal_id
- vaccine_name — VARCHAR(100)
- vaccination_date — DATE
- next_due_date — DATE