b
Tables (9)
Department (Untitled2)
- departmentID (Key) — char(30) — Primary key — NOT NULL
- departmentName (Field) — char(30)
Family (Untitled5)
- FID (Key) — int(20) — Primary key — NOT NULL
- fName (Field) — char(30)
- fBirthDate (Field2) — date
- fRelationship (Field3) — char(10)
- EID (Key2) — int(20) — Foreign key → employee.EID — NOT NULL
Maker (Untitled8)
- mkNumber (Key) — int(20) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — int(10)
Part (Untitled7)
- paNumber (Key) — int(20) — Primary key — NOT NULL
- pexplain (Field) — text
- mkNumber (Key2) — int(20) — Foreign key → Maker.mkNumber — NOT NULL
Product (Untitled6)
- pNumber (Key) — int(20) — Primary key — NOT NULL
- explain (Field) — text
- price (Field2) — int(20)
Project (Untitled3)
- projectNumber (Key) — Primary key — NOT NULL
- projectName (Field)
- departmentID (Key2) — char(30) — Foreign key → Department.departmentID — NOT NULL
Work_On (Untitled4)
- PID (Key) — int(20) — Foreign key → employee.EID — NOT NULL
- projectNumber (Key2) — char(10) — Foreign key → Project.projectNumber — NOT NULL
- hours (Field) — int(10)
Works_On (Untitled9)
- paNumber (Key) — int(20) — Foreign key → Part.paNumber — NOT NULL
- pNumber (Key2) — int(20) — Foreign key → Product.pNumber — NOT NULL
- partAmount (Field) — int(10)
employee (Untitled)
- EID (Key) — int(20) — Primary key — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(50)
- wage (Field3) — float
- gender (Field4) — char(10)
- birthDate (Field5) — date
- departmentID (Key2) — char(30) — Foreign key → Department.departmentID — NOT NULL
- senior (Key3) — int(20) — Foreign key → employee.EID — NOT NULL