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