DB_MIDTERM
Tables (4)
CASE (table_case)
- NUMBER (case_number) — INT(20) — Primary key — NOT NULL
- DRID (doctor_number) — INT(20) — Foreign key → DOCTOR.DRID — NOT NULL
- PATIENT NAME (patient_name) — VARCHAR(30)
- DIAGNOSIS (diagnosis_information) — VARCHAR(255)
DOCTOR (table_doctor)
- DRID (doctor_number) — INT(20) — Primary key — NOT NULL
- NAME (doctor_name) — VARCHAR(30)
- ADDRESS (doctor_address) — VARCHAR(255)
EMPLOYEE (table_employee)
- SOCIAL SECURITY NUMBER (employee_number) — INT(20) — Primary key — NOT NULL
- LAST NAME (last_name) — VARCHAR(30)
- FRISTNAME (first_name) — VARCHAR(30)
- CLASSIFICATION (classification) — VARCHAR(20)
WORK (table_work)
- SOCIALSECURITYNUMBER (employee_number) — INT(20) — Foreign key → EMPLOYEE.SOCIAL SECURITY NUMBER — NOT NULL
- NUMBER (case_number) — INT(20) — Foreign key → CASE.NUMBER — NOT NULL