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