SchemaSpy - Table webco_4.4.1.public.group

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

obj_oid

int8

group_oid

int8

group_member.group_oid	authorization_group_fkeys
wco_group.obj_oid	group_authorization_group_oid_fkey

person_oid

int8

person.obj_oid	group_authorization_person_oid_fkey
group_member.person_oid	authorization_group_fkeys

rtype_oid

int8

group_authorization_rtype_oid_fkey

start_date

timestamptz

35,6

√

null

expire

timestamptz

35,6

√

null

Table contained 0 rows at Fri Mar 24 10:48 CDT 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
obj_oid	Primary key	Asc	group_authorization_pkey
group_oid	Performance	Asc	group_authorization_group_idx
person_oid	Performance	Asc	group_authorization_person_idx
rtype_oid	Performance	Asc	group_authorization_rtype_idx