쇼핑몰2

테이블 (12)

address

  • address_id — int — 기본 키 — NOT NULL
  • road_address — VARCHAR(255) — NOT NULL
  • detail_address — VARCHAR(255) — NOT NULL
  • user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL
  • created_at — datetime — NOT NULL

categories

  • category_id — int — 기본 키 — NOT NULL
  • category_name — VARCHAR(255) — NOT NULL

order_product

  • order_product_id — int — 기본 키 — NOT NULL
  • quantity — int — NOT NULL
  • price — int — NOT NULL
  • order_id — int — 외래 키 → orders.order_id — NOT NULL
  • product_id — int — 외래 키 → products.product_id — NOT NULL

orders

  • order_id — int — 기본 키 — NOT NULL
  • order_total_amount — int — NOT NULL
  • order_status — enum('PENDING', 'COMPLETED', 'CANCELED') — NOT NULL
  • ordered_at — datetime
  • user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL

payment_methods

  • payment_method_id — int — 기본 키 — NOT NULL
  • payment_method_name — varchar(50) — NOT NULL

payments

  • payment_id — int — 기본 키 — NOT NULL
  • payment_amount — int — NOT NULL
  • order_id — int — 외래 키 → orders.order_id — NOT NULL
  • payment_method_id — int — 외래 키 → payment_methods.payment_method_id — NOT NULL
  • payment_status — enum('PENDING', 'COMPLETED', 'FAILED') — NOT NULL
  • paid_at — datetime
  • created_at — datetime — NOT NULL

point_change_types

  • point_change_type_id — int — 기본 키 — NOT NULL
  • point_change_type_name — varchar(20) — NOT NULL

point_changes

  • point_change_history_id — int — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → users.user_id — NOT NULL
  • points — int — NOT NULL
  • direction — enum('ADD', 'SUBTRACT') — NOT NULL
  • memo — varchar(200)
  • changed_at — datetime — NOT NULL
  • point_change_type_id — int — 외래 키 → point_change_types.point_change_type_id — NOT NULL

product_category

  • product_category_id — int — 기본 키 — NOT NULL
  • product_id — int — 외래 키 → products.product_id — NOT NULL
  • category_id — int — 외래 키 → categories.category_id — NOT NULL

product_details

  • product_detail_id — int — 기본 키 — NOT NULL
  • product_id — int — 외래 키 → products.product_id — NOT NULL
  • product_detail_image_url — varchar(255) — NOT NULL
  • product_detail_priority — int — NOT NULL

products

  • product_id — int — 기본 키 — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • product_thumbnail_image_url — varchar(255) — NOT NULL
  • product_price — int — NOT NULL
  • product_unit — varchar(10) — NOT NULL
  • register_at — datetime — NOT NULL

users

  • user_id — varchar(50) — 기본 키 — NOT NULL — 아이디
  • user_name — varchar(50) — NOT NULL — 이름
  • user_password — varchar(255) — 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 — 마지막 로그인 일자