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