fg
Tables (10)
Copy Of board (CopyOfUntitled3)
- boardid (게시글id) — int — Primary key — NOT NULL
- title (제목) — text
- description (본문) — text
- created (작성일) — datetime
- user_id (Field) — int
- workbookid (Field2) — int
Copy Of question (CopyOfUntitled4)
- questionid (Key) — int — Primary key — NOT NULL
- grade (Field) — byte
- year (Field2) — short
- month (Field3) — byte
- bigunit (Field8) — byte
- smallunit (Field4) — byte
- point (Field5) — byte
- answerRate (Field6) — bigdecimal
- isMultipleChoice (Field7) — boolean
- num (Field9) — byte
- description (Field10) — text
Copy Of user (CopyOf사용자)
- userid (사용자id) — int — Primary key — NOT NULL
- nickname (닉네임) — varchar(20)
Copy Of workbook (CopyOfUntitled2)
- workbookid (문제집ID) — int — Primary key — NOT NULL
- Field
board (게시글)
- id (게시글id) — int — Primary key — NOT NULL
- user_id (사용자id) — int — Foreign key → user.id — NOT NULL
- workbook_id (문제집id) — int — Foreign key → workbook.id — NOT NULL
- title (제목) — varchar(30)
- description (본문) — text
- created (작성일) — datetime
question (문제)
- id (문제id) — int — Primary key — NOT NULL
- grade (학년) — byte
- year (년도) — short
- month (월) — byte
- mainUnit (대단원) — byte
- subUnit (소단원) — byte
- num (번호) — byte
- point (점수) — byte
- answerRate (정답률) — bigdecimal
- isMultipleChoice (답유형) — boolean
- descriptionPath (본문) — text
- answer (정답) — short
- solutionPath (해설) — text
storage (보관)
- user_id (사용자id) — int — Foreign key → user.id — NOT NULL
- workbook_id (문제집id) — int — Foreign key → workbook.id — NOT NULL
user (사용자)
- id (사용자id) — int — Primary key — NOT NULL
- nickname (닉네임) — varchar(20)
workbook (문제집)
- id (문제집id) — int — Primary key — NOT NULL
- user_id (사용자id) — int — Foreign key → user.id — NOT NULL
- title (제목) — varchar(30)
- description (본문) — text
- created (생성일) — datetime
workbook_question_include (포함)
- workbook_id (문제집id) — int — Foreign key → workbook.id — NOT NULL
- question_id (문제id) — int — Foreign key → question.id — NOT NULL
- num (번호) — byte