hospital
Tables (4)
Clients (Untitled)
- CLNUMBER (고객번호) — PRIMARY KEY — Primary key — NOT NULL
- CLNAME (고객이름) — NOT NULL
- CLPN (고객주민번호) — NOT NULL
- CLPHONE (고객전화번호) — NOT NULL
DOCTOR (Untitled2)
- DONUMBER (의사번호) — PRIMARY KEY — Primary key — NOT NULL
- PARTNUMBER (부서번호2) — FOREIGN KEY — Foreign key → PART.PARTNUMBER — NOT NULL
- DONAME (의사이름) — NOT NULL
- PASSWORD (비밀번호) — NOT NULL
- INFO_DOCTOR (의사정보) — NOT NULL
PART (Untitled4)
- PARTNUMBER (부서번호) — PRIMARY KEY — Primary key — NOT NULL
- PARTNAME (부서명) — NOT NULL
RESERVE (Untitled3)
- RENUMBER (예약번호) — PRIMARY KEY — Primary key — NOT NULL
- CLNUMBER (고객번호2) — FOREIGN KEY — Foreign key → Clients.CLNUMBER — NOT NULL
- DONUMBER (의사번호) — FOREIGN KEY — Foreign key → DOCTOR.DONUMBER — NOT NULL
- SYMPTOM (증상) — NOT NULL
- SCHEDULE (예약날짜) — NOT NULL