Hospital
Tables (5)
Charts
- C.ID — Vachar(20) — Primary key — NOT NULL
- T.ID — INT — Foreign key → Treatments.T.ID — NOT NULL
- P.ID — INT — Foreign key → Treatments.P.ID — NOT NULL
- D.ID — INT — Foreign key → Treatments.D.ID — NOT NULL
- C.contents — Vachar(1000)
- N.ID — INT — Foreign key → Nurses.N.ID — NOT NULL
Doctors
- D.ID — INT — Primary key — NOT NULL
- major_treat — Vachar(25)
- D.name — Vachar(20)
- D.gen — Char(1)
- D.phone — Vachar(15)
- D.email — Varchar(50)
- D.position (D.postion) — Varchar(20)
Nurses
- N.ID — INT — Primary key — NOT NULL
- N.job — Vachar(25)
- N.name — Vachar(20)
- N.gen — Char(1)
- N.phone — Vachar(15)
- N.email — Vachar(50)
- N.position — Vachar(20)
- Field
Patients
- P.ID — INT — Primary key — NOT NULL
- P.name — Vachar(20)
- P.gen — Char(1)
- P.jumin — Vachar(14)
- P.addr — Vachar(100)
- P.phone — Vachar(15)
- P.email — Vachar(50) — NOT NULL
- P..job — Vachar(20)
- D.ID — INT — Foreign key → Doctors.D.ID — NOT NULL
- N.ID — INT — Foreign key → Nurses.N.ID — NOT NULL
Treatments
- T.ID — INT — Primary key — NOT NULL
- P.ID — INT — Foreign key → Patients.P.ID — NOT NULL
- D.ID — INT — Foreign key → Doctors.D.ID — NOT NULL
- T.contents — Vachar(1000)
- T.date — DATE