rerort2
Tables (5)
charts (Untitled3)
- chart_id (Key) — varchar2(20) — Primary key — NOT NULL
- treat_id (Key5) — number(15) — Foreign key → treatments.treat_id — NOT NULL
- doc_id (Key42) — number(10) — Foreign key → treatments.doc_id — NOT NULL
- pat_id (Key52) — number(10) — Foreign key → treatments.pat_id — NOT NULL
- nur_id (Key2) — number(10) — Foreign key → nurses.nur_id — NOT NULL
- chart_contents (Field2) — varchar2(1000)
doc_id (Untitled)
- doc_id (Key) — number(10) — Primary key — NOT NULL
- major_treat (Field) — varchar2(25)
- doc_name (Field2) — varchar2(20)
- doc_gen (Field3) — char(1)
- doc_phone (Field4) — vachar(15) — NOT NULL
- doc_email (Field5) — varchar2(50)
- doc_position (Field6) — varchar2(20)
nurses (Untitled4)
- nur_id (Key) — number(10) — Primary key — NOT NULL
- major_job (Field) — varchar2(25)
- nur_name (Field2) — varchar2(20)
- nur_gen (Field3) — char(1)
- nur_phone (Field4) — varchar2(15) — NOT NULL
- nur_email (Field5) — varchar2(50) — NOT NULL
- nur_position (Field6) — varchar2(20)
patients (Untitled5)
- pat_id (Key) — number(10) — Primary key — NOT NULL
- doc_id (Key2) — number(10) — Foreign key → doc_id.doc_id — NOT NULL
- nur_id (Key3) — number(10) — Foreign key → nurses.nur_id — NOT NULL
- pat_name (Field3) — varchar2(20)
- pat_gen (Field4) — char(1)
- pat_jumin (Field5) — varchar2(14)
- pat_addr (Field6) — varchar2(100)
- pat_phone (Field7) — varchar2(15) — NOT NULL
- pat_email (Field8) — varchar2(50) — NOT NULL
- pat_job (Field9) — varchar2(20)
treatments (Untitled2)
- treat_id (Key) — namber(15) — Primary key — NOT NULL
- doc_id (Key4) — number(10) — Foreign key → doc_id.doc_id — NOT NULL
- pat_id (Key5) — number(10) — Foreign key → patients.pat_id — NOT NULL
- treat_contents (Field) — varchar2(1000)
- treat_date (Field2) — date