company

Tables (7)

DEPARTMENT (Untitled)

  • dept_nb (Key) — CHAR(8) — Primary key — NOT NULL
  • dept_name (Field) — CHAR(32)

DEPENDENT (Untitled4)

  • dep_nb (Key) — CHAR(8) — Primary key — NOT NULL
  • Field

DEPT-LOC (Untitled7)

  • dept_nb (Key) — CHAR(8) — Primary key — NOT NULL
  • loc_nb (Field) — INT(2)
  • startdate (Field2) — DATE

EMPLOYEE (Untitled3)

  • emp_id (Key) — CAHR(30) — Primary key — NOT NULL
  • dept_id (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dept_nb — NOT NULL
  • minit (Field2) — CHAR(30)
  • lname (Field3) — CHAR(30)
  • bdate (Field4) — date
  • address (Field5) — VARCHAR
  • sex (Field6) — CHAR(30)
  • salary (Field7) — INT(30)
  • superssn (Field8) — CHAR(30)

LOCATION (Untitled2)

  • loc_nb (Key) — INT2 — Primary key — NOT NULL
  • address (Field) — VARCHAR
  • name (Field2) — CHAR(30)

PROJECT (Untitled5)

  • pro_id (Key) — CHAR(30) — Primary key — NOT NULL
  • name (Field) — CHAR(30)
  • plocation (Field2) — CHAR(30)

WORKSON (Untitled6)

  • work_id (Key) — CHAR(30) — Primary key — NOT NULL
  • emp_id (Field) — CHAR(30)
  • pro_id (Field2) — CHAR(30)
  • hour (Field3) — INT(3)