car_company_N:N_woncheol_2

Tables (6)

CAR_INFO

  • CI_PK — VARCHAR(20) — Primary key — NOT NULL
  • CP_FK — VARCHAR(20) — Foreign key → COMPANY.CP_PK — NOT NULL
  • CN_FK — VARCHAR(20) — Foreign key → CAR_NAME.CN_PK — NOT NULL
  • YEAR_FK — VARCHAR(20) — Foreign key → MODEL_YEAR.YEAR_PK — NOT NULL

CAR_INFO_OPTIONS

  • CI_OP_PK — VARCHAR(20) — Primary key — NOT NULL
  • OP_FK — VARCHAR(20) — Foreign key → OPTIONS.OP_PK — NOT NULL
  • CI_FK — VARCHAR(20) — Foreign key → CAR_INFO.CI_PK — NOT NULL

CAR_NAME

  • CN_PK — VARCHAR(20) — Primary key — NOT NULL
  • CAR_NAME — VARCHAR(20)

COMPANY

  • CP_PK — VARCHAR(20) — Primary key — NOT NULL
  • CP_NAME — VARCHAR(20)

MODEL_YEAR

  • YEAR_PK — VARCHAR(20) — Primary key — NOT NULL
  • DATE_YEAR — VARCHAR(20)

OPTIONS

  • OP_PK — VARCHAR(20) — Primary key — NOT NULL
  • OPTION — VARCHAR(20)