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)