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