Exercise1
Tables (5)
COMPANY (Untitled2)
- companyId (Key) — char(5) — Primary key — NOT NULL
- companyName (Field) — char(30)
COMPONENT (Untitled3)
- componentId (Key) — char(10) — Primary key — NOT NULL
- componentName (Field) — char(30)
- description (Field2) — text
- producterId (Key2) — char(5) — Foreign key → PRODUCTER.producterId — NOT NULL
PRODUCT (Untitled5)
- productId (Key) — char(10) — Primary key — NOT NULL
- productName (Field) — char(30)
- productPrice (Field2) — char(10)
- description (Field3) — text
- companyId (Key2) — char(5) — Foreign key → COMPANY.companyId — NOT NULL
PRODUCTER (Untitled)
- producterId (Key) — char(5) — Primary key — NOT NULL
- producterName (Field) — char(30)
- producterPhone (Field2) — char(11)
- producterAddress (Field3) — text
- companyId (Key2) — char(5) — Foreign key → COMPANY.companyId — NOT NULL
PRODUCT_COMPONENT (Untitled4)
- productComponentId (Key) — char(10) — Primary key — NOT NULL
- componentAmount (Field) — char(20)
- componentId (Key2) — char(10) — Foreign key → COMPONENT.componentId — NOT NULL
- productId (Key3) — char(10) — Foreign key → PRODUCT.productId — NOT NULL