project 1

Tables (5)

medical_dept

  • DEPT_NUM — int(11) — Primary key — NOT NULL
  • DEPT_NAME — varchar(30) — NOT NULL

medical_doctor

  • DOC_NUM — varchar(20) — Primary key — NOT NULL
  • DEPT_NUM — int(11) — Foreign key → medical_dept.DEPT_NUM — NOT NULL
  • DOC_NAME — varchar(20) — NOT NULL

medical_member

  • MEM_NUM — varchar(20) — Primary key — NOT NULL
  • MEM_NAME — varchar(20) — NOT NULL
  • MEM_TEL — varchar(50) — NOT NULL
  • MEM_RRN — varchar(20) — NOT NULL
  • MEM_ROLE — varchar(30)

medical_schedule

  • SCH_NUM — int(11) — Primary key — NOT NULL
  • DOC_NUM — varchar(20) — Foreign key → medical_doctor.DOC_NUM — NOT NULL
  • DEPT_NUM — int(11) — Foreign key → medical_doctor.DEPT_NUM — NOT NULL
  • MEM_NUM (MEM_NUM2) — varchar(20) — Foreign key → medical_member.MEM_NUM — NOT NULL
  • REG_DATE — datetime
  • SCH_DATE — date — NOT NULL
  • SCH_TIME — time — NOT NULL
  • DETAIL — varchar(100)
  • SCH_STATUS — varchar(10)

temp_data

  • TEMP_NUM — int(11) — Primary key — NOT NULL
  • CURRENT_TEMP — double
  • TEMP_TIME — datetime