skku-oss-project

Tables (3)

answers

  • uuid 값 (id) — char(36) — Primary key — NOT NULL
  • 작성자 uuid 값 (writer) — char(36) — Foreign key → users.uuid 값 — NOT NULL
  • 질문 uuid 값 (question_id) — char(36) — Foreign key → questions.uuid 값 — NOT NULL
  • 내용 (content) — varchar(2000) — NOT NULL
  • 작성일자 (date) — timestamp — NOT NULL

questions

  • uuid 값 (id) — char(36) — Primary key — NOT NULL
  • 작성자 uuid (writer) — char(36) — Foreign key → users.uuid 값 — NOT NULL
  • 내용 (content) — varchar(2000) — NOT NULL
  • 작성일자 (date) — timestamp — NOT NULL
  • 제목 (title) — varchar(64) — NOT NULL

users

  • uuid 값 (id) — char(36) — Primary key — NOT NULL
  • 이메일 (email) — varchar(254) — NOT NULL
  • 비밀번호 (password) — varchar(64) — NOT NULL
  • 솔트 (salt) — varchar(8)
  • 닉네임 (nickname) — varchar(10) — NOT NULL