SYC Digitalization

Tables (8)

SNS (소셜미디어정보)

  • date (작성일시) — date
  • id (작성자 식별코드) — str
  • contents (내용) — str
  • image_url (이미지 주소) — str

competitors (온라인 채널 상품)

  • data_source (검색 source) — str
  • channel_name (온라인몰 이름) — str
  • category_name (카테고리) — str
  • product_name (상품명) — str
  • product_volume (규격) — str
  • product_price (기격) — int
  • product_img (이미지 URL) — str

food_ingredients (외식 레시피)

  • food_name (음식명) — str
  • food_img (음식 이미지 주소) — str
  • ingredient (식재정보) — obj

log (웹페이지 행동 정보)

  • user_code (회원고유번호) — str — Foreign key → user.user_code — NOT NULL

product (상품 정보)

  • product_code (상품고유번호) — str — Primary key — NOT NULL
  • product_name (상품명) — str
  • category_code (분류코드) — int
  • category_name (분류명) — str
  • product_volume (규격) — str
  • product_price (가격) — int
  • product_img (상품이미지 URL) — str
  • product_status (판매상태) — int

purchasement (구매정보)

  • purchase_code (구매고유번호) — str — Primary key — NOT NULL
  • user_code (회원고유번호) — str — Foreign key → user.user_code — NOT NULL
  • product_code (상품고유번호) — str — Foreign key → product.product_code — NOT NULL
  • purchase_time (구매발생일시) — date

review (후기 정보)

  • review_code (리뷰번호) — str — Primary key — NOT NULL
  • purchase_code (구매고유번호) — str — Foreign key → purchasement.purchase_code — NOT NULL
  • user_code (회원고유번호) — str — Foreign key → purchasement.user_code — NOT NULL
  • product_code (상품고유번호) — str — Foreign key → purchasement.product_code — NOT NULL
  • review_content (리뷰내용) — str
  • rating (평점) — int
  • review_created (리뷰생성일시) — date

user (고객 정보)

  • user_code (회원고유번호) — str — Primary key — NOT NULL
  • user_type (고객경로) — int
  • user_size (매출규모) — int
  • user_created (회원가입일시) — date