Table SIEM.public.adv_nxs_feed
Advisor feed files that are processed on regular schedule

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
file_name varchar 256
adv_nxs_feed_v.file_name Implied Constraint R
raw_data_files_info.file_name Implied Constraint R
The filename of the Advisor feed file.
hash_value varchar 256 The hash value of the Advisor feed file.
records_inserted int4 10  √  null The number of records inserted into the database.
records_updated int4 10  √  null The number of records updated into the database.
processing_start_time timestamp 29,6 Time stamp indicating when the processing of the feed files started.
processing_end_time timestamp 29,6  √  null Time stamp indicating when the processing of the feed files ended.
generation timestamp 29,6 The unique ID to which each feed file belongs.
date_created timestamp 29,6 Date the entry was created
date_modified timestamp 29,6 Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Indexes:
Column(s) Type Sort Constraint Name
file_name Primary key Asc adv_nxs_feed_pkey

Close relationships: