qewr

Tables (10)

ACTIVITY (Untitled6)

  • activityID (Key) — char(30) — Primary key — NOT NULL
  • activityNAME (Field) — char(30)
  • description (Field2) — text

CATEGORT (Untitled3)

  • catID (Key) — char(30) — Primary key — NOT NULL
  • catNAME (Field) — char(30)
  • descripiton (Field2) — text

CLASS (Untitled7)

  • classID (Key) — char(30) — Primary key — NOT NULL
  • classNAME (Field) — hcar(30)
  • Registration limit (Field4) — int(30)
  • Number of registered people (Field5) — int
  • activityID (Key2) — char(30) — Foreign key → ACTIVITY.activityID — NOT NULL
  • class_location (Field2) — char(30)
  • classday (Field3) — cahr(30)
  • registerID (Key3) — char(30) — Foreign key → REGISTER.registerID — NOT NULL
  • Difficulty level ID (Key22) — char(30) — Foreign key → REGISTER.Difficulty level ID — NOT NULL
  • mwmberID (Key222) — hcar(30) — Foreign key → REGISTER.mwmberID — NOT NULL

Difficulty level (Untitled12)

  • Difficulty level ID (Key) — char(30) — Primary key — NOT NULL

MWMBER (Untitled8)

  • mwmberID (Key2) — hcar(30) — Primary key — NOT NULL
  • mwmberNAME (Field) — char(30)
  • address (Field2) — char(30)
  • age (Field3) — cahr(30)

PART (Untitled)

  • partID (Key) — char(30) — Primary key — NOT NULL
  • partNAME (Field) — char(30)
  • description (Field2) — text
  • price (Field3) — int(11)
  • supID (Key2) — char(30) — Foreign key → SUPPLIER.supID — NOT NULL
  • catID (Key3) — char(30) — Foreign key → CATEGORT.catID — NOT NULL

PRODUCT (Untitled4)

  • proID (Key) — char(30) — Primary key — NOT NULL
  • proNAME (Field) — char(30)
  • category (Field2) — char(30)
  • price (Field3) — int(11)
  • descripiton (Field4) — text
  • releasedDate (Field5) — date

PRODUCT_PART (Untitled5)

  • partID (Key) — char(30) — Foreign key → PART.partID — NOT NULL
  • proID (Key2) — char(30) — Foreign key → PRODUCT.proID — NOT NULL
  • quantity (Field) — int(10)

REGISTER (Untitled11)

  • registerID (Key) — char(30) — Primary key — NOT NULL
  • Difficulty level ID (Key2) — char(30) — Foreign key → Difficulty level.Difficulty level ID — NOT NULL
  • mwmberID (Key22) — hcar(30) — Foreign key → MWMBER.mwmberID — NOT NULL

SUPPLIER (Untitled2)

  • supID (Key) — char(30) — Primary key — NOT NULL
  • supNAME (Field) — char(30)
  • phone (Field2) — char(12)
  • email (Field3) — char(30)
  • grade (Field4) — text
  • descripiton (Field5) — text
  • fax (Field6) — char(30)