shopping mall

Tables (11)

Account (Untitled)

  • UserPassword
  • UserName
  • UserAuth
  • CreatedDateAt
  • LatestLoginDateAt
  • UserBirth

Addresses

  • AddressID — INT — Primary key
  • UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
  • 우편번호 (ZipCode) — varchar(20)
  • State — varchar(50)
  • City — varchar(50) — NOT NULL
  • Street — varchar(255) — NOT NULL

Categories

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

OrderDetails

  • OrderID — int — Foreign key → Orders.OrderID
  • ProductID — INT — Foreign key → Products.ProductID
  • Quantity — int

Orders

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

PointUsageHistory

  • PointHistoryID — INT — Primary key
  • UserID — varchar(50) — Foreign key → Users.UserID — NOT NULL — 아이디
  • PointsUsage — INT
  • RemainingPoints — INT
  • Route

Products

  • ProductID — INT — Primary key
  • ModelNumber — nvarchar(10)
  • ModelName — nvarchar(120)
  • ProductImage — nvarchar(30)
  • UnitCost — decimal(15)
  • Description — text

Reviews

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

ShoppingCart

  • CartID — nvarchar(150)
  • Quantity — int
  • DateCreated — Datetime
  • RecordID — int

Users

  • UserID — varchar(50) — Primary key — NOT NULL — 아이디
  • UserPassword
  • UserName
  • UserBirth
  • UserRole
  • UserPoint — int — NOT NULL — default : 1000000
  • CreatedDateAt
  • LatestLoginDateAt

product_categories (Untitled2)

  • CategoryID — INT — Foreign key → Categories.CategoryID
  • ProductID — INT — Foreign key → Products.ProductID