action

23261 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
action_num serial 10 √ nextval('action_action_num_seq'::regclass)
action_annotation.action_num fk_action_annotation_action_numR
action_by.action_num fk_action_person_role_organization_actionR
action_external_identifier.action_num action_external_identifier_action_num_fkeyR
additional_method_info.action_num Implied ConstraintR
equipment_action.action_num fk_equipment_action_actionR
feature_action.action_num fk_feature_action_result_actionR
mv_dataset_result_summary.action_num Implied ConstraintR
related_action.action_num fk_related_action_actionR
related_action.related_action_num fk_parent_action_actionR
v_dataset_result.action_num Implied ConstraintR
v_dataset_result_summary.action_num Implied ConstraintR
action_type_num int4 10 null
action_type.action_type_num fk_action_action_typeR
method_num int4 10 null
method.method_num fk_action_methodR
begin_date_time timestamp 29,6 '1900-01-01 00:00:00'::timestamp without time zone
begin_date_time_utc_offset int4 10 √ null
end_date_time timestamp 29,6 √ null
end_date_time_utc_offset int4 10 √ null
action_description varchar 2000 'N/A'::character varying

eg. where the lab analysis is done or expedition code
action_file_link varchar 2000 √ null
organization_num int4 10 null
organization.organization_num fk_action_organizationR
action_name varchar 256 'N/A'::character varying

eg. expedition name with leg information
dataset_num int4 10 null
dataset.dataset_num fk_action_datasetR
status int4 10 √ 1

Indexes

Constraint Name Type Sort Column(s)
action_pkey Primary key Asc action_num
action_method_num_idx Performance Asc method_num
uc_action Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc action_type_num + method_num + action_name + action_description + organization_num + dataset_num + begin_date_time

Relationships

Close relationships within degrees of separation