zamfit

Tables (63)

app_version

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • app_os — varchar(10)
  • selection_type — varchar(10)
  • update_content — text
  • version — varchar(255)
  • version_code — int4

city

  • id — int8 — Primary key — NOT NULL
  • code — varchar(255)
  • name — varchar(255)
  • short_name — varchar(255)
  • state_id — int8

escape_room (방탈출테마)

  • Key — Primary key — NOT NULL
  • Field

escape_room

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • activity — varchar(255)
  • escape_device — int4
  • escape_lock — int4
  • genre — varchar(255)
  • introduction — text
  • level — int4
  • max_people — int4
  • min_people — int4
  • name — varchar(255)
  • date_type — varchar(255)
  • day_of_week — int4
  • is_last_days — bool
  • month_pick_days — int4
  • notify_time — varchar(255)
  • play_time — int4
  • thumbnail_name — varchar(255)
  • thumbnail_url — varchar(2000)
  • store_id — int8
  • default_star_point — float8
  • is_visible — bool
  • is_reservation — bool
  • crawling_name — varchar(255)
  • avg_star_point — float8

escape_room_image

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • image_name — varchar(255)
  • image_url — varchar(2000)
  • sort — int4
  • escape_room_id — int8

escape_room_keep

  • id — int8 — Primary key — NOT NULL
  • escape_room_id — int8
  • user_id — int8

escape_room_price

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • number_of_people — int4
  • price — int4
  • escape_room_id — int8
  • discount_price — int4

escape_room_price_aud

  • id — int8 — Primary key — NOT NULL
  • rev — int4 — Primary key — NOT NULL
  • revtype — int2
  • discount_price — int4
  • number_of_people — int4
  • price — int4

escape_room_ranking

  • id — int8 — Primary key — NOT NULL
  • ranking — int4
  • reload_at — date
  • escape_room_id — int8

escape_room_review

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • is_pass — bool
  • message — text
  • number_of_people — int4
  • play_at — date
  • rating — float8
  • escape_room_id — int8
  • user_id — int8
  • is_block — bool

escape_room_review_image

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • image_name — varchar(255)
  • image_url — varchar(2000)
  • sort — int4
  • escape_room_review_id — int8

escape_room_review_keyword

  • id — int8 — Primary key — NOT NULL
  • escape_room_review_id — int8
  • review_keyword_id — int8

escape_room_review_pass

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • pass_at — timestamp

escape_room_review_report

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • reason — varchar(350)
  • escape_room_review_id — int8
  • user_id — int8

escape_room_time

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • time — varchar(255)
  • escape_room_id — int8

escape_room_time_aud

  • id — int8 — Primary key — NOT NULL
  • rev — int4 — Primary key — NOT NULL
  • revtype — int2
  • time — varchar(255)

event

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • contents — text
  • end_at — timestamp
  • is_visible — bool
  • start_at — timestamp
  • title — varchar(255)

faq

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • answer — text
  • question — text

flyway_schema_history

  • installed_rank — int4 — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int4
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int4 — NOT NULL
  • success — bool — NOT NULL

main_banner

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • bottom_text — varchar(255)
  • end_visible_at — timestamp
  • image_name — varchar(255)
  • image_url — varchar(2000)
  • is_visible — bool
  • middle_text — varchar(255)
  • next_screen — varchar(255)
  • next_screen_key — int8
  • sort — int4
  • start_visible_at — timestamp
  • title — varchar(255)
  • top_text — varchar(255)
  • screen_key — varchar(255)
  • screen_type — varchar(255)

main_recommend

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • title — varchar(255)
  • sort — int4

main_recommend_escape

  • id — int8 — Primary key — NOT NULL
  • escape_room_id — int8
  • main_recommend_id — int8
  • sort — int4

notice

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • contents — text
  • is_visible — bool
  • title — varchar(255)

partner

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • name — varchar(255)

push_event

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • body — varchar(255)
  • image_name — varchar(255)
  • image_url — varchar(2000)
  • next_screen — varchar(255)
  • reason — varchar(255)
  • title — varchar(255)
  • next_screen_key — int8
  • deleted — bool
  • deleted_at — timestamp
  • send_at — timestamp

reservation

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • people_count — int4
  • reservation_at — timestamp
  • reservation_number — varchar(255)
  • reservation_state — varchar(255)
  • total_price — int4
  • user_phone_number — varchar(255)
  • escape_room_id — int8
  • user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • is_no_show — bool
  • reservation_date — varchar(255)
  • reservation_time — varchar(255)
  • cancel_reason — varchar(255)
  • canceled_at — timestamp
  • linked_number — varchar(255)

reservation_aud

  • id — int8 — Primary key — NOT NULL
  • rev — int4 — Primary key — NOT NULL
  • revtype — int2
  • is_no_show — bool
  • people_count — int4
  • reservation_at — timestamp
  • reservation_date — varchar(255)
  • reservation_number — varchar(255)
  • reservation_state — varchar(255)
  • reservation_time — varchar(255)
  • total_price — int4
  • user_phone_number — varchar(255)
  • cancel_reason — varchar(255)
  • canceled_at — timestamp
  • linked_number — varchar(255)

reservation_payment

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • payment_method — varchar(255)
  • payment_state — varchar(255)
  • please_comment — varchar(255) — archar(255) NUL
  • total_price — int4
  • reservation_id — int8

reservation_state_history

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • reservation_state — varchar(255)
  • reservation_id — int8

review_prefix_keyword

  • id — int8 — Primary key — NOT NULL
  • prefix — varchar(255)

review_suffix_keyword

  • id — int8 — Primary key — NOT NULL
  • sort — int4
  • suffix — varchar(255)
  • review_prefix_keyword_id — int8

