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