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