When developing a database it is important to use consistent naming conventions so that database objects and associated fields are easily understandable. Consistent prefixes can be used to differentiate between the core data objects being managed in the database and the data objects for the various modules installed. Consistent object suffixes indicate what each object represents and what type of data each field contains. Oracle requires object names and field names to have a maximum of 30 characters so abbreviations are required to keep the length within the acceptable range, consistent abbreviations improve the usability of the database. The underscore character should be used to separate the various abbreviations for objects/fields. The PIFSC-ITS DB naming and coding standards defines database naming standards for PIFSC. This document defines the database naming conventions for the Database Version Control Module (VCM).
- Object Prefixes:
- DB_UPGRADE - Database Upgrade
- Object Suffixes:
- BRI: Before Row Insert (for triggers)
- SEQ: Sequence
- V: View
- Field Suffixes:
- DESC: Description field
- ID: Primary/foreign keys (e.g. LOC_ID, SPECIES_ID)
- Abbreviations:
- APP: Application