dodopoint
Tables (34)
activity (활동기록)
- id (활동 id) — Primary key — NOT NULL
- event_discriminator (이벤트종류)
- event_id (이벤트id)
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- user_id (고객정보 id) — Foreign key → user.id — NOT NULL
- points (변경포인트)
brand (브랜드매장)
- id (매장 id) — Foreign key → place.id — NOT NULL
card (카드)
- id (카드 id) — Primary key — NOT NULL
- user_id (고객정보 id) — Foreign key → user.id — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
catalog (카탈로그)
- id (카탈로그id) — Primary key — NOT NULL
claim_policy (포인트적립정책)
- id (매장 id) — Foreign key → place.id — NOT NULL
contract (계약)
- id (계약 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- manager_id (매니저 id) — Foreign key → manager.id — NOT NULL
contract_revision (매장계약변경기록)
- id (계약변경id) — Primary key — NOT NULL
- contract_id (계약 id) — Foreign key → contract.id — NOT NULL
coupon (쿠폰)
- id (쿠폰 id) — Primary key — NOT NULL
coupon_place_assoc (쿠폰매장매핑)
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- coupon_id (쿠폰 id) — Foreign key → coupon.id — NOT NULL
coupon_promotion (프로모션쿠폰)
- id (프로모션쿠폰id) — Primary key — NOT NULL
- coupon_id (쿠폰 id) — Foreign key → coupon.id — NOT NULL
customer_tag (고객그룹)
- id (고객그룹id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
item (상품)
- id (상품id) — Primary key — NOT NULL
manager (매니저)
- id (매니저 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- type (계정타입) — employee, partner, lead
memo (메모)
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- user_id (고객정보 id) — Foreign key → user.id — NOT NULL
- memo (메모)
message_log (쿠폰메시지로그)
- id (메시지로그id) — Primary key — NOT NULL
- couopon_id (쿠폰 id) — Foreign key → coupon.id — NOT NULL
- users (유저목록(json)) — 쿠폰메시지 전송한 유저들 목록
notice (공지사항)
- id (공지사항id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
order (주문)
- id (주문id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- catalog_id (카탈로그id) — Foreign key → catalog.id — NOT NULL
order_item (주문상품)
- order_id (주문id) — Foreign key → order.id — NOT NULL
- item_id (상품id) — Foreign key → item.id — NOT NULL
phone_account (고객전화번호)
- id (고객전화번호 id) — Primary key — NOT NULL
- user_id (고객정보 id) — Foreign key → user.id — NOT NULL
place (매장)
- id (매장 id) — Primary key — NOT NULL
- parent_id (상위 매장 id) — Foreign key → place.id — NOT NULL
- name (매장명)
- tier_policy_id (고객등급정책id) — Foreign key → tier_policy.id — NOT NULL
place_device (매장 기기정보)
- id (매장기기정보 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
place_tag_assoc (매장-태그)
- tag_id (태그id) — Foreign key → tag.id — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
point (포인트)
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- receiver_id (고객정보 id) — Foreign key → user.id — NOT NULL
promotion (프로모션)
- id (프로모션id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
purchase (매출적립)
- id (매출적립 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- receiver_id (고객정보 id) — Foreign key → user.id — NOT NULL
received_coupon (수신쿠폰)
- id (수신쿠폰id) — Primary key — NOT NULL
- coupon_id (쿠폰 id) — Foreign key → coupon.id — NOT NULL
- user_id (고객정보 id) — Foreign key → user.id — NOT NULL
reward (매장 리워드)
- id (매장리워드 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
store (개인매장)
- id (매장 id) — Foreign key → place.id — NOT NULL
- Field
tag (태그정보)
- id (태그id) — Primary key — NOT NULL
- type (태그타입) — 지역분류, 카테고리, 행정구역
tier (고객등급)
- tier_level (등급레벨) — Primary key — NOT NULL
- tier_policy_id (고객등급정책id) — Foreign key → tier_policy.id — NOT NULL
tier_policy (고객등급정책)
- id (고객등급정책id) — Primary key — NOT NULL
usage (사용정보)
- id (사용정보id) — Primary key — NOT NULL
- group_id (사용정보그룹 id) — Foreign key → useage_group.id — NOT NULL
- reward_id (매장리워드 id) — Foreign key → reward.id — NOT NULL
- coupon_id (쿠폰 id) — Foreign key → coupon.id — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- receiver_id (고객정보 id) — Foreign key → user.id — NOT NULL
useage_group (리워드/쿠폰 사용정보그룹)
- id (사용정보그룹 id) — Primary key — NOT NULL
- place_id (매장 id) — Foreign key → place.id — NOT NULL
- receiver_id (고객정보 id) — Foreign key → user.id — NOT NULL
user (고객정보)
- id (고객정보 id) — Primary key — NOT NULL