특화

테이블 (6)

Board (Untitled5)

  • BoardId (board_id) — Long — 기본 키 — NOT NULL
  • Content (content) — mediumText
  • ViewCount (view) — Int
  • Datetime (time) — Varchar(30)
  • Assessment (assessment) — Int
  • Writer (uid) — Long — 외래 키 → User.UserId — NOT NULL

Choice (Untitled4)

  • ProblemId (pro_id) — Long — 외래 키 → Problem.ProblemId — NOT NULL
  • WordId (word_id) — Int(Not Null)

Comment (Untitled6)

  • CommentId (comment_id) — Long — 기본 키 — NOT NULL
  • Content (content) — mediumText
  • Datetime (time) — Varchar(30)
  • BoardId (board_id) — Long — 외래 키 → Board.BoardId — NOT NULL
  • Writer (uid) — Long — 외래 키 → User.UserId — NOT NULL

Example (Untitled2)

  • ProblemId (pro_id) — Long — 외래 키 → Problem.ProblemId — NOT NULL
  • WordId (word_id) — Int(Not Null)

Problem (Untitled3)

  • ProblemId (pro_id) — Long(Auto Increment) — 기본 키 — NOT NULL
  • SentenseId (sentense_id) — Int
  • AnswerId (answer_Id) — Int(Not Null)
  • Type (type) — Int(Not Null)
  • CategoryId (category_id) — Int(Not Null)
  • WrongCnt (wrong_cnt) — Int(def. 1)
  • UserId (uid) — Long — 외래 키 → User.UserId — NOT NULL

User (Untitled)

  • UserId (uid) — Long(AutoIncrement) — 기본 키 — NOT NULL
  • Nickname (nickname) — Varchar(20)(Unique)
  • SocialId (social_id) — Varchar(50)(Unique)(Not Null)
  • Language (language) — Int(Not null)
  • Type (type) — Varchar(8)(Not null)