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 — 행동 분류 (마우스 포커스, 스크롤 등)