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