RiddleBox
Tables (20)
comment
- comment_id — bigint
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- content — text — NOT NULL
- depth — int — NOT NULL
- modified_date — datetime(6)
- status — enum
- game_id — bigint
- parent_id — bigint
- user_id — bigint
- is_active — tinyint
faq
- view_count — int — NOT NULL
- created_by — bigint
- created_date — datetime(6)
- faq_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- answer — varchar(255)
- question — varchar(255)
- faq_category — enum
- status — enum
forbidden_word
- id — bigint
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- word — varchar(255) — NOT NULL
game
- game_id — bigint
- view_count — int — NOT NULL
- category_id — bigint
- title — varchar(255)
- descript — tinytext
- created_by — bigint
- created_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- official_release_date — datetime(6)
- official_update_date — datetime(6)
- author — varchar(255)
- game_level — enum
- status — enum
game_category
- display_order — int — NOT NULL
- icon — int — NOT NULL
- category_id — bigint
- created_by — bigint
- created_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- parent_category_id — bigint
- description — varchar(255)
- status — enum
- subject — enum
game_content
- game_content_id — bigint
- game_id — bigint
- question — varchar(255)
- answer — varchar(255)
- ordering — int
- created_by — bigint
- created_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- status — enum
game_event
- created_by — bigint
- created_date — datetime(6)
- event_time — datetime(6)
- game_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- user_id — bigint
- user_event_id — bigint
- event_type — enum
game_image
- game_image_id — bigint
- game_id — bigint
- file_path — varchar(255)
- file_save_name — varchar(255)
- file_origin_name — varchar(255)
- file_url — varchar(255)
- image_type — enum
- created_by — bigint
- created_date — datetime(6)
- file_size — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- description — varchar(255)
- status — enum
game_record
- play_time — int — NOT NULL
- score — int — NOT NULL
- success_rate — float — NOT NULL
- created_by — bigint
- created_date — datetime(6)
- game_id — bigint
- game_record_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- user_id — bigint
- result_type — enum
game_solver
- gamesolver_id — bigint
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- end_date_time — datetime(6)
- remaining_time — bigint
- solved_date_time — datetime(6)
- game_id — bigint
- user_id — bigint
game_text
- game_text_id — bigint
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- status — enum
- text — mediumtext
- game_id — bigint
- explanation — mediumtext
inquiry
- created_by — bigint
- created_date — datetime(6)
- inquirer_id — bigint
- inquiry_at — datetime(6)
- inquiry_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- responded_date — datetime(6)
- responder_id — bigint
- content — varchar(255)
- question — varchar(255)
- response — varchar(255)
- faq_category — enum
- status — enum
notice
- view_count — int
- created_by — bigint
- created_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- notice_date — datetime(6)
- notice_id — bigint
- title — varchar(255)
- category — enum
- content — mediumtext
- status — enum
payment_info
- payment_info_id — bigint
- tid — varchar(255)
- status — enum
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- aid — varchar(255)
- discount — int
- point — int
- tax_free — int
- total — int
- approved_at — datetime(6)
- approved_id — varchar(255)
- bin — varchar(255)
- card_item_code — varchar(255)
- card_mid — varchar(255)
- card_type — varchar(255)
- installment_type — varchar(255)
- interest_free_install — varchar(255)
- kakaopay_issuer_corp — varchar(255)
- kakaopay_issuer_corp_code — varchar(255)
- kakaopay_purchase_corp — varchar(255)
- kakaopay_purchase_corp_code — varchar(255)
- created_at — datetime(6)
- item_code — varchar(255)
- item_name — varchar(255)
- partner_order_id — varchar(255)
- partner_user_id — varchar(255)
- total_amount — int
- total_point_amount — int
- user_id — bigint
- green_deposit — int
- vat — int
- install_month — varchar(255)
- tax_free_amount — int
- vat_amount — int
recommend_game
- clicks — int — NOT NULL
- recommend_rank — int — NOT NULL
- created_by — bigint
- created_date — datetime(6)
- end_date — datetime(6)
- game_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- recommend_id — bigint
- start_date — datetime(6)
- reason — varchar(255)
- status — enum
roles
- level — int
- created_by — bigint
- created_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- role_id — bigint
- description — varchar(500)
- name — varchar(255) — NOT NULL
- status — enum
social_profile
- id — bigint
- user_id — bigint
- profile_pictureurl — varchar(255)
- provider — varchar(255)
- provider_id — varchar(255)
- refresh_token — varchar(255)
user_point
- user_point_id — bigint
- user_id — bigint
- total_points — int — NOT NULL
- reason — varchar(255)
- earned_points — int — NOT NULL
- created_date — datetime(6)
- last_modified_date — datetime(6)
- created_by — bigint
- last_modified_by — bigint
- earned_date — datetime(6)
user_role
- is_active — bit
- assigned_date — datetime(6)
- created_by — bigint
- created_date — datetime(6)
- user_role_id — bigint
- last_modified_by — bigint
- last_modified_date — datetime(6)
- role_id — bigint
- user_id — bigint
- assigned_by — varchar(255)
- notes — varchar(255)
users
- password_set_date — date
- created_by — bigint
- created_date — datetime(6)
- last_login_date — datetime(6)
- last_modified_by — bigint
- last_modified_date — datetime(6)
- reg_date — datetime(6)
- user_id — bigint
- login_email — varchar(255) — NOT NULL
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- status — enum