Policy

25 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Policy_id_seq"'::regclass)
RolePolicy.policyId Implied Constraint R
uuid uuid 2147483647 null
policyName varchar 255 null
description text 2147483647 √ null
isDeleted bool 1 √ false
resourceId int4 10 null
Resource.id Implied Constraint R
createdBy int4 10 null
updatedBy int4 10 √ null
organizationId int4 10 null
Organization.id Implied Constraint R
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
Policy_pkey Primary key Asc id
Policy_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation