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
- loomno — char(4)
product
- productID — char(2) — Primary key — NOT NULL
- productname — char(6)
- groupName — char(4)\
- price — int(11)
stdclubtbl
- clubname — varchar(10) — Foreign key → clubtbl.clubname — NOT NULL
- stdID — char(4) — Foreign key → stdtbl.stdID — 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)
- birthyear — in(11)
- addr — char(2)
- mobile1 — char(3)
- mobile2 — char(8)
- height — smallint(6)
- mDate — date