Field Naming Rules

From AgileApps Support Wiki
Revision as of 22:27, 30 July 2010 by imported>Aeric
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Rules
  • Field names must start with an alphabetic character.
  • Field names can contain only alphabetic characters (A-Z), numeric characters (0-9), and underscores (_)
  • Field names cannot be one of the Reserved Words
  • Field names must be unique within the object. (They cannot duplicate the name of any other field defined for that object.)
Reserved Words

These words are used within the platform internally, and cannot be used for names.

See also: Reserved Words by Group
A
ABSTRACT
ACCESSIBLE
ACTIVITIES
ADD
AFFILIATE_ID
ALL
ALTER
ANALYZE
AND
APPOINTMENTS
AS
ASC
ASENSITIVE
ASSERT
AUTO_INCREMENT
BDB
BEFORE
BETWEEN
BIGINT
BINARY
BLOB
BOOLEAN
BOTH
BREAK
BTREE
BY
BYTE
CALL
CAMPAIGNS
CASCADE
CASE
CASES
CATCH
CEIL
CHANGE
CHAR
CHARACTER
CHECK
CLASS
COFF
COLLATE
COLUMN
COLUMNS
COMMENTS
CONCAT
CONDITION
CONNECTION
CONST
CONSTRAINT
contact_email
contact_fax
contact_first_name
contact_last_name
contact_mobile_phone
contact_phone
contact_title
CONTACTS
CONTAINS
CONTINUE
CONTRACTS
CONVERT
CREATE
CREATED_ID
CREATOR
CRITERIA
CROSS
CUBE            
CUME_DIST        
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CUSTOMER_ID
DATABASE
DATABASES
DATE
DATE_CREATED
DATE_MODIFIED
DATEADD
DATECOMP
DATESUB
DATEVALUE
DAY
DAY_HOUR
DAY_MICROSECOND
DAY_MINUTE
DAY_SECOND
DEC
DECIMAL
DECLARE
DEFAULT
DELAYED
DELETE
DENSE_RANK        
DESC
DESCRIBE
DETERMINISTIC
DISTINCT
DISTINCTROW
DIV
DO
DOCUMENTS
DONE
DOUBLE
DROP
DUAL
EACH
ELSE
ELSEIF
EMAIL_ACTIVITIES
EMPTY            
ENCLOSED
ENDSWITH
ENUM
ERRORS
ESCAPED
EXCEPT            
EXISTS
EXIT
EXP
EXPLAIN
EXTENDS
FALSE
FETCH
FIELDS
FINAL
FINALLY
FIND
FIRST_NAME
FIRST_VALUE        
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FORCE
FOREIGN
FROM
FULLTEXT
FUNCTION
GENERAL
GENERATED        
GEOMETRY
GET                
GOTO
GROUP
GRANT
GROUPING        
GROUPS            
HASH
HAVING
HELP
HIGH_PRIORITY
HISTORY
HOUR
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
ID
IF
IGNORE
IGNORE_SERVER_IDS
IMPLEMENTS
IMPORT
IN
INDEX
INFILE
INNER
INNODB
INOUT
INSENSITIVE
INSERT
INSTANCEOF
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERFACE
INTERSECT        
INTERVAL
INTO
IO_AFTER_GTIDS    
IO_BEFORE_GTIDS    
IS
ISCHANGED
ISNEW
ISNULL
ITERATE
JOIN
JSON_TABLE        
KEY
KEYS
KILL
LABEL 
LAG                
LAST_MODIFIED_TIMESTAMP
LAST_NAME
LAST_VALUE        
LATERAL            
LEAD            
LEADING
LEAVE
LEFT
LEN
LIFECYCLE
LIKE
LIMIT
LINEAR                 
LINES
LN
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LOG
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
LOWER
MASTER_BIND        
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MAX
MAXVALUE
MAXVALUE        
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT
MIN
MINUTE
MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MODIFIED_ID
MODIFIER
MODIFIES
MONTH
MRG_MYISAM
NAME
NATIVE
NATURAL
NEW
NO_WRITE_TO_BINLOG
NOT
NOW
NTH_VALUE        
NTILE            
NULL
NUMERIC
OBJECT_ID
OF                
ON
OPPORTUNITIES
OPTIMIZE
OPTIMIZER_COSTS    
OPTION
OPTIONALLY
OR
ORDER
OUT
OUTER
OUTFILE
OVER            
OWNER
OWNER_ID
OWNER_TEAM_ID
P_KEYWORD
PACKAGE
PARTITION        
PERCENT_RANK    
PLANS
POW
PRECISION
PRICELIST
PRIMARY
PRIOR_NAME
PRIORVALUE
PRIVATE
PRIVILEGES
PROCEDURE
PRODUCTS
PROTECTED
PUBLIC
PURGE
PURPOSE_ACCOUNT
GROUP
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTRACT
PURPOSE_LEAD
PURPOSE_OPPORTUNITY_V2
PURPOSE_PRICE_BOOK
PURPOSE_PRODUCT
PURPOSE_PROJECT
RANGE                 
RANK            
READ
READ_ONLY       
READ_WRITE
READS
REAL
RECORD
RECURSIVE        
REFERENCES
RELEASE
RENAME
REPEAT
REPLACE
REQUIRE
RESIGNAL
RESIGNAL        
RESTRICT
RETURN
RETURNS
REVOKE
RIGHT
RLIKE
ROUND
ROW                
ROW_NUMBER        
ROWS            
RTREE
S
SCHEMA
SCHEMAS
SEARCH_STRING
SECOND
SECOND_MICROSECOND
SELECT
SENSITIVE
SEPARATOR
SET
SHORT
SHOW
SHOW_LAYOUT
SIGN_HASH_ACCOUNT
SIGN_HASH_CASE
SIGN_HASH_CONTACT
SIGN_HASH_CONTRACT
SIGN_HASH_LEAD
SIGN_HASH_OPPORTUNITY_V2
SIGN_HASH_PRICE_BOOK
SIGN_HASH_PRODUCT
SIGN_HASH_PROJECT
SIGNAL
SIGNAL            
SIGNED_BY_ACCOUNT
SIGNED_BY_CASE
SIGNED_BY_CONTACT
SIGNED_BY_CONTRACT
SIGNED_BY_DATE_ACCOUNT
SIGNED_BY_DATE_CASE
SIGNED_BY_DATE_CONTACT
SIGNED_BY_DATE_CONTRACT
SIGNED_BY_DATE_LEAD
SIGNED_BY_DATE_OPPORTUNITY_V2
SIGNED_BY_DATE_PRICE_BOOK
SIGNED_BY_DATE_PRODUCT
SIGNED_BY_DATE_PROJECT
SIGNED_BY_LEAD
SIGNED_BY_OPPORTUNITY_V2
SIGNED_BY_PRICE_BOOK
SIGNED_BY_PRODUCT
SIGNED_BY_PROJECT
SLOW
SMALLINT
SOME
SONAME
SOURCEPAGE
SPATIAL
SPECIFIC
SPENDING
SQL
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
SSL
STARTING
STARTSWITH
STATIC
STORED            
STRAIGHT_JOIN
STRICTFP
STRIPED
SUBSTRING
SUPER
SWITCH
SYNCHRONIZED
SYSTEM            
T
TABLE
TABLES
TAGLIST
TARGETPAGE
TERMINATED
TEXT
THEN
THIS
THROW
THROWS
TIME
TIMEVALUE
TINYBLOB
TINYINT
TINYTEXT
TO
TODAY
TOP_TAB
TRAILING
TRANSIENT
TRIGGER
TRIM
TRUE
TRY
TYPES
UNDO
UNION
UNIQUE
UNLOCK
UNSIGNED
UPDATE
UPGRADE
UPPER
USAGE
USE
USER
USER_RESOURCES
USERID
USERPRIMARYTEAMID
GROUP
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
VALUE
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARYING
VIRTUAL            
VOID
VOLATILE
WARNINGS
WEEKDAY
WHEN
WHERE
WHILE
WINDOW 
WITH
WORKFLOW_HISTORY
WRITE
XOR
YEAR
YEAR_MONTH
ZEROFILL