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