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