POP
Tables (3)
POP_SPEC (P)
- SET_CODE — varchar — Primary key — NOT NULL
- SET_NO (Field) — varchar
- FACTORY_CODE (Field2) — varchar
- CAR_CODE (Field3) — varchar
- L_R (Field5) — varchar
- FRONT_LH_ID (Field4) — varchar
- FRONT_LH_NO (Field6) — varchar
- FRONT_RH_ID (Field7) — varchar
- FRONT_RH_NO (Field8) — varchar
- REAR_CUSH_ID (Field9) — varchar
- REAR_CUSH_NO (Field10) — varchar
- REAR_FIXED_ID (Field11) — varchar
- REAR_FIXED_NO (Field12) — varchar
- REAR_BACK_LH_ID (Field13) — varchar
- REAR_BACK_LH_NO (Field14) — varchar
- 3RD_FIXED_ID (Field15) — varchar
- 3RD_FIXED_NO (Field16) — varchar
- 3RD_BACK_LH_ID (Field17) — varchar
- 3RD_BACK_LH_NO (Field18) — varchar
- 3RD_BACK_RH_ID (Field19) — varchar
- 3RD_BACK_RH_NO (Field20) — varchar
- REAR_SIDE_LH_ID (Field21) — varchar
- REAR_SIDE_LH_NO (Field22) — varchar
- REAR_SIDE_RH_ID (Field23) — varchar
- REAR_SIDE_RH_NO (Field24) — varchar
- PRODUCT_NAME (Field25) — varchar
- CREATE_DATE (Field26) — datetime
- UPDATE_DATE (Field27) — datetime
- USER_ID (Field28) — varchar
- SPEC_STATUS (Field29) — varchar
POP_SPEC_ITEM (Untitled2)
- SPEC_ITEM_INDEX (Key) — int — Primary key — NOT NULL
- SPEC_GROUP_INDEX (Field) — varchar
- SPEC_ITEM_NAME (Field2) — varchar
POP_SPEC_OPTION (Untitled)
- SET_CODE — varchar — Foreign key → POP_SPEC.SET_CODE — NOT NULL
- SPEC_ITEM_INDEX (Key) — int — Foreign key → POP_SPEC_ITEM.SPEC_ITEM_INDEX — NOT NULL