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 — char(8) — 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