ModelAnalysisCollectDB

Tables (8)

COLLECT100

  • C100_CODE — varchar(10) — Primary key — NOT NULL
  • C100_CONDITION_CODE — varchar(10) — NOT NULL
  • C100_STDTYPE_CODE — varchar(10) — NOT NULL
  • C100_PROPERTY_CODE — varchar(10)
  • C100_MODEL_NAME — nvarchar(256)
  • C100_PRODUCT_NAME — nvarchar(256)
  • C100_PART_NAME — nvarchar(256)
  • C100_MIN_X — float
  • C100_MAX_X — float
  • C100_MIN_Y — float
  • C100_MAX_Y — float
  • C100_MIN_Z — float
  • C100_MAX_Z — float
  • C100_LENGTH_X — float
  • C100_LENGTH_Y — float
  • C100_LENGTH_Z — float
  • C100_MODEL_DATA — varbinary(max)
  • C100_TOP_IMAGE — varbinary(max)
  • C100_FRONT_IMAGE — varbinary(max)
  • C100_LEFT_IMAGE — varbinary(max)
  • C100_ISO_IMAGE — varbinary(max)
  • C100_REMARK — varchar(256)
  • C100_NEWDATE — smalldatetime
  • C100_MODDATE — smalldatetime

COLLECT101

  • C101_COLORIDX — int — Primary key — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C101_NAME — nvarchar(256)
  • C101_RGB — varchar(256)
  • C101_MIN_Z — float
  • C101_MAX_Z — float
  • C101_HEIGHT — float
  • C101_AREA_TOTAL — float
  • C101_CLASS — varchar(50)
  • C101_REMARK — varchar(256)
  • C101_NEWDATE — smalldatetime
  • C101_MODDATE — smalldatetime

COLLECT102

  • C102_CODE — varchar(10) — Primary key — NOT NULL
  • C101_COLORIDX — int — Foreign key → COLLECT101.C101_COLORIDX — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C102_DIAMETER — float — NOT NULL
  • C102_AREA_FLAT — float
  • C102_AREA_ANGLE10 — float
  • C102_AREA_ANGLE20 — float
  • C102_AREA_ANGLE30 — float
  • C102_AREA_ANGLE40 — float
  • C102_AREA_ANGLE50 — float
  • C102_AREA_ANGLE60 — float
  • C102_AREA_ANGLE70 — float
  • C102_AREA_ANGLE80 — float
  • C102_AREA_ANGLE90 — float
  • C102_AREA_VERTICAL — float
  • C102_REMARK — varchar(256)
  • C102_NEWDATE — smalldatetime
  • C102_MODDATE — smalldatetime

COLLECT200

  • C200_CODE — varchar(10) — Primary key — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C200_PATHNAME — nvarchar(256)
  • C200_PROCESS_TYPE — varchar(10)
  • C200_PROCESS_AREA — varchar(10)
  • C200_LEVELCOLOR — nvarchar(256)
  • C200_MULTIFINISH — nvarchar(256)
  • C200_ADDTOSTOCK — nvarchar(256)
  • C200_MACRO_ID — varchar(32)
  • C200_MACRO_KIND — nvarchar(256)
  • C200_TOOL_NAME — nvarchar(256)
  • C200_TOOL_TYPE — varchar(10)
  • C200_TOOL_LENCODE — varchar(10)
  • C200_TOOL_DIAMETER — float
  • C200_TOOL_LENGTH — float
  • C200_TOOL_OVERHANG — float
  • C200_REFTOOL_NAME — nvarchar(256)
  • C200_REFTOOL_TYPE — varchar(10)
  • C200_REFTOOL_INFO — varchar(256)
  • C200_SHANK_NAME — nvarchar(256)
  • C200_SHANK_CODE — varchar(10)
  • C200_HOLDER_NAME — nvarchar(256)
  • C200_HOLDER_CODE — varchar(10)
  • C200_SEQ — smallint — NOT NULL
  • C200_REMARK — varchar(256)
  • C200_NEWDATE — smalldatetime
  • C200_MODDATE — smalldatetime

