|
id
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
description
|
text
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
case_number
|
int(11)
|
|
|
|
|
type
|
varchar(255)
|
|
|
|
|
status
|
varchar(100)
|
|
|
|
|
priority
|
varchar(100)
|
|
|
|
|
resolution
|
text
|
|
|
|
|
work_log
|
text
|
|
|
|
|
account_id
|
char(36)
|
|
|
|
|
state
|
varchar(100)
|
|
|
Open
|
|
contact_created_by_id
|
char(36)
|
|
|
|