ShoppingMall

Tables (7)

Categories (카테고리)

  • CategoryID (카테고리ID) — INT — Primary key — NOT NULL
  • CategoryName (카테고리이름) — VARCHAR(50)

Customers (Untitled2)

  • CustomerID (Key) — INT — Primary key — NOT NULL — auto_increment
  • Name (Field) — VARCHAR(10)
  • EmailAddress (Field2) — VARCHAR(100)
  • Password (Field3) — VARCHAR(12)

OrderDetails (Untitled5)

  • OrderID (Key) — INT — Foreign key → Orders.OrderID — NOT NULL
  • ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
  • Quantity (Field) — INT
  • UnitCost (Field2) — DECIMAL(15)

Orders (Untitled4)

  • OrderID (Key) — INT — Primary key — NOT NULL
  • CustomerID (Key2) — INT — Foreign key → Customers.CustomerID — NOT NULL — auto_increment
  • OrderDate (Field) — DATETIME
  • ShipDate (Field2) — DATETIME

Products (Untitled)

  • ProductID (Key) — INT — Primary key — NOT NULL — auto_increment
  • Field
  • CategoryID (카테고리ID) — INT — Foreign key → Categories.CategoryID — NOT NULL
  • ModelNumber (Field2) — NVARCHAR(10)
  • ModelName (Field3) — NVARCHAR(120)
  • ProductImage (Field4) — NVARCHARR(30)
  • UnitCost (Field5) — DECIMAL(15)
  • Description (Field6) — TEXT

Reviews (Untitled3)

  • ReviewID (Key) — INT — Primary key — NOT NULL — auto_increment
  • Field
  • ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
  • CustomerID (Key3) — INT — Foreign key → Customers.CustomerID — NOT NULL — auto_increment
  • Rating (Field2) — INT
  • Comments (Field3) — TEXT

ShoppingCart (Untitled6)

  • RecordID (Key) — INT — Primary key — NOT NULL — auto_increment
  • CartID (Field) — NVARCHAR(150)
  • Quantity (Field2) — INT
  • ProductID (Key2) — INT — Foreign key → Products.ProductID — NOT NULL — auto_increment
  • DateCreated (Field3) — DATETIME