251001/202320621

Tables (5)

Untitled (employee)

  • Key (emp_id) — int — Primary key — NOT NULL
  • Key (dependent_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (emp_name) — vanchar
  • Field (hire_date) — date
  • Field (salary) — decimal(10.2)
  • Key — int — Foreign key → Untitled.Key — NOT NULL
  • Field (job_id) — int

Untitled (department)

  • Key — int — Primary key — NOT NULL
  • Field (dept_name) — varchar
  • Field (location) — varchar

Untitled (dependent)

  • Key (dependent_id) — int — Primary key — NOT NULL
  • Field (first_name) — varchar
  • Field (last_name) — varchar
  • Field (relationship) — varchar
  • Field (birth_date) — date
  • Field (phone_number) — varchar

Untitled (project)

  • Key (proj_id) — int — Primary key — NOT NULL
  • Field (dept_id) — int
  • Key — int — Foreign key → Untitled.Key — NOT NULL

project_member (Untitled)

  • proj_id (Key) — int — Primary key — NOT NULL
  • emp_id (Key2) — int — Primary key — NOT NULL
  • Key (proj_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (emp_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (dependent_id) — int — Foreign key → Untitled.Key — NOT NULL
  • assignment_date (Field) — date