exquiz.me
Tables (13)
host
- id (Key) — int — Primary key — NOT NULL
host_info (Untitled)
- host_id (Key2) — int — Foreign key → host.id — NOT NULL
- name (Field) — varchar
- phone_number (Field2) — varchar
- nickname (Field3) — varchar
- registration_date (Field4) — datetime
- picture (Field5) — varchar
- sex (Field6) — char
- email (Field7) — varchar
oauthid
- id (Key) — int — Primary key — NOT NULL
- host_id (Key2) — int — Foreign key → host.id — NOT NULL
- version (Field2) — NOT NULL
- access_token (Field)
- provider (Field3)
participant (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- room_id (Key2) — int — Foreign key → room.id — NOT NULL
- nickname (Field) — varchar
- entry_date (Field2) — datetime
- current_score (Field3) — int
participant_session (Untitled8)
- participant_id (Key) — int — Foreign key → participant.id — NOT NULL
- deviceinfo (Field)
- sessioninfo (Field2)
problem (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- problemset_id (Key2) — int — Foreign key → problemset.id — NOT NULL
- title (Field) — varchar
- description (Field2) — varchar
- timelimit (Field3) — int
- score (Field4) — int
- answer (Field9)
- problem_type (Field5) — int
- picture (Field6) — varchar
- sequence (Field7) — int
problem_option (Untitled4)
- id (Key2) — int — Primary key — NOT NULL
- problem_id (Key) — int — Foreign key → problem.id — NOT NULL
- option_number (Field) — int
- description (Field2) — varchar
- picture (Field3) — varchar
- pickcount (Field4) — int
- (Field5)
problem_statistics (Untitled11)
- id (Key2) — int — Primary key — NOT NULL
- problem_id (Key) — int — Foreign key → problem.id — NOT NULL
- total_try (Field) — int
- total_correct (Field2) — int
problemset (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- host_id (Key2) — int — Foreign key → host.id — NOT NULL
- title (Field) — varchar
- description (Field2) — varchar
- closing (Field3) — varchar
- deleted (Field4) — bool
problemset_statistics (Untitled10)
- problemset_id (Key) — int — Foreign key → problemset.id — NOT NULL
- total_participant (Field) — int
problemset_tag (Untitled5)
- problemset_id (Key) — int — Foreign key → problemset.id — NOT NULL
- tag_name (Field) — varchar
room (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- problemset_id (Key2) — int — Foreign key → problemset.id — NOT NULL
- pin (Field) — int
- max_participation (Field2) — int
- start_date (Field3) — datetime
- end_date (Field4) — datetime
- current_state (Field5) — int
room_result (Untitled9)
- room_id (Key) — int — Foreign key → room.id — NOT NULL
- correct (Field) — char
- time (Field2) — float