shoppingMall

Tables (6)

CartItem (Untitled3)

  • CartItemId (pk) — int
  • ProductID (fk) — int — Foreign key → Products.ProductID — NOT NULL
  • UserId (fk2) — int — Foreign key → Users.UserId — NOT NULL
  • Quantity (Field2) — decimal(15)
  • RecordID (pk2) — int — Foreign key → ShoppingCart.RecordID — NOT NULL

Orders (주문)

  • OrderID (pk) — int — Primary key — NOT NULL
  • OrderDate (Field) — datetime
  • ShipDate (Field2) — datetime
  • UserId (fk) — String — Foreign key → Users.UserId — NOT NULL
  • address_id (fk1) — Foreign key → address.address_id — NOT NULL
  • Quantity (Field3) — int
  • UnitCost (Field4) — int
  • OrderDate (Field5) — datetime
  • ProductID (fk2) — int — Foreign key → Products.ProductID — NOT NULL

Products (상품)

  • ProductID (pk) — int — Primary key — NOT NULL
  • ModelNumber (Field) — nvarchar(10)
  • ModelName (Field2) — nvarchar(120)
  • ProductImage (Field3) — nvarchar(30)
  • UnitCost (Field4) — decimal(15)
  • Description (Field5) — text

ShoppingCart (Untitled)

  • RecordID (pk) — int — Primary key — NOT NULL
  • UserId (pk2) — int — Foreign key → Users.UserId — NOT NULL

Users (유저)

  • UserId (pk) — String — Primary key — NOT NULL
  • UserName (Field2) — varchar(50)
  • UserPassword (Field3) — varchar(50)
  • UserBirth (Field4) — varchar(8)
  • UserAuth (Field5) — varchar(10)
  • UserPoint (Field6) — int
  • CreatedAt (Field7) — datetime
  • LatestLogin_at (Field) — datetime

address (주소)

  • address_id (pk) — Primary key — NOT NULL
  • City (Field) — varchar(10)
  • District (Field2) — varchar(10)
  • Area (Field3) — varchar(50)
  • UserId (fk) — varchar(50) — Foreign key → Users.UserId — NOT NULL