Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
id |
char |
36 |
|
|
|
|
|
name |
varchar |
255 |
√ |
|
null |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
description |
text |
65535 |
√ |
|
null |
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
base_module |
varchar |
100 |
√ |
|
null |
|
|
published |
varchar |
100 |
√ |
|
yes |
|
|
field |
varchar |
100 |
√ |
|
0 |
|
|
body_html |
text |
65535 |
√ |
|
null |
|
|
template_name |
varchar |
255 |
√ |
|
null |
|
|
author |
varchar |
255 |
√ |
|
SugarCRM |
|
|
title |
varchar |
255 |
√ |
|
null |
|
|
subject |
varchar |
255 |
√ |
|
null |
|
|
keywords |
varchar |
255 |
√ |
|
null |
|
|
header_title |
varchar |
255 |
√ |
|
null |
|
|
header_text |
varchar |
255 |
√ |
|
null |
|
|
header_logo |
varchar |
255 |
√ |
|
null |
|
|
footer_text |
varchar |
255 |
√ |
|
null |
|
|
Analyzed at Tue Sep 23 22:34 UTC 2014
|