ee

Tables (3)

department

  • department_code — VARCHAR(50) — Primary key — NOT NULL
  • department_team — VARCHAR(50) — NOT NULL

employee

  • employee_id — INT — Primary key — NOT NULL
  • employee_name — VARCHAR(20) — NOT NULL

record

  • record_id — INT — Foreign key → employee.employee_id — NOT NULL
  • record_code — VARCHAR(50) — Foreign key → department.department_code — NOT NULL
  • record_name — VARCHAR(20)
  • record_team — VARCHAR(50)