ㅅㄷㄴㅅ
Tables (5)
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
- product_price_id — INT — NOT NULL
Orders
- order_id — INT
- customer_id — INT — NOT NULL
- order_date — DATETIME — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
Product_Prices
- product_price_id — INT
- product_id — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- effective_date — DATE — NOT NULL
Products
- product_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL