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 = '机型信息';