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