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