2023_webDB_practice
Tables (8)
Untitled (PRODUCT)
- Key (proNo) — int — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int
- Field (proName) — char(50)
Untitled (PARTS)
- Key (partNo) — int — Primary key — NOT NULL
- Field (description) — text
- Key (producerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCER)
- Key (ssn) — char(14) — Primary key — NOT NULL
- Field (producerName) — char(50)
- Field (address) — text
- Field (phone) — char(20)
Untitled (COMPOSITION)
- Key (proNo) — int — Foreign key → Untitled.Key — NOT NULL
- Key (partNo) — int — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int
Untitled (ACTIVITY)
- Key (activityCode) — char(10) — Primary key — NOT NULL
- Field (activityName) — char(20)
- Field (description)
Untitled (CLASS)
- Key (classNo) — char(10) — Primary key — NOT NULL
- Field
- Field2 (time) — date
- Field2 (limit) — int
- Field2 (current) — int
- Field2 (level) — int
- Key (activityCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (ssn) — char(14) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (age) — int
- Field (adress) — char(50)
Untitled (REGISTRATION)
- Key (classNo) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn) — char(14) — Foreign key → Untitled.Key — NOT NULL