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