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