dodo

Tables (100)

activity

  • id — integer — Primary key — NOT NULL
  • event_discriminator — ck_event_type — NOT NULL — 이벤트
  • event_id — integer — 이벤트
  • place_id — integer — NOT NULL — 매장
  • user_id — integer — NOT NULL — 고객
  • points — integer — 이벤트로
  • created_at — timestamp — NOT NULL
  • token — uuid — 손님

admin_change_log

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • table_name — character — NOT NULL
  • target_id — integer
  • column_name — character — NOT NULL
  • before — text
  • after — text
  • refer — text
  • employee_id — integer — NOT NULL
  • transaction_id — character — NOT NULL

admin_permission

  • id — integer — Primary key — NOT NULL
  • role_id — integer
  • created_at — timestamp — NOT NULL
  • code — character — NOT NULL

admin_role

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • created_at — timestamp — NOT NULL

admin_role_assoc

  • admin_role_id — integer — Primary key — NOT NULL
  • employee_id — integer — Primary key — NOT NULL

alembic_version

  • version_num — character — NOT NULL

app_device

  • identifier — character — Primary key — NOT NULL
  • user_id — integer — NOT NULL
  • fcm_token — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • platform — character — NOT NULL
  • platform_version — character — NOT NULL
  • expo_push_token — character
  • apns_token — character

application

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • url — character — NOT NULL
  • permissions — json — NOT NULL
  • description — text
  • created_at — timestamp — NOT NULL
  • rejection — character
  • status — character
  • status_details — json
  • developer_id — integer
  • base_access_token — character — NOT NULL
  • config_url — character
  • type — character — NOT NULL

application_place_assoc

  • place_id — integer — Primary key — NOT NULL
  • application_id — integer — Primary key — NOT NULL

application_role

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — character — NOT NULL
  • permissions — json — NOT NULL
  • resource_permissions — json — NOT NULL

application_role_assoc

  • application_id — integer — Primary key — NOT NULL
  • application_role_id — integer — Primary key — NOT NULL

approved_phone_number

  • phone_number — character — Primary key — NOT NULL
  • partner_id — integer — Primary key — NOT NULL
  • approved_at — timestamp
  • approver_id — integer
  • contract_image_id — integer
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • rejected_at — timestamp
  • rejected_reason — text
  • contract_image_1_id — integer
  • contract_image_2_id — integer
  • contract_image_3_id — integer

auto_request_policy

  • id — integer — Primary key — NOT NULL
  • auto_request — boolean — NOT NULL
  • use_claimable_items — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp
  • non_revenue_keywords — character — NOT NULL
  • payment_price_keywords — character — NOT NULL

background

  • place_id — integer — Primary key — NOT NULL
  • type — character — NOT NULL
  • background_color — text
  • library_id — integer
  • uploaded_url — text

base_contract_document

  • id — integer — Primary key — NOT NULL
  • discriminator — contract_document_type — NOT NULL

base_image_storage

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • discriminator — image_storage_type — NOT NULL

base_place_theme

  • id — integer — Primary key — NOT NULL
  • discriminator — place_theme_type — NOT NULL

brand

  • id — integer — Primary key — NOT NULL — 브랜드
  • privacy_sharing_policy_id — integer — 제
  • company_name — character — NOT NULL — 법인명
  • brand_theme_authority — boolean — NOT NULL
  • monthly_settlement — boolean — NOT NULL
  • contract_supervision — boolean — NOT NULL
  • purchase_notifiable — boolean — NOT NULL

brand_logo_image

  • id — integer — Primary key — NOT NULL

brand_privacy_sharing_consent

  • brand_id — integer — Primary key — NOT NULL
  • user_id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • consented_at — timestamp
  • dissented_at — timestamp

brand_settlement

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • brand_id — integer — NOT NULL
  • year — integer — NOT NULL
  • month — integer — NOT NULL
  • entries — integer — NOT NULL

