병원 ERD

테이블 (5)

chart (Untitled5)

  • c_id (Key) — bigint — 기본 키 — NOT NULL
  • treatment_id (FK) — varchar(10) — 외래 키 → treatment.treatment_id — NOT NULL
  • n_id (FK2) — bigint — 외래 키 → nurse.n_id — NOT NULL
  • d_id (FK3) — bigint — 외래 키 → doctor.d_id — NOT NULL
  • p_id (FK4) — bigint — 외래 키 → patient.p_id — NOT NULL
  • memo (Field) — varchar(100)

doctor (Untitled)

  • d_id (Key) — bigint — 기본 키 — 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 — 기본 키 — 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 — 기본 키 — NOT NULL
  • d_id (FK) — bigint — 외래 키 → doctor.d_id — NOT NULL
  • n_id (FK2) — bigint — 외래 키 → nurse.n_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)

treatment (Untitled4)

  • treatment_id (PK) — varchar(10) — 기본 키 — NOT NULL
  • d_id (FK) — bigint — 외래 키 → doctor.d_id — NOT NULL
  • p_id (FK2) — bigint — 외래 키 → patient.p_id — NOT NULL
  • content (Field) — varchar(100)
  • date (Field2) — date