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