Hospital
Tables (6)
Chart (Untitled4)
- C_id (PK) — int — Primary key — NOT NULL
- turn (PK2) — int — Foreign key → Medical-treatment.turn — NOT NULL
- date (Key2) — date — Foreign key → Medical-treatment.date — NOT NULL
- d_say (Field) — varchar(100) — NOT NULL
Doctor (Untitled)
- D_id (PK) — int — Primary key — NOT NULL
- Department (Field) — varchar(20) — NOT NULL
- D_name (Field2) — varchar(10) — NOT NULL
- gender (Field3) — int
- phone (Field6) — varchar(20)
- e_mail (Field4) — varchar(40)
- ranks (Field5) — varchar(10)
Medical-treatment (Untitled5)
- turn (PK) — int — Primary key — NOT NULL
- date (Key2) — date — Primary key — NOT NULL
- treat (Field) — varchar(40) — NOT NULL
- R_id (PK2) — int — Foreign key → receipt.R_id — NOT NULL
- treat_status (Field2) — char(1)
Nurse (Untitled3)
- N_id (PK) — int — Primary key — NOT NULL
- N_job (Field) — varchar(10)
- N_name (Field2) — varchar(10) — NOT NULL
- gender (Field3) — int
- phone (Field4) — varchar(20) — NOT NULL
- e_mail (Field5) — varchar(40)
- ranks (Field6) — varchar(10)
Patient (Untitled2)
- P_id (PK) — int — Primary key — NOT NULL
- P_name (Field) — varchar(10) — NOT NULL
- ID_CARD (Field2) — varchar(12) — NOT NULL
- gender (Field3) — int — NOT NULL
- address (Field4) — varchar(40) — NOT NULL
- e_mail (Field5) — varchar(40)
- job (Field6) — varchar(20)
- D_id (PK2) — int — Foreign key → Doctor.D_id — NOT NULL
- N_id (PK3) — int — Foreign key → Nurse.N_id — NOT NULL
receipt (Untitled6)
- R_id (PK) — int — Primary key — NOT NULL
- status (Field) — char(1) — NOT NULL
- P_id (PK2) — int — Foreign key → Patient.P_id — NOT NULL