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