red

Tables (10)

Cart

  • cart_id — INT — Primary key
  • user_id — VARCHAR(50) — Foreign key → Users.user_id — NOT NULL
  • created_at — DATETIME

CartItem

  • cart_item_id — INT — Primary key
  • cart_id — INT — Foreign key → Cart.cart_id — NOT NULL
  • product_id — INT — Foreign key → Products.product_id — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

Categories

  • category_id — INT — Primary key
  • category_name — VARCHAR(50) — NOT NULL
  • sort_order — INT — NOT NULL

Order_Details

  • detail_id — INT — Primary key
  • order_id — INT — Foreign key → Orders.order_id
  • product_id — INT — Foreign key → Products.product_id
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL

Orders

  • order_id — INT — Primary key
  • order_number — VARCHAR(50) — NOT NULL
  • order_status — VARCHAR(50)
  • user_id — VARCHAR(50) — Foreign key → Users.user_id
  • total_amount — INT — NOT NULL
  • saved_point — INT — NOT NULL
  • ordered_at — DATETIME

Point_History

  • history_id — INT — Primary key
  • user_id — VARCHAR(50) — Foreign key → Users.user_id
  • amount — INT — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • created_at — DATETIME

Product_Category

  • pc_id — INT — Primary key
  • product_id — INT — Foreign key → Products.product_id
  • category_id — INT — Foreign key → Categories.category_id

Products

  • product_id — INT — Primary key
  • product_name — VARCHAR(200) — NOT NULL
  • product_price — INT — NOT NULL
  • product_stock — INT — NOT NULL
  • thumb_image — VARCHAR(500)
  • detail_image — VARCHAR(500)

User_Addresses

  • address_id — INT — Primary key
  • user_id — VARCHAR(50) — Foreign key → Users.user_id
  • address_detail — VARCHAR(500) — NOT NULL

Users

  • user_id — varchar(50) — Primary key — NOT NULL — 아이디
  • user_name — varchar(50) — NOT NULL — 이름
  • user_password — varchar(200) — NOT NULL — mysql password 사용
  • user_birth — varchar(8) — NOT NULL — 생년월일 : 19840503
  • user_auth — varchar(10) — NOT NULL — 권한: ROLE_ADMIN,ROLE_USER
  • user_point — int — NOT NULL — default : 1000000
  • created_at — datetime — NOT NULL — 가입 일자
  • latest_login_at — datetime — 마지막 로그인 일자