NBE5-6-1-Team04 Public 1차 프로젝트 커피 ERD

테이블 (9)

cart

  • cart_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → user.user_id — NOT NULL

cart_item

  • cart_item_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • cart_id — bigint — 외래 키 → cart.cart_id — NOT NULL
  • product_count — int

delivery

  • delivery_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → order.order_id — NOT NULL
  • delivery_status — varchart(50)
  • delivery_expected_date — timestamp

order

  • order_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → user.user_id — NOT NULL
  • order_count — int — NOT NULL
  • total_price — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • order_status — varchar(50)
  • order_address — varchar(50)

order_item

  • order_item_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → order.order_id — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • order_count — int — NOT NULL

payment

  • payment_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → order.order_id — NOT NULL
  • payment_price — int
  • create_at — timestamp

product

  • product_id — bigint — 기본 키 — NOT NULL
  • product_name — varchar(100) — NOT NULL — GIN IDX (TRIGRAM)
  • price — int — NOT NULL
  • description — varchar(100)
  • stock — int — NOT NULL — GIN IDX
  • created_at — timestamp — NOT NULL

product_image

  • product_image_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.product_id — NOT NULL
  • type — varchar(50)
  • image_name (name) — varchar(50)

user

  • user_id — varchar(50) — 기본 키 — NOT NULL
  • password — varchar(100)
  • name — varchar(50)
  • address — varchar(300)
  • email — varchar(100) — NOT NULL
  • role — varchar(50) — NOT NULL — GIN IDX
  • created_at — timestamp — NOT NULL