Myplant_MySQl

create MySQL 语句

CREATE TABLE dataset (
id bigint(20) NOT NULL AUTO_INCREMENT,
author varchar(255) NOT NULL,
created_at datetime NOT NULL,
dataset_meta_id bigint(20) DEFAULT NULL,
description varchar(500) DEFAULT NULL,
equipment_id bigint(20) DEFAULT NULL,
name varchar(255) NOT NULL,
state varchar(255) NOT NULL,
type varchar(255) NOT NULL,
updated_at datetime NOT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

CREATE TABLE dataset_meta (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
detail varchar(255) DEFAULT NULL,
goal varchar(255) DEFAULT NULL,
name varchar(255) NOT NULL,
operators varchar(255) DEFAULT NULL,
paper varchar(255) DEFAULT NULL,
position varchar(255) DEFAULT NULL,
sample varchar(255) DEFAULT NULL,
signal_type varchar(255) DEFAULT NULL,
stimulus varchar(255) DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE environment (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
humidity double DEFAULT NULL,
light double DEFAULT NULL,
name varchar(255) NOT NULL,
pressure double DEFAULT NULL,
temperature double DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE equipment (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
description varchar(255) DEFAULT NULL,
name varchar(255) NOT NULL,
provider varchar(255) DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE iec_meta (
id bigint(20) NOT NULL AUTO_INCREMENT,
channel_num smallint(6) DEFAULT NULL,
created_at datetime DEFAULT NULL,
duration double DEFAULT NULL,
name varchar(255) NOT NULL,
rate int(11) DEFAULT NULL,
record_position varchar(255) DEFAULT NULL,
sampling_rate bigint(20) DEFAULT NULL,
signal_type varchar(255) DEFAULT NULL,
start_at datetime DEFAULT NULL,
stimulate_detail varchar(255) DEFAULT NULL,
stimulate_material varchar(255) DEFAULT NULL,
stimulate_type varchar(255) DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE image_meta (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
duration double DEFAULT NULL,
format varchar(255) DEFAULT NULL,
frame_rate int(11) DEFAULT NULL,
name varchar(255) NOT NULL,
record_area varchar(255) DEFAULT NULL,
record_position varchar(255) DEFAULT NULL,
signal_type varchar(255) DEFAULT NULL,
start_at datetime DEFAULT NULL,
stimulate_detail varchar(255) DEFAULT NULL,
stimulate_material varchar(255) DEFAULT NULL,
stimulate_type varchar(255) DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE sample (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
growth varchar(255) DEFAULT NULL,
name varchar(255) NOT NULL,
period varchar(255) DEFAULT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE software (
id bigint(20) NOT NULL AUTO_INCREMENT,
created_at datetime DEFAULT NULL,
name varchar(255) NOT NULL,
updated_at datetime DEFAULT NULL,
user_id bigint(20) NOT NULL,
version varchar(255) DEFAULT NULL,
PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE user (
id bigint(20) NOT NULL AUTO_INCREMENT,
address varchar(255) NOT NULL,
created_at datetime NOT NULL,
email varchar(255) NOT NULL,
password varchar(255) NOT NULL,
sex varchar(255) NOT NULL,
updated_at datetime NOT NULL,
username varchar(255) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY UK_ob8kqyqqgmefl0aco34akdtpe (email),
UNIQUE KEY UK_sb8bbouer5wak8vyiiy4pf2bx (username) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;