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