likelion
Tables (4)
Doctor (의사)
- id (의사 id) — int — Primary key — NOT NULL
- password (비밀번호) — varchar(150)
- hospital_id (병원 id) — int — Foreign key → Hospital.id — NOT NULL
Hospital (병원)
- id (병원 id) — int — Primary key — NOT NULL
- name (병원 이름) — varchar(5)
- address (주소) — varchar(50)
Medical Treatment (진료)
- id (진료 id) — int — Primary key — NOT NULL
- date (진료일) — date
- treatment_list (재활 치료 목록) — varchar(100)
- doctor_id (의사 id) — int — Foreign key → Doctor.id — NOT NULL
- patient_id (환자 id) — int — Foreign key → Patient.id — NOT NULL
Patient (환자)
- id (환자 id) — int — Primary key — NOT NULL
- name (이름) — varchar(5)
- gender (성별) — char(1)
- birth (생년월일) — date
- height (신장) — int
- weight (몸무게) — int
- hospital_id (병원 id) — int — Foreign key → Hospital.id — NOT NULL