brand_theme

  • id — integer — Primary key — NOT NULL
  • brand_id — integer — NOT NULL
  • brand_theme_color — character — NOT NULL
  • brand_logo_id — integer

business_hour

  • id — integer — Primary key — NOT NULL
  • weekday_open_time — time
  • weekday_close_time — time
  • weekend_open_time — time
  • weekend_close_time — time

cancel_point_propagation

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • status — cancel_point_propagation_status — NOT NULL
  • approved_at — timestamp
  • place_id — integer — NOT NULL — 매장
  • approve_employee_id — integer
  • request_employee_id — integer — NOT NULL

card

  • id — integer — Primary key — NOT NULL
  • code — character
  • place_id — integer
  • created_at — timestamp — NOT NULL
  • user_id — integer — 고객
  • base_access_token — character — NOT NULL
  • started_at — timestamp
  • fakeid — integer

catalog

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL

checkin_alert_policy

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • manager_phone — character

checkin_customization_policy

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • checkin_message_url — character
  • checkin_button_label — character

checkin_policy

  • id — integer — Primary key — NOT NULL
  • default_type — checkin_type — NOT NULL

claim_policy

  • id — integer — Primary key — NOT NULL
  • discriminator — claim_policy_type — NOT NULL
  • points_rate_a — numeric — NOT NULL
  • points_rate_b — numeric — NOT NULL
  • default_point — integer — NOT NULL
  • updated_at — timestamp — NOT NULL
  • claim_cooldown_time — interval — NOT NULL
  • daily_max_purchases — integer
  • max_points_at_once — integer
  • front_save_button_disabled — boolean — NOT NULL
  • uses_staff_view — boolean — NOT NULL

closing_schedule

  • id — integer — Primary key — NOT NULL
  • monday — boolean — NOT NULL
  • tuesday — boolean — NOT NULL
  • wednesday — boolean — NOT NULL
  • thursday — boolean — NOT NULL
  • friday — boolean — NOT NULL
  • saturday — boolean — NOT NULL
  • sunday — boolean — NOT NULL
  • holiday — boolean — NOT NULL
  • etc_note — text

confirmed_notice

  • id — integer — Primary key — NOT NULL
  • notice_id — integer
  • place_id — integer
  • last_seen_at — timestamp

contract

  • id — integer — Primary key — NOT NULL — 계약
  • place_id — integer — NOT NULL — 매장
  • contracted_at — date — NOT NULL
  • expired_at — date — NOT NULL
  • contract_code — character
  • contract_type — character
  • contract_fee — integer — NOT NULL
  • install_fee — integer — NOT NULL
  • design_fee — integer — NOT NULL
  • contract_type_id — integer
  • sales_repr_id — integer — NOT NULL — 계약담당자
  • monthly_charge_amount — integer
  • applicant — character
  • business_trip_fee — integer — NOT NULL
  • commissioned — boolean — NOT NULL
  • machine_offer — character — NOT NULL
  • machine_type — character — NOT NULL
  • note — character
  • payment_method — payment_method_type — NOT NULL — 결제
  • recommend_benefit_detail — character
  • cms_mail — character
  • machine_fee — integer — NOT NULL
  • created_at — timestamp — NOT NULL — 계약
  • kr_reg_num — character — 사업자
  • documents_id — integer
  • initial_charge_amount — integer
  • entry_type — entry_type — NOT NULL — 인입
  • revision_id — integer — 현재
  • deleted_at — timestamp
  • contraction_subject — contraction_subject — NOT NULL — 계약

contract_document

  • id — integer — Primary key — NOT NULL
  • business_licence_id — integer
  • cms_form_id — integer
  • copy_of_bankbook_id — integer
  • cancellation_id — integer
  • contract_paper_id — integer

contract_document_image

  • id — integer — Primary key — NOT NULL

contract_page

  • id — integer — Primary key — NOT NULL
  • contract_id — integer
  • number — smallint — NOT NULL

