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