sqlDB_new2
Tables (6)
buyTbl
- userID — char(8) — Foreign key → userTbl.userID — NOT NULL
- productID — char(2) — Foreign key → product.productID — NOT NULL
- amount — smallint(6)
clubTbl
- clubName — varchar(10) — Primary key — NOT NULL
- roomNo — char(4)
product
- productID — char(2) — Primary key — NOT NULL
- prodName — char(6)
- groupName — char(4)
- price — int(11)
stdTbl
- stdID — char(4) — Primary key — NOT NULL
- userID (userID2) — char(8) — Foreign key → userTbl.userID — NOT NULL
stdclubTbl
- clubName — varchar(10) — Foreign key → clubTbl.clubName — NOT NULL
- stdID — char(4) — Foreign key → stdTbl.stdID — NOT NULL
userTbl
- userID — char(8) — Primary key — NOT NULL
- name — varchar(10)
- birthYear — int(11)
- addr — char(2)
- mobile1 — char(3)
- mobile2 — char(8)
- height — smallint(6)
- mDate — date