cs_order_review

cs订单评审信息表

• Rows (estimated): 8
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:52:05
• Updated: 2026-04-27 18:52:05

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	order_review_id	int	NO	PRI		auto_increment	订单信息表id
2	salsalesordermaster_sId	varchar(50)	YES				原订单主表id
3	order_id	int	YES				订单表id
4	order_num	varchar(50)	YES				订单编号
5	operation_node	varchar(50)	YES				操作节点
6	remarks	text	YES				备注
7	creation_time	datetime	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	制单日期
8	creation_person	varchar(50)	YES				制单人
9	last_update_time	datetime	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	修改日期
10	last_update_person	varchar(50)	YES				修改人
11	isSendMessage	bit(1)	YES		b'0'		是否推送消息
12	sendMessageTime	datetime	YES				推送消息时间
13	bInvalid	bit(1)	YES		b'0'		是否作废
14	sMReserve1	varchar(50)	YES				预留字符1
15	sMReserve2	varchar(50)	YES				预留字符2
16	sMReserve3	varchar(50)	YES				预留字符3
17	sMReserve4	varchar(50)	YES				预留字符4
18	sMReserve5	varchar(50)	YES				预留字符5
19	dMReserve1	decimal(18,6)	YES				预留数字1
20	dMReserve2	decimal(18,6)	YES				预留数字2

Indexes

Name	Unique	Type	Columns
PRIMARY	✓	BTREE	order_review_id

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.