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