report_group

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
report_report.group_id fk_report_to_report_group R
create_ts timestamp 29,6 √ null
created_by varchar 50 √ null
version int4 10 1
update_ts timestamp 29,6 √ null
updated_by varchar 50 √ null
delete_ts timestamp 29,6 √ null
deleted_by varchar 50 √ null
sys_tenant_id varchar 255 √ null
title varchar 255 null
code varchar 255 √ null
locale_names varchar 4000 √ null

Indexes

Constraint Name Type Sort Column(s)
REPORT_GROUP_pkey Primary key Asc id
idx_report_group_uniq_title Must be unique Asc title
idx_report_group_uniq_title_sys_tenant_id_nn Must be unique Asc/Asc title + sys_tenant_id

Relationships

Close relationships within degrees of separation