(수정)유기동물 입양 매칭 시스템 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