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
  • rommNo — 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)
  • momile2 — char(8)
  • hight — smallint(6)
  • mDate — date