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