特别注意时间创建,时间默认值等
CREATE TABLE pes_pps_station_tube_stock_daily(
id BIGSERIAL NOT NULL,
data_date TIMESTAMP,
pipeline_id VARCHAR(64),
pipeline_name VARCHAR(128),
station_id VARCHAR(64),
station_name VARCHAR(128),
temperament_data LVARCHAR(10240),
tube_volume DECIMAL(24,8),
start_outbound_pressure DECIMAL(24,8),
end_inbound_pressure DECIMAL(24,8),
start_outbound_temperature DECIMAL(24,8),
end_inbound_temperature DECIMAL(24,8),
tube_stock DECIMAL(24,8),
created_time TIMESTAMP DEFAULT SYSDATE YEAR TO SECOND, -- 时间
PRIMARY KEY (id) CONSTRAINT pk_pes_pps_station_tube_stock_daily
);