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