SchemaSpy - Table marinedb.field_event_mammal_disturbance

mammal disturbance info from the field log data entry

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

site_code

char

field_events_active.site_code

FK_field_event_mammald_activefield_events R

survey_date

date

field_events_active.survey_date

FK_field_event_mammald_activefield_events R

group_code

varchar

field_events_active.group_code

FK_field_event_mammald_activefield_events R

observation_time

time

mammal_code

varchar

mammal_codes.mammal_code

FK_field_event_mammald_activespecies R

mammal_age

enum

mammal_sex

enum

disturbance_level

int

mammal_disturbance_levels.disturbance_level

FK_field_event_mammald_activelevels R

disturbance_detail

varchar

mammal_disturbance_details.disturbance_detail

FK_field_event_mammald_activedetails R

mammal_count_value

varchar

mammal_count_values.mammal_count_value

FK_field_event_mammald_activecounts R

create_date

date

modify_date

timestamp

current_timestamp()

Table contained 0 rows at Thu Apr 03 16:08 PDT 2025

Indexes:

Column(s)	Type	Sort	Constraint Name
site_code + survey_date + group_code + observation_time + mammal_code + mammal_age + mammal_sex + disturbance_level + disturbance_detail	Primary key	Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc	PRIMARY
mammal_count_value	Performance	Asc	FK_field_event_mammald_activecounts
disturbance_detail	Performance	Asc	FK_field_event_mammald_activedetails
disturbance_level	Performance	Asc	FK_field_event_mammald_activelevels
mammal_code	Performance	Asc	FK_field_event_mammald_activespecies