BoardERD
Tables (6)
Questions
- uploadnumber — int — Primary key — NOT NULL — auto_increase
- Category (category) — varchar(255) — NOT NULL
- Content (content) — text — NOT NULL
- Modify_date (modify_date) — datetime(6)
- Nowtime (nowtime) — datetime(6)
- Title (title) — varchar(200) — NOT NULL
- View (view) — int — NOT NULL
- Username (username) — varchar(255) — Foreign key → Users.Id — NOT NULL — FK
- Id (id) — bigint — Foreign key → Users.Id — NOT NULL — FK
Questions_voter
- uploadnumber — int — Foreign key → Questions.uploadnumber — NOT NULL — PK
- Id (id) — int — Foreign key → Users.Id — NOT NULL — PK
Replys
- Uploadnumber (uploadnumber) — int — Primary key — NOT NULL — auto_increase
- Content (content) — text
- Depth (depth) — int — NOT NULL
- Modify_date (modify_date) — datetime(6)
- Nowtime (nowtime) — datetime(6)
- Parent_id (parent_id) — int — 계층형 답변을 위한 부모 id
- uploadnumber (questions_uploadnumber) — int — Foreign key → Questions.uploadnumber — NOT NULL — auto_increase
- Id (id2) — bigint — Foreign key → Users.Id — NOT NULL — auto_increase
Replys_voter
- Id (voter_id) — bigint — Foreign key → Users.Id — NOT NULL — auto_increase
- Uploadnumber (replys_uploadnumber) — int — Foreign key → Replys.Uploadnumber — NOT NULL — auto_increase
Users
- Id (id) — bigint — Primary key — NOT NULL — auto_increase
- Nickname (nickname) — varchar(255) — NOT NULL — unique
- Username (username) — varchar(255) — NOT NULL — unique
Users_Detail
- Id (id) — bigint — Foreign key → Users.Id — NOT NULL — auto_increase
- Email (email) — varchar(255) — unique
- Password (password) — varchar(255)