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