|
-
I already searched in OTN, but I found nothing about Naming convention...
I just really want to know if there is same standard or recommndation about naming in databases...
For example, there is people that say that a table name must be in singular, because it represents an entity. (ie: PRODUCT). Others say that it must be in plural, because it represents a collection of data (PRODUCTS)
I personally like the first one, but I would like to know if there is any academic white paper (recomendation, publication, standard, whatever...) that establish and fundament things like that.
Another example. The ID of a Table. Continuing with the PRODUCT example, the id of that table should be named:
a - id
b - ProductID
c - id_product
d - IdProduct
e - iProductID ("i" from int data type)
Does it makes sense?
Does anybody have a document or a URL with papers discussing this topic? I don't care if they have different conventions... I just want material to build my own naming convention, or to adopt some standard if it convinces me.
tnxs
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|