itil_appointment
The table below describes the itil_appointment table.
This table contains the following foldable columns:
- sys_id_value
- location_value
- task_value
- user_value
- add_to_calendar_display_value
- add_to_calendar_value
- duration_display_value
- duration_value
- ends_display_value
- ends_value
- location_display_value
- notes_display_value
- notes_value
- reminder_display_value
- reminder_value
- starts_display_value
- starts_value
- subject_display_value
- subject_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
- task_display_value
- user_display_value
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
location_value Foreign Key linked to column sys_id_value in cmn_location table |
SQL_VARCHAR(64) | True | True |
|
task_value Foreign Key linked to column sys_id_value in task table |
SQL_VARCHAR(64) | True | True |
|
user_value Foreign Key linked to column sys_id_value in sys_user table |
SQL_VARCHAR(64) | True | True |
|
add_to_calendar_display_value |
SQL_VARCHAR(500) | True | True |
|
add_to_calendar_value |
SQL_BIT | True | True |
|
duration_display_value |
SQL_VARCHAR(500) | True | True |
|
duration_value |
SQL_TIMESTAMP | True | True |
|
ends_display_value |
SQL_VARCHAR(500) | True | True |
|
ends_value |
SQL_TIMESTAMP | True | True |
|
location_display_value |
SQL_VARCHAR(500) | True | True |
|
notes_display_value |
SQL_LONGVARCHAR(1024) | True | True |
|
notes_value |
SQL_LONGVARCHAR(1024) | True | True |
|
reminder_display_value |
SQL_VARCHAR(500) | True | True |
|
reminder_value |
SQL_VARCHAR(80) | True | True |
|
starts_display_value |
SQL_VARCHAR(500) | True | True |
|
starts_value |
SQL_TIMESTAMP | True | True |
|
subject_display_value |
SQL_VARCHAR(500) | True | True |
|
subject_value |
SQL_VARCHAR(200) | 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 |
|
task_display_value |
SQL_VARCHAR(500) | True | True |
|
user_display_value |
SQL_VARCHAR(500) | True | True |