day8

Tables (6)

Day8_departments (Untitled)

  • dept_no (PK) — char(4) — Primary key — NOT NULL
  • dept_name (UNQ) — varchar(40) — Primary key — NOT NULL

Day8_dept_emp (Untitled2)

  • emp_no (PK) — int — Primary key — NOT NULL
  • dept_no (Key2) — char(4) — Primary key — NOT NULL
  • dept_no (PK2) — char(4) — Foreign key → Day8_departments.dept_no — NOT NULL
  • dept_name (UNQ) — varchar(40) — Foreign key → Day8_departments.dept_name — NOT NULL
  • from_date (Field) — date
  • to_date (Field2) — date

Day8_dept_manager (Untitled3)

  • detp_no (Key) — char(4) — Primary key — NOT NULL
  • emp_no (Key2) — int — Primary key — NOT NULL
  • from_date (Field) — date
  • to_date (Field2) — date

Day8_employees (Untitled4)

  • emp_no (Key) — int — Primary key — NOT NULL
  • birth_date (Field) — date
  • fisrt_name (Field2) — varchar(14)
  • last_name (Field3) — varchar(14)
  • gender (Field4) — enum('M','F')
  • hire_date (Field5) — date

Day8_salaries (Untitled5)

  • emp_no (Key) — int — Primary key — NOT NULL
  • from_date (Key2) — date — Primary key — NOT NULL
  • Field3 — Primary key
  • salary (Field) — int
  • to_date (Field2) — date

titles (Untitled6)

  • emp_no (Key) — int — Primary key — NOT NULL
  • title (Key2) — varchar(50) — Primary key — NOT NULL
  • from_date (Key3) — date — Primary key — NOT NULL
  • Field2 — Primary key
  • to_date (Field) — date