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)