12334

Tables (7)

Untitled

  • Key — Primary key — NOT NULL

order

  • order_id — varchar(255) — Primary key — NOT NULL
  • user_id — varchar(255) — Foreign key → users.user_id — NOT NULL

order_detail

  • orderdetail_id — varchar(255) — Primary key — NOT NULL
  • order_id — varchar(255) — Foreign key → order.order_id — NOT NULL
  • product_id — varchar(255) — NOT NULL
  • quantity — int
  • totalprice — int
  • product_id (product_id2) — varchar(255) — Foreign key → product.product_id — NOT NULL

payment

  • payment_id — varchar(255) — Primary key — NOT NULL
  • order_id — varchar(255) — Foreign key → order.order_id — NOT NULL

product

  • product_id — varchar(255) — Primary key — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • product_price — int — NOT NULL
  • product_quantity — int — NOT NULL

product_image

  • image_id — varchar(255) — Primary key — NOT NULL
  • product_id — varchar(255) — Foreign key → product.product_id — NOT NULL
  • image_link — varchar(255)

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