202410_산대111
테이블 (4)
Customers
- customer_id — INT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20)
- address — VARCHAR(255)
Order_Details
- order_detail_id — INT
- order_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10, 2) — NOT NULL
Orders
- order_id — INT
- customer_id — INT — NOT NULL
- order_date — DATETIME — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
Products
- product_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock_quantity — INT — NOT NULL