board
Tables (5)
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