SchemaSpy - Table marinedb.field_event_mammal_disturbance

mammal disturbance info from the field log

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

6

field_events.site_code

FK_field_event_mammald_field_events R

survey_date

date

10

field_events.survey_date

FK_field_event_mammald_field_events R

group_code

varchar

8

field_events.group_code

FK_field_event_mammald_field_events R

observation_time

time

8

mammal_code

varchar

20

mammal_codes.mammal_code

FK_field_event_mammald_species R

mammal_age

enum

8

mammal_sex

enum

7

disturbance_level

int

10

mammal_disturbance_levels.disturbance_level

FK_field_event_mammald_levels R

disturbance_detail

varchar

80

mammal_disturbance_details.disturbance_detail

FK_field_event_mammald_details R

mammal_count_value

varchar

3

mammal_count_values.mammal_count_value

FK_field_event_mammald_counts R

create_date

date

10

modify_date

timestamp

19

current_timestamp()

Table contained 147 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_counts
disturbance_detail	Performance	Asc	FK_field_event_mammald_details
disturbance_level	Performance	Asc	FK_field_event_mammald_levels
mammal_code	Performance	Asc	FK_field_event_mammald_species