LYNQ

테이블 (13)

channel_product_variants

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_product_id — BIGINT — 외래 키 → channel_products.id — NOT NULL — 상품ID
  • external_variant_code — VARCHAR(100) — NOT NULL — 외부
  • manage_code — VARCHAR(100) — 판매자
  • option_summary — VARCHAR(255) — NOT NULL — 옵션
  • option_values — JSON — 옵션축
  • is_default_variant — BOOLEAN — NOT NULL — 기본상품
  • sale_status — VARCHAR(50) — 판매상태(SELLING
  • image_url — VARCHAR(500) — 품목
  • image_source — VARCHAR(30) — 이미지
  • raw_data — JSON — 채널
  • synced_at — TIMESTAMP — 동기화일시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

channel_products

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_connection_id — BIGINT — 외래 키 → sales_channel_connections.id — NOT NULL — 채널연동ID
  • external_product_no — VARCHAR(100) — NOT NULL — 외부
  • external_product_code — VARCHAR(100) — 외부
  • product_name — VARCHAR(255) — NOT NULL — 상품명
  • product_status — VARCHAR(50) — 상품상태(SELLING
  • main_image_url — VARCHAR(500) — 대표
  • raw_data — JSON — 채널
  • synced_at — TIMESTAMP — 동기화일시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

consumer_identities

  • id — BIGINT
  • phone_hash — VARCHAR(128) — NOT NULL — 전화번호
  • verified_at — TIMESTAMP — 본인인증
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)

consumers

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • consumer_identity_id — BIGINT — 외래 키 → consumer_identities.id — 글로벌
  • name — VARCHAR(100) — 고객명(개인정보)
  • phone — VARCHAR(50) — 연락처(개인정보)
  • email — VARCHAR(255) — 이메일(개인정보)
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

order_items

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • order_id — BIGINT — 외래 키 → orders.id — NOT NULL — 주문ID
  • channel_product_id — BIGINT — 외래 키 → channel_products.id — 매칭된
  • channel_product_variant_id — BIGINT — 외래 키 → channel_product_variants.id — 매칭된
  • external_product_no — VARCHAR(100) — 외부
  • external_product_code — VARCHAR(100) — 외부
  • external_variant_code — VARCHAR(100) — 외부
  • product_name_snapshot — VARCHAR(255) — NOT NULL — 상품명
  • option_summary_snapshot — VARCHAR(255) — 옵션
  • quantity — INT — NOT NULL — 수량
  • match_status — VARCHAR(30) — NOT NULL — 상품매칭상태(MATCH_PENDING
  • warranty_status — VARCHAR(30) — NOT NULL — 보증서상태(NOT_ELIGIBLE
  • raw_data — JSON — 채널
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

orders

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_connection_id — BIGINT — 외래 키 → sales_channel_connections.id — NOT NULL — 채널연동ID
  • consumer_id — BIGINT — 외래 키 → consumers.id — 고객ID
  • external_order_no — VARCHAR(100) — NOT NULL — 채널
  • buyer_name — VARCHAR(100) — 구매자명(개인정보)
  • buyer_phone — VARCHAR(50) — 구매자
  • order_status — VARCHAR(50) — NOT NULL — 주문상태(ORDER_PLACED
  • ordered_at — TIMESTAMP — 주문일시
  • paid_at — TIMESTAMP — 결제일시
  • delivered_at — TIMESTAMP — 배송완료일시
  • raw_data — JSON — 채널
  • synced_at — TIMESTAMP — 동기화일시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

product_images

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_product_id — BIGINT — 외래 키 → channel_products.id — 상품ID
  • channel_product_variant_id — BIGINT — 외래 키 → channel_product_variants.id — 품목ID
  • image_type — VARCHAR(30) — NOT NULL — 이미지유형(MAIN
  • image_url — VARCHAR(500) — NOT NULL — 이미지
  • sort_order — INT — NOT NULL — 정렬순서
  • is_thumbnail — BOOLEAN — NOT NULL — 썸네일
  • synced_at — TIMESTAMP — 동기화일시
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

sales_channel_connections

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_type — VARCHAR(50) — NOT NULL — 채널유형(CAFE24
  • channel_name — VARCHAR(100) — NOT NULL — 채널명
  • external_shop_id — VARCHAR(100) — 외부
  • external_shop_name — VARCHAR(100) — 외부
  • status — VARCHAR(30) — NOT NULL — 연동상태(CONNECTED
  • access_token_encrypted — TEXT — 액세스토큰(암호화
  • refresh_token_encrypted — TEXT — 리프레시토큰(암호화
  • token_expires_at — TIMESTAMP — 토큰
  • last_synced_at — TIMESTAMP — 최근
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

users

  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL — 이메일(로그인ID)
  • password_hash — VARCHAR(255) — NOT NULL — 비밀번호
  • name — VARCHAR(100) — NOT NULL — 이름
  • role — VARCHAR(30) — NOT NULL — 권한(BRAND_ADMIN
  • status — VARCHAR(30) — NOT NULL — 상태(ACTIVE
  • last_login_at — TIMESTAMP — 최근
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)

warranties

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • order_item_id — BIGINT — 외래 키 → order_items.id — NOT NULL — 주문상품ID(1:1
  • consumer_id — BIGINT — 외래 키 → consumers.id — 고객ID
  • warranty_policy_id — BIGINT — 외래 키 → warranty_policies.id — 적용
  • warranty_no — VARCHAR(100) — NOT NULL — 보증서
  • issue_type — VARCHAR(30) — NOT NULL — 발급유형(AUTO
  • status — VARCHAR(30) — NOT NULL — 상태(ISSUED
  • issued_at — TIMESTAMP — NOT NULL — 발급일시
  • started_at — TIMESTAMP — NOT NULL — 보증
  • expired_at — TIMESTAMP — NOT NULL — 보증
  • warranty_period_months — INT — NOT NULL — 보증기간(개월)
  • warranty_link — VARCHAR(500) — 보증서
  • product_name_snapshot — VARCHAR(255) — NOT NULL — 상품명
  • option_summary_snapshot — VARCHAR(255) — 옵션
  • product_image_url_snapshot — VARCHAR(500) — 상품
  • buyer_name_snapshot — VARCHAR(100) — 구매자명
  • buyer_phone_snapshot — VARCHAR(50) — 구매자
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

warranty_histories

  • id — BIGINT
  • warranty_id — BIGINT — 외래 키 → warranties.id — NOT NULL — 보증서ID
  • action_type — VARCHAR(50) — NOT NULL — 행위유형(AUTO_ISSUED
  • before_status — VARCHAR(30) — 변경
  • after_status — VARCHAR(30) — 변경
  • reason — VARCHAR(255) — 사유
  • actor_type — VARCHAR(30) — NOT NULL — 행위자
  • actor_id — BIGINT — 행위자ID
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • Key — 외래 키 — NOT NULL
  • Key2 — 외래 키 — NOT NULL
  • Key (Key22) — 외래 키 — NOT NULL
  • Physical Name (Logical Name) — Type — 외래 키 — NOT NULL

warranty_policies

  • id — BIGINT
  • brand_id — BIGINT — 외래 키 → 브랜드.brand_id — NOT NULL — 소속
  • channel_connection_id — BIGINT — 외래 키 → sales_channel_connections.id — 적용
  • channel_product_id — BIGINT — 외래 키 → channel_products.id — 적용
  • channel_product_variant_id — BIGINT — 외래 키 → channel_product_variants.id — 적용
  • policy_scope — VARCHAR(30) — NOT NULL — 정책
  • issue_mode — VARCHAR(30) — NOT NULL — 발급방식(AUTO
  • issue_timing_status — VARCHAR(30) — 자동발급
  • issue_timing_delay_days — INT — NOT NULL — 발급
  • warranty_period_months — INT — NOT NULL — 보증기간(개월)
  • product_name_display_type — VARCHAR(30) — NOT NULL — 상품명
  • use_product_image — BOOLEAN — NOT NULL — 상품
  • use_option_info — BOOLEAN — NOT NULL — 옵션
  • use_detail_info — BOOLEAN — NOT NULL — 상세
  • is_active — BOOLEAN — NOT NULL — 활성화
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)
  • Physical Name (Logical Name) — Type — 외래 키 → 브랜드.Physical Name — NOT NULL

브랜드 (brands)

  • Physical Name (Logical Name) — Type — 기본 키
  • brand_id (브랜드ID) — BIGINT
  • name — VARCHAR(100) — NOT NULL — 브랜드명
  • logo_url — VARCHAR(500) — 로고
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시(소프트삭제)