쇼핑몰
테이블 (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