back_office

Tables (3)

Untitled

    position_list

    • id — INT — Primary key — NOT NULL
    • position — VARCHAR(50)
    • createdAt — DATETIME
    • updatedAt — DATETIME

    user

    • id — INT — Primary key — NOT NULL
    • position_id — INT — Foreign key → position_list.id — NOT NULL
    • name — VARCHAR(50)
    • email — VARCHAR(255)
    • phone — VARCHAR(20)
    • password — VARCHAR(128)
    • team — VARCHAR(50)
    • duty — VARCHAR(50)
    • createdAt — DATETIME
    • updatedAt — DATETIME