Assignment 2 Part 1

Tables (5)

CHARTS

  • CHART ID (CHART_ID) — INT(11) — Primary key — NOT NULL
  • NURSE ID (NUR_ID2) — VARCHAR(20) — Foreign key → NURSES.NURSE ID
  • TREATMENT ID (TREAT_ID2) — VARCHAR(20) — Foreign key → TREATMENTS.TREATMENT ID
  • DOCTOR ID (DOC_ID2) — VARCHAR(20) — Foreign key → TREATMENTS.DOCTOR ID
  • NURSE ID (NUR_ID3) — VARCHAR(20) — Foreign key → TREATMENTS.NURSE ID
  • TREATMENT ID (TREAT_ID) — VARCHAR(20)
  • DOCTOR ID (DOC_ID) — VARCHAR(20)
  • PATIENT ID (PAT_ID) — VARCHAR(20)
  • NURSE ID (NUR_ID) — VARCHAR(20)
  • CHART CONTENT (CHART_CONTENT) — TEXT

DOCTORS

  • DOCTOR ID (DOC_ID) — VARCHAR(20) — Primary key
  • MAJOR TREATMENT (MAJOR_TREAT) — TEXT
  • DOCTOR NAME (DOC_NAME) — VARCHAR(255)
  • DOCTOR GENDER (DOC_GEN) — CHAR(1)
  • DOCTOR PHONE (DOC_PHONE) — VARCHAR(255)
  • DOCTOR EMAIL (DOC_EMAIL) — VARCHAR(255) — NOT NULL
  • DOCTOR POSITION (DOC_POSITION) — VARCHAR(255)

NURSES

  • NURSE ID (NUR_ID) — VARCHAR(20) — Primary key
  • MAJOR TREATMENT (MAJOR_TREAT) — TEXT
  • NURSE NAME (NUR_NAME) — VARCHAR(255)
  • NURSE GENDER (NUR_GEN) — VARCHAR(20)
  • NURSE PHONE (NUR_PHONE) — VARCHAR(255)
  • NURSE EMAIL (NUR_EMAIL) — VARCHAR(255) — NOT NULL
  • NURSE POSITION (NUR_POSITION) — VARCHAR(255)

PATIENTS

  • PATIENT ID (PAT_ID) — VARCHAR(20) — Primary key
  • NURSE ID (NUR_ID2) — VARCHAR(20) — Foreign key → NURSES.NURSE ID
  • DOCTOR ID (DOC_ID2) — VARCHAR(20) — Foreign key → DOCTORS.DOCTOR ID
  • NURSE ID (NUR_ID) — VARCHAR(20)
  • DOCTOR ID (DOC_ID) — VARCHAR(20)
  • PATIENT NAME (PAT_NAME) — VARCHAR(255)
  • PATIENT GENDER (PAT_GEN) — CHAR(1)
  • PATIENT ADDRESS (PAT_ADDR) — VARCHAR(255) — NOT NULL
  • PATIENT PHONE (PAT_PHONE) — VARCHAR(255)
  • PATIENT EMAIL (PAT_EMAIL) — VARCHAR(255)
  • PATIENT JOB (PAT_JOB) — VARCHAR(255)

TREATMENTS

  • TREATMENT ID (TREAT_ID) — VARCHAR(20) — Primary key
  • DOCTOR ID (DOC_ID2) — VARCHAR(20) — Foreign key → DOCTORS.DOCTOR ID
  • NURSE ID (NUR_ID) — VARCHAR(20) — Foreign key → NURSES.NURSE ID
  • PATIENT ID (PAT_ID) — VARCHAR(20)
  • DOCTOR ID (DOC_ID) — VARCHAR(20)
  • TREATMENT CONTENTS (TREAT_CONTENTS) — TEXT
  • TREATMENT DATE (TREAT_DATE) — DATE