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