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