컬리_주연 연습장
테이블 (6)
CART
- cart_id — bigint — 기본 키 — NOT NULL
- customer_id — VARCHAR(50) — 외래 키 → CUSTOMER.customer_id — NOT NULL
- product_id — bigint — 외래 키 → PRODUCT.product_id — NOT NULL
- cart_num — int
- product_buy — boolean
COUPON
- coupon_id — int — 기본 키 — NOT NULL
- coupon_discount — int
COUPON_CUSTOMER
- customer_id — VARCHAR(50) — 외래 키 → CUSTOMER.customer_id — NOT NULL
- coupon_id — int — 외래 키 → COUPON.coupon_id — NOT NULL
CUSTOMER
- customer_id — VARCHAR(50) — 기본 키 — NOT NULL
- customer_pw — VARCHAR(255)
- customer_grade — VARCHAR(255)
- total_spent — BIGINT
- point — INT
- address — VARCHAR(255)
- phone_num — varchar(50)
PAYMENT
- order_id — VARCHAR(50) — 기본 키 — NOT NULL
- cart_id — bigint — 외래 키 → CART.cart_id — NOT NULL
- customer_id — VARCHAR(50) — 외래 키 → CART.customer_id — NOT NULL
- product_id (product_id2) — bigint — 외래 키 → CART.product_id — NOT NULL
- or_product_id — VARCHAR(50)
- order_date — datetime
- order_state — boolean
- or_product_num — INT
- total_price — BIGINT
PRODUCT
- product_id — bigint — 기본 키 — NOT NULL
- product_name — varchar(30)
- product_category — varchar(15)
- product_num — INT
- product_price — BIGINT — NOT NULL