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)