teest

Tables (50)

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