shop

Tables (8)

address

  • addressID — int — NOT NULL
  • addressLine1 — varchar(50)
  • addressLine2 — varchar(50)
  • city — varchar(30)
  • stateProvince — varchar(50)
  • contryRegion — varchar(50)
  • postalCode — varchar(10)

categories

  • CategoryID — INT — NOT NULL
  • CategoryName — varchar(50) — NOT NULL

customerAddress

  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디
  • addressID — int — Foreign key → address.addressID — NOT NULL
  • addressType — text

orders

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

products

  • ProductID — INT — NOT NULL
  • ModelNumber — varchar(20)
  • ProductImage — varchar(60)
  • UnitCost — decimal(15)
  • Description — text
  • Inventory — INT — NOT NULL
  • CategoryID1 — INT — Foreign key → categories.CategoryID — NOT NULL
  • CategoryID2 — INT — Foreign key → categories.CategoryID
  • CategoryID3 — INT — Foreign key → categories.CategoryID
  • ModelName — varchar(200) — NOT NULL

reviews

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

shoppingCart

  • RecordID — int — NOT NULL
  • CartID — nvarchar(150)
  • Quantity — int
  • ProductID — int — Foreign key → products.ProductID
  • DateCreateed — Datetime
  • ProductID — INT
  • user_id — varchar(50) — Foreign key → users.user_id — NOT NULL — 아이디

users

  • user_id — varchar(50) — 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 — 마지막 로그인 일자