contract_revision

  • id — integer — Primary key — NOT NULL — 계약
  • contract_id — integer — NOT NULL — 계약
  • created_at — timestamp — NOT NULL — 기록
  • contracted_at — date — NOT NULL — 계약
  • expired_at — date — NOT NULL — 계약
  • contract_type — character — 게약
  • applicant — character — 신청자

contract_sign

  • id — integer — Primary key — NOT NULL
  • sign_type — character — NOT NULL
  • number — smallint — NOT NULL
  • contract_id — integer — NOT NULL

contract_type

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — character

coupon

  • id — integer — Primary key — NOT NULL
  • name — character — 쿠폰
  • pictures — json — NOT NULL — 쿠폰
  • created_at — timestamp — NOT NULL
  • content — text — 쿠폰
  • data — json

coupon_charge

  • id — integer — Primary key — NOT NULL
  • place_id — integer — NOT NULL — 매장
  • count — integer — NOT NULL
  • comment — text — ext COLLATE pg_catalog."default
  • created_at — timestamp — NOT NULL
  • token — character

coupon_place_assoc

  • place_id — integer — Primary key — NOT NULL
  • coupon_id — integer — Primary key — NOT NULL

coupon_promotion

  • id — integer — Primary key — NOT NULL
  • coupon_id — integer — NOT NULL — 쿠폰
  • target — json
  • status — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • manager_id — integer
  • message_only — boolean
  • expired_at — date
  • started_at — date
  • start_time — integer
  • end_time — integer
  • page_view — integer
  • use_footer — boolean

coupon_promotion_allowed_place

  • place_id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • reason — character — NOT NULL

coupon_rule

  • id — integer — Primary key — NOT NULL
  • required — integer
  • place_id — integer — NOT NULL — 매장
  • coupon_id — integer
  • created_at — timestamp — NOT NULL
  • notification — boolean
  • criteria — character — NOT NULL

customer_customer_tag_assoc

  • customer_id — integer — Primary key — NOT NULL
  • customer_tag_id — integer — Primary key — NOT NULL

customer_tag

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — text
  • place_id — integer — NOT NULL — 매장

deleted_user

  • id — uuid — Primary key — NOT NULL
  • deleted_at — timestamp — NOT NULL
  • synced_at — timestamp

developer

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • base_access_token — character — NOT NULL
  • name — character
  • password — character — NOT NULL
  • email — character — NOT NULL
  • phone_number — character — NOT NULL
  • url — character
  • status — character

disallowed_manage_panel_menu

  • place_id — integer — Primary key — NOT NULL
  • name — character — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL

event_coupon_rule

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • duration — interval
  • place_id — integer — NOT NULL
  • coupon_id — integer
  • discriminator — event_coupon_rule_type — NOT NULL

fb_messenger_store

  • store_id — uuid — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • page_access_token — text — NOT NULL

image_library

  • id — integer — Primary key — NOT NULL
  • url — text
  • description — text

image_storage_collection

  • width — integer — Primary key — NOT NULL
  • height — integer — Primary key — NOT NULL
  • id — integer — Primary key — NOT NULL
  • mimetype — character — NOT NULL
  • original — boolean — NOT NULL
  • created_at — timestamp — NOT NULL

incremental_privacy_collection_policy

  • id — integer — Primary key — NOT NULL

install_repr

  • discriminator — install_repr_discriminator_type — Primary key — NOT NULL
  • repr_id — integer — Primary key — NOT NULL
  • contract_id — integer — Primary key — NOT NULL

item

  • id — integer — Primary key — NOT NULL
  • code — character
  • name — character
  • price — integer
  • created_at — timestamp — NOT NULL
  • catalog_id — integer — NOT NULL
  • point_aware — boolean — NOT NULL
  • replacing_id — integer

legacy_document

  • id — integer — Primary key — NOT NULL
  • business_licence — text
  • cms_form — text
  • copy_of_bankbook — text

