CAR2
Tables (5)
CAR
- Key (CAR_PK) — VARCHAR(20) — Primary key — NOT NULL
- Key (CP_FK) — VARCHAR(20) — Foreign key → COMPANY.Key — NOT NULL
- Field (CAR_NAME) — VARCHAR(20)
CAR_MODEL
- Key (CAR_MODEL_PK) — VARCHAR(20) — Primary key — NOT NULL
- Key (CAR_FK) — VARCHAR(20) — Foreign key → CAR.Key — NOT NULL
- Key (YEAR_FK) — VARCHAR(20) — Foreign key → YEAR.Key — NOT NULL
- Key (OPTION_FK) — VARCHAR(20) — Foreign key → OPTION.Key — NOT NULL
- Field
COMPANY
- Key (CP_PK) — VARCHAR(20) — Primary key — NOT NULL
- Field (CP_NAME) — VARCHAR(20)
OPTION
- Key (OPTION_PK) — VARCHAR(20) — Primary key — NOT NULL
- Field (OP_NAME) — VARCHAR(20)
- Field
YEAR
- Key (YEAR_PK) — VARCHAR(20) — Primary key — NOT NULL
- Field (MODEL_YEAR) — VARCHAR(20)