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