database_emr

Tables (5)

CHART (환자 정보)

  • Chart_No (Key) — INT — Primary key — NOT NULL
  • Name — VARCHAR(30) — NOT NULL
  • Birthday (Field) — VARCHAR(8) — NOT NULL
  • Address (Field2) — VARCHAR(255)
  • Phone (Field3) — VARCHAR(13)
  • First_visit (Field4) — VARCHAR(8)
  • Last_visit (Field5) — VARCHAR(8)
  • Memo (Field6) — TEXT
  • Use_yn (Field7) — VARCHAR(2) — NOT NULL
  • User_Id (Key2) — VARCHAR(20) — Foreign key → Users.User_Id — NOT NULL

Diagnosis_log (CopyOfUntitled)

  • Diag_date (Key2) — DATE — Primary key — NOT NULL
  • Seq (Key3) — INT — Primary key — NOT NULL
  • Chart_No (Key) — INT — Foreign key → CHART.Chart_No — NOT NULL
  • Department (Key4) — VARCHAR(10) — NOT NULL
  • Memo (Field2) — TEXT
  • Doctor (Field) — VARCHAR(20) — NOT NULL
  • User_Id (Key5) — VARCHAR(20) — Foreign key → Users.User_Id — NOT NULL

Item_Code (Untitled3)

  • Order_Code (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Code_Name (Field) — VARCHAR(50) — NOT NULL
  • Start_Date (Field2) — VARCHAR(8) — NOT NULL
  • End_Date (Field3) — VARCHAR(8)

Order_log (Untitled)

  • Order_Seq (Key5) — INT — Primary key — NOT NULL
  • Diag_date (Key2) — DATE — Foreign key → Diagnosis_log.Diag_date — NOT NULL
  • Seq (Key3) — INT — Foreign key → Diagnosis_log.Seq — NOT NULL
  • Chart_No (Key) — INT — Foreign key → Diagnosis_log.Chart_No — NOT NULL
  • Order_Code (Key4) — VARCHAR(20) — Foreign key → Item_Code.Order_Code — NOT NULL
  • Order_Quantity (Field2) — INT — NOT NULL

Users (Untitled2)

  • User_Id (Key) — VARCHAR(20) — Primary key — NOT NULL
  • Password (Field6) — VARCHAR(50) — NOT NULL
  • Name (Field) — VARCHAR(50) — NOT NULL
  • Department (Field2) — VARCHAR(20) — NOT NULL
  • Doctor_Number (Field5) — VARCHAR(10)
  • Start_Date (Field3) — VARCHAR(8) — NOT NULL
  • End_Date (Field4) — VARCHAR(8)