catalog_tables: data, roles_fields
This data as json
| database_name | table_name | rootpage | sql |
|---|---|---|---|
| data | roles_fields | 4 | CREATE TABLE [roles_fields] ( [env] TEXT, [role_id] TEXT, [rolenameorig] TEXT, [issalesrole] TEXT, [_eml_nkey_] TEXT, [type] TEXT, [nsapiCT] TEXT, [subsidiaryoption] TEXT, [sys_id] TEXT, [tfaduration] TEXT, [id] TEXT, [issupportrole] TEXT, [employeeselectionunrestricted] TEXT, [centertype] TEXT, [parentrolelink] TEXT, [restrictbydevice] TEXT, [issinglesignononly] TEXT, [subsidiaryviewingallowed] TEXT, [entryformquerystring] TEXT, [tfarequired] TEXT, [cr] TEXT, [coreadminpermission] TEXT, [external] TEXT, [restricttimeandexpenses] TEXT, [name] TEXT, [iswebserviceonly] TEXT, [employeerestriction] TEXT, [origid] TEXT, [employeeviewingallowed] TEXT, [isinactive] TEXT, [scriptid] TEXT, [savedash] TEXT, [parentrolescriptid] TEXT, [package] TEXT, [roletype] TEXT, [internalid] TEXT, PRIMARY KEY ([env], [role_id]) ) |