QuizSite

Tables (8)

Admin (관리자)

  • rootID (Key) — int — Primary key — NOT NULL
  • Permissions (Key2) — int — Primary key — NOT NULL
  • passward (Field) — int
  • nickname (Field2) — varchar

Comment (Untitled5)

  • CommentID (Key) — int — Primary key — NOT NULL
  • DiscussionID (Key2) — int — Foreign key → Discussion.DiscussionID — NOT NULL
  • SolverID (Key3) — int — Foreign key → Solver.SolverID — NOT NULL
  • Content (Field) — varchar
  • Created)at (Field2) — datetime

Contributor (출제자)

  • ContributorID (Key) — int — Primary key — NOT NULL
  • Permissions (Key22) — int — Foreign key → Admin.Permissions — NOT NULL
  • passward (Field) — int
  • nickname (Field2) — varchar

Discussion (Untitled4)

  • DiscussionID (Key) — int — Primary key — NOT NULL
  • SolverID (Key3) — int — Foreign key → Solver.SolverID — NOT NULL
  • QuizIndex (Key2) — int — Foreign key → Quiz.QuizIndex — NOT NULL
  • Title (Field) — varchar
  • Content (Field2) — varchar
  • Created_at (Field3) — datetime

Quiz (Untitled)

  • QuizIndex (Key) — int — Primary key — NOT NULL
  • ContributorID (Key2) — int — Foreign key → Contributor.ContributorID — NOT NULL
  • Title (Field) — varchar(100)
  • Description (Field2) — varchar(100)
  • Level (Field5) — varchar
  • Category (Field6) — varchar

Ranking (Untitled2)

  • RankingIndex (Key) — int — Primary key — NOT NULL
  • SolverID (Key3) — int — Foreign key → Solver.SolverID — NOT NULL
  • Score (Field2) — int
  • Rank (Field3) — int

Simulation (Untitled3)

  • QuizIndex (Key) — int — Foreign key → Quiz.QuizIndex — NOT NULL
  • Time (Field) — int
  • PassNonpass (Field2) — boolean
  • Date (Field3) — datetime
  • DetailDescription (Field4) — varchar

Solver (풀이자)

  • SolverID (Key3) — int — Primary key — NOT NULL
  • Permissions (Key22) — int — Foreign key → Admin.Permissions — NOT NULL
  • QuizIndex (Key) — int — Foreign key → Quiz.QuizIndex — NOT NULL
  • passward (Field) — int
  • nickname (Field4) — varchar