Table SIEM.public.esec_ctrl
Part of the solution pack content tracking system. This table holds the details of the controls that are present in a solution pack.

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
ctrl_id uuid 2147483647
esec_content_grp.ctrl_id esec_content_grp_ctrl_id_fk1 R
esec_content_grp_rpt_v.ctrl_id Implied Constraint R
esec_ctrl_rpt_v.ctrl_id Implied Constraint R
Control identifier
ctrl_name varchar 255 Control name
ctrl_desc text 2147483647  √  null Control description
ctrl_state int4 10 Control state
ctrl_notes text 2147483647  √  null Control notes
ctrl_ctgry_id uuid 2147483647  √  null
esec_ctrl_ctgry.ctrl_ctgry_id esec_ctrl_cagry_id_fk1 R
Control category identifier
content_external_id varchar 255  √  null Content external identifier
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

Indexes:
Column(s) Type Sort Constraint Name
ctrl_id Primary key Asc esec_ctrl_pk

Close relationships  within of separation: