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