test
Tables (7)
tblMyWallet
- MyWalletId — bigint — Primary key — NOT NULL
- UserId — bigint — Foreign key → tblUser.UserId — NOT NULL
tblOrder
- OrderId — bigint — Primary key — NOT NULL
- UserId — bigint — Foreign key → tblUser.UserId — NOT NULL
tblOrderDetail
- OrderId — bigint — Foreign key → tblOrder.OrderId — NOT NULL
- ProductId — bigint — Foreign key → tblProduct.ProductId — NOT NULL
- Quatity — int — NOT NULL
tblProduct
- ProductId — bigint — Primary key — NOT NULL
- ProductName — varchar(150)
tblSignoff
- UserId — bigint — Foreign key → tblUser.UserId — NOT NULL
tblUser
- UserId — bigint — Primary key — NOT NULL
- UserPw — varchar(255) — NOT NULL
- UserUsing — bit — NOT NULL
tblborder
- BorderID — int — Primary key — NOT NULL
- UserId — bigint — Foreign key → tblUser.UserId — NOT NULL