exercise 1
Tables (10)
CLASS (Untitled6)
- classID (Key) — int — Primary key — NOT NULL
- code (Key2) — int — Foreign key → EXERCISE.code — NOT NULL
- time (Field)
- level (Field2)
- Field3
CLASS_MEMBER (Untitled8)
- classID (Key) — int — Foreign key → CLASS.classID — NOT NULL
- code (Key2) — int — Foreign key → CLASS.code — NOT NULL
- memberID (Key3) — int — Foreign key → MEMBER.memberID — NOT NULL
EXERCISE (Untitled5)
- code (Key) — int — Primary key — NOT NULL
- description (Field) — text
MEMBER (Untitled7)
- memberID (Key) — int — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(20)
- age (Field3) — num
PART (Untitled2)
- partID (Key) — char(20) — Primary key — NOT NULL
- modelNumber (Field2) — char(30)
- description (Field) — text
- supID (Key2) — char(10) — Foreign key → SUPPLIER.supID — NOT NULL
PRODUCT (Untitled3)
- productID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- category (Field2) — char(15)
- description (Field3) — text
- listPrice (Field4) — int
PRODUCT_PART (Untitled4)
- partID (Key) — char(20) — Foreign key → PART.partID — NOT NULL
- productID (Key2) — char(10) — Foreign key → PRODUCT.productID — NOT NULL
- quantity (Field) — int
REVIEW (Untitled9)
- classID (Key) — int — Foreign key → CLASS_MEMBER.classID — NOT NULL
- code (Key2) — int — Foreign key → CLASS_MEMBER.code — NOT NULL
- memberID (Key3) — int — Foreign key → CLASS_MEMBER.memberID — NOT NULL
- review (Field) — text
SUPPLIER (Untitled)
- supID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(15)
- phone (Field3) — char(11)
- email (Field4) — char(20)
- address (Field2) — char(50)
- fax (Field5) — char(11)
WAITLIST (Untitled10)
- classID (Key) — int — Foreign key → CLASS.classID — NOT NULL
- code (Key2) — int — Foreign key → CLASS.code — NOT NULL
- memberID (Key3) — int — Foreign key → MEMBER.memberID — NOT NULL
- Field — datetime
- waitOrder (Field2) — int