Table SIEM.public.user_tag_state
Association of users and tags.

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
user_id int4 10
users.usr_id user_tag_user_fk C
User identifier
tag_name varchar 255
tags.tag_name user_tag_tag_fk C
Name of the tag for User state
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified
modified_by int4 10  √  null User who last modified object
created_by int4 10  √  null User who created object

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

Indexes:
Column(s) Type Sort Constraint Name
user_id + tag_name Primary key Asc/Asc user_tag_pk

Close relationships  within of separation: