board

Tables (5)

Untitled

    comment

    • Key (id) — Long — Primary key — NOT NULL
    • Key (post_id) — Long — Foreign key → post.Key — NOT NULL
    • Key (user_id) — Long — Foreign key → user.Key — NOT NULL
    • Field (content)
    • Field (createdAt) — datetime
    • Field2 (updatedAt) — datetime

    post

    • Key (id) — Long — Primary key — NOT NULL
    • Key (user_id) — Long — Foreign key → user.Key — NOT NULL
    • Field (title)
    • Key (content)
    • Field (createdAt) — datetime
    • Field2 (updatedAt) — datetime

    problem_answer

    • id — bigint
    • answer — varchar(255) — NOT NULL
    • problem_id — bigint — NOT NULL

    user

    • Key (id) — Long — Primary key — NOT NULL
    • Field (name)
    • Field2 (email)
    • Field3 (password)
    • Field (role) — varchar(255)
    • Field (createdAt) — datetime
    • Field (updatedAt) — datetime