shoppingmall

Tables (8)

Categories

  • CategoryID — INT — Primary key
  • CategoryName — varchar(50)

OrderDetails

  • OrderID — int — Foreign key → Orders.OrderID
  • user_id — varchar(50) — Foreign key → Orders.user_id — NOT NULL — 아이디
  • ProductID — INT — Foreign key → Products.ProductID
  • Quantity — int
  • UnitCost — decimal(15)

Orders

  • OrderID — int — Primary key
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
  • OrderDate — Datetime
  • ShipDate — Datetime

Products

  • ProductID — INT — Primary key
  • ModelNumber — nvarchar(10)
  • ModelName — nvarchar(120)
  • ProductImage — nvarchar(30)
  • UnitCost — decimal(15)
  • Description — text
  • CategoryID (CategoryID2) — INT — Foreign key → Categories.CategoryID

Reviews

  • ReviewID — int — Primary key
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
  • ProductID — INT — Foreign key → Products.ProductID
  • Rating — int
  • Comments — text

ShoppingCart

  • RecordID — int — Primary key
  • ProductID — INT — Foreign key → Products.ProductID
  • CartID — nvarchar(150)
  • Quantity — int
  • DateCreateed — Datetime

address (Untitled)

  • address (Field)
  • user_id — varchar(50) — Foreign key → users.user_id — 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 — 마지막 로그인 일자