revinfo

  • rev — int4 — Primary key — NOT NULL
  • revtstmp — int8

state

  • id — int8 — Primary key — NOT NULL
  • code — varchar(255)
  • name — varchar(255)
  • short_name — varchar(255)

store

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • address — varchar(255)
  • address_detail — varchar(255)
  • city — varchar(255)
  • state — varchar(255)
  • introduction — text
  • name — varchar(255)
  • tel — varchar(255)
  • thumbnail_name — varchar(255)
  • thumbnail_url — varchar(2000)
  • url — varchar(255)
  • open_time — varchar
  • close_time — varchar

store_business_day

  • id — int8 — Primary key — NOT NULL
  • day_of_week — int4
  • store_id — int8

store_image

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • image_name — varchar(255)
  • image_url — varchar(2000)
  • sort — int4
  • store_id — int8

team

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • gender_type — varchar(255)
  • introduction — text
  • is_play_at_agreement — bool
  • max_people — int4
  • maybe_play_at — date
  • open_kakao_url — varchar(255)
  • recruit_type — varchar(255)
  • team_state — varchar(255)
  • title — varchar(255)
  • escape_room_id — int8
  • user_id — int8
  • is_block — bool
  • last_message — varchar(255)
  • last_message_at — timestamp

team_age_group

  • id — int8 — Primary key — NOT NULL
  • age_group — varchar(255)
  • team_id — int8

team_comment

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • message — varchar(255)
  • parent_id — int8
  • team_id — int8
  • user_id — int8

team_comment_report

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • reason — varchar(350)
  • team_comment_id — int8
  • user_id — int8

team_entry_application

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • is_leader_read — bool
  • message — varchar(255)
  • team_apply_state — varchar(255)
  • team_id — int8
  • user_id — int8

team_entry_application_state

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • team_apply_state — varchar(255)
  • team_entry_application_id — int8

team_keep

  • id — int8 — Primary key — NOT NULL
  • team_id — int8
  • user_id — int8

team_member

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • member_state — varchar(255)
  • team_id — int8
  • user_id — int8
  • team_entry_application_id — int8

team_report

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • reason — varchar(350)
  • team_id — int8
  • user_id — int8

ticket

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • discount_price — int4
  • is_visible — bool
  • name — varchar(255)
  • people_count — int4
  • price — int4
  • sort — int4
  • ticket_type — varchar(255)
  • escape_room_id — int8

ticket (이용권)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → escape_room.Key — NOT NULL
  • is_visible (Field)
  • week (Field2)
  • Field3
  • Field4
  • Field5

user_account

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • background_image_name — varchar(255)
  • background_image_url — varchar(2000)
  • birth — date
  • city — int4
  • email — varchar(255)
  • gender — varchar(255)
  • introduction — text
  • is_advert_alarm_agreement — bool
  • is_contents_alarm_agreement — bool
  • is_escape_alarm_agreement — bool
  • is_notice_alarm_agreement — bool
  • is_team_alarm_agreement — bool
  • last_login_at — timestamp
  • nickname — varchar(255)
  • password — varchar(255)
  • phone_number — varchar(255)
  • profile_image_name — varchar(255)
  • profile_image_url — varchar(2000)
  • push_token — varchar(255)
  • social — varchar(255)
  • social_id — varchar(255)
  • zamfit_type_id — int8
  • drop_message — varchar(300)

user_account (유저)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

user_alarm

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • alarm_type — varchar(255)
  • description — varchar(2000)
  • dtype — varchar(255)
  • dtype_id — int8
  • image_skin — varchar(255)
  • image_url — varchar(2000)
  • is_read — bool
  • sub_description — varchar(2000)
  • tab_category — varchar(255)
  • title — varchar(255)
  • user_id — int8

user_alarm_read

  • id — int8 — Primary key — NOT NULL
  • last_read_at — timestamp
  • user_id — int8

user_block

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • blocked_user_id — int8
  • user_id — int8

user_escape_notify

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • is_notify — bool
  • escape_room_id — int8
  • user_id — int8
  • deleted — bool
  • deleted_at — timestamp

user_point_history (포인트 히스토리)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

user_report

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • reason — varchar(350)
  • report_user_id — int8
  • user_id — int8

user_ticket (구매한 이용권)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → ticket.Key — NOT NULL
  • Key (Key3) — Foreign key → user_account.Key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

user_ticket

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • canceled_at — timestamp
  • origin_ticket_json — varchar(255)
  • ticket_state — varchar(255)
  • used_at — timestamp
  • ticket_id — int8
  • user_id — int8

user_ticket_aud (이용권 변경내역)

  • Key — Primary key — NOT NULL
  • Key (Key22) — Foreign key → user_ticket.Key — NOT NULL

user_ticket_aud

  • id — int8 — Primary key — NOT NULL
  • rev — int4 — Primary key — NOT NULL
  • revtype — int2
  • canceled_at — timestamp
  • origin_ticket_json — varchar(255)
  • ticket_state — varchar(255)
  • used_at — timestamp

zamfit_mate

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • zamfit_type_id — int8
  • zamfit_type_mate_id — int8

zamfit_type

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • introduction — text
  • name — varchar(255)
  • sub_name — varchar(255)
  • thumbnail_name — varchar(255)
  • thumbnail_url — varchar(2000)

zamfit_type_recommend_escape_room

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • deleted — bool
  • deleted_at — timestamp
  • recommend_text — varchar(255)
  • escape_room_id — int8
  • zamfit_type_id — int8

zamfit_type_tag

  • id — int8 — Primary key — NOT NULL
  • created_at — timestamp
  • created_user_id — int8
  • updated_at — timestamp
  • updated_user_id — int8
  • tag — varchar(255)
  • zamfit_type_id — int8