ddd

Tables (9)

Address

  • Address_ID — int — Primary key — NOT NULL
  • User_ID — varchar(20) — Foreign key → Users.user_id
  • State — varchar(255)
  • City — varchar(255)
  • Address_line — varchar(255)
  • Postal_code — varchar(20)

Categories

  • CategoryID — int — Primary key — NOT NULL
  • CategoryName — varchar(50)

OrderDetails

  • ProductID — int — Foreign key → Products.ProductID — NOT NULL
  • OrderID — int — Foreign key → Orders.OrderID — NOT NULL
  • Quantity — int
  • UnitCost — decimal(15,0)

Orders

  • OrderID — int — Primary key — NOT NULL
  • UserID — varchar(20) — Foreign key → Users.user_id
  • OrderDate — datetime
  • ShipDate — datetime
  • Address — varchar(100)

PointHistory

  • historyId — int — Primary key — NOT NULL
  • userId — varchar(50) — Foreign key → Users.user_id
  • transactionType — varchar(255)
  • transactionAmount — decimal(15,0)
  • transactionDate — timestamp

Products

  • ProductID — int — Primary key — NOT NULL
  • CategoryID — int — Foreign key → Categories.CategoryID
  • ModelNumber — varchar(10)
  • ModelName — varchar(120)
  • ProductImage — varchar(200)
  • UnitCost — decimal(15,0)
  • Description — text

Reviews

  • ReviewID — int — Primary key — NOT NULL
  • ProductID — int — Foreign key → Products.ProductID
  • UserID — varchar(20) — Foreign key → Users.user_id
  • Rating — int
  • Comments — text

ShoppingCart

  • RecordID — int — Primary key — NOT NULL
  • UserID — varchar(50) — Foreign key → Users.user_id
  • Quantity — int
  • ProductID — int — Foreign key → Products.ProductID
  • DateCreated — datetime

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