UK Ecommerce

Tables (4)

Customers (customers)

  • 고객 ID (customer_id) — string — Primary key — NOT NULL
  • 배송지 국가 (country) — string

Items (items)

  • 상품 ID (item_id) — string — Primary key — NOT NULL
  • 상품명 (name) — string

Order_items (order_items)

  • 상품 ID (item_id) — string — Foreign key → Items.상품 ID — NOT NULL
  • 거래 ID (order_id) — string — Foreign key → Orders.거래 ID — NOT NULL
  • 1개 당 가격 (price) — number
  • 수량 (quantity) — integer

Orders (orders)

  • 거래 ID (order_id) — string — Primary key — NOT NULL
  • 고객 ID (customer_id) — string — Foreign key → Customers.고객 ID — NOT NULL
  • 거래일 (order_date) — date