COLLECT201

  • C201_SEQ — smallint — Primary key — NOT NULL
  • C200_CODE — varchar(10) — Foreign key → COLLECT200.C200_CODE — NOT NULL
  • C201_ATTRID — varchar(256)
  • C201_ATTRVALUE — varchar(256)
  • C201_REMARK — varchar(256)
  • C201_NEWDATE — smalldatetime
  • C201_MODDATE — smalldatetime

COLLECT202

  • C202_CODE — varchar(10) — Primary key — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C202_SEQ — smallint
  • C202_PROCESS_TYPE — varchar(10)
  • C202_TOOL_NAME — nvarchar(256)
  • C202_TOOL_TYPE — varchar(10)
  • C202_TOOL_LENCODE — varchar(10)
  • C202_TOOL_DIAMETER — float
  • C202_TOOL_LENGTH — float
  • C202_TOOL_OVERHANG — float
  • C202_SHANK_NAME — nvarchar(256)
  • C202_SHANK_CODE — varchar(10)
  • C202_HOLDER_NAME — nvarchar(256)
  • C202_HOLDER_CODE — varchar(10)
  • C202_MIN_Z — float
  • C202_MAX_Z — float
  • C202_CUT_VOLUME — float
  • C202_UNCUT_VOLUME — float
  • C202_TOTAL_VOLUME — float
  • C202_REMARK — varchar(256)
  • C202_NEWDATE — smalldatetime
  • C202_MODDATE — smalldatetime

COLLECT203

  • C203_CODE — varchar(10) — Primary key — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C203_PROCESS_TYPE — varchar(10)
  • C203_LEVELCOLOR — nvarchar(256)
  • C203_TOOL_UNION — varchar(64)
  • C203_TILT_CLASS — varchar(64)
  • C203_MACROID_CLASS — varchar(256)
  • C203_TOOL_NAME — nvarchar(256)
  • C203_TOOL_TYPE — varchar(10)
  • C203_TOOL_LENCODE — varchar(10)
  • C203_TOOL_DIAMETER — float
  • C203_TOOL_LENGTH — float
  • C203_TOOL_OVERHANG — float
  • C203_SHANK_NAME — nvarchar(256)
  • C203_SHANK_CODE — varchar(10)
  • C203_HOLDER_NAME — nvarchar(256)
  • C203_HOLDER_CODE — varchar(10)
  • C203_MIN_Z — float
  • C203_MAX_Z — float
  • C203_CUT_AREA — float
  • C203_UNCUT_AREA — float
  • C203_TOTAL_AREA — float
  • C203_REMARK — varchar(256)
  • C203_NEWDATE — smalldatetime
  • C203_MODDATE — smalldatetime

COLLECT204

  • C204_CODE — varchar(10) — Primary key — NOT NULL
  • C100_CODE — varchar(10) — Foreign key → COLLECT100.C100_CODE — NOT NULL
  • C204_LEVELCOLOR — nvarchar(256)
  • C204_SEQ — smallint
  • C204_PROCESS_TYPE — varchar(10)
  • C204_TOOL_UNION — varchar(64)
  • C204_TILT_CLASS — varchar(64)
  • C204_MACROID_CLASS — varchar(256)
  • C204_TOOL_NAME — nvarchar(256)
  • C204_TOOL_TYPE — varchar(10)
  • C204_TOOL_LENCODE — varchar(10)
  • C204_TOOL_DIAMETER — float
  • C204_TOOL_LENGTH — float
  • C204_TOOL_OVERHANG — float
  • C204_SHANK_NAME — nvarchar(256)
  • C204_SHANK_CODE — varchar(10)
  • C204_HOLDER_NAME — nvarchar(256)
  • C204_HOLDER_CODE — varchar(10)
  • C204_MIN_Z — float
  • C204_MAX_Z — float
  • C204_CUT_AREA — float
  • C204_UNCUT_AREA — float
  • C204_TOTAL_AREA — float
  • C204_REMARK — varchar(256)
  • C204_NEWDATE — smalldatetime
  • C204_MODDATE — smalldatetime