ai-model/data/cx_aps.sql

{
	"tables": [
		{
			"name": "aps_blank_order",
			"note": "生产订单_坯料计划",
			"columns": [
				{
					"name": "ID",
					"type": "varchar",
					"precision": "36",
					"note": "主键"
				},
				{
					"name": "PRODUCTIONORDERID",
					"type": "varchar",
					"precision": "36",
					"note": "生产订单ID"
				},
				{
					"name": "BLANKNUMBER",
					"type": "varchar",
					"precision": "36",
					"note": "坯料计划编号"
				},
				{
					"name": "MATERIALNAME",
					"type": "varchar",
					"precision": "50",
					"note": "物料名称"
				},
				{
					"name": "MATERIALCODE",
					"type": "varchar",
					"precision": "50",
					"note": "物料编码"
				},
				{
					"name": "ALLOY",
					"type": "varchar",
					"precision": "50",
					"note": "合金"
				},
				{
					"name": "ALLOYSTATUS",
					"type": "varchar",
					"precision": "50",
					"note": "合金状态"
				},
				{
					"name": "PLANHAVEMATERIALDATE",
					"type": "datetime",
					"precision": "0",
					"note": "预计来料日期"
				},
				{
					"name": "MAXHEATROLL",
					"type": "int",
					"precision": "11",
					"note": "最大装炉卷数"
				},
				{
					"name": "EXPECTEDDAYS",
					"type": "varchar",
					"int": "11",
					"note": "期望交货天数"
				},
				{
					"name": "ROLLNUM",
					"type": "int",
					"precision": "11",
					"note": "卷数"
				},
				{
					"name": "PROWIDTH",
					"type": "decimal",
					"precision": "20, 3",
					"note": "宽度（mm）"
				}
			]
		}
	]
}