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)