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