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