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