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