use kgraph;

DROP TABLE
IF
	EXISTS t_air_model_info;
CREATE TABLE t_air_model_info (
	id BIGINT ( 20 ) NOT NULL auto_increment COMMENT '序号',
	air_number VARCHAR ( 64 ) COMMENT '机号',
	model_component_id BIGINT ( 20 ) COMMENT '型号id',
	model_number VARCHAR ( 64 ) COMMENT '型号',
	serial VARCHAR ( 64 ) COMMENT '编号',
	production_date datetime COMMENT '出厂日期',
	version VARCHAR ( 64 ) COMMENT '版本号',
	create_by VARCHAR ( 64 ) DEFAULT '' COMMENT '创建者',
	create_time datetime COMMENT '创建时间',
	update_by VARCHAR ( 64 ) DEFAULT '' COMMENT '更新者',
	update_time datetime COMMENT '更新时间',
	PRIMARY KEY ( id )
) ENGINE = INNODB COMMENT = '机型信息';