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