SNS_DB
Tables (4)
department (Untitled3)
- dept_id (Key) — int — Primary key — NOT NULL
- name (Field) — vharchar(15)
employee (Untitled)
- employee_id (Key) — int — Primary key — NOT NULL
- person_id (Key2) — int — Primary key — NOT NULL
- dept_id (Key3) — int — Primary key — NOT NULL
- employee_id (Key5) — int — Foreign key → family.employee_id — NOT NULL
- person_id (Key22) — int — Foreign key → family.person_id — NOT NULL
- dept_id (Key4) — int — Foreign key → department.dept_id — NOT NULL
family (Untitled4)
- employee_id (Key) — int — Primary key — NOT NULL
- person_id (Key2) — int — Primary key — NOT NULL
- person_id (Key3) — int — Foreign key → person.person_id — NOT NULL
- employee_id (Key5) — int — Foreign key → person.employee_id — NOT NULL
- person_id (Key222) — int — Foreign key → person.person_id — NOT NULL
person (Untitled2)
- person_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(15)
- gender (Field2) — char(1)
- address (Field3) — varchar(30)
- height (Field4) — int
- age (Field5) — int
- employee_id (Key2) — int — Foreign key → employee.employee_id — NOT NULL
- person_id (Key22) — int — Foreign key → employee.person_id — NOT NULL
- dept_id (Key3) — int — Foreign key → employee.dept_id — NOT NULL
- employee_id (Key5) — int — Foreign key → employee.employee_id — NOT NULL
- person_id (Key222) — int — Foreign key → employee.person_id — NOT NULL