company
Tables (11)
DEPARTMENT (Untitled)
- departmentID (Key) — char(10) — Primary key — NOT NULL
- id (Key3) — char(30) — Foreign key → LOCATED_AT.id — NOT NULL
- departmentName (Field) — char(20)
- departmentManager (Field2) — int(10)
- manageStartDate (Field3) — date
- ssn (Key2) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- identification (Field2) — int(13)
- address (Field3) — char(50)
- departmentID (Key2) — char(10) — Foreign key → DEPARTMENT.departmentID — NOT NULL
- id (Key3) — char(30) — Foreign key → DEPARTMENT.id — NOT NULL
- ssn (Key4) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
FAMILY (Untitled5)
- familyID (Key) — char(10) — Primary key — NOT NULL
- familyName (Field) — char(30)
- familyGender (Field2) — char(1)
- familyBirthday (Field3) — date
- ssn (Key2) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
- familyRelationship (Field4) — char(10)
- id (Key3) — char(30) — Foreign key → EMPLOYEE.id — NOT NULL
LOCATED_AT (Untitled7)
- id (Key) — char(30) — Primary key — NOT NULL
LOCATION (Untitled6)
- locationName (Key) — char(50) — Primary key — NOT NULL
- id (Key2) — char(30) — Foreign key → LOCATED_AT.id — NOT NULL
PARTS (Untitled9)
- partsID (Key) — char(10) — Primary key — NOT NULL
PRODUCER (Untitled10)
- ID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(50)
- phone (Field3) — int(11)
PRODUCT (Untitled8)
- productID (Key) — char(10) — Primary key — NOT NULL
- explanation (Field) — char(200)
- price (Field2) — int(20)
PROJECT (Untitled3)
- projectID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- departmentID (Key2) — char(10) — Foreign key → DEPARTMENT.departmentID — NOT NULL
- id (Key3) — char(30) — Foreign key → DEPARTMENT.id — NOT NULL
WORKS_ON (Untitled4)
- ssn (Key2) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
- projectID (Key3) — char(10) — Foreign key → PROJECT.projectID — NOT NULL
- id (Key32) — char(30) — Foreign key → EMPLOYEE.id — NOT NULL
- hours (Field) — float