The creation of tables in the OnBase database is strongly discouraged. If the end-user table creation is for an OnBase-related application and the tables will not be joined to the OnBase database and will not be filled using the OnBase tables, then these database tables can be located in a separate database on the same server.
If the end-user table creation is for an OnBase-related application and the tables will be joined to the OnBase database or will be filled using the OnBase tables, then all of the non-recommended access methods are being used.
If non‐recommended tables are added to the OnBase system, all non‐ OnBase tables should have the following characteristics:
-
The tables' owner is different from the OnBase database owner.
-
All tables follow the naming convention of cc_tablename.
-
All automated processes, triggers, and stored procedures are documented.
A complete set of database modification documentation is required before you can receive support on a database that has been altered in a non‐recommended way.