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)