1

Tables (5)

Untitled

    Untitled2 (EMPLOYEE)

    • Key (ssn) — char(12) — Primary key — NOT NULL
    • Field (name) — char(30)
    • Field (address) — char(50)
    • Field (email) — email
    • Field (phone) — char(12)
    • Key (departmentId) — char(10) — Foreign key → Untitled2.Key — NOT NULL

    Untitled2 (PROJECT)

    • Key (projectID) — char(20) — Primary key — NOT NULL
    • Field (name) — char(30)
    • Field (description) — longtext
    • Field (ssn) — char(10)
    • Field (departmentID) — char(10)

    Untitled2 (DEPARTMENT)

    • Key (departmentId) — char(10) — Primary key — NOT NULL
    • Field (name) — char(20)
    • Field (phone) — char(20)
    • Field (email) — email
    • Field (manager) — char(10)
    • Field (startManageDate) — date
    • Field (location) — char(30)
    • Field (description) — longtext
    • Field (projectID) — char(20)
    • Key (mangaerSsn) — char(12) — Foreign key → Untitled2.Key — NOT NULL

    Untitled2 (WORKSON)

    • Key (ssn) — char(12) — Foreign key → Untitled2.Key — NOT NULL
    • Key (projectID) — char(20) — Foreign key → Untitled2.Key — NOT NULL