SchemaSpy Analysis of tsunami.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Apr 06 11:50 PDT 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
tsunami.public contains 244 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
status users int4 4 0
have_result job bool 1 false
config_parameters_id config_parameters serial 4  √  nextval('config_parameters_config_parameters_id_seq'::regclass)
job.config_parameters_id fk_job_1
fault_parameters_id fault_parameters serial 4  √  nextval('fault_parameters_fault_parameters_id_seq'::regclass)
config_parameters.fault_parameters_id fk_config_parameters_1
input_grids_id input_grids serial 4  √  nextval('input_grids_input_grids_id_seq'::regclass)
output_grids.input_grids_id fk_output_grids_2
job_id job serial 4  √  nextval('job_job_id_seq'::regclass)
job_output.job_id fk_job_output_1
user_supplied_documents.job_id fk_user_supplied_documents_1
job_output_id job_output serial 4  √  nextval('job_output_job_output_id_seq'::regclass)
model_metadata_id model_metadata serial 4  √  nextval('model_metadata_model_metadata_id_seq'::regclass)
job.model_metadata_id fk_job_2
output_grids_id output_grids serial 4  √  nextval('output_grids_output_grids_id_seq'::regclass)
job.output_grids_id fk_job_4
output_grids.parent_id fk_output_grids_1
region_id region serial 4  √  nextval('region_region_id_seq'::regclass)
input_grids.region_id fk_input_grids_1
user_supplied_documents_id user_supplied_documents serial 4  √  nextval('user_supplied_documents_user_supplied_documents_id_seq'::regclass)
users_id users serial 4  √  nextval('users_users_id_seq'::regclass)
job.users_id fk_job_3
default_fault_params_id default_fault_params serial 4  √  nextval(('public.default_fault_params_default_fault_params_id_seq'::text)::regclass)
datetime_created job timestamp 8,1 now()
address users varchar 512
address users_last varchar 256  √  null
auth_name spatial_ref_sys varchar 256  √  null
auth_srid spatial_ref_sys int4 4  √  null
author model_metadata varchar 256
citation model_metadata text -1
coef_of_bottom_friction config_parameters numeric 65535,65531  √  null
complete_date job_output varchar 32  √  null
config_parameters_id job int4 4
config_parameters.config_parameters_id fk_job_1
constant_depth config_parameters bool 1  √  null
coord_dimension geometry_columns int4 4
coordinate_switch output_grids bool 1  √  null
cpu_elapsed job_output numeric 65535,65531  √  null
db_table input_grids varchar 64
depth cook_inlet_24sec float4 4  √  null
depth crm_gebco_1min float4 4  √  null
depth crm_or_wa_coast_12sec numeric 65535,65531  √  null
depth crm_or_wa_coast_3sec numeric 65535,65531  √  null
depth etopo2 int2 2  √  null
depth fake_owase_10m int2 2  √  null
depth fake_owase_20m int2 2  √  null
depth gebco int2 2  √  null
depth gulf_of_alaska_2min int2 2  √  null
depth homer_1sec float4 4  √  null
depth homer_3sec float4 4  √  null
depth homer_8sec float4 4  √  null
depth owase_500m int2 2  √  null
depth owase_50m int2 2  √  null
depth seaside_3sec_test numeric 65535,65531  √  null
depth seldovia_1sec float4 4  √  null
depth seldovia_3sec float4 4  √  null
depth seward_1sec float4 4  √  null
depth seward_3sec float4 4  √  null
depth seward_8sec float4 4  √  null
depth_file output_grids varchar 128  √  null
description model_metadata text -1
dip_angle default_fault_params numeric 65535,65531
dip_angle fault_parameters numeric 65535,65531
dislocation default_fault_params numeric 65535,65531
dislocation fault_parameters numeric 65535,65531
domain_latitude fault_parameters numeric 65535,65531
domain_longitude fault_parameters numeric 65535,65531
east_west_points output_grids int4 4
email users varchar 128
email users_last varchar 128  √  null
end_date job_output varchar 32  √  null
epicenter_latitude default_fault_params numeric 65535,65531
epicenter_latitude fault_parameters numeric 65535,65531
epicenter_longitude default_fault_params numeric 65535,65531
epicenter_longitude fault_parameters numeric 65535,65531
event_title default_fault_params varchar 128  √  null
execute_date job_output varchar 32  √  null
f_geometry_column geometry_columns varchar 256
f_table_catalog geometry_columns varchar 256
f_table_name geometry_columns varchar 256
f_table_schema geometry_columns varchar 256
fault_length default_fault_params numeric 65535,65531
fault_length fault_parameters numeric 65535,65531
fault_parameters_id config_parameters int4 4  √  null
fault_parameters.fault_parameters_id fk_config_parameters_1
fault_width default_fault_params numeric 65535,65531
fault_width fault_parameters numeric 65535,65531
file user_supplied_documents varchar 128  √  null
firstmiddle users varchar 64
firstmiddle users_last varchar 64  √  null
flag owase_500m int2 2  √  null
focal_depth default_fault_params numeric 65535,65531
focal_depth fault_parameters numeric 65535,65531
friction_switch output_grids bool 1  √  null
geom cook_inlet_24sec geometry -1  √  null
geom crm_gebco_1min geometry -1  √  null
geom crm_or_wa_coast_12sec geometry -1  √  null
geom crm_or_wa_coast_3sec geometry -1  √  null
geom etopo2 geometry -1  √  null
geom fake_owase_10m geometry -1  √  null
geom fake_owase_20m geometry -1  √  null
geom gebco geometry -1  √  null
geom gulf_of_alaska_2min geometry -1  √  null
geom homer_1sec geometry -1  √  null
geom homer_3sec geometry -1  √  null
geom homer_8sec geometry -1  √  null
geom owase_500m geometry -1  √  null
geom owase_50m geometry -1  √  null
geom seaside_3sec_test geometry -1  √  null
geom seldovia_1sec geometry -1  √  null
geom seldovia_3sec geometry -1  √  null
geom seward_1sec geometry -1  √  null
geom seward_3sec geometry -1  √  null
geom seward_8sec geometry -1  √  null
global_friction_switch config_parameters bool 1  √  null
global_nonlinear_switch config_parameters bool 1  √  null
grid_number output_grids int4 4
id cook_inlet_24sec int4 4  √  null
id crm_gebco_1min int4 4  √  null
id crm_or_wa_coast_12sec int4 4  √  null
id crm_or_wa_coast_3sec int4 4  √  null
id etopo2 int4 4  √  null
id gebco int4 4  √  null
id gulf_of_alaska_2min int4 4  √  null
id homer_1sec int4 4  √  null
id homer_3sec int4 4  √  null
id homer_8sec int4 4  √  null
id owase_500m int4 4  √  null
id owase_50m int4 4  √  null
id seaside_3sec_test int4 4  √  null
id seldovia_1sec int4 4  √  null
id seldovia_3sec int4 4  √  null
id seward_1sec int4 4  √  null
id seward_3sec int4 4  √  null
id seward_8sec int4 4  √  null
initial_wave_source config_parameters varchar 8
input_deform_file output_grids varchar 128  √  null
input_grids_id output_grids int4 4
input_grids.input_grids_id fk_output_grids_2
institution model_metadata varchar 256
institution users varchar 256
institution users_last varchar 128  √  null
job_elapsed job_output numeric 65535,65531  √  null
job_id job_output int4 4
job.job_id fk_job_output_1
job_id user_supplied_documents int4 4
job.job_id fk_user_supplied_documents_1
job_title job varchar 64
lastname users varchar 64
lastname users_last varchar 64  √  null
latitude_sw_corner output_grids numeric 65535,65531
len_time_step config_parameters numeric 65535,65531
libs job_output text -1  √  null
longitude_sw_corner output_grids numeric 65535,65531
max_allowable_time_step input_grids numeric 6,4  √  null
max_x input_grids numeric 65535,65531
max_x region numeric 65535,65531
max_y input_grids numeric 65535,65531
max_y region numeric 65535,65531
metadata_file input_grids varchar 128  √  null
min_x input_grids numeric 65535,65531
min_x region numeric 65535,65531
min_y input_grids numeric 65535,65531
min_y region numeric 65535,65531
model_metadata_id job int4 4
model_metadata.model_metadata_id fk_job_2
name model_metadata varchar 256
name output_grids varchar 128
name region varchar 32
negative_water_depth input_grids bool 1  √  null
nonlinear_switch output_grids bool 1  √  null
north_south_points output_grids int4 4
num_time_steps config_parameters int4 4
output_deform_dbtable output_grids varchar 128  √  null
output_frequency config_parameters int4 4
output_grids_id job int4 4
output_grids.output_grids_id fk_job_4
output_slmax_dbtable output_grids varchar 128  √  null
parent_child_spacing_ratio output_grids int2 2
parent_id output_grids int4 4
output_grids.output_grids_id fk_output_grids_1
password users varchar 32
password users_last varchar 32  √  null
phone users varchar 128
phone users_last varchar 15  √  null
platform job_output varchar 32  √  null
proj4text spatial_ref_sys varchar 2048  √  null
reference_pub model_metadata text -1
region_id input_grids int4 4
region.region_id fk_input_grids_1
request_date job_output varchar 32  √  null
research users varchar 1024
research users_last varchar 1024  √  null
save_maximum config_parameters bool 1  √  null
save_minimum config_parameters bool 1  √  null
slip_angle default_fault_params numeric 65535,65531
slip_angle fault_parameters numeric 65535,65531
spacing input_grids numeric 65535,65531
spacing output_grids numeric 65535,65531
srid geometry_columns int4 4
spatial_ref_sys.srid Implied Constraint
srid spatial_ref_sys int4 4
geometry_columns.srid Implied Constraint
srtext spatial_ref_sys varchar 2048  √  null
start_date job_output varchar 32  √  null
status users_last int4 4  √  null
strike_direction default_fault_params numeric 65535,65531
strike_direction fault_parameters numeric 65535,65531
submit_date job_output varchar 32  √  null
submitted job bool 1
time_to_cross_max_domain input_grids int4 4  √  null
title user_supplied_documents varchar 256  √  null
title users varchar 64
title users_last varchar 64  √  null
type geometry_columns varchar 30
units input_grids varchar 16  √  null
user_intent job text -1
users_id job int4 4
users.users_id fk_job_3
users_id users_last int4 4  √  null
using_extent output_grids bool 1
version model_metadata varchar 64  √  null
x cook_inlet_24sec int2 2  √  null
x crm_gebco_1min int2 2  √  null
x crm_or_wa_coast_12sec int2 2  √  null
x crm_or_wa_coast_3sec int2 2  √  null
x etopo2 int2 2  √  null
x fake_owase_10m int2 2  √  null
x fake_owase_20m int2 2  √  null
x gebco int2 2  √  null
x gulf_of_alaska_2min int2 2  √  null
x homer_1sec int2 2  √  null
x homer_3sec int2 2  √  null
x homer_8sec int2 2  √  null
x owase_50m int2 2  √  null
x seaside_3sec_test int2 2  √  null
x seldovia_1sec int2 2  √  null
x seldovia_3sec int2 2  √  null
x seward_1sec int2 2  √  null
x seward_3sec int2 2  √  null
x seward_8sec int2 2  √  null
x_end output_grids int4 4
x_max input_grids numeric 65535,65531  √  null
x_start output_grids int4 4
y cook_inlet_24sec int2 2  √  null
y crm_gebco_1min int2 2  √  null
y crm_or_wa_coast_12sec int2 2  √  null
y crm_or_wa_coast_3sec int2 2  √  null
y etopo2 int2 2  √  null
y fake_owase_10m int2 2  √  null
y fake_owase_20m int2 2  √  null
y gebco int2 2  √  null
y gulf_of_alaska_2min int2 2  √  null
y homer_1sec int2 2  √  null
y homer_3sec int2 2  √  null
y homer_8sec int2 2  √  null
y owase_50m int2 2  √  null
y seaside_3sec_test int2 2  √  null
y seldovia_1sec int2 2  √  null
y seldovia_3sec int2 2  √  null
y seward_1sec int2 2  √  null
y seward_3sec int2 2  √  null
y seward_8sec int2 2  √  null
y_end output_grids int4 4
y_max input_grids numeric 65535,65531  √  null
y_start output_grids int4 4