특화
테이블 (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)