By default, database object names are stored in all uppercase in Oracle and all lowercase in PostgreSQL. It is possible when creating tables using SQL to force the database to store mixed case names. However, if you plan to use your data with ArcGIS,
do not do this. The ArcGIS suite of software does not allow for case sensitivity. If you create mixed case object names, queries executed using such applications as ArcSDE commands or ArcMap will fail. Similarly, if you create object names in all uppercase in a PostgreSQL database or object names in all lowercase in an Oracle database, ArcGIS queries will fail.
It is also possible to create multiple ST_Geometry columns in the same table. However, ArcGIS does not support multiple geometry columns in the same table. ArcGIS can access tables with multiple type columns through spatial views that contain only one ST_Geometry column. For more information on spatial views, see
Using spatial views on tables with an ST_Geometry column.
ArcSDE requires a registered unique feature identifier column in the spatial table to perform spatial queries, log file queries, single-row operations, and multiversioned database operations. When you add an ST_Geometry column to an existing table in an ArcSDE geodatabase, it may also add a unique identifying column. This column is often called OBJECTID, but it can have another name. An existing column can also be used for the unique identifying column as long as it is indexed and declared as NUMBER(38) UNIQUE NOT NULL in Oracle or INTEGER UNIQUE NOT NULL in PostgreSQL.
For details on this column, see
Registering tables to be used by ArcGIS Desktop.