wnthc

Tables (11)

Untitled (user)

  • Key (id) — int — Primary key — NOT NULL
  • Field (nickname) — varchar(255)
  • Field (phone) — varchar(255)
  • Field (country_code) — varchar(255)
  • Field2 (email) — varchar(255)
  • Field (password) — varchar(255)
  • Field (profile) — varchar(255)
  • Field (prize) — int
  • Field (push_token) — varchar(255)
  • Field (life) — int
  • Field (language) — varchar(255)
  • Field (created_at) — datetime
  • Field (deleted_at) — datetime
  • Field (terms_of_service_agree) — int
  • Field2 (personal_info_agree) — int

Untitled (user_log)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (mission_problem_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (start_at) — datetime
  • Field (end_at) — datetime
  • Field2 (time_used) — int
  • Field (answer) — varchar(255)
  • Field (correct) — int

Untitled (mission)

  • Key (id) — int — Primary key — NOT NULL
  • Key (admin_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — int
  • Field (level) — int
  • Field (foreign) — int
  • Field (prize) — int
  • Field (problem_cnt) — int
  • Field (weight) — double
  • Field2 (etb_location) — varchar(255)
  • Field (created_at) — datetime

Untitled (problem)

  • Key (id) — int — Primary key — NOT NULL
  • Field (difficulty) — int
  • Field (answer_type) — int
  • Field (start_location) — varchar(255)
  • Field (end_location) — varchar(255)
  • Field (end_latitude) — double
  • Field (end_longitude) — double
  • Field (translatable) — int
  • Field (link) — varchar(255)
  • Field (type) — varchar(255)
  • Field (use_hour) — varchar(255)
  • Field (confirm) — int
  • Field (report_result) — int
  • Field (solution) — varchar(255)

Untitled (translate_problem)

  • Key (id) — int — Primary key — NOT NULL
  • Key (problem_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (context) — varchar(255)
  • Field (image) — varchar(255)
  • Field (answer) — varchar(255)
  • Field (language) — varchar(255)

Untitled (admin)

  • Key (id) — int — Primary key — NOT NULL
  • Field (login_id) — varchar(255)
  • Field (password) — varchar(255)
  • Field2 (role) — int
  • Field (user_name) — varchar(255)
  • Field (created_at) — datetime

Untitled (update_problem)

  • Key (id) — int — Primary key — NOT NULL
  • Key (problem_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (admin_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (update_type) — int
  • Field (update_at) — datetime

Untitled (mission_problem)

  • Key (id) — int — Primary key — NOT NULL
  • Key (mission_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (problem_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (order) — int

Untitled (notice)

  • Key (id) — int — Primary key — NOT NULL
  • Key (admin_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (context) — text
  • Field (language) — varchar(255)
  • Field (last_update) — datetime

Untitled (notice_image)

  • Key (notice_image_id) — int — Primary key — NOT NULL
  • Key (notice_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (image) — varchar(255)

Untitled (report)

  • Key (id) — int — Primary key — NOT NULL
  • Key (problem_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (report_reason) — text
  • Field (created_at) — datetime
  • Field (status) — int