company

Tables (11)

BRIDGE (Untitled11)

    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