sqlDB_new

Tables (6)

Untitled (product)

  • Key (productID) — char(2) — Primary key — NOT NULL
  • Field (prodName) — char(6)
  • Field2 (groupName) — char(4)
  • Field3 (price) — int(11)

Untitled (clubTBL)

  • Key (clubName) — varchar(10) — Primary key — NOT NULL
  • Field (roomNo) — char(4)

Untitled (stdTbL)

  • Key (stdID) — char(4) — Primary key — NOT NULL
  • Field (userid) — char(3)
  • Field2
  • Key (userID) — char(8) — Foreign key → userTBL.Key — NOT NULL

Untitled (buyTbl)

  • Key (productID) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Key (userID) — char(8) — Foreign key → userTBL.Key — NOT NULL
  • Field (amount) — smallint(6)

Untitled (stdclubTbl)

  • Key (clubName) — varchar(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (stdID) — char(4) — Foreign key → Untitled.Key — NOT NULL

userTBL (uerTBL)

  • Key (userID) — char(8) — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field2 (birthYear) — int(11)
  • Field (addr) — char(2)
  • Field (mobile1) — char(3)
  • Field (mobile2) — char(8)
  • Field (height) — smallint(6)
  • Field (mDate) — date