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