Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
ad_client_id |
int4 |
10 |
√ |
|
null |
|
|
ad_org_id |
int4 |
10 |
√ |
|
null |
|
|
ad_allusers_v_id |
numeric |
10 |
√ |
|
null |
|
|
ad_allclients_v_id |
numeric |
10 |
√ |
|
null |
|
|
isactive |
bpchar |
1 |
√ |
|
null |
|
|
created |
timestamp |
29,6 |
√ |
|
null |
|
|
createdby |
numeric |
10 |
√ |
|
null |
|
|
updated |
timestamp |
29,6 |
√ |
|
null |
|
|
updatedby |
numeric |
10 |
√ |
|
null |
|
|
ad_alluserroles_v_uu |
varchar |
36 |
√ |
|
null |
|
|
name |
varchar |
60 |
√ |
|
null |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
userlevel |
bpchar |
3 |
√ |
|
null |
|
|
ismanual |
bpchar |
1 |
√ |
|
null |
|
|
isshowacct |
bpchar |
1 |
√ |
|
null |
|
|
ispersonallock |
bpchar |
1 |
√ |
|
null |
|
|
ispersonalaccess |
bpchar |
1 |
√ |
|
null |
|
|
iscanexport |
bpchar |
1 |
√ |
|
null |
|
|
iscanreport |
bpchar |
1 |
√ |
|
null |
|
|
isaccessallorgs |
bpchar |
1 |
√ |
|
null |
|
|
ischangelog |
bpchar |
1 |
√ |
|
null |
|
|
preferencetype |
bpchar |
1 |
√ |
|
null |
|
|
isuseuserorgaccess |
bpchar |
1 |
√ |
|
null |
|
|
ismasterrole |
bpchar |
1 |
√ |
|
null |
|
|
isaccessadvanced |
bpchar |
1 |
√ |
|
null |
|
|
roletype |
varchar |
2 |
√ |
|
null |
|
|
ad_allroles_v_id |
numeric |
10 |
√ |
|
null |
|
|
Analyzed at 2024-01-03 13:44 +0100
|