{ TABLE common_raster row size = 1342 number of columns = 32 index size 
              = 891 }
create table common_raster 
  (
    status smallint 
        default 1 not null ,
    type char(16) not null ,
    format_version char(64) not null ,
    data_source char(64) not null ,
    create_module char(64) not null ,
    create_comment char(64) not null ,
    last_modify_module char(64) not null ,
    modify_comment char(64) not null ,
    satellite_data smallint not null ,
    satellite_name char(64) not null ,
    satellite_channel integer not null ,
    satellite_calib smallint not null ,
    description char(64) not null ,
    thematic smallint not null ,
    data_units char(64) not null ,
    product_id integer not null ,
    attribute_table char(64) not null ,
    data_file_pathname char(255) not null ,
    min_data_value float not null ,
    max_data_value float not null ,
    horiz_precision float not null ,
    vertical_precision float not null ,
    x_axis_resolution float not null ,
    y_axis_resolution float not null ,
    min_x_axis_coord float not null ,
    max_x_axis_coord float not null ,
    min_y_axis_coord float not null ,
    max_y_axis_coord float not null ,
    start_time datetime year to second not null ,
    stop_time datetime year to second not null ,
    gis_layer char(64) not null ,
    header_pathname char(255) not null 
  );
revoke all on common_raster from "public";



create unique index pg_uniq_1_18 on common_raster 
    (gis_layer) using btree ;
create unique index pg_uniq_2_18 on common_raster 
    (header_pathname) using btree ;
create unique index pg_uniq_3_18 on common_raster 
    (data_file_pathname) using btree ;
create unique index prod_for_18 on common_raster 
    (product_id) using btree ;


