Re: Namingconvention, suggestions?

Ola Hjollo (ola.hjollo_at_nho.hydro.com) wrote: : Hi!  

: I whant to make a simple and short paper containing rules for 
: how we should name most common objects within a database.  If anyone
: has anything written, a "good enough" type of thing, information
: would be appreciated!
 

: best regards  

: ola hjollo

Here is what we are using.

TABLE OF CONTENTS

     1.1    Objects . . . . . . . . . . . . . . . . . . . . . . . . .1
     1.1.1  Variables. . . . . . . . . . . . . . . . . . . . . .1
     1.1.2  Database and PL/SQL. . . . . . . . . . . . . . . . .1
     1.1.3  Forms. . . . . . . . . . . . . . . . . . . . . . . .1
     1.1.4  Reports. . . . . . . . . . . . . . . . . . . . . . .1

1    Naming Standards
                                      1.1  Objects

     1.1.1     Variables



_D               Display-Only Field in FORMS

_G               Global Variable

_H               Hidden/Hold Field in FORMS

_P               Parameter


_V               PL/SQL Variable




     1.1.2     Database and PL/SQL



_FK          Constraint, Foreign Key

_PK          Constraint, Primary Key

_UK          Constraint, Unique Key

_CUR         Cursor

_FUNC        Function

_I           Index

_IFK         Index, Foreign Key

_IPK         Index, Primary Key

_IUK         Index, Unique Key (second PK)

_PKG         Package

_PROC        Procedure

_RS          Rollback Segment

_SEQ         Sequence

_SS          Snapshot


_T           Table


ashrtnm      Table Alias=CASE short table name


_TS          Tablespace


_TRG         Trigger




     1.1.3     Forms



_ALT          Alert


bnm           Block
               (bnm=CASE short table name)


_BTN          Button

_CAN          Canvas

_CB           Checkbox

_LIB          Library

_LOV          List of Values

_OG           Object Group

_PLIST        Parameter List

_PC           Property Class

_RBTN         Radio Button

_RG           Radio Group

_VA           Visual Attribute


_W            Window




     1.1.4     Reports



_FC          Formula Column on Data Model

_PC          Placeholder Column on Data Model

_SC          Summary Column on Data Model

_G           Group

_P           Parameter

_Q           Query


_EQ          Query, External


F_           Prefix for Layout.  NOTE: Reports puts a prefix of F_ by default in front of Data Model Objects for the Layout.

Kalpesh S. Patel Received on Sat Jun 03 1995 - 00:00:00 CEST