Table SIEM.public.actvy
iTRAC activity (aka action) details

Generated by
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
actvy_id uuid 2147483647
actvy_parm.actvy_id actvy_parm_fk1 R
actvy_parm_rpt_v.actvy_id Implied Constraint R
actvy_ref.actvy_id actvy_ref_fk1 R
actvy_ref.refd_actvy_id actvy_ref_fk2 R
actvy_ref_parm_val_rpt_v.actvy_id Implied Constraint R
actvy_ref_rpt_v.actvy_id Implied Constraint R
actvy_rpt_v.actvy_id Implied Constraint R
Activity identifier
actvy_name varchar 255 Activity name
actvy_typ_cd varchar 1 Activity type code
access_lvl varchar 50 Access level
exec_loc varchar 50 Execution location
actvy_desc varchar 255  √  null Activity description
processor varchar 255  √  null Processor
input_formatter varchar 255  √  null Input formatter
output_formatter varchar 255  √  null Output formatter
app_name varchar 25  √  null Application name
date_created timestamptz 35,6  √  null Date the entry was created
date_modified timestamptz 35,6  √  null 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

Column(s) Type Sort Constraint Name
actvy_id Primary key Asc actvy_pk

Close relationships  within of separation: