cof_access

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

ad_role_id

numeric

√

null

ad_role.ad_role_id

Implied Constraint

cof_tipoacesso

text

2147483647

√

null

value

varchar

2147483647

√

null

name

varchar

2147483647

√

null

character_entity.name

Implied Constraint

isactive

bpchar

√

null

isreadwrite

bpchar

2147483647

√

null

ismasterrole

bpchar

√

null

ismanual

bpchar

√

null

iscanapproveowndoc

bpchar

√

null

isshowacct

bpchar

√

null

iscanreport

bpchar

√

null

ispersonallock

bpchar

√

null

isaccessadvanced

bpchar

√

null

overwritepricelimit

bpchar

√

null

ischangelog

bpchar

√

null

isaccessallorgs

bpchar

√

null

isuseuserorgaccess

bpchar

√

null

iscanexport

bpchar

√

null

ispersonalaccess

bpchar

√

null

ismenuautoexpand

bpchar

√

null

allow_info_account

bpchar

√

null

allow_info_schedule

bpchar

√

null

cof_rolelevel

varchar

√

null

ad_user_id

numeric

√

null

ad_window_id

numeric

√

null

ad_process_id

numeric

√

null

ad_form_id

numeric

√

null

ad_infowindow_id

numeric

√

null

ad_workflow_id

numeric

√

null

ad_task_id

numeric

√

null

c_doctype_id

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT ado.ad_client_id,
    ado.ad_org_id,
    ado.ad_role_id,
    'Organização'::text AS cof_tipoacesso,
    o.value,
    o.name,
    ado.isactive,
    ado.isreadonly AS isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM ((ad_role_orgaccess ado
     LEFT JOIN ad_org o ON ((ado.ad_org_id = o.ad_org_id)))
     LEFT JOIN ad_role r ON ((ado.ad_role_id = r.ad_role_id)))
UNION
 SELECT adu.ad_client_id,
    adu.ad_org_id,
    adu.ad_role_id,
    'Usuário'::text AS cof_tipoacesso,
    u.value,
    u.name,
    adu.isactive,
    ''::bpchar AS isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    u.ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM ((ad_user_roles adu
     LEFT JOIN ad_user u ON ((adu.ad_user_id = u.ad_user_id)))
     LEFT JOIN ad_role r ON ((adu.ad_role_id = r.ad_role_id)))
UNION
 SELECT adw.ad_client_id,
    adw.ad_org_id,
    adw.ad_role_id,
    'Janela'::text AS cof_tipoacesso,
    w.name AS value,
    trl.name,
    adw.isactive,
    adw.isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    w.ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_window_access adw
     LEFT JOIN ad_window w ON ((adw.ad_window_id = w.ad_window_id)))
     LEFT JOIN ad_role r ON ((adw.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_window_trl trl ON ((w.ad_window_id = trl.ad_window_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT adp.ad_client_id,
    adp.ad_org_id,
    adp.ad_role_id,
    'Processo'::text AS cof_tipoacesso,
    p.value,
    trl.name,
    adp.isactive,
    adp.isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    p.ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_process_access adp
     LEFT JOIN ad_process p ON ((adp.ad_process_id = p.ad_process_id)))
     LEFT JOIN ad_role r ON ((adp.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_process_trl trl ON ((p.ad_process_id = trl.ad_process_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT adf.ad_client_id,
    adf.ad_org_id,
    adf.ad_role_id,
    'Formulário'::text AS cof_tipoacesso,
    f.name AS value,
    trl.name,
    adf.isactive,
    adf.isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    f.ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_form_access adf
     LEFT JOIN ad_form f ON ((adf.ad_form_id = f.ad_form_id)))
     LEFT JOIN ad_role r ON ((adf.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_form_trl trl ON ((f.ad_form_id = trl.ad_form_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT adi.ad_client_id,
    adi.ad_org_id,
    adi.ad_role_id,
    'Info Window'::text AS cof_tipoacesso,
    i.name AS value,
    trl.name,
    adi.isactive,
    ''::bpchar AS isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    i.ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_infowindow_access adi
     LEFT JOIN ad_infowindow i ON ((adi.ad_infowindow_id = i.ad_infowindow_id)))
     LEFT JOIN ad_role r ON ((adi.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_infowindow_trl trl ON ((i.ad_infowindow_id = trl.ad_infowindow_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT adwf.ad_client_id,
    adwf.ad_org_id,
    adwf.ad_role_id,
    'Fluxo de Trabalho'::text AS cof_tipoacesso,
    wf.value,
    trl.name,
    adwf.isactive,
    adwf.isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    wf.ad_workflow_id,
    NULL::numeric AS ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_workflow_access adwf
     LEFT JOIN ad_workflow wf ON ((adwf.ad_workflow_id = wf.ad_workflow_id)))
     LEFT JOIN ad_role r ON ((adwf.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_workflow_trl trl ON ((wf.ad_workflow_id = trl.ad_workflow_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT adt.ad_client_id,
    adt.ad_org_id,
    adt.ad_role_id,
    'Tarefa'::text AS cof_tipoacesso,
    t.name AS value,
    trl.name,
    adt.isactive,
    adt.isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    t.ad_task_id,
    NULL::numeric AS c_doctype_id
   FROM (((ad_task_access adt
     LEFT JOIN ad_task t ON ((adt.ad_task_id = t.ad_task_id)))
     LEFT JOIN ad_role r ON ((adt.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_task_trl trl ON ((t.ad_task_id = trl.ad_task_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text)
UNION
 SELECT addoc.ad_client_id,
    addoc.ad_org_id,
    addoc.ad_role_id,
    'Ação do Documento'::text AS cof_tipoacesso,
    adr.value,
    trl.name,
    addoc.isactive,
    ''::bpchar AS isreadwrite,
    r.ismasterrole,
    r.ismanual,
    r.iscanapproveowndoc,
    r.isshowacct,
    r.iscanreport,
    r.ispersonallock,
    r.isaccessadvanced,
    r.overwritepricelimit,
    r.ischangelog,
    r.isaccessallorgs,
    r.isuseuserorgaccess,
    r.iscanexport,
    r.ispersonalaccess,
    r.ismenuautoexpand,
    r.allow_info_account,
    r.allow_info_schedule,
    r.cof_rolelevel,
    NULL::numeric AS ad_user_id,
    NULL::numeric AS ad_window_id,
    NULL::numeric AS ad_process_id,
    NULL::numeric AS ad_form_id,
    NULL::numeric AS ad_infowindow_id,
    NULL::numeric AS ad_workflow_id,
    NULL::numeric AS ad_task_id,
    addoc.c_doctype_id
   FROM (((ad_document_action_access addoc
     LEFT JOIN ad_ref_list adr ON ((addoc.ad_ref_list_id = adr.ad_ref_list_id)))
     LEFT JOIN ad_role r ON ((addoc.ad_role_id = r.ad_role_id)))
     LEFT JOIN ad_ref_list_trl trl ON ((adr.ad_ref_list_id = trl.ad_ref_list_id)))
  WHERE ((trl.ad_language)::text = 'pt_BR'::text);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views