{
	"name": "table/external/nestix/product/nxsheetpathdet.json",
	"table_name": "nxsheetpathdet",
	"table_prefix": "sheetpathdet",
	"record_type": ["nxsheetpathdet"],
	"local_table": "product_lot",
	"local_record_type": "nxsheetpathdet",
	"field": [
		{
			"field_name": "nxarea",
			"info": "needed by 4D",
			"local_field": "json_data.area",
			"field_type": "double"
		},
		{
			"field_name": "nxcomplited",
			"local_field": "",
			"field_type": "timestamp without time zone"
		},
		{
			"field_name": "nxcutted",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"field_name": "nxdelivdate",
			"local_field": "",
			"field_type": "timestamp without time zone"
		},
		{
			"field_name": "nxdetailcode",
			"local_field": "",
			"field_type": "text"
		},
		{
			"field_name": "nxdetailcount",
			"info": "needed by 4D",
			"local_field": "json_data.detail_count",
			"field_type": "integer"
		},
		{
			"field_name": "nxorderposid",
			"info": "needed by 4D",
			"local_field": "order_id",
			"field_type": "integer",
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "nxorderposid",
					"linked_table": "nxorderpos"
				}
			]
		},
		{
			"field_name": "nxpartid",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"field_name": "nxpausetime",
			"local_field": "",
			"field_type": "double"
		},
		{
			"field_name": "nxrejected",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"field_name": "nxrejectedreasonid",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"field_name": "nxscratch",
			"local_field": "",
			"field_type": "integer"
		},
		{
			"field_name": "nxsheetpathdetid",
			"local_field": "product_lot_id",
			"field_type": "integer"
		},
		{
			"field_name": "nxsheetpathid",
			"info": "needed by 4D",
			"local_field": "json_data.nxsheetpathid",
			"field_type": "integer",
			"foreign_key": [
				{
					"link_type": "prevent delete",
					"linked_field": "nxsheetpathid",
					"linked_table": "nxsheetpath"
				}
			]
		},
		{
			"field_name": "nxspdmachtime",
			"info": "needed by 4D",
			"local_field": "json_data.machine_time",
			"field_type": "double"
		},
		{
			"field_name": "nxspdusedtime",
			"local_field": "json_data.used_time",
			"field_type": "double"
		},
		{
			"field_name": "nxtimestamp",
			"info": "needed by 4D",
			"local_field": "modify_time",
			"field_type": "integer"
		},
		{
			"field_name": "nxusedarea",
			"info": "needed by 4D",
			"local_field": "json_data.used_area",
			"field_type": "double"
		},
		{
			"field_name": "nxusedtime",
			"local_field": "",
			"field_type": "double"
		},
		{
			"field_name": "nxusedweight",
			"local_field": "",
			"field_type": "double"
		},
		{
			"field_name": "nxweight",
			"info": "needed by 4D",
			"local_field": "json_data.weight",
			"field_type": "double"
		}
	]
}
