쇼핑몰

테이블 (8)

Cart

  • cart_id (Key) — Integer — 기본 키 — NOT NULL
  • quantity (Field) — Integer

Category

  • category_id — Integer — 기본 키 — NOT NULL
  • name — Varchar

Customer

  • customer_id — Integer — 기본 키 — NOT NULL
  • first_name — Varchar
  • last_name — Varchar
  • email — Varchar
  • password — Varchar
  • address — Varchar
  • phone_number — Varchar

Order

  • order_id — Integer — 기본 키 — NOT NULL
  • order_date — DateTime
  • total_price — Decimal

Order_Item

  • order_item_id — Integer — 기본 키 — NOT NULL
  • quantity (Field) — Integer
  • price (Field2) — Decimal

Payment

  • payment_id — Integer — 기본 키 — NOT NULL
  • payment_date — DateTime
  • payment_method — Varchar
  • amount — Decimal

Product

  • product_id — Integer — 기본 키 — NOT NULL
  • SKU — Varchar
  • description — Varchar
  • price — Decimal
  • stock — Integer

Wishlist

  • wishlist_id (Key) — Integer — 기본 키 — NOT NULL