Database – Support Transaction (support_transaction_entity)
Holds support transaction information.
Column | Data Type | Column Info | Value Notes | Other |
id | int(10) | The id of the entity | ||
title | varchar(100) | The name/title of the entity instance | ||
support_date | datetime | support date | ||
minutes | int(11) | support minutes | ||
adjustment_type | tinyint(1) | adjustment type | 1 - yes, 0 - no | |
notes | text | transaction notes | ||
user_id | int(10) | ID of the associated agent user | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
staff_user_id | int(11) | staff user id that gave support | ||
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
support_code_id | int(10) | Support code ID | ||
remote_addr | char(20) | IP address of the client machine |