legacy_reward_picture

  • id — integer — Primary key — NOT NULL
  • _picture — json — NOT NULL

legacy_theme

  • id — integer — Primary key — NOT NULL
  • pictures — json
  • dashboard — json
  • slides — json
  • place_theme_id — integer

line_at

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — text — NOT NULL

line_at_store

  • store_id — uuid — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • synced_at — timestamp — NOT NULL
  • channel_access_token — text
  • channel_id — text — NOT NULL
  • channel_secret — text — NOT NULL

linepay_uid

  • uid — character — Primary key — NOT NULL
  • place_id — integer — Primary key — NOT NULL — 매장
  • user_id — integer — NOT NULL — 고객
  • created_at — timestamp — NOT NULL

manager

  • id — integer — Primary key — NOT NULL — 계정
  • phone_number — character — 전화번호
  • password_hash — character
  • name — character — 이름
  • email — character — NOT NULL — 이메일
  • type — character — NOT NULL — 계정
  • place_id — integer
  • nickname — text — 닉네임
  • created_at — timestamp — 생성일
  • recent_virtual_login_ids — integer — NOT NULL
  • locale — character — NOT NULL — 지역(국가)
  • di — character
  • uuid — uuid — NOT NULL — 계정

marketing_event

  • id — integer — NOT NULL
  • name — text — NOT NULL
  • link_url — text — NOT NULL
  • button_name — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • start_at — timestamp — NOT NULL
  • expire_at — timestamp — NOT NULL
  • keyword — text
  • message_prefix — character
  • event_content — character

memo

  • place_id — integer — Primary key — NOT NULL — 매장
  • user_id — integer — Primary key — NOT NULL — 고객
  • memo — text — NOT NULL

message_log

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • users — json — NOT NULL
  • provider — text
  • format — character — NOT NULL
  • body — text
  • coupon_id — integer

mobile_notice

  • id — integer — Primary key — NOT NULL
  • title — text — NOT NULL
  • body — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • notice_type — character — NOT NULL
  • country — character — NOT NULL

new_category_tag

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — character
  • sequence — integer — NOT NULL
  • parent_id — integer
  • locale — character — NOT NULL

new_category_tag_assoc

  • place_id — integer — Primary key — NOT NULL
  • tag_id — integer — Primary key — NOT NULL

notice

  • id — integer — Primary key — NOT NULL
  • title — text — NOT NULL
  • body — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • place_id — integer
  • replied_id — integer
  • locale — character — NOT NULL

oauth_client

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — character — NOT NULL
  • description — character
  • client_id — character — NOT NULL
  • client_secret — character — NOT NULL
  • confidential — boolean — NOT NULL
  • manager_id — integer — NOT NULL
  • archived_at — timestamp
  • raw_default_scopes — text — NOT NULL

oauth_redirect_uri

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • uri — text — NOT NULL
  • description — character
  • client_id — integer — NOT NULL

one_shot_privacy_collection_policy

  • id — integer — Primary key — NOT NULL

opt_out_list

  • place_id — integer — Primary key — NOT NULL
  • user_id — integer — Primary key — NOT NULL

order

  • id — integer — Primary key — NOT NULL
  • place_id — integer — NOT NULL
  • price — integer
  • created_at — timestamp — NOT NULL
  • payment_method — character — NOT NULL
  • uuid — uuid

order_item

  • item_id — integer — Primary key — NOT NULL
  • order_id — integer — Primary key — NOT NULL
  • quantity — integer — NOT NULL
  • created_at — timestamp — NOT NULL

outsourcing_installation

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — character — NOT NULL

partner_feedback

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • place_id — integer
  • place_name — text
  • phone_number — character
  • positive_feedback — text
  • negative_feedback — text

partner_feedback_unsubscribe

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • phone_number — character — NOT NULL
  • reason — text

and 20 more tables