Table odyssey_test._oat.oat_tag
Tags to use in various oat applications: queries, FAQs, etc.

Generated by
SchemaSpy
Legend: SourceForge.net
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
group_id text 2147483647
oat_tag_content.group_id oat_tag_content_group_id_fkey R
Tags are grouped by application: qry, faq, etc.
tag text 2147483647
oat_tag_content.tag oat_tag_content_group_id_fkey R
The tag used within the system; may not have spaces.
label text 2147483647 The tag displayed to users; may have spaces.
description text 2147483647  √  null Describe the intent of the tag to users.

Table contained 26 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
group_id + tag Primary key Asc/Asc oat_tag_pkey

Close relationships: