order
Tables (8)
cart_item
- id — BIGINT — Primary key — NOT NULL
- quantity — INT
- product_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
coupon
- id — BIGINT — Primary key — NOT NULL
- coupon_name — VARCHAR
- discount_type — VARCHAR
- value — DECIMAL(10,3)
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR
- password — VARCHAR
member_coupon
- id — BIGINT — Primary key — NOT NULL
- is_used — BOOLEAN
- member_id — BIGINT — NOT NULL
- coupon_id — BIGINT — NOT NULL
order_coupon
- id — BIGINT — Primary key — NOT NULL
- coupon_name — VARCHAR
- discount_amount — INT
- orders_id — BIGINT — NOT NULL
- member_coupon_id — BIGINT — NOT NULL
order_item
- id — BIGINT — Primary key — NOT NULL
- product_name — VARCHAR
- price — INT
- image_url — VARCHAR
- quantity — INT
- orders_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
orders
- id — BIGINT — Primary key — NOT NULL
- original_price — INT
- actual_price — INT
- delivery_fee — INT
- member_id — BIGINT — NOT NULL
product
- id — BIGINT — Primary key — NOT NULL
- product_name — VARCHAR
- price — INT
- image_url — VARCHAR