a

Tables (8)

categories

  • category_id — int — Primary key — NOT NULL
  • category_name — varchar(50)

order_details

  • order_id — int — Foreign key → orders.order_id — NOT NULL
  • product_id — int — Foreign key → products.product_id — NOT NULL
  • quantity — int
  • unit_cost — decimal(15,0)

orders

  • order_id — int — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → users.user_id
  • order_date — datetime
  • ship_date — datetime

point_info

  • info_id — int — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • info — varchar(50)
  • point — int
  • date — datetime

products

  • product_id — int — Primary key — NOT NULL
  • category_id — int — Foreign key → categories.category_id
  • model_number — varchar(10)
  • model_name — varchar(120)
  • product_image — varchar(300)
  • unit_cost — decimal(15,0)
  • description — text

reviews

  • review_id — int — Primary key — NOT NULL
  • product_id — int — Foreign key → products.product_id
  • user_id — varchar(50) — Foreign key → users.user_id
  • rating — int
  • comments — text

shopping_cart

  • record_id — int — Primary key — NOT NULL
  • quantity — int
  • product_id — int — Foreign key → products.product_id
  • user_id — varchar(50) — Foreign key → users.user_id

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 — 마지막 로그인 일자