ad_process_access

2594 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_process_id numeric 10 null
ad_process.ad_process_id adprocess_adprocessaccess C
ad_role_id numeric 10 null
ad_role.ad_role_id adrole_adprocessaccess C
ad_client_id numeric 10 null
ad_client.ad_client_id ad_processaccess_client R
ad_org_id numeric 10 null
ad_org.ad_org_id ad_processtaccess_org R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
isreadwrite bpchar 1 'Y'::bpchar
ad_process_access_uu varchar 36 NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_process_access_pkey Primary key Asc/Asc ad_process_id + ad_role_id
ad_process_access_uu_idx Must be unique Asc ad_process_access_uu

Check Constraints

Constraint Name Constraint
ad_process_access_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_access_isreadwrite_check ((isreadwrite = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships