Use this form to assign naming conventions that conform to your organization's IT standards for primary and unique keys and indexes.
Oracle Table Name
When Scriptoria generates Oracle primary and unique keys and indexes, it will prefix all names with the name of the associated Oracle table that was either generated by Scriptoria or renamed using the Assign Table Names form.
Primary Keys:
You can instruct Scriptoria to use the name assigned to the MS-Access index (see Table Design | View Indexes) or to append a suffix to the Oracle table name. The default suffix is _PK.
Unique Keys:
Scriptoria prefixes unique key names with the associated Oracle table name and appends either the Access index name or a suffix that defaults to _UK. Since more than one unique key can be defined, a unique sequence number is appended when the suffix option is selected. Sequence numbers are also generated for triggers and foreign keys and are unique for each table.
Indexes:
Scriptoria prefixes index names with the associated Oracle table name and appends either the Access index name or a suffix that defaults to _IX. A unique sequence number is appended when the suffix option is selected.