priv_erd

Tables (14)

admin_action_history

  • id — INT — Primary key — NOT NULL
  • created_at — DATETIME
  • INDEX — `fk_admin_operation_history_admin_manager1_idx`
  • admin_manager_id (id2) — INT — Foreign key → admin_manager.id — NOT NULL

admin_manager

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • privilege_level — VARCHAR(45)
  • email — VARCHAR(45)
  • password — VARCHAR(45)

affiliation (제휴사 관리)

  • id — INT — Primary key — NOT NULL
  • order — VARCHAR(45)
  • name — VARCHAR(45) — 제휴사 명
  • image_url — VARCHAR(45) — 제휴사 로고 이미지
  • registrant — VARCHAR(40) — 등록자
  • created_at — DATETIME — NOT NULL — 생성일
  • updated_at — DATETIME — NOT NULL — 최근 수정일

customer

  • mbr_id — VARCHAR(45) — Primary key — NOT NULL
  • wallet_address — VARCHAR(45) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • is_connected_wallet — TINYINT(4) — 지갑 연결 여부
  • uptn_rejoin_status — TINYINT(4) — Uptn 재가입여부
  • wallet_connected_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • level — TINYINT(4)

customer_action_history (고객 행동 히스토리)

  • id — INT — Primary key — NOT NULL
  • customer_mbr_id — VARCHAR(45)
  • customer_name — VARCHAR(45)
  • action_type — VARCHAR(45) — MOVE_PAGE,

event_participant (이벤트 참여 기록)

  • id — INT — Primary key — NOT NULL
  • event_type — VARCHAR(45)
  • status — VARCHAR(45)
  • created_at — VARCHAR(45)
  • updated_at — VARCHAR(45)
  • customer_mbr_id — VARCHAR(45) — NOT NULL
  • INDEX — `fk_event_participant_customer1_idx`

inventory

  • id — INT — Primary key — NOT NULL
  • episode_no — VARCHAR(45)
  • level — TINYINT(4)
  • category — VARCHAR(45)
  • location — VARCHAR(45)
  • is_combined — VARCHAR(45)
  • status — VARCHAR(45) — 아이템 장착여부
  • item_id — INT — Foreign key → tem.id — NOT NULL

notice (공지 롤업팝업)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(45)
  • image_url — VARCHAR(45)
  • is_visible — VARCHAR(45)
  • start_at — VARCHAR(45)
  • end_at — VARCHAR(45)
  • order — INT(4)
  • created_at — VARCHAR(45)
  • updated_at — VARCHAR(45)
  • registrant — VARCHAR(45)

policy

  • version — INT — Primary key — NOT NULL
  • type — VARCHAR(45) — Primary key — NOT NULL — 약관, 이용정책, 유의사항
  • is_visible — VARCHAR(45)
  • title — VARCHAR(45)
  • content — TEXT
  • modifier — VARCHAR(45)
  • created_at — VARCHAR(45)
  • updated_at — VARCHAR(45)

product

  • id — INT — Primary key — NOT NULL
  • expire_start_at — VARCHAR(45)
  • expire_end_at — VARCHAR(45)
  • items — VARCHAR(45)
  • use_count — VARCHAR(45) — 사용횟수
  • count — VARCHAR(45) — 민팅갯수

reward_history ((임시))

  • id — INT — Primary key — NOT NULL

shop_banner (템상점 전시관리)

  • id — INT — Primary key — NOT NULL
  • order — VARCHAR(45)
  • title — VARCHAR(45)
  • product_id — INT — Foreign key → product.id — NOT NULL
  • description — 설명1. 2

tem

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • description — VARCHAR(45)
  • image_url — VARCHAR(45)
  • position — VARCHAR(45)
  • category — VARCHAR(45)
  • is_benefit — VARCHAR(45)
  • coupon_start_at — DATETIME
  • coupon_end_at — DATETIME
  • episode_no — VARCHAR(45)

win_history ((임시2))

  • id — INT — Primary key — NOT NULL