ua_app_usage
The table below describes the ua_app_usage table.
This table contains the following foldable columns:
- sys_id_value
- user_value
- access_count_display_value
- access_count_value
- app_id_display_value
- app_id_value
- app_name_display_value
- app_name_value
- app_type_display_value
- app_type_value
- delete_count_display_value
- delete_count_value
- delete_other_count_display_value
- delete_other_count_value
- delete_own_count_display_value
- delete_own_count_value
- insert_count_display_value
- insert_count_value
- insert_other_count_display_value
- insert_other_count_value
- insert_own_count_display_value
- insert_own_count_value
- license_ids_display_value
- license_ids_value
- lineage_id_display_value
- lineage_id_value
- status_display_value
- status_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_tags_display_value
- sys_tags_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
- time_stamp_display_value
- time_stamp_value
- update_count_display_value
- update_count_value
- update_other_count_display_value
- update_other_count_value
- update_own_count_display_value
- update_own_count_value
- user_display_value
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
user_value Foreign Key linked to column sys_id_value in sys_user table |
SQL_VARCHAR(64) | True | True |
|
access_count_display_value |
SQL_VARCHAR(500) | True | True |
|
access_count_value |
SQL_INTEGER(signed) | True | True |
|
app_id_display_value |
SQL_VARCHAR(500) | True | True |
|
app_id_value |
SQL_VARCHAR(510) | True | True |
|
app_name_display_value |
SQL_VARCHAR(500) | True | True |
|
app_name_value |
SQL_VARCHAR(200) | True | True |
|
app_type_display_value |
SQL_VARCHAR(500) | True | True |
|
app_type_value |
SQL_VARCHAR(80) | True | True |
|
delete_count_display_value |
SQL_VARCHAR(500) | True | True |
|
delete_count_value |
SQL_INTEGER(signed) | True | True |
|
delete_other_count_display_value |
SQL_VARCHAR(500) | True | True |
|
delete_other_count_value |
SQL_INTEGER(signed) | True | True |
|
delete_own_count_display_value |
SQL_VARCHAR(500) | True | True |
|
delete_own_count_value |
SQL_INTEGER(signed) | True | True |
|
insert_count_display_value |
SQL_VARCHAR(500) | True | True |
|
insert_count_value |
SQL_INTEGER(signed) | True | True |
|
insert_other_count_display_value |
SQL_VARCHAR(500) | True | True |
|
insert_other_count_value |
SQL_INTEGER(signed) | True | True |
|
insert_own_count_display_value |
SQL_VARCHAR(500) | True | True |
|
insert_own_count_value |
SQL_INTEGER(signed) | True | True |
|
license_ids_display_value |
SQL_VARCHAR(8000) | True | True |
|
license_ids_value |
SQL_VARCHAR(8000) | True | True |
|
lineage_id_display_value |
SQL_VARCHAR(500) | True | True |
|
lineage_id_value |
SQL_VARCHAR(200) | True | True |
|
status_display_value |
SQL_VARCHAR(500) | True | True |
|
status_value |
SQL_INTEGER(signed) | True | True |
|
sys_created_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_created_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_on_value |
SQL_TIMESTAMP | False | True |
|
sys_id_display_value |
SQL_VARCHAR(500) | False | False |
|
sys_mod_count_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_mod_count_value |
SQL_INTEGER(signed) | False | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_updated_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_updated_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_on_value |
SQL_TIMESTAMP | False | True |
|
time_stamp_display_value |
SQL_VARCHAR(500) | True | True |
|
time_stamp_value |
SQL_VARCHAR(32) | True | True |
|
update_count_display_value |
SQL_VARCHAR(500) | True | True |
|
update_count_value |
SQL_INTEGER(signed) | True | True |
|
update_other_count_display_value |
SQL_VARCHAR(500) | True | True |
|
update_other_count_value |
SQL_INTEGER(signed) | True | True |
|
update_own_count_display_value |
SQL_VARCHAR(500) | True | True |
|
update_own_count_value |
SQL_INTEGER(signed) | True | True |
|
user_display_value |
SQL_VARCHAR(500) | True | True |