ecommerce_db

테이블 (4)

oder_details (products)

  • order_id — NOT NULL — 기본 키 — NOT NULL
  • product_id — NOT NULL — 기본 키 — NOT NULL
  • order_detail_id — NOT NULL
  • quantity (Field) — NOT NULL
  • price (Field2) — NOT NULL

order_details (Untitled)

  • product_id (Key2) — NOT NULL — 기본 키 — NOT NULL
  • product_name (Field) — NOT NULL
  • category_id (Field2) — NOT NULL
  • price (Field3) — NOT NULL
  • Field4

orders

  • order_id — NOT NULL — 기본 키 — NOT NULL
  • customer_id (Key) — NOT NULL — 기본 키 — NOT NULL
  • order_date — NOT NULL
  • status — NOT NULL
  • region — NOT NULL

음악 (music)

  • 음악고유식별자 (music_id) — INT — 기본 키 — NOT NULL
  • Field