company
Tables (7)
DEPARTMENT (部门)
- dept_no (部门编号) — Primary key — NOT NULL
- name (名称)
- locations (位置)
- manager (经理)
- manager_start_date (经理开始时间)
- empl_no (员工编号) — int(4) — Foreign key → EMPLOYEE.empl_no — NOT NULL
DEPENDENT (受抚养家庭)
- depe_no (家庭号码) — Primary key — NOT NULL
- dependent_name (受抚养姓名)
- gender (性别)
- birth_date (出生日期)
- relationship (关系)
- parent (父母)
- empl_no (员工编号) — int(4) — Foreign key → EMPLOYEE.empl_no — NOT NULL
DEPT-LOCATION (部门位置)
- loc_no (位置编号) — Foreign key → LOCATION.loc_no
- dept_no (部门编号) — Foreign key → DEPARTMENT.dept_no — NOT NULL
EMPLOYEE (员工)
- empl_no (员工编号) — int(4) — Primary key — NOT NULL
- name (名称)
- gender (性别)
- address (地址)
- salary (工资)
- birth_date (出生日期)
- department (部门)
- supervisor (主管)
- works_on (工作)
- dept_no (部门编号) — Foreign key → DEPARTMENT.dept_no — NOT NULL
- empl_no (员工编号2) — int(4) — Foreign key → EMPLOYEE.empl_no — NOT NULL
LOCATION (位置)
- loc_no (位置编号) — Primary key
- city_name (城市名)
- address (地址)
PROJECT (项目)
- proj_no (项目编号) — Primary key — NOT NULL
- name (名称)
- location (位置)
- controlling_department (控制部门)
- dept_no (部门编号) — Foreign key → DEPARTMENT.dept_no — NOT NULL
WORKS-ON (工作)
- empl_no (员工编号) — int(4) — Foreign key → EMPLOYEE.empl_no — NOT NULL
- proj_no (项目编号) — Foreign key → PROJECT.proj_no — NOT NULL
- hours (时间)