hospital

Tables (5)

chart (Untitled5)

  • c_id (Key) — bigint — Primary key — NOT NULL
  • n_id (Key3) — bigint — Foreign key → nurse.n_id — NOT NULL
  • turn (Key4) — bigint — Foreign key → treat.t_id — NOT NULL
  • date (Key5) — date — Foreign key → treat.date — NOT NULL
  • d_id (Key2) — bigint — Foreign key → doctor.d_id — NOT NULL
  • p_id (Key6) — bigint — Foreign key → patient.p_id — NOT NULL
  • memo (Field) — varchar(100)

doctor (Untitled)

  • d_id (Key) — bigint — Primary key — NOT NULL
  • subject (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • gender (Field3) — varchar(20)
  • phone (Field4) — varchar(20)
  • e-mail (Field5) — varchar(20)
  • rank (Field6) — varchar(20)

nurse (Untitled3)

  • n_id (Key) — bigint — Primary key — NOT NULL
  • gender (Field) — varchar(20)
  • phone (Field2) — varchar(20)
  • name (Field3) — varchar(20)
  • e-mail (Field4) — varchar(20)
  • rank (Field5) — varchar(20)
  • work (Field6) — varchar(20)

patient (Untitled2)

  • p_id (Key) — bigint — Primary key — NOT NULL
  • n_id (Key3) — bigint — Foreign key → nurse.n_id — NOT NULL
  • d_id (Key2) — bigint — Foreign key → doctor.d_id — NOT NULL
  • name (Field) — varchar(20)
  • se_num (Field2) — varchar(20)
  • gender (Field3) — varchar(20)
  • adress (Field4) — varchar(40)
  • phone (Field5) — varchar(20)
  • e-mail (Field6) — varchar(20)
  • job (Field7) — varchar(20)

treat (Untitled4)

  • date (Key) — date — Primary key — NOT NULL
  • t_id (Key2) — integer — Primary key — NOT NULL
  • note (Field) — varchar(100)
  • d_id (Key3) — bigint — Foreign key → doctor.d_id — NOT NULL
  • p_id (Key4) — bigint — Foreign key → patient.p_id — NOT NULL