DB_1

Tables (4)

Untitled (officer)

  • Key (officer_name) — char — Primary key — NOT NULL
  • Field (age) — int
  • Field2 (rank) — char
  • Field (affiliation) — char
  • Field (salary) — int

Untitled (Genre)

  • Key (pNo) — int — Primary key — NOT NULL
  • Field (work) — char
  • Field

employee (Author)

  • employee_name (Author_name) — char — Primary key — NOT NULL
  • street (age) — int
  • city (rank) — char
  • gender (platoon) — int
  • number (affiliation) — char

works

  • Key (employee_name) — char — Primary key — NOT NULL
  • Key2 (company_name) — char — Primary key — NOT NULL
  • Field (salary) — int
  • Field2