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