1101 chpa2
Tables (6)
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
buyTbl
- productID — char(2) — Foreign key → productTbl.productID — NOT NULL
- userID — char(8) — Foreign key → UserTbl.userID — NOT NULL
- amount — smallint(6)
clubTbl
- clubName — varchar(10) — Primary key — NOT NULL
- roomNo — char(4)
productTbl
- 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 — char(8) — NOT NULL
- userID (userID2) — char(8) — Foreign key → UserTbl.userID — NOT NULL
stdclubTbl
- stdID — char(4) — Foreign key → stdTbl.stdID — NOT NULL
- clubName — varchar(10) — Foreign key → clubTbl.clubName — NOT NULL