ecommerce_advanced

Tables (7)

categories

  • 카테고리ID (category_id) — INT64 — Primary key — NOT NULL
  • 카테고리이름 (category_name) — STRING — NOT NULL
  • 상위카테고리ID (parent_category_id) — INT64

order_items

  • 주문항목ID (order_item_id) — INT64 — Primary key — NOT NULL
  • 주문ID (order_id) — INT64 — Foreign key → orders.주문ID — NOT NULL
  • 제품ID (product_id) — INT64 — Foreign key → products.제품ID — NOT NULL
  • 주문수량 (quantity) — INT64 — NOT NULL
  • 단위가격 (price_per_unit) — NUMERIC — NOT NULL
  • 할인금액 (discount) — NUMERIC

orders

  • 주문ID (order_id) — INT64 — Primary key — NOT NULL
  • 회원ID (user_id) — INT64 — Foreign key → users.회원ID — NOT NULL
  • 주문일 (order_date) — TIMESTAMP — NOT NULL
  • 주문총금액 (total_amount) — NUMERIC — NOT NULL
  • 결제방법 (payment_method) — STRING
  • 주문상태 (order_status) — STRING — NOT NULL

products

  • 제품ID (product_id) — INT64 — Primary key — NOT NULL
  • 공급업체ID (supplier_id) — INT64 — Foreign key → suppliers.공급업체ID — NOT NULL
  • 카테고리ID (category_id) — INT64 — Foreign key → categories.카테고리ID — NOT NULL
  • 제품이름 (product_name) — STRING — NOT NULL
  • 제품가격 (price) — NUMERIC — NOT NULL
  • 재고수량 (stock_quantity) — INT64 — NOT NULL
  • 제품등록일자 (added_date) — DATE — NOT NULL

reviews

  • 리뷰ID (review_id) — INT64 — Primary key — NOT NULL
  • 제품ID (product_id) — INT64 — Foreign key → products.제품ID — NOT NULL
  • 회원ID (user_id) — INT64 — Foreign key → users.회원ID — NOT NULL
  • 평점 (rating) — INT64 — NOT NULL
  • 리뷰내용 (review_text) — STRING
  • 리뷰작성시간 (review_date) — TIMESTAMP — NOT NULL

suppliers

  • 공급업체ID (supplier_id) — INT64 — Primary key — NOT NULL
  • 공급업체이름 (supplier_name) — STRING — NOT NULL
  • 연락담당자 (contact_person) — STRING
  • 연락이메일 (contact_email) — STRING
  • 공급업체국가 (country) — STRING

users

  • 회원ID (user_id) — INT64 — Primary key — NOT NULL
  • 등록날짜 (registration_date) — DATE — NOT NULL
  • 회원유형 (user_type) — STRING — NOT NULL
  • 거주도시 (city) — STRING
  • 거주국가 (country) — STRING