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