Skip to content

Fluent Support Database Schema

Fluent Support use custom database tables with options tables to store all the data. Here are the list of database tables, and it's schema to understand overall database design and related data attributes of each model.

Schema Design

Database Tables

fs_tickets

This table stores the ticket data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
customer_idbigint(20) UNSIGNED NULL
agent_idbigint(20) UNSIGNED NULL
mailbox_idbigint(20) UNSIGNED NULL
product_idbigint(20) UNSIGNED NULL
product_sourcevarchar(192) NULL
privacyvarchar(100) [private]
priorityvarchar(100) [normal]
client_priorityvarchar(100) [normal]
statusvarchar(100) [new]
titlevarchar(192) NULL
slugvarchar(192) NULL
hashvarchar(192) NULL
content_hashvarchar(192) NULL
message_idvarchar(192) NULL
sourcevarchar(192) NULL
contentlongtext NULL
secret_contentlongtext NULL
last_agent_responsetimestamp NULL
last_customer_responsetimestamp NULL
waiting_sincetimestamp NULL
response_countint(11) [0]
first_response_timeint(11) NULL
total_close_timeint(11) NULL
resolved_attimestamp NULL
closed_bybigint(20) UNSIGNED NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_tag_pivot

This table stores the tag relations

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
tag_idbigint(20) UNSIGNED
source_idbigint(20) UNSIGNED
source_typevarchar(192)
created_attimestamp NULL
updated_attimestamp NULL

fs_taggables

This table stores the tag data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
tag_typevarchar(192) NULL
titlevarchar(192)
slugvarchar(192)
descriptionlongtext NULL
settingstext NULL
created_bybigint(20) UNSIGNED NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_products

This table stores the product data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
source_uidbigint(20) UNSIGNED NULL
mailbox_idbigint(20) UNSIGNED NULL
titlevarchar(192) NULL
descriptiontext NULL
settingslongtext NULL
sourcevarchar(100) [local]
created_bybigint(20) UNSIGNED NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_persons

This table stores the persons data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
first_namevarchar(192) NULL
last_namevarchar(192) NULL
emailvarchar(192) NULL
titlevarchar(192) NULL
avatarvarchar(192) NULL
person_typevarchar(192) [customer]
statusvarchar(192) [active]
ip_addressvarchar(20) NULL
last_ip_addressvarchar(20) NULL
address_line_1varchar(192) NULL
address_line_2varchar(192) NULL
cityvarchar(192) NULL
zipvarchar(192) NULL
statevarchar(192) NULL
countryvarchar(192) NULL
notelongtext NULL
hashvarchar(192) NULL
user_idbigint(20) UNSIGNED NULL
descriptionmediumtext NULL
remote_uidbigint(20) UNSIGNED NULL
last_response_attimestamp NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_meta

This table stores the meta data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
object_typevarchar(192) NULL
object_idbigint(20) NULL
keyvarchar(192) NULL
valuelongtext NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_mail_boxes

This table stores the mailbox data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
namevarchar(192)
slugvarchar(192)
box_typevarchar(50) [web]
emailvarchar(192)
mapped_emailvarchar(192) NULL
email_footerlongtext NULL
settingslongtext NULL
avatarvarchar(192) NULL
created_bybigint(20) UNSIGNED NULL
is_defaultENUM('yes', 'no') [no]
created_attimestamp NULL
updated_attimestamp NULL

fs_data_metrix

This table stores the data metrix

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
stat_dateDATE
data_typevarchar(100) [agent_stat]
agent_idbigint(20) UNSIGNED NULL
repliesint(11) UNSIGNED NULL [0]
active_ticketsint(11) UNSIGNED NULL [0]
resolved_ticketsint(11) UNSIGNED NULL [0]
new_ticketsint(11) UNSIGNED NULL [0]
unassigned_ticketsint(11) UNSIGNED NULL [0]
close_to_averageint(11) UNSIGNED NULL [0]
created_attimestamp NULL
updated_attimestamp NULL

fs_conversations

This table stores the conversation data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
serialint(11) UNSIGNED [1]
ticket_idbigint(20) UNSIGNED
person_idbigint(20) UNSIGNED
conversation_typevarchar(100) [response]
contentlongtext NULL
sourcevarchar(100) [web]
content_hashvarchar(192) NULL
message_idvarchar(192) NULL
is_importantENUM('yes', 'no') [no]
created_attimestamp NULL
updated_attimestamp NULL

fs_attachments

This table stores the attachment data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
ticket_idbigint(20) UNSIGNED NULL
person_idbigint(20) UNSIGNED NULL
conversation_idbigint(20) UNSIGNED NULL
file_typevarchar(100) NULL
file_pathtext NULL
full_urltext NULL
settingstext NULL
titlevarchar(192) NULL
file_hashvarchar(192) NULL
drivervarchar(100) [local]
statusvarchar(100) NULL [active]
file_sizevarchar(100) NULL
created_attimestamp NULL
updated_attimestamp NULL

fs_activities

This table stores the activities data

ColumnTypeComment
idbigint(20) UNSIGNED Auto Increment
person_idbigint(20) NULL
person_typevarchar(192) NULL
event_typevarchar(192) NULL
object_idbigint(20) NULL
object_typevarchar(192) NULL
descriptionmediumtext NULL
created_attimestamp NULL
updated_attimestamp NULL