medy

Tables (5)

Hospital (병원)

  • id (hospital_id) — Long — Primary key — NOT NULL
  • name (hospital_name) — varchar
  • city — varchar
  • street — varchar
  • zipcode — varchar
  • phone — varchar
  • doctor — varchar

Medicine (약)

  • id (medicine_id) — bigint(20) — Primary key — NOT NULL
  • id (medicinebag_id) — bigint(20) — Foreign key → MedicineBag.id — NOT NULL
  • name (medicine_name) — varchar

MedicineBag (약봉투)

  • id (medicinebag_id) — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → Member.id — NOT NULL
  • name (medicinebag_name) — varchar
  • startDate — Date
  • endDate — Date

Member (회원)

  • id (member_id) — Long — Primary key — NOT NULL
  • username — varchar
  • email — varchar
  • password — varchar
  • gender — varchar
  • age — int

Member_Hospital (멤버_병원)

  • id (member_hospital_id) — Long — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL
  • id (hospital_id) — Long — Foreign key → Hospital.id — NOT NULL