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