X3
Tables (15)
CTA analysis (CopyOfCopyOfnotifications2)
- id (Key) — INTEGER — Primary key — NOT NULL
- event_id (Key22) — INTEGER — Foreign key → event (cart & order & favorite).id — NOT NULL
- view_id (Key23) — INTEGER — Foreign key → view.id — NOT NULL
- view_log_id (Key2) — INTEGER — Foreign key → view_log.id
asset analysis (CopyOfCopyOfCopyOfnotifications2)
- id (Key) — INTEGER — Primary key — NOT NULL
- event_id (Key22) — INTEGER — Foreign key → event (cart & order & favorite).id — NOT NULL
- view_id (Key23) — INTEGER — Foreign key → view.id — NOT NULL
audience_group (Untitled4)
- Key — INTEGER — Primary key — NOT NULL
- name (Field2) — varchar — NOT NULL
- type (Field) — varchar — NOT NULL
- user_count (Field3) — integer — NOT NULL
campaign (CopyOfCopyOfnotifications)
- id (Key5) — INTEGER — Primary key — NOT NULL
- user_id (Key3) — INTEGER — Foreign key → user.id — NOT NULL
- product_id (Key2) — INTEGER — Foreign key → product.id — NOT NULL
- audience_group_id (Key4) — INTEGER — Foreign key → audience_group.Key — NOT NULL
- name (Field3) — VARCHAR — NOT NULL
- type (FK) — varchar — NOT NULL — performance, aware, click, etc..
- landing_url (Field) — varchar — 미수신 시 재알림 or 광고 피로 계산
- asset_image (Field2) — varchar — 장기간 미수신 시 drop
category (CopyOfUntitled24)
- id (Key) — INTEGER — Primary key — NOT NULL
- name (Field) — varchar — NOT NULL
- creative_datetime (Field2) — TIMESTAMP — NOT NULL
- update_datetime (Field3) — TIMESTAMP — NOT NULL
event (cart & order & favorite) (CopyOfCopyOfCopyOfCopyOfUntitled24)
- id (Key2) — INTEGER — Primary key — NOT NULL
- user_id (Key3) — INTEGER — Foreign key → user.id — NOT NULL
- product_id (Key) — INTEGER — Foreign key → product.id — NOT NULL
- state (Field6) — varchar — NOT NULL — 현재 상태 (장바구니, 구매완료, 선호)
- quantity (Field3) — integer — NOT NULL
- price (Field4) — integer — NOT NULL
- discount (Field5) — integer
- create_datetime (Field) — timestamp — NOT NULL
- update_datetime (Field2) — timestamp — 재구매 주기, 장바구니 상품 프로모션 등
- campaign_id (Key5) — INTEGER — Foreign key → campaign.id
notifications
- id (Key) — INTEGER — Primary key — NOT NULL
- event_id (Key2) — INTEGER — Foreign key → event (cart & order & favorite).id — NOT NULL
- type (FK) — varchar — NOT NULL — 어떤 종류의 알림인지 (재구매 유도, 프로모션, 품절 임박 등)
- is_reached (Field) — BOOL — NOT NULL — 미수신 시 재알림 or 광고 피로 계산
- create_datetime (Field2) — timestamp — NOT NULL — 장기간 미수신 시 drop
product (CopyOfUntitled22)
- id (Key) — INTEGER — Primary key — NOT NULL
- category_id (Key2) — INTEGER — Foreign key → category.id — NOT NULL
- seller_id (Key3) — INTEGER — Foreign key → seller.id — NOT NULL
- name (Field3) — varchar — NOT NULL
- url (Field9) — varchar — NOT NULL
- price (Field) — integer — NOT NULL
- state (Field2) — varchar — NOT NULL — 판매중, 품절, 판매 정지, 할인 중
- thumb (Field4) — varchar — NOT NULL
- product_image (Field5) — varchar — NOT NULL
- view_count (Field6) — integer — NOT NULL
- create_datetime (Field7) — timestamp — NOT NULL
- update_datetime (Field8) — timestamp
refund (Untitled)
- id (Key2) — INTEGER — Foreign key → event (cart & order & favorite).id — NOT NULL
- is_refund (Field) — BOOL — NOT NULL
reviews (sale_reviews)
- id (Key) — INTEGER — Primary key — NOT NULL
- event_id (Key2) — INTEGER — Foreign key → event (cart & order & favorite).id — NOT NULL
- star (FK3) — INTEGER — NOT NULL
- text (Field2) — VARCHAR
seller (CopyOfCopyOfUntitled24)
- id (Key) — INTEGER — Primary key — NOT NULL
- seller_company_id (Key2) — INTEGER — Foreign key → seller_company.id — NOT NULL
- name (Field) — VARCHAR — NOT NULL
- gender (Field3) — VARCHAR
- phone_number (Field2) — VARCHAR
seller_company (CopyOfCopyOfCopyOfCopyOfUntitled242)
- id (Key) — INTEGER — Primary key — NOT NULL
- name (Field) — STRING — NOT NULL
- company_number (Field3) — STRING — NOT NULL
- company_regist_number (Field4) — STRING — NOT NULL
- first_resist_datetime (Field5) — STRING
user (Untitled2)
- id (Key) — INTEGER — Primary key — NOT NULL
- name (Field) — VARCHAR — NOT NULL
- gender (Field2) — VARCHAR — NOT NULL
- e-mail (Field7) — VARCHAR
- address (Field3) — VARCHAR — NOT NULL
- phone_number (Field4) — VARCHAR — NOT NULL
- first_visit_datetime (Field6) — timestamp — NOT NULL — 첫 방문 고객, 재방문 고객 이탈율 등
- last_visit_datetime (Field5) — timestamp — NOT NULL — 첫 방문 고객, 재방문 고객 이탈율 등
- update_datetime (Field8) — timestamp
- is_active (Field9) — BOOL — NOT NULL
- interest (Field10) — varchar — 가입 시 선택 or 유입경로
- audience_group_id (Key2) — INTEGER — Foreign key → audience_group.Key
view (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled24)
- id (Key2) — INTEGER — Primary key — NOT NULL
- user_id (Key3) — INTEGER — Foreign key → user.id — NOT NULL
- product_id (Key) — INTEGER — Foreign key → product.id — NOT NULL
- search_keyword (Field) — varchar — 유입 시 검색한 키워드
- duration_start (Field3) — integer — NOT NULL
- first_view_datetime (Field5) — timestamp — NOT NULL
- last_view_datetime (Field4) — timestamp — NOT NULL
- entry_source (Field2) — varchar — organic, dv360_da, dv360_yt, ga_sa)
- entry_medium (Field7) — varchar — da, sa, video, youtube, app
- entry_creative (Field8) — varchar — 소재 id
- campaign_id (Key5) — INTEGER — Foreign key → campaign.id
view_log (Untitled3)
- id (Key) — INTEGER — Primary key — NOT NULL
- view_id (Key2) — INTEGER — Foreign key → view.id — NOT NULL
- type (Field) — varchar — NOT NULL — 행동 분류 (마우스 포커스, 스크롤 등)