sqlDB2
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) — NOT NULL
- groupName — char(4)
- price — int(11)
stdclubtbl
- stdid — char(4) — Foreign key → stdtbl.stdid — NOT NULL
- clubName — varchar(10) — Foreign key → clubtbl.clubName — NOT NULL
stdtbl
- stdid — char(4) — Primary key — NOT NULL
- userID — char(8) — Foreign key → usertbl.userID — NOT NULL
usertbl
- userID — char(8) — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- birthYear — int(11) — NOT NULL
- addr — char(2) — NOT NULL
- mobile1 — char(3)
- mobile2 — char(8)
- height — smallint(6)
- mDate — date