Skip to content

Instantly share code, notes, and snippets.

/beanFiles Secret

Created February 12, 2015 20:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/8f1b4537cadffbcf2081 to your computer and use it in GitHub Desktop.
Save anonymous/8f1b4537cadffbcf2081 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
beanFiles
This information tells us whether or not the beanFiles specified in the beanList actually exists. This can be an issue with an improperly defined module loaded extension.
Green means the file does exist.
Orange means there is no indexed file, so we cannot look it up.
Red means the file does not exist.
YES --- ACLRole file "modules/ACLRoles/ACLRole.php" exists
YES --- ACLAction file "modules/ACLActions/ACLAction.php" exists
YES --- Lead file "modules/Leads/Lead.php" exists
YES --- aCase file "modules/Cases/Case.php" exists
YES --- Bug file "modules/Bugs/Bug.php" exists
YES --- ProspectList file "modules/ProspectLists/ProspectList.php" exists
YES --- Prospect file "modules/Prospects/Prospect.php" exists
YES --- Project file "modules/Project/Project.php" exists
YES --- ProjectTask file "modules/ProjectTask/ProjectTask.php" exists
YES --- Campaign file "modules/Campaigns/Campaign.php" exists
YES --- EmailMarketing file "modules/EmailMarketing/EmailMarketing.php" exists
YES --- CampaignLog file "modules/CampaignLog/CampaignLog.php" exists
YES --- CampaignTracker file "modules/CampaignTrackers/CampaignTracker.php" exists
YES --- Release file "modules/Releases/Release.php" exists
YES --- Group file "modules/Groups/Group.php" exists
YES --- EmailMan file "modules/EmailMan/EmailMan.php" exists
YES --- Scheduler file "modules/Schedulers/Scheduler.php" exists
YES --- SchedulersJob file "modules/SchedulersJobs/SchedulersJob.php" exists
YES --- Contact file "modules/Contacts/Contact.php" exists
YES --- Account file "modules/Accounts/Account.php" exists
NO! --- DynamicField is not an index in $beanFiles
YES --- FieldsMetaData file "modules/DynamicFields/FieldsMetaData.php" exists
YES --- Opportunity file "modules/Opportunities/Opportunity.php" exists
YES --- EmailTemplate file "modules/EmailTemplates/EmailTemplate.php" exists
YES --- Note file "modules/Notes/Note.php" exists
YES --- Call file "modules/Calls/Call.php" exists
YES --- Email file "modules/Emails/Email.php" exists
YES --- Meeting file "modules/Meetings/Meeting.php" exists
YES --- Task file "modules/Tasks/Task.php" exists
YES --- User file "modules/Users/User.php" exists
YES --- Currency file "modules/Currencies/Currency.php" exists
YES --- Tracker file "modules/Trackers/Tracker.php" exists
NO! --- Connectors is not an index in $beanFiles
YES --- ImportMap file "modules/Import/maps/ImportMap.php" exists
YES --- UsersLastImport file "modules/Import/UsersLastImport.php" exists
YES --- Version file "modules/Versions/Version.php" exists
YES --- Administration file "modules/Administration/Administration.php" exists
YES --- vCal file "modules/vCals/vCal.php" exists
NO! --- CustomFields is not an index in $beanFiles
YES --- Document file "modules/Documents/Document.php" exists
YES --- DocumentRevision file "modules/DocumentRevisions/DocumentRevision.php" exists
YES --- Role file "modules/Roles/Role.php" exists
NO! --- Audit is not an index in $beanFiles
YES --- InboundEmail file "modules/InboundEmail/InboundEmail.php" exists
YES --- SavedSearch file "modules/SavedSearch/SavedSearch.php" exists
YES --- UserPreference file "modules/UserPreferences/UserPreference.php" exists
YES --- MergeRecord file "modules/MergeRecords/MergeRecord.php" exists
YES --- EmailAddress file "modules/EmailAddresses/EmailAddress.php" exists
YES --- EmailText file "modules/EmailText/EmailText.php" exists
YES --- Relationship file "modules/Relationships/Relationship.php" exists
YES --- Employee file "modules/Employees/Employee.php" exists
YES --- SugarFeed file "modules/SugarFeed/SugarFeed.php" exists
YES --- EAPM file "modules/EAPM/EAPM.php" exists
YES --- OAuthKey file "modules/OAuthKeys/OAuthKey.php" exists
YES --- OAuthToken file "modules/OAuthTokens/OAuthToken.php" exists
YES --- jjwg_Maps file "modules/jjwg_Maps/jjwg_Maps.php" exists
YES --- jjwg_Markers file "modules/jjwg_Markers/jjwg_Markers.php" exists
YES --- jjwg_Areas file "modules/jjwg_Areas/jjwg_Areas.php" exists
YES --- jjwg_Address_Cache file "modules/jjwg_Address_Cache/jjwg_Address_Cache.php" exists
YES --- AOD_IndexEvent file "modules/AOD_IndexEvent/AOD_IndexEvent.php" exists
YES --- AOD_Index file "modules/AOD_Index/AOD_Index.php" exists
YES --- AOS_Contracts file "modules/AOS_Contracts/AOS_Contracts.php" exists
YES --- AOS_Invoices file "modules/AOS_Invoices/AOS_Invoices.php" exists
YES --- AOS_PDF_Templates file "modules/AOS_PDF_Templates/AOS_PDF_Templates.php" exists
YES --- AOS_Product_Categories file "modules/AOS_Product_Categories/AOS_Product_Categories.php" exists
YES --- AOS_Products file "modules/AOS_Products/AOS_Products.php" exists
YES --- AOS_Products_Quotes file "modules/AOS_Products_Quotes/AOS_Products_Quotes.php" exists
YES --- AOS_Line_Item_Groups file "modules/AOS_Line_Item_Groups/AOS_Line_Item_Groups.php" exists
YES --- AOS_Quotes file "modules/AOS_Quotes/AOS_Quotes.php" exists
YES --- Calls_Reschedule file "modules/Calls_Reschedule/Calls_Reschedule.php" exists
YES --- AOP_Case_Events file "modules/AOP_Case_Events/AOP_Case_Events.php" exists
YES --- AOP_Case_Updates file "modules/AOP_Case_Updates/AOP_Case_Updates.php" exists
YES --- SecurityGroup file "modules/SecurityGroups/SecurityGroup.php" exists
YES --- AOW_Action file "modules/AOW_Actions/AOW_Action.php" exists
YES --- AOW_WorkFlow file "modules/AOW_WorkFlow/AOW_WorkFlow.php" exists
YES --- AOW_Processed file "modules/AOW_Processed/AOW_Processed.php" exists
YES --- AOW_Condition file "modules/AOW_Conditions/AOW_Condition.php" exists
YES --- AM_ProjectTemplates file "modules/AM_ProjectTemplates/AM_ProjectTemplates.php" exists
YES --- AM_TaskTemplates file "modules/AM_TaskTemplates/AM_TaskTemplates.php" exists
YES --- AM_ProjectHolidays file "modules/AM_ProjectHolidays/AM_ProjectHolidays.php" exists
YES --- FP_events file "modules/FP_events/FP_events.php" exists
YES --- FP_Event_Locations file "modules/FP_Event_Locations/FP_Event_Locations.php" exists
YES --- AOR_Report file "modules/AOR_Reports/AOR_Report.php" exists
YES --- AOR_Field file "modules/AOR_Fields/AOR_Field.php" exists
YES --- AOR_Chart file "modules/AOR_Charts/AOR_Chart.php" exists
YES --- AOR_Condition file "modules/AOR_Conditions/AOR_Condition.php" exists
YES --- AOR_Scheduled_Reports file "modules/AOR_Scheduled_Reports/AOR_Scheduled_Reports.php" exists
Raw
php.ini
phpinfo()
PHP Version => 5.3.3
System => Linux crm.example.com 2.6.32-504.8.1.el6.x86_64 #1 SMP Wed Jan 28 21:11:36 UTC 2015 x86_64
Build Date => Oct 30 2014 20:10:32
Configure Command => './configure' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' '--without-sqlite' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--enable-force-cgi-redirect' '--enable-pcntl' '--with-imap=shared' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbregex' '--with-gd=shared' '--enable-bcmath=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-ldap-sasl' '--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/lib64/mysql/mysql_config' '--enable-dom=shared' '--with-pgsql=shared' '--enable-wddx=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared,/usr' '--enable-fastcgi' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,/usr/lib64/mysql/mysql_config' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-sqlite3=shared,/usr' '--enable-json=shared' '--enable-zip=shared' '--without-readline' '--with-libedit' '--with-pspell=shared' '--enable-phar=shared' '--with-tidy=shared,/usr' '--enable-sysvmsg=shared' '--enable-sysvshm=shared' '--enable-sysvsem=shared' '--enable-posix=shared' '--with-unixODBC=shared,/usr' '--enable-fileinfo=shared' '--enable-intl=shared' '--with-icu-dir=/usr' '--with-enchant=shared,/usr' '--with-recode=shared,/usr'
Server API => Command Line Interface
Virtual Directory Support => disabled
Configuration File (php.ini) Path => /etc
Loaded Configuration File => /etc/php.ini
Scan this dir for additional .ini files => /etc/php.d
Additional .ini files parsed => /etc/php.d/gd.ini,
/etc/php.d/imap.ini,
/etc/php.d/mbstring.ini,
/etc/php.d/mysql.ini,
/etc/php.d/mysqli.ini,
/etc/php.d/pdo.ini,
/etc/php.d/pdo_mysql.ini,
/etc/php.d/pdo_sqlite.ini,
/etc/php.d/sqlite3.ini
PHP API => 20090626
PHP Extension => 20090626
Zend Extension => 220090626
Zend Extension Build => API220090626,NTS
PHP Extension Build => API20090626,NTS
Debug Build => no
Thread Safety => disabled
Zend Memory Manager => enabled
Zend Multibyte Support => disabled
IPv6 Support => enabled
Registered PHP Streams => https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, zip
Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters => zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
_______________________________________________________________________
Configuration
bz2
BZip2 Support => Enabled
Stream Wrapper support => compress.bz2://
Stream Filter support => bzip2.decompress, bzip2.compress
BZip2 Version => 1.0.5, 10-Dec-2007
calendar
Calendar support => enabled
Core
PHP Version => 5.3.3
Directive => Local Value => Master Value
allow_call_time_pass_reference => Off => Off
allow_url_fopen => On => On
allow_url_include => Off => Off
always_populate_raw_post_data => Off => Off
arg_separator.input => & => &
arg_separator.output => & => &
asp_tags => Off => Off
auto_append_file => no value => no value
auto_globals_jit => On => On
auto_prepend_file => no value => no value
browscap => no value => no value
default_charset => no value => no value
default_mimetype => text/html => text/html
define_syslog_variables => Off => Off
disable_classes => no value => no value
disable_functions => no value => no value
display_errors => Off => Off
display_startup_errors => Off => Off
doc_root => no value => no value
docref_ext => no value => no value
docref_root => no value => no value
enable_dl => Off => Off
error_append_string => no value => no value
error_log => no value => no value
error_prepend_string => no value => no value
error_reporting => 22527 => 22527
exit_on_timeout => Off => Off
expose_php => On => On
extension_dir => /usr/lib64/php/modules => /usr/lib64/php/modules
file_uploads => On => On
highlight.bg => <font style="color: #FFFFFF">#FFFFFF</font> => <font style="color: #FFFFFF">#FFFFFF</font>
highlight.comment => <font style="color: #FF8000">#FF8000</font> => <font style="color: #FF8000">#FF8000</font>
highlight.default => <font style="color: #0000BB">#0000BB</font> => <font style="color: #0000BB">#0000BB</font>
highlight.html => <font style="color: #000000">#000000</font> => <font style="color: #000000">#000000</font>
highlight.keyword => <font style="color: #007700">#007700</font> => <font style="color: #007700">#007700</font>
highlight.string => <font style="color: #DD0000">#DD0000</font> => <font style="color: #DD0000">#DD0000</font>
html_errors => Off => Off
ignore_repeated_errors => Off => Off
ignore_repeated_source => Off => Off
ignore_user_abort => Off => Off
implicit_flush => On => On
include_path => .:/usr/share/pear:/usr/share/php => .:/usr/share/pear:/usr/share/php
log_errors => On => On
log_errors_max_len => 1024 => 1024
magic_quotes_gpc => Off => Off
magic_quotes_runtime => Off => Off
magic_quotes_sybase => Off => Off
mail.add_x_header => On => On
mail.force_extra_parameters => no value => no value
mail.log => no value => no value
max_execution_time => 0 => 0
max_file_uploads => 20 => 20
max_input_nesting_level => 64 => 64
max_input_time => -1 => -1
max_input_vars => 1000 => 1000
memory_limit => 512M => 512M
open_basedir => no value => no value
output_buffering => 0 => 0
output_handler => no value => no value
post_max_size => 8000M => 8000M
precision => 14 => 14
realpath_cache_size => 16K => 16K
realpath_cache_ttl => 120 => 120
register_argc_argv => On => On
register_globals => Off => Off
register_long_arrays => Off => Off
report_memleaks => On => On
report_zend_debug => Off => Off
request_order => GP => GP
safe_mode => Off => Off
safe_mode_exec_dir => no value => no value
safe_mode_gid => Off => Off
safe_mode_include_dir => no value => no value
sendmail_from => no value => no value
sendmail_path => /usr/sbin/sendmail -t -i => /usr/sbin/sendmail -t -i
serialize_precision => 100 => 100
short_open_tag => Off => Off
SMTP => localhost => localhost
smtp_port => 25 => 25
sql.safe_mode => Off => Off
track_errors => Off => Off
unserialize_callback_func => no value => no value
upload_max_filesize => 2000M => 2000M
upload_tmp_dir => no value => no value
user_dir => no value => no value
user_ini.cache_ttl => 300 => 300
user_ini.filename => .user.ini => .user.ini
variables_order => GPCS => GPCS
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
y2k_compliance => On => On
zend.enable_gc => On => On
ctype
ctype functions => enabled
date
date/time support => enabled
"Olson" Timezone Database Version => 0.system
Timezone Database => internal
Default timezone => America/Chicago
Directive => Local Value => Master Value
date.default_latitude => 31.7667 => 31.7667
date.default_longitude => 35.2333 => 35.2333
date.sunrise_zenith => 90.583333 => 90.583333
date.sunset_zenith => 90.583333 => 90.583333
date.timezone => America/Chicago => America/Chicago
ereg
Regex Library => Bundled library enabled
exif
EXIF Support => enabled
EXIF Version => 1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $
Supported EXIF Version => 0220
Supported filetypes => JPEG,TIFF
Directive => Local Value => Master Value
exif.decode_jis_intel => JIS => JIS
exif.decode_jis_motorola => JIS => JIS
exif.decode_unicode_intel => UCS-2LE => UCS-2LE
exif.decode_unicode_motorola => UCS-2BE => UCS-2BE
exif.encode_jis => no value => no value
exif.encode_unicode => ISO-8859-15 => ISO-8859-15
filter
Input Validation and Filtering => enabled
Revision => $Revision: 298196 $
Directive => Local Value => Master Value
filter.default => unsafe_raw => unsafe_raw
filter.default_flags => no value => no value
ftp
FTP support => enabled
gd
GD Support => enabled
GD Version => bundled (2.0.34 compatible)
FreeType Support => enabled
FreeType Linkage => with freetype
FreeType Version => 2.3.11
GIF Read Support => enabled
GIF Create Support => enabled
JPEG Support => enabled
libJPEG Version => 6b
PNG Support => enabled
libPNG Version => 1.2.49
WBMP Support => enabled
XPM Support => enabled
XBM Support => enabled
Directive => Local Value => Master Value
gd.jpeg_ignore_warning => 0 => 0
gettext
GetText Support => enabled
gmp
gmp support => enabled
GMP version => 4.3.1
hash
hash support => enabled
Hashing Engines => md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
iconv
iconv support => enabled
iconv implementation => glibc
iconv library version => 2.12
Directive => Local Value => Master Value
iconv.input_encoding => ISO-8859-1 => ISO-8859-1
iconv.internal_encoding => ISO-8859-1 => ISO-8859-1
iconv.output_encoding => ISO-8859-1 => ISO-8859-1
imap
IMAP c-Client Version => 2007e
SSL Support => enabled
Kerberos Support => enabled
json
json support => enabled
json version => 1.2.1
libxml
libXML support => active
libXML Compiled Version => 2.7.6
libXML Loaded Version => 20706
libXML streams => enabled
mbstring
Multibyte Support => enabled
Multibyte string engine => libmbfl
HTTP input encoding translation => disabled
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex support => enabled
Multibyte regex (oniguruma) backtrack check => On
Multibyte regex (oniguruma) version => 4.7.1
Directive => Local Value => Master Value
mbstring.detect_order => no value => no value
mbstring.encoding_translation => Off => Off
mbstring.func_overload => 0 => 0
mbstring.http_input => pass => pass
mbstring.http_output => pass => pass
mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml\+xml) => ^(text/|application/xhtml\+xml)
mbstring.internal_encoding => no value => no value
mbstring.language => neutral => neutral
mbstring.strict_detection => Off => Off
mbstring.substitute_character => no value => no value
mysql
MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 5.3.12-MariaDB
MYSQL_MODULE_TYPE => external
MYSQL_SOCKET => /var/lib/mysql/mysql.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib64/mysql -lmysqlclient
Directive => Local Value => Master Value
mysql.allow_local_infile => On => On
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off
mysqli
MysqlI Support => enabled
Client API library version => 5.3.12-MariaDB
Active Persistent Links => 0
Inactive Persistent Links => 0
Active Links => 0
Client API header version => 5.1.73
MYSQLI_SOCKET => /var/lib/mysql/mysql.sock
Directive => Local Value => Master Value
mysqli.allow_local_infile => On => On
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => no value => no value
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
openssl
OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 1.0.1e-fips 11 Feb 2013
OpenSSL Header Version => OpenSSL 1.0.1e-fips 11 Feb 2013
pcntl
pcntl support => enabled
pcre
PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 7.8 2008-09-05
Directive => Local Value => Master Value
pcre.backtrack_limit => 100000 => 100000
pcre.recursion_limit => 100000 => 100000
PDO
PDO support => enabled
PDO drivers => mysql, sqlite
pdo_mysql
PDO Driver for MySQL => enabled
Client API version => 5.3.12-MariaDB
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.6.20
Reflection
Reflection => enabled
Version => $Revision: 300393 $
session
Session Support => enabled
Registered save handlers => files user
Registered serializer handlers => php php_binary
Directive => Local Value => Master Value
session.auto_start => Off => Off
session.bug_compat_42 => Off => Off
session.bug_compat_warn => Off => Off
session.cache_expire => 180 => 180
session.cache_limiter => nocache => nocache
session.cookie_domain => no value => no value
session.cookie_httponly => Off => Off
session.cookie_lifetime => 0 => 0
session.cookie_path => / => /
session.cookie_secure => Off => Off
session.entropy_file => no value => no value
session.entropy_length => 0 => 0
session.gc_divisor => 1000 => 1000
session.gc_maxlifetime => 1440 => 1440
session.gc_probability => 1 => 1
session.hash_bits_per_character => 5 => 5
session.hash_function => 0 => 0
session.name => PHPSESSID => PHPSESSID
session.referer_check => no value => no value
session.save_handler => files => files
session.save_path => no value => no value
session.serialize_handler => php => php
session.use_cookies => On => On
session.use_only_cookies => On => On
session.use_trans_sid => 0 => 0
shmop
shmop support => enabled
SimpleXML
Simplexml support => enabled
Revision => $Revision: 299424 $
Schema support => enabled
sockets
Sockets Support => enabled
SPL
SPL support => enabled
Interfaces => Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes => AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
sqlite3
SQLite3 support => enabled
SQLite3 module version => 0.7-dev
SQLite Library => 3.6.20
Directive => Local Value => Master Value
sqlite3.extension_dir => no value => no value
standard
Dynamic Library Support => enabled
Path to sendmail => /usr/sbin/sendmail -t -i
Directive => Local Value => Master Value
assert.active => 1 => 1
assert.bail => 0 => 0
assert.callback => no value => no value
assert.quiet_eval => 0 => 0
assert.warning => 1 => 1
auto_detect_line_endings => 0 => 0
default_socket_timeout => 60 => 60
safe_mode_allowed_env_vars => PHP_ => PHP_
safe_mode_protected_env_vars => LD_LIBRARY_PATH => LD_LIBRARY_PATH
url_rewriter.tags => a=href,area=href,frame=src,input=src,form=fakeentry => a=href,area=href,frame=src,input=src,form=fakeentry
user_agent => no value => no value
tokenizer
Tokenizer Support => enabled
xml
XML Support => active
XML Namespace Support => active
libxml2 Version => 2.7.6
zip
Zip => enabled
Extension Version => $Id: php_zip.c 300470 2010-06-15 18:48:33Z pajoye $
Zip version => 1.9.1
Libzip version => 0.9.0
zlib
ZLib Support => enabled
Stream Wrapper support => compress.zlib://
Stream Filter support => zlib.inflate, zlib.deflate
Compiled Version => 1.2.3
Linked Version => 1.2.3
Directive => Local Value => Master Value
zlib.output_compression => Off => Off
zlib.output_compression_level => -1 => -1
zlib.output_handler => no value => no value
Additional Modules
Module Name
readline
Environment
Variable => Value
HOSTNAME => crm.example.com
SHELL => /bin/bash
TERM => screen
HISTSIZE => 1000
SSH_TTY => /dev/pts/0
USER => root
LS_COLORS => rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
TERMCAP => SC|screen|VT 100/ANSI X3.64 virtual terminal:\
:DO=\E[%dB:LE=\E[%dD:RI=\E[%dC:UP=\E[%dA:bs:bt=\E[Z:\
:cd=\E[J:ce=\E[K:cl=\E[H\E[J:cm=\E[%i%d;%dH:ct=\E[3g:\
:do=^J:nd=\E[C:pt:rc=\E8:rs=\Ec:sc=\E7:st=\EH:up=\EM:\
:le=^H:bl=^G:cr=^M:it#8:ho=\E[H:nw=\EE:ta=^I:is=\E)0:\
:li#53:co#226:am:xn:xv:LP:sr=\EM:al=\E[L:AL=\E[%dL:\
:cs=\E[%i%d;%dr:dl=\E[M:DL=\E[%dM:dc=\E[P:DC=\E[%dP:\
:im=\E[4h:ei=\E[4l:mi:IC=\E[%d@:ks=\E[?1h\E=:\
:ke=\E[?1l\E>:vi=\E[?25l:ve=\E[34h\E[?25h:vs=\E[34l:\
:ti=\E[?1049h:te=\E[?1049l:us=\E[4m:ue=\E[24m:so=\E[3m:\
:se=\E[23m:mb=\E[5m:md=\E[1m:mr=\E[7m:me=\E[m:ms:\
:Co#8:pa#64:AF=\E[3%dm:AB=\E[4%dm:op=\E[39;49m:AX:\
:vb=\Eg:G0:as=\E(0:ae=\E(B:\
:ac=\140\140aaffggjjkkllmmnnooppqqrrssttuuvvwwxxyyzz{{||}}~~..--++,,hhII00:\
:po=\E[5i:pf=\E[4i:k0=\E[10~:k1=\EOP:k2=\EOQ:k3=\EOR:\
:k4=\EOS:k5=\E[15~:k6=\E[17~:k7=\E[18~:k8=\E[19~:\
:k9=\E[20~:k;=\E[21~:F1=\E[23~:F2=\E[24~:F3=\E[1;2P:\
:F4=\E[1;2Q:F5=\E[1;2R:F6=\E[1;2S:F7=\E[15;2~:\
:F8=\E[17;2~:F9=\E[18;2~:FA=\E[19;2~:kb=:K2=\EOE:\
:kB=\E[Z:kF=\E[1;2B:kR=\E[1;2A:*4=\E[3;2~:*7=\E[1;2F:\
:#2=\E[1;2H:#3=\E[2;2~:#4=\E[1;2D:%c=\E[6;2~:%e=\E[5;2~:\
:%i=\E[1;2C:kh=\E[1~:@1=\E[1~:kH=\E[4~:@7=\E[4~:\
:kN=\E[6~:kP=\E[5~:kI=\E[2~:kD=\E[3~:ku=\EOA:kd=\EOB:\
:kr=\EOC:kl=\EOD:km:
PATH => /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
MAIL => /var/spool/mail/root
STY => 22415.pts-0.crm
PWD => /var/www/html/crm
LANG => en_US.UTF-8
HISTCONTROL => ignoredups
HOME => /root
SHLVL => 2
LOGNAME => root
CVS_RSH => ssh
WINDOW => 5
LESSOPEN => ||/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES => 1
OLDPWD => /var/www/html/crm
_ => /usr/bin/php
PHP Variables
Variable => Value
_SERVER["HOSTNAME"] => crm.example.com
_SERVER["SHELL"] => /bin/bash
_SERVER["TERM"] => screen
_SERVER["HISTSIZE"] => 1000
_SERVER["SSH_TTY"] => /dev/pts/0
_SERVER["USER"] => root
_SERVER["LS_COLORS"] => rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
_SERVER["TERMCAP"] => SC|screen|VT 100/ANSI X3.64 virtual terminal:\
:DO=\E[%dB:LE=\E[%dD:RI=\E[%dC:UP=\E[%dA:bs:bt=\E[Z:\
:cd=\E[J:ce=\E[K:cl=\E[H\E[J:cm=\E[%i%d;%dH:ct=\E[3g:\
:do=^J:nd=\E[C:pt:rc=\E8:rs=\Ec:sc=\E7:st=\EH:up=\EM:\
:le=^H:bl=^G:cr=^M:it#8:ho=\E[H:nw=\EE:ta=^I:is=\E)0:\
:li#53:co#226:am:xn:xv:LP:sr=\EM:al=\E[L:AL=\E[%dL:\
:cs=\E[%i%d;%dr:dl=\E[M:DL=\E[%dM:dc=\E[P:DC=\E[%dP:\
:im=\E[4h:ei=\E[4l:mi:IC=\E[%d@:ks=\E[?1h\E=:\
:ke=\E[?1l\E>:vi=\E[?25l:ve=\E[34h\E[?25h:vs=\E[34l:\
:ti=\E[?1049h:te=\E[?1049l:us=\E[4m:ue=\E[24m:so=\E[3m:\
:se=\E[23m:mb=\E[5m:md=\E[1m:mr=\E[7m:me=\E[m:ms:\
:Co#8:pa#64:AF=\E[3%dm:AB=\E[4%dm:op=\E[39;49m:AX:\
:vb=\Eg:G0:as=\E(0:ae=\E(B:\
:ac=\140\140aaffggjjkkllmmnnooppqqrrssttuuvvwwxxyyzz{{||}}~~..--++,,hhII00:\
:po=\E[5i:pf=\E[4i:k0=\E[10~:k1=\EOP:k2=\EOQ:k3=\EOR:\
:k4=\EOS:k5=\E[15~:k6=\E[17~:k7=\E[18~:k8=\E[19~:\
:k9=\E[20~:k;=\E[21~:F1=\E[23~:F2=\E[24~:F3=\E[1;2P:\
:F4=\E[1;2Q:F5=\E[1;2R:F6=\E[1;2S:F7=\E[15;2~:\
:F8=\E[17;2~:F9=\E[18;2~:FA=\E[19;2~:kb=:K2=\EOE:\
:kB=\E[Z:kF=\E[1;2B:kR=\E[1;2A:*4=\E[3;2~:*7=\E[1;2F:\
:#2=\E[1;2H:#3=\E[2;2~:#4=\E[1;2D:%c=\E[6;2~:%e=\E[5;2~:\
:%i=\E[1;2C:kh=\E[1~:@1=\E[1~:kH=\E[4~:@7=\E[4~:\
:kN=\E[6~:kP=\E[5~:kI=\E[2~:kD=\E[3~:ku=\EOA:kd=\EOB:\
:kr=\EOC:kl=\EOD:km:
_SERVER["PATH"] => /usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
_SERVER["MAIL"] => /var/spool/mail/root
_SERVER["STY"] => 22415.pts-0.crm
_SERVER["PWD"] => /var/www/html/crm
_SERVER["LANG"] => en_US.UTF-8
_SERVER["HISTCONTROL"] => ignoredups
_SERVER["HOME"] => /root
_SERVER["SHLVL"] => 2
_SERVER["LOGNAME"] => root
_SERVER["CVS_RSH"] => ssh
_SERVER["WINDOW"] => 5
_SERVER["LESSOPEN"] => ||/usr/bin/lesspipe.sh %s
_SERVER["G_BROKEN_FILENAMES"] => 1
_SERVER["OLDPWD"] => /var/www/html/crm
_SERVER["_"] => /usr/bin/php
_SERVER["PHP_SELF"] =>
_SERVER["SCRIPT_NAME"] =>
_SERVER["SCRIPT_FILENAME"] =>
_SERVER["PATH_TRANSLATED"] =>
_SERVER["DOCUMENT_ROOT"] =>
_SERVER["REQUEST_TIME"] => 1423773332
_SERVER["argv"] => Array
(
)
_SERVER["argc"] => 0
PHP License
This program is free software; you can redistribute it and/or modify
it under the terms of the PHP License as published by the PHP Group
and included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any
questions about PHP licensing, please contact license@php.net.
Raw
sytemenvironment
[root@dev ~]# vim /var/www/html/crm/phpinfo.txt
[root@dev ~]# mysql -V
mysql Ver 15.1 Distrib 10.0.16-MariaDB, for Linux (x86_64) using readline 5.1
[root@dev ~]# cat /etc/redhat-release
CentOS release 6.6 (Final)
[root@dev ~]# httpd -V
Server version: Apache/2.2.15 (Unix)
Server built: Oct 16 2014 14:48:21
Server's Module Magic Number: 20051115:25
Server loaded: APR 1.3.9, APR-Util 1.3.9
Compiled using: APR 1.3.9, APR-Util 1.3.9
Architecture: 64-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT="/etc/httpd"
-D SUEXEC_BIN="/usr/sbin/suexec"
-D DEFAULT_PIDLOG="run/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_LOCKFILE="logs/accept.lock"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"
Raw
vardefschema
Schema listing based on vardefs
Sugar version: 6.5.20 / Sugar DB version: 6.5.20 / Sugar flavor: CE
Table: accounts
Accounts are organizations or entities that are the target of selling, support, and marketing activities, or have already purchased products or services
Column Type Length Required Comment
account_type enum 50 no The Company is of this type
annual_revenue varchar 100 no Annual revenue for this company
assigned_user_id id n/a no User ID assigned to record
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
campaign_id id n/a no Campaign that generated Account
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
employees varchar 10 no Number of employees, varchar to accomodate for both number (100) or range (50-100)
id id n/a yes Unique identifier
industry enum 50 no The company belongs in this industry
modified_user_id id n/a no User who last modified record
name varchar 150 yes Name of the Company
ownership varchar 100 no (none)
parent_id id n/a no Account ID of the parent of this account
phone_alternate varchar 100 no An alternate phone number
phone_fax varchar 100 no The fax phone number of this company
phone_office varchar 100 no The office phone number
rating varchar 100 no An arbitrary rating for this company for use in comparisons with others
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
sic_code varchar 10 no SIC code of the account
ticker_symbol varchar 10 no The stock trading (ticker) symbol for the company
website varchar 255 no URL of website for the company
Table: accounts_bugs
Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
bug_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: accounts_cases
Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
case_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: accounts_contacts
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
account_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: accounts_opportunities
Column Type Length Required Comment
id varchar 36 no (none)
opportunity_id varchar 36 no (none)
account_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: acl_actions
Determine the allowable actions available to users
Column Type Length Required Comment
aclaccess int 3 no Number specifying access priority; highest access "wins"
acltype varchar 100 no Specifier for Category, usually "module"
category varchar 100 no Category of the allowable action (usually the name of a module)
created_by id 36 no User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
modified_user_id id 36 no User who last modified record
name varchar 150 no Name of the allowable action (view, list, delete, edit)
Table: acl_roles
ACL Role definition
Column Type Length Required Comment
created_by id 36 no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no The role description
id id n/a yes Unique identifier
modified_user_id id 36 no User who last modified record
name varchar 150 no The role name
Table: acl_roles_actions
Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
action_id varchar 36 no (none)
access_override int 3 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: acl_roles_users
Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: address_book
Column Type Length Required Comment
assigned_user_id id n/a yes (none)
bean varchar 50 yes (none)
bean_id id n/a yes (none)
Table: am_projectholidays
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
holiday_date date n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
resource_id varchar 36 no (none)
resource_type varchar 255 no (none)
resourse_users enum 100 no (none)
Table: am_projectholidays_project_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_projectholidays_projectproject_ida varchar 36 no (none)
am_projectholidays_projectam_projectholidays_idb varchar 36 no (none)
Table: am_projecttemplates
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
priority enum 100 no (none)
status enum 100 no (none)
Table: am_projecttemplates_project_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_projecttemplates_project_1am_projecttemplates_ida varchar 36 no (none)
am_projecttemplates_project_1project_idb varchar 36 no (none)
Table: am_tasktemplates
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
duration int 255 yes (none)
estimated_effort int 255 no (none)
id id n/a yes Unique identifier
milestone_flag bool 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
order_number int 255 no (none)
percent_complete varchar 255 no (none)
predecessors int 255 no (none)
priority enum 100 no (none)
relationship_type enum 100 no (none)
status enum 100 no (none)
task_number int 255 no (none)
utilization enum 100 no (none)
Table: am_tasktemplates_am_projecttemplates_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_tasktemplates_am_projecttemplatesam_projecttemplates_ida varchar 36 no (none)
am_tasktemplates_am_projecttemplatesam_tasktemplates_idb varchar 36 no (none)
Table: aod_index
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
last_optimised datetime n/a no (none)
location varchar 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: aod_indexevent
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
error varchar 255 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
record_id id n/a no (none)
record_module varchar 255 no (none)
success bool n/a no (none)
Table: aop_case_events
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
case_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: aop_case_updates
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
case_id id n/a no (none)
contact_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
internal bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: aor_charts
Column Type Length Required Comment
aor_report_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
type enum 100 no (none)
x_field int n/a no (none)
y_field int n/a no (none)
Table: aor_conditions
Column Type Length Required Comment
aor_report_id id 36 no (none)
condition_order int 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
field enum 100 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
operator enum 100 no (none)
parameter bool n/a no (none)
value varchar 255 no (none)
value_type varchar 255 no (none)
Table: aor_fields
Column Type Length Required Comment
aor_report_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
display bool n/a no (none)
field enum 100 no (none)
field_function enum 100 no (none)
field_order int 255 no (none)
group_by bool n/a no (none)
group_display bool n/a no (none)
group_order enum 100 no (none)
id id n/a yes Unique identifier
label varchar 255 no (none)
link bool n/a no (none)
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
sort_by enum 100 no (none)
sort_order enum 100 no (none)
total enum 100 no (none)
Table: aor_reports
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
report_module enum 100 yes (none)
Table: aor_scheduled_reports
Column Type Length Required Comment
aor_report_id id n/a no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
last_run readonly n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
schedule varchar 100 yes (none)
status enum 100 no (none)
Table: aos_contracts
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
call_id id 36 no (none)
company_signed_date date n/a no (none)
contact_id id 36 no (none)
contract_account_id id 36 no (none)
contract_type enum 100 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
customer_signed_date date n/a no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
end_date date n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
opportunity_id id 36 no (none)
reference_code varchar 255 no (none)
renewal_reminder_date datetime n/a no (none)
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
start_date date n/a no (none)
status enum 100 yes (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)
total_contract_value currency 26,6 no (none)
total_contract_value_usdollar currency 26,6 no (none)
Table: aos_contracts_documents
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_contracts_id varchar 36 no (none)
documents_id varchar 36 no (none)
document_revision_id varchar 36 no (none)
Table: aos_invoices
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
billing_account_id id 36 no (none)
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
billing_contact_id id 36 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
due_date date n/a no (none)
id id n/a yes Unique identifier
invoice_date date n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
number int 11 yes (none)
quote_date date n/a no (none)
quote_number int 11 no (none)
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
status enum 100 no (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no Formatted amount of the opportunity
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
template_ddown_c multienum n/a no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)
Table: aos_line_item_groups
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
number int 11 no (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)
Table: aos_pdf_templates
Column Type Length Required Comment
active bool n/a no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
margin_bottom int 255 no (none)
margin_footer int 255 no (none)
margin_header int 255 no (none)
margin_left int 255 no (none)
margin_right int 255 no (none)
margin_top int 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
pdffooter text n/a no (none)
pdfheader text n/a no (none)
type enum 100 yes (none)
Table: aos_product_categories
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
is_parent bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parent_category_id id n/a no (none)
Table: aos_products
Column Type Length Required Comment
aos_product_category_id id n/a no (none)
assigned_user_id id n/a no User ID assigned to record
category enum 100 no (none)
contact_id id 36 no (none)
cost currency 26,6 no (none)
cost_usdollar currency 26,6 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
maincode enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
part_number varchar 25 no (none)
price currency 26,6 yes (none)
price_usdollar currency 26,6 no (none)
product_image varchar 255 no File name associated with the note (attachment)
type enum 100 no (none)
url varchar 255 no (none)
Table: aos_products_quotes
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount enum 255 no (none)
group_id id 36 no (none)
id id n/a yes Unique identifier
item_description text n/a no (none)
modified_user_id id n/a no User who last modified record
name text n/a yes (none)
number int 11 no (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
part_number varchar 255 no (none)
product_cost_price currency 26,6 no (none)
product_cost_price_usdollar currency 26,6 no (none)
product_discount currency 26,6 no (none)
product_discount_amount currency 26,6 no (none)
product_discount_amount_usdollar currency 26,6 no (none)
product_discount_usdollar currency 26,6 no (none)
product_id id 36 no (none)
product_list_price currency 26,6 no (none)
product_list_price_usdollar currency 26,6 no (none)
product_qty decimal 18 no (none)
product_total_price currency 26,6 yes (none)
product_total_price_usdollar currency 26,6 no (none)
product_unit_price currency 26,6 yes (none)
product_unit_price_usdollar currency 26,6 no (none)
vat enum 100 no (none)
vat_amt currency 26,6 yes (none)
vat_amt_usdollar currency 26,6 no (none)
Table: aos_quotes
Column Type Length Required Comment
approval_issue text n/a no (none)
approval_status enum 100 no (none)
assigned_user_id id n/a no User ID assigned to record
billing_account_id id 36 no (none)
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
billing_contact_id id 36 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
expiration date n/a yes (none)
id id n/a yes Unique identifier
invoice_status enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
number int 11 yes (none)
opportunity_id id 36 no (none)
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
stage enum 100 yes (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
template_ddown_c multienum n/a no (none)
term enum 100 no (none)
terms_c text n/a no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)
Table: aos_quotes_aos_invoices_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotes77d9_quotes_ida varchar 36 no (none)
aos_quotes6b83nvoices_idb varchar 36 no (none)
Table: aos_quotes_os_contracts_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotese81e_quotes_ida varchar 36 no (none)
aos_quotes4dc0ntracts_idb varchar 36 no (none)
Table: aos_quotes_project_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotes1112_quotes_ida varchar 36 no (none)
aos_quotes7207project_idb varchar 36 no (none)
Table: aow_actions
Column Type Length Required Comment
action enum 100 no (none)
action_order int 255 no (none)
aow_workflow_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parameters longtext n/a no (none)
Table: aow_conditions
Column Type Length Required Comment
aow_workflow_id id 36 no (none)
condition_order int 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
field enum 100 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
operator enum 100 no (none)
value varchar 255 no (none)
value_type varchar 255 no (none)
Table: aow_processed
Column Type Length Required Comment
aow_workflow_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
status enum 100 no (none)
Table: aow_processed_aow_actions
Column Type Length Required Comment
id varchar 36 no (none)
aow_processed_id varchar 36 no (none)
aow_action_id varchar 36 no (none)
status varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: aow_workflow
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
flow_module enum 100 yes (none)
flow_run_on enum 100 yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
multiple_runs bool n/a no (none)
name varchar 255 yes (none)
run_when enum 100 no (none)
status enum 100 no (none)
Table: bugs
Bugs are defects in products and services
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
bug_number int 11 yes Visual unique identifier
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
fixed_in_release enum n/a no The software or service release that corrected the bug
found_in_release enum n/a no The software or service release that manifested the bug
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes The short description of the bug
priority enum 100 no An indication of the priorty of the issue
product_category enum 255 no Where the bug was discovered (ex: Accounts, Contacts, Leads)
resolution enum 255 no An indication of how the issue was resolved
source enum 255 no An indicator of how the bug was entered (ex: via web, email, etc.)
status enum 100 no The status of the issue
type enum 255 no The type of issue (ex: issue, feature)
work_log text n/a no Free-form text used to denote activities of interest
Table: calls
A Call is an activity representing a phone call
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_end datetime n/a no Date is which call is scheduled to (or did) end
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date in which call is schedule to (or did) start
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
direction enum 100 no Indicates whether call is inbound or outbound
duration_hours int 2 yes Call duration, hours portion
duration_minutes int 2 no Call duration, minutes portion
email_reminder_sent bool n/a no Whether email reminder is already sent
email_reminder_time int n/a no Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes Brief description of the call
outlook_id varchar 255 no When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID
parent_id id n/a no The ID of the parent Sugar object identified by parent_type
parent_type varchar 255 no The Sugar object to which the call is related
recurring_source varchar 36 no Source of recurring call
reminder_time int n/a no Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
repeat_count int 7 no Number of recurrence
repeat_dow varchar 7 no Days of week in recurrence
repeat_interval int 3 no Interval of recurrence
repeat_parent_id id 36 no Id of the first element of recurring records
repeat_type enum 36 no Type of recurrence
repeat_until date n/a no Repeat until specified date
status enum 100 yes The status of the call (Held, Not Held, etc.)
Table: calls_contacts
Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
contact_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: calls_leads
Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
lead_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: calls_reschedule
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
call_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
reason enum 100 no (none)
Table: calls_users
Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
user_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: campaign_log
Tracks items of interest that occurred after you send an email campaign
Column Type Length Required Comment
activity_date datetime n/a no The date the activity occurred
activity_type enum 100 no The activity that occurred (e.g., Viewed Message, Bounced, Opted out)
archived bool n/a no Indicates if item has been archived
campaign_id id n/a no Campaign identifier
date_modified datetime n/a no (none)
deleted bool n/a no Record deletion indicator
hits int n/a no Number of times the item has been invoked (e.g., multiple click-thrus)
id id n/a yes Unique identifier
list_id id 36 no The target list from which item originated
marketing_id id n/a no ID of marketing email this entry is associated with
more_information varchar 100 no (none)
related_id varchar 36 no (none)
related_type varchar 100 no (none)
target_id varchar 36 no Identifier of target record
target_tracker_key varchar 36 no Identifier of Tracker URL
target_type varchar 100 no Descriptor of the target record type (e.g., Contact, Lead)
Table: campaign_trkrs
Maintains the Tracker URLs used in campaign emails
Column Type Length Required Comment
campaign_id id n/a no The ID of the campaign
created_by id n/a no User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
is_optout bool n/a yes Indicator whether tracker URL represents an opt-out link
modified_user_id id n/a no User who last modified record
tracker_key int 11 yes Internal key to uniquely identifier the tracker URL
tracker_name varchar 30 no The name of the campaign tracker
tracker_url varchar 255 no The URL that represents the landing page when the tracker URL in the campaign email is clicked
Table: campaigns
Campaigns are a series of operations undertaken to accomplish a purpose, usually acquiring leads
Column Type Length Required Comment
actual_cost double n/a no Actual cost of the campaign
assigned_user_id id n/a no User ID assigned to record
budget double n/a no Budgeted amount for the campaign
campaign_type enum 100 yes The type of campaign
content text n/a no The campaign description
created_by id n/a no User who created record
currency_id id n/a no Currency in use for the campaign
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
end_date date n/a yes Ending date of the campaign
expected_cost double n/a no Expected cost of the campaign
expected_revenue double n/a no Expected revenue stemming from the campaign
frequency enum 100 no Frequency of the campaign
id id n/a yes Unique identifier
impressions int n/a no Expected Click throughs manually entered by Campaign Manager
modified_user_id id n/a no User who last modified record
name varchar 50 yes The name of the campaign
objective text n/a no The objective of the campaign
refer_url varchar 255 no The URL referenced in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)
start_date date n/a no Starting date of the campaign
status enum 100 yes Status of the campaign
tracker_count int 11 no The number of accesses made to the tracker URL; no longer used as of 4.2 (see campaign_trkrs)
tracker_key int 11 yes The internal ID of the tracker used in a campaign; no longer used as of 4.2 (see campaign_trkrs)
tracker_text varchar 255 no The text that appears in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)
Table: cases
Cases are issues or problems that a customer asks a support representative to resolve
Column Type Length Required Comment
account_id id n/a no The account to which the case is associated
assigned_user_id id n/a no User ID assigned to record
case_number int 11 yes Visual unique identifier
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes The short description of the bug
priority enum 100 no The priority of the case
resolution text n/a no The resolution of the case
state enum 100 no The state of the case (i.e. open/closed)
status enum 100 no The status of the case
type enum 255 no The type of issue (ex: issue, feature)
work_log text n/a no Free-form text used to denote activities of interest
Table: cases_bugs
Column Type Length Required Comment
id varchar 36 no (none)
case_id varchar 36 no (none)
bug_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: config
System table containing system-wide definitions
Column Type Length Required Comment
category varchar 32 no Settings are grouped under this category; arbitraily defined based on requirements
name varchar 32 no The name given to the setting
value text n/a no The value given to the setting
Table: contacts
Column Type Length Required Comment
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no The birthdate of the contact
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
department varchar 255 no The department of the contact
description text n/a no Full text of the note
do_not_call bool n/a no An indicator of whether contact can be called
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
last_name varchar 100 yes Last name of the contact
lead_source enum 255 no How did the contact come about
modified_user_id id n/a no User who last modified record
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
reports_to_id id n/a no The contact this contact reports to
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
title varchar 100 no The title of the contact
Table: contacts_bugs
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
bug_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: contacts_cases
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
case_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: contacts_users
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: cron_remove_documents
Column Type Length Required Comment
id varchar 36 no (none)
bean_id varchar 36 no (none)
module varchar 25 no (none)
date_modified datetime n/a no (none)
Table: currencies
Currencies allow Sugar to store and display monetary values in various denominations
Column Type Length Required Comment
conversion_rate double n/a yes Conversion rate factor (relative to stored value)
created_by id 36 yes User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifer
iso4217 varchar 3 no 3-letter identifier specified by ISO 4217 (ex: USD)
name varchar 36 yes Name of the currency
status varchar 100 no Currency status
symbol varchar 36 yes Symbol representing the currency
Table: custom_fields
Column Type Length Required Comment
bean_id varchar 36 no (none)
set_num int 11 no (none)
field0 varchar 255 no (none)
field1 varchar 255 no (none)
field2 varchar 255 no (none)
field3 varchar 255 no (none)
field4 varchar 255 no (none)
field5 varchar 255 no (none)
field6 varchar 255 no (none)
field7 varchar 255 no (none)
field8 varchar 255 no (none)
field9 varchar 255 no (none)
deleted bool 1 no (none)
Table: document_revisions
Column Type Length Required Comment
change_log varchar 255 no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
doc_id varchar 100 no Document ID from documents web server provider
doc_type enum 100 no Document type (ex: Google, box.net, IBM SmartCloud)
doc_url varchar 255 no Document URL from documents web server provider
document_id varchar 36 no (none)
file_ext varchar 100 no (none)
file_mime_type varchar 100 no (none)
filename varchar 255 yes (none)
id varchar 36 yes (none)
revision varchar 100 no (none)
Table: documents
Column Type Length Required Comment
active_date date n/a yes (none)
assigned_user_id id n/a no User ID assigned to record
category_id enum 100 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
doc_id varchar 100 no Document ID from documents web server provider
doc_type enum 100 no Document type (ex: Google, box.net, IBM SmartCloud)
doc_url varchar 255 no Document URL from documents web server provider
document_name varchar 255 yes (none)
document_revision_id varchar 36 no (none)
exp_date date n/a no (none)
id id n/a yes Unique identifier
is_template bool n/a no (none)
modified_user_id id n/a no User who last modified record
related_doc_id id 36 no (none)
related_doc_rev_id id 36 no (none)
status_id enum 100 no (none)
subcategory_id enum 100 no (none)
template_type enum 100 no (none)
Table: documents_accounts
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
account_id varchar 36 no (none)
Table: documents_bugs
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
bug_id varchar 36 no (none)
Table: documents_cases
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
case_id varchar 36 no (none)
Table: documents_contacts
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
contact_id varchar 36 no (none)
Table: documents_opportunities
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
opportunity_id varchar 36 no (none)
Table: eapm
Column Type Length Required Comment
api_data text n/a no Any API data that the external API may wish to store on a per-user basis
application enum 100 yes (none)
assigned_user_id id n/a no User ID assigned to record
consumer_key varchar n/a no (none)
consumer_secret varchar n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
oauth_secret varchar n/a no (none)
oauth_token varchar n/a no (none)
password encrypt 255 yes (none)
url varchar 255 yes (none)
validated bool n/a no (none)
Table: email_addr_bean_rel
Column Type Length Required Comment
id id n/a yes (none)
email_address_id id n/a yes (none)
bean_id id n/a yes (none)
bean_module varchar 100 yes (none)
primary_address bool n/a no (none)
reply_to_address bool n/a no (none)
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
Table: email_addresses
Column Type Length Required Comment
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
email_address varchar n/a yes (none)
email_address_caps varchar n/a yes (none)
id id n/a yes (none)
invalid_email bool n/a no (none)
opt_out bool n/a no (none)
Table: email_addresses
Column Type Length Required Comment
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
email_address varchar n/a yes (none)
email_address_caps varchar n/a yes (none)
id id n/a yes (none)
invalid_email bool n/a no (none)
opt_out bool n/a no (none)
Table: email_cache
Column Type Length Required Comment
answered tinyint 1 yes (none)
deleted tinyint 1 no (none)
draft tinyint 1 yes (none)
flagged tinyint 1 yes (none)
fromaddr varchar 100 no (none)
ie_id id n/a no (none)
imap_uid uint 32 yes (none)
mailsize uint 16 yes (none)
mbox varchar 60 yes (none)
message_id varchar 255 no (none)
msgno uint 32 no (none)
recent tinyint 1 yes (none)
seen tinyint 1 yes (none)
senddate datetime n/a no (none)
subject varchar 255 no (none)
toaddr varchar 255 no (none)
Table: email_marketing
Column Type Length Required Comment
all_prospect_lists bool n/a no (none)
campaign_id id n/a no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
date_start datetime n/a yes (none)
deleted bool n/a no (none)
from_addr varchar 100 yes (none)
from_name varchar 100 yes (none)
id id n/a yes (none)
inbound_email_id varchar 36 no (none)
modified_user_id id n/a no (none)
name varchar 255 yes (none)
reply_to_addr varchar 100 no (none)
reply_to_name varchar 100 no (none)
status enum 100 yes (none)
template_id id n/a yes (none)
Table: email_marketing_prospect_lists
Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
email_marketing_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: email_templates
Templates used in email processing
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
body text n/a no Plain text body to be used in resulting email
body_html html n/a no HTML formatted email body to be used in resulting email
created_by varchar 36 no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Email template description
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes Email template name
published varchar 3 no (none)
subject varchar 255 no Email subject to be used in resulting email
text_only bool n/a no Should be checked if email template is to be sent in text only
type enum n/a no Type of the email template
Table: emailman
Email campaign queue
Column Type Length Required Comment
campaign_id id n/a no ID of related campaign
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
id int 11 no Unique identifier
in_queue bool n/a no Flag indicating if item still in queue
in_queue_date datetime n/a no Datetime in which item entered queue
list_id id 36 no Associated list
marketing_id id n/a no (none)
modified_user_id id 36 no User ID who last modified record
related_id id n/a no ID of Sugar object to which this item is related
related_type varchar 100 no Descriptor of the Sugar object indicated by related_id
send_attempts int n/a no Number of attempts made to send this item
send_date_time datetime n/a no (none)
user_id id 36 no User ID representing assigned-to user
Table: emails
Contains a record of emails sent to and from the Sugar application
Column Type Length Required Comment
assigned_user_id id n/a no User ID that last modified record
created_by id 36 no User name who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
date_sent datetime n/a no (none)
deleted bool n/a no Record deletion indicator
flagged bool n/a no flagged status
id id n/a yes Unique identifier
intent varchar 100 no Target of action used in Inbound Email assignment
mailbox_id id 36 no (none)
message_id varchar 255 no ID of the email item obtained from the email transport system
modified_user_id id n/a no User ID that last modified record
name varchar 255 no The subject of the email
parent_id id 36 no ID of Sugar object referenced by parent_type (deprecated as of 4.2)
parent_type varchar 100 no Identifier of Sugar module to which this email is associated (deprecated as of 4.2)
reply_to_status bool n/a no I you reply to an email then reply to status of original email is set
status enum 100 no (none)
type enum 100 no Type of email (ex: draft)
Table: emails_beans
Column Type Length Required Comment
id id 36 no (none)
email_id id 36 no FK to emails table
bean_id id 36 no FK to various beans's tables
bean_module varchar 100 no bean's Module
campaign_data text n/a no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: emails_email_addr_rel
Normalization of multi-address fields such as To:, CC:, BCC
Column Type Length Required Comment
address_type varchar 4 yes Type of entry, TO, CC, or BCC
deleted bool n/a no (none)
email_address_id id n/a yes Foriegn key to emails table NOT unique
email_id id n/a yes Foriegn key to emails table NOT unique
id id n/a yes GUID
Table: emails_text
Large email text fields
Column Type Length Required Comment
bcc_addrs text n/a no Email address(es) of person(s) to receive a blind carbon copy of the email
cc_addrs text n/a no Email address(es) of person(s) to receive a carbon copy of the email
deleted bool n/a no (none)
description longtext n/a no Email body in plain text
description_html longhtml n/a no Email body in HTML format
email_id id 36 yes Foriegn key to emails table
from_addr varchar 255 no Email address of person who send the email
raw_source longtext n/a no Full raw source of email
reply_to_addr varchar 255 no reply to email address
to_addrs text n/a no Email address(es) of person(s) to receive the email
Table: emails_text
Large email text fields
Column Type Length Required Comment
bcc_addrs text n/a no Email address(es) of person(s) to receive a blind carbon copy of the email
cc_addrs text n/a no Email address(es) of person(s) to receive a carbon copy of the email
deleted bool n/a no (none)
description longtext n/a no Email body in plain text
description_html longhtml n/a no Email body in HTML format
email_id id 36 yes Foriegn key to emails table
from_addr varchar 255 no Email address of person who send the email
raw_source longtext n/a no Full raw source of email
reply_to_addr varchar 255 no reply to email address
to_addrs text n/a no Email address(es) of person(s) to receive the email
Table: fields_meta_data
Column Type Length Required Comment
audited bool n/a no (none)
comments varchar 255 no (none)
custom_module varchar 255 no (none)
date_modified datetime 255 no (none)
default_value varchar 255 no (none)
deleted bool n/a no (none)
duplicate_merge short n/a no (none)
ext1 varchar 255 no (none)
ext2 varchar 255 no (none)
ext3 varchar 255 no (none)
ext4 text n/a no (none)
help varchar 255 no (none)
id varchar 255 no (none)
importable varchar 255 no (none)
len int 11 no (none)
massupdate bool n/a no (none)
name varchar 255 no (none)
reportable bool n/a no (none)
required bool n/a no (none)
type varchar 255 no (none)
vname varchar 255 no (none)
Table: folders
Column Type Length Required Comment
id id n/a yes (none)
name varchar 25 yes (none)
folder_type varchar 25 no (none)
parent_folder id n/a no (none)
has_child bool n/a no (none)
is_group bool n/a no (none)
is_dynamic bool n/a no (none)
dynamic_query text n/a no (none)
assign_to_id id n/a no (none)
created_by id n/a yes (none)
modified_by id n/a yes (none)
deleted bool n/a no (none)
Table: folders_rel
Column Type Length Required Comment
id id n/a yes (none)
folder_id id n/a yes (none)
polymorphic_module varchar 25 yes (none)
polymorphic_id id n/a yes (none)
deleted bool n/a no (none)
Table: folders_subscriptions
Column Type Length Required Comment
id id n/a yes (none)
folder_id id n/a yes (none)
assigned_user_id id n/a yes (none)
Table: fp_event_locations
Column Type Length Required Comment
address varchar 255 yes (none)
address_city varchar 100 yes (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 yes (none)
address_state varchar 100 no (none)
assigned_user_id id n/a no User ID assigned to record
capacity varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: fp_event_locations_fp_events_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_event_locations_fp_events_1fp_event_locations_ida varchar 36 no (none)
fp_event_locations_fp_events_1fp_events_idb varchar 36 no (none)
Table: fp_events
Column Type Length Required Comment
accept_redirect varchar 255 no (none)
assigned_user_id id n/a no User ID assigned to record
budget currency 26 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_end datetime n/a no Date meeting ends
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date of start of meeting
decline_redirect varchar 255 no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
duration_hours int 3 yes Duration (hours)
duration_minutes int 2 no Duration (minutes)
id id n/a yes Unique identifier
invite_templates enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: fp_events_contacts_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_contactsfp_events_ida varchar 36 no (none)
fp_events_contactscontacts_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)
Table: fp_events_fp_event_delegates_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_fp_event_delegates_1fp_events_ida varchar 36 no (none)
fp_events_fp_event_delegates_1fp_event_delegates_idb varchar 36 no (none)
Table: fp_events_fp_event_locations_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_fp_event_locations_1fp_events_ida varchar 36 no (none)
fp_events_fp_event_locations_1fp_event_locations_idb varchar 36 no (none)
Table: fp_events_leads_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_leads_1fp_events_ida varchar 36 no (none)
fp_events_leads_1leads_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)
Table: fp_events_prospects_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_prospects_1fp_events_ida varchar 36 no (none)
fp_events_prospects_1prospects_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)
Table: import_maps
Import mapping control table
Column Type Length Required Comment
assigned_user_id id n/a no Assigned-to user
content text n/a no Mappings for all columns
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
default_values text n/a no Default Values for all columns
deleted bool n/a no Record deletion indicator
delimiter varchar 1 yes (none)
enclosure varchar 1 yes (none)
has_header bool n/a yes Indicator if source file contains a header row
id id n/a yes Unique identifier
is_published varchar 3 yes Indicator if mapping is published
module varchar 36 yes Module used for import
name varchar 254 yes Name of import map
source varchar 36 yes (none)
Table: inbound_email
Inbound email parameters
Column Type Length Required Comment
created_by id n/a no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
delete_seen bool n/a no Delete email from server once read (seen)
deleted bool n/a no Record deltion indicator
email_password varchar 100 yes Password of user identified by email_user
email_user varchar 100 yes User name allowed access to mail server
group_id id n/a no Group ID (unused)
groupfolder_id id n/a no Unique identifier
id varchar 36 yes Unique identifier
is_personal bool n/a yes Personal account flag
mailbox text n/a yes (none)
mailbox_type varchar 10 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 no Name given to the inbound email mailbox
port int 5 yes Port used to access mail server
server_url varchar 100 yes Mail server URL
service varchar 50 yes (none)
status varchar 100 yes Status of the inbound email mailbox (ex: Active or Inactive)
stored_options text n/a no (none)
template_id id 36 no Template used for auto-reply
Table: inbound_email_autoreply
Column Type Length Required Comment
autoreplied_to varchar 100 yes (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
ie_id id 36 yes (none)
Table: inbound_email_cache_ts
Column Type Length Required Comment
id varchar 255 yes (none)
ie_timestamp uint 16 yes (none)
Table: jjwg_address_cache
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
lat float 26 yes (none)
lng float 26 yes (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: jjwg_areas
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
city varchar 255 no (none)
coordinates text n/a no (none)
country varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
state varchar 255 no (none)
Table: jjwg_maps
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
distance float 26 yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
module_type enum 100 yes (none)
name varchar 255 yes (none)
parent_id id 36 no (none)
parent_type varchar 255 no (none)
unit_type enum 100 yes (none)
Table: jjwg_maps_jjwg_areas_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
jjwg_maps_5304wg_maps_ida varchar 36 no (none)
jjwg_maps_41f2g_areas_idb varchar 36 no (none)
Table: jjwg_maps_jjwg_markers_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
jjwg_maps_b229wg_maps_ida varchar 36 no (none)
jjwg_maps_2e31markers_idb varchar 36 no (none)
Table: jjwg_markers
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
city varchar 255 no (none)
country varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
jjwg_maps_lat float 26 no (none)
jjwg_maps_lng float 26 no (none)
marker_image enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
state varchar 255 no (none)
Table: job_queue
Job queue keeps the list of the jobs executed by this instance
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
client varchar 255 yes (none)
data text n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a yes (none)
execute_time datetime n/a yes (none)
failure_count tinyint n/a no (none)
id id 36 yes (none)
job_delay int n/a no (none)
message text n/a no (none)
name varchar 255 yes (none)
percent_complete int n/a no (none)
requeue bool n/a no (none)
resolution enum 20 yes (none)
retry_count tinyint n/a no (none)
scheduler_id id n/a no (none)
status enum 20 yes (none)
target varchar 255 yes (none)
Table: leads
Leads are persons of interest early in a sales cycle
Column Type Length Required Comment
account_description text n/a no Description of lead account
account_id id n/a no If converted, Account ID resulting from the conversion
account_name varchar 255 no Account name for lead
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no The birthdate of the contact
campaign_id id n/a no Campaign that generated lead
contact_id id n/a no If converted, Contact ID resulting from the conversion
converted bool n/a no Has Lead been converted to a Contact (and other Sugar objects)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
department varchar 100 no Department the lead belongs to
description text n/a no Full text of the note
do_not_call bool n/a no An indicator of whether contact can be called
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
last_name varchar 100 yes Last name of the contact
lead_source enum 100 no Lead source (ex: Web, print)
lead_source_description text n/a no Description of the lead source
modified_user_id id n/a no User who last modified record
opportunity_amount varchar 50 no Amount of the opportunity
opportunity_id id n/a no If converted, Opportunity ID resulting from the conversion
opportunity_name varchar 255 no Opportunity name associated with lead
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
portal_app varchar 255 no Portal application that resulted in created of lead
portal_name varchar 255 no Portal user name when lead created via lead portal
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
refered_by varchar 100 no Identifies who refered the lead
reports_to_id id n/a no ID of Contact the Lead reports to
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
status enum 100 no Status of the lead
status_description text n/a no Description of the status of the lead
title varchar 100 no The title of the contact
website varchar 255 no URL of website for the company
Table: linked_documents
Column Type Length Required Comment
id varchar 36 no (none)
parent_id varchar 36 no (none)
parent_type varchar 25 no (none)
document_id varchar 36 no (none)
document_revision_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: meetings
Meeting activities
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
creator varchar 50 no Meeting creator
date_end datetime n/a no Date meeting ends
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date of start of meeting
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
displayed_url url 400 no Meeting URL
duration_hours int 3 yes Duration (hours)
duration_minutes int 2 no Duration (minutes)
email_reminder_sent bool n/a no Whether email reminder is already sent
email_reminder_time int n/a no Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
external_id varchar 50 no Meeting ID for external app API
host_url varchar 400 no Host URL
id id n/a yes Unique identifier
join_url varchar 200 no Join URL
location varchar 50 no Meeting location
modified_user_id id n/a no User who last modified record
name varchar 50 yes Meeting name
outlook_id varchar 255 no When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID
parent_id id n/a no ID of item indicated by parent_type
parent_type varchar 100 no Module meeting is associated with
password varchar 50 no Meeting password
recurring_source varchar 36 no Source of recurring meeting
reminder_time int n/a no Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
repeat_count int 7 no Number of recurrence
repeat_dow varchar 7 no Days of week in recurrence
repeat_interval int 3 no Interval of recurrence
repeat_parent_id id 36 no Id of the first element of recurring records
repeat_type enum 36 no Type of recurrence
repeat_until date n/a no Repeat until specified date
sequence int 11 no Meeting update sequence for meetings as per iCalendar standards
status enum 100 no Meeting status (ex: Planned, Held, Not held)
type enum 255 no Meeting type (ex: WebEx, Other)
Table: meetings_contacts
Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
contact_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: meetings_leads
Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
lead_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: meetings_users
Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
user_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: notes
Notes and Attachments
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
contact_id id n/a no Contact ID note is associated with
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
embed_flag bool n/a no Embed flag indicator determines if note embedded in email
file_mime_type varchar 100 no Attachment MIME type
filename varchar 255 no File name associated with the note (attachment)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes Name of the note
parent_id id n/a no The ID of the Sugar item specified in parent_type
parent_type varchar 255 no Sugar module the Note is associated with
portal_flag bool n/a yes Portal flag indicator determines if note created via portal
Table: oauth_consumer
OAuth consumer keys
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
c_key varchar n/a yes Consumer public key
c_secret varchar n/a yes Consumer secret key
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
Table: oauth_nonce
Column Type Length Required Comment
conskey varchar 32 yes (none)
nonce varchar 32 yes (none)
nonce_ts long n/a yes (none)
Table: oauth_tokens
OAuth tokens
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
callback_url url 255 no Callback URL for Authorization
consumer id n/a yes Token related to the consumer
deleted bool n/a yes Record deletion indicator
id id n/a yes Unique identifier
secret varchar 32 yes Secret key
token_ts long n/a yes Token timestamp
tstate enum 1 yes Token state
verify varchar 32 no Token verification info
Table: opportunities
An opportunity is the target of selling activities
Column Type Length Required Comment
amount double n/a yes Unconverted amount of the opportunity
amount_usdollar double n/a no Formatted amount of the opportunity
assigned_user_id id n/a no User ID assigned to record
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
currency_id id n/a no Currency used for display purposes
date_closed date n/a yes Expected or actual date the oppportunity will close
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
lead_source enum 50 no Source of the opportunity
modified_user_id id n/a no User who last modified record
name varchar 50 yes Name of the opportunity
next_step varchar 100 no The next step in the sales process
opportunity_type enum 255 no Type of opportunity (ex: Existing, New)
probability double n/a no The probability of closure
sales_stage enum 255 yes Indication of progression towards closure
Table: opportunities_contacts
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
opportunity_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: outbound_email
Column Type Length Required Comment
id id n/a yes (none)
mail_sendtype varchar 8 yes (none)
mail_smtpauth_req bool n/a no (none)
mail_smtppass varchar 100 no (none)
mail_smtpport int 5 no (none)
mail_smtpserver varchar 100 no (none)
mail_smtpssl int 1 no (none)
mail_smtptype varchar 20 yes (none)
mail_smtpuser varchar 100 no (none)
name varchar 50 yes (none)
type varchar 15 yes (none)
user_id id n/a yes (none)
Table: project
Project
Column Type Length Required Comment
assigned_user_id id 36 no User assigned to this record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Project description
estimated_end_date date n/a yes (none)
estimated_start_date date n/a yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes Project name
priority enum n/a no (none)
status enum n/a no (none)
Table: project_contacts_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
project_contacts_1project_ida varchar 36 no (none)
project_contacts_1contacts_idb varchar 36 no (none)
Table: project_task
Column Type Length Required Comment
actual_duration int n/a no (none)
actual_effort int n/a no (none)
assigned_user_id id n/a no (none)
created_by id n/a no (none)
date_due date n/a no (none)
date_entered datetime n/a no (none)
date_finish date n/a no (none)
date_modified datetime n/a no (none)
date_start date n/a no (none)
deleted bool n/a no (none)
description text n/a no (none)
duration int n/a yes (none)
duration_unit text n/a no (none)
estimated_effort int n/a no (none)
id id n/a yes (none)
milestone_flag bool n/a no (none)
modified_user_id id n/a no (none)
name varchar 50 yes (none)
order_number int n/a no (none)
parent_task_id int n/a no (none)
percent_complete int n/a no (none)
predecessors text n/a no (none)
priority enum n/a no (none)
project_id id n/a yes (none)
project_task_id int n/a no (none)
status enum n/a no (none)
task_number int n/a no (none)
time_due time n/a no (none)
time_finish int n/a no (none)
time_start int n/a no (none)
utilization int n/a no (none)
Table: project_users_1_c
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
project_users_1project_ida varchar 36 no (none)
project_users_1users_idb varchar 36 no (none)
Table: projects_accounts
Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: projects_bugs
Column Type Length Required Comment
id varchar 36 no (none)
bug_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: projects_cases
Column Type Length Required Comment
id varchar 36 no (none)
case_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: projects_contacts
Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: projects_opportunities
Column Type Length Required Comment
id varchar 36 no (none)
opportunity_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: projects_products
Column Type Length Required Comment
id varchar 36 no (none)
product_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: prospect_list_campaigns
Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
campaign_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: prospect_lists
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
description text n/a no (none)
domain_name varchar 255 no (none)
id id n/a yes (none)
list_type enum 100 no (none)
modified_user_id id n/a no (none)
name varchar 50 no (none)
Table: prospect_lists_prospects
Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
related_id varchar 36 no (none)
related_type varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: prospects
Column Type Length Required Comment
account_name varchar 150 no (none)
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no (none)
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
department varchar 255 no The department of the contact
description text n/a no Full text of the note
do_not_call bool n/a no (none)
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
last_name varchar 100 yes Last name of the contact
lead_id id n/a no (none)
modified_user_id id n/a no User who last modified record
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
title varchar 100 no The title of the contact
tracker_key int 11 yes (none)
Table: relationships
Column Type Length Required Comment
deleted bool n/a no (none)
id id n/a yes (none)
join_key_lhs varchar 64 no (none)
join_key_rhs varchar 64 no (none)
join_table varchar 64 no (none)
lhs_key varchar 64 yes (none)
lhs_module varchar 100 yes (none)
lhs_table varchar 64 yes (none)
relationship_name varchar 150 yes (none)
relationship_role_column varchar 64 no (none)
relationship_role_column_value varchar 50 no (none)
relationship_type varchar 64 no (none)
reverse bool n/a no (none)
rhs_key varchar 64 yes (none)
rhs_module varchar 100 yes (none)
rhs_table varchar 64 yes (none)
Table: releases
Column Type Length Required Comment
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
list_order int 4 no (none)
modified_user_id id n/a no (none)
name varchar 50 yes (none)
status enum 100 no (none)
Table: roles
Column Type Length Required Comment
created_by id 36 no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
description text n/a no (none)
id id n/a yes (none)
modified_user_id id 36 no (none)
modules text n/a no (none)
name varchar 150 no (none)
Table: roles_modules
Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
module_id varchar 36 no (none)
allow bool 1 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: roles_users
Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)
Table: saved_search
Column Type Length Required Comment
assigned_user_id id n/a no (none)
contents text n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a yes (none)
description text n/a no (none)
id id n/a yes (none)
name varchar 150 no (none)
search_module varchar 150 no (none)
Table: schedulers
Column Type Length Required Comment
catch_up bool 1 no (none)
created_by id 36 no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
date_time_end datetimecombo n/a no (none)
date_time_start datetimecombo n/a yes (none)
deleted bool 1 no (none)
id varchar 36 yes (none)
job varchar 255 yes (none)
job_interval varchar 100 yes (none)
last_run datetime n/a no (none)
modified_user_id id 36 no (none)
name varchar 255 yes (none)
status enum 100 no (none)
time_from time n/a no (none)
time_to time n/a no (none)
Table: securitygroups
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
noninheritable bool n/a no Indicator for whether a group can be inherited by a record
Table: securitygroups_acl_roles
Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
role_id char 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
Table: securitygroups_default
Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
module varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
Table: securitygroups_records
Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
record_id char 36 no (none)
module char 36 no (none)
date_modified datetime n/a no (none)
modified_user_id char 36 no (none)
created_by char 36 no (none)
deleted bool 1 yes (none)
Table: securitygroups_users
Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
securitygroup_id varchar 36 no (none)
user_id varchar 36 no (none)
primary_group bool n/a no Drives which custom layout to show if a user is a member of more than 1 group
noninheritable bool n/a no Indicator for whether a group can be inherited by a record
Table: sugarfeed
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text 255 no Name of the feed
id id n/a yes Unique identifier
link_type varchar 30 no Name of the feed
link_url varchar 255 no Name of the feed
modified_user_id id n/a no User who last modified record
name varchar 255 no Name of the feed
related_id id 36 no related module
related_module varchar 100 no related module
Table: tasks
Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
contact_id id n/a no (none)
created_by id n/a no User who created record
date_due datetime n/a no (none)
date_due_flag bool n/a no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a no (none)
date_start_flag bool n/a no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes (none)
parent_id id n/a no (none)
parent_type varchar 255 no The Sugar object to which the call is related
priority enum 100 yes (none)
status enum 100 yes (none)
Table: tracker
Column Type Length Required Comment
action varchar 255 no (none)
date_modified datetime n/a no (none)
deleted bool n/a no Record deletion indicator
id int 11 no (none)
item_id varchar 36 no (none)
item_summary varchar 255 no (none)
module_name varchar 255 no (none)
monitor_id id n/a yes (none)
session_id varchar 36 no (none)
user_id varchar 36 no (none)
visible bool 1 no (none)
Table: upgrade_history
Tracks Sugar upgrades made over time; used by Upgrade Wizard and Module Loader
Column Type Length Required Comment
date_entered datetime n/a yes Date of upgrade or module load
description text n/a no (none)
enabled bool 1 no (none)
filename varchar 255 no Cached filename containing the upgrade scripts and content
id id n/a yes Unique identifier
id_name varchar 255 no The unique id of the module
manifest longtext n/a no A serialized copy of the manifest file.
md5sum varchar 32 no The MD5 checksum of the upgrade file
name varchar 255 no (none)
status varchar 50 no The status of the upgrade (ex: "installed")
type varchar 30 no The upgrade type (module, patch, theme, etc)
version varchar 64 no Version as contained in manifest file
Table: user_preferences
Column Type Length Required Comment
assigned_user_id id n/a yes (none)
category varchar 50 no (none)
contents longtext n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
Table: users
Column Type Length Required Comment
address_city varchar 100 no (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 no (none)
address_state varchar 100 no (none)
address_street varchar 150 no (none)
authenticate_id varchar 100 no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
department varchar 50 no (none)
description text n/a no (none)
employee_status varchar 100 no (none)
external_auth_only bool n/a no (none)
first_name varchar 30 no (none)
id id n/a yes (none)
is_admin bool n/a no (none)
is_group bool n/a no (none)
last_name varchar 30 yes (none)
messenger_id varchar 100 no (none)
messenger_type enum 100 no (none)
modified_user_id id n/a no (none)
phone_fax varchar 50 no (none)
phone_home varchar 50 no (none)
phone_mobile varchar 50 no (none)
phone_other varchar 50 no (none)
phone_work varchar 50 no (none)
portal_only bool n/a no (none)
pwd_last_changed datetime n/a no (none)
receive_notifications bool n/a no (none)
reports_to_id id n/a no (none)
show_on_employees bool n/a no (none)
status enum 100 no (none)
sugar_login bool n/a no (none)
system_generated_password bool n/a yes (none)
title varchar 50 no (none)
user_hash varchar 255 no (none)
user_name varchar 60 yes (none)
Table: users
Column Type Length Required Comment
address_city varchar 100 no (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 no (none)
address_state varchar 100 no (none)
address_street varchar 150 no (none)
authenticate_id varchar 100 no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
department varchar 50 no (none)
description text n/a no (none)
employee_status varchar 100 no (none)
external_auth_only bool n/a no (none)
first_name varchar 30 no (none)
id id n/a yes (none)
is_admin bool n/a no (none)
is_group bool n/a no (none)
last_name varchar 30 yes (none)
messenger_id varchar 100 no (none)
messenger_type enum 100 no (none)
modified_user_id id n/a no (none)
phone_fax varchar 50 no (none)
phone_home varchar 50 no (none)
phone_mobile varchar 50 no (none)
phone_other varchar 50 no (none)
phone_work varchar 50 no (none)
portal_only bool n/a no (none)
pwd_last_changed datetime n/a no (none)
receive_notifications bool n/a no (none)
reports_to_id id n/a no (none)
show_on_employees bool n/a no (none)
status enum 100 no (none)
sugar_login bool n/a no (none)
system_generated_password bool n/a yes (none)
title varchar 50 no (none)
user_hash varchar 255 no (none)
user_name varchar 60 yes (none)
Table: users_feeds
Column Type Length Required Comment
user_id varchar 36 no (none)
feed_id varchar 36 no (none)
rank int n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
Table: users_last_import
Maintains rows last imported by user
Column Type Length Required Comment
assigned_user_id id n/a no User assigned to this record
bean_id id n/a no ID of item identified by bean_type
bean_type varchar 36 no Bean type for which import occurs
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
import_module varchar 36 no Module for which import occurs
Table: users_password_link
Column Type Length Required Comment
date_generated datetime n/a no (none)
deleted bool n/a no (none)
id id n/a yes (none)
username varchar 36 no (none)
Table: users_signatures
Column Type Length Required Comment
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
name varchar 255 no (none)
signature text n/a no (none)
signature_html text n/a no (none)
user_id varchar 36 no (none)
Table: vcals
Column Type Length Required Comment
content text n/a no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
id id n/a yes (none)
source varchar 100 no (none)
type varchar 100 no (none)
user_id id n/a yes (none)
Table: versions
Column Type Length Required Comment
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
db_version varchar 255 yes (none)
deleted bool n/a no (none)
file_version varchar 255 yes (none)
id id n/a yes (none)
modified_user_id id n/a no (none)
name varchar 255 yes (none)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment