컬리_주연 연습장

테이블 (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