[UPHPU] Database Conventions

[MilesTogoe]

Ditto.  Not that Rails is perfect but some things are pretty logical, ie:
id fields: fieldname _ id
2 syllable: either my_field (rails like) or myField (java like)
table name: plural (rails) or not - really your preference
class name: capitalize 1st letter (pretty standard)
file name:  all small letters (pretty standard)


Mike Moore wrote:
> When I think database conventions I think Ruby on Rails.  At first I wasn't
> too enamored with them, but now I've come to appreciate them.  I find myself
> using those conventions on non-Rails projects.
>
> On Jan 9, 2008 12:03 PM, Trevyn Meyer <trevyn at esourcehome.com> wrote:
>
>   
>> I was thinking
>> table / field naming conventions
>> I have used this in the pase
>>
>> Table: users  (Plural)
>> userID
>> userName
>>
>> Table: properties
>> propertyID
>> propertyName
>>
>> Table: user_property_map
>> user_property_mapID
>> userID
>> propertyID
>>
>> Wade Preston Shearer wrote:
>>     
>>>> This sounds like it could be a very helpful discussion, but I'm not
>>>> sure exactly what you're looking for. :)
>>>>         
>>> Could also be a great meeting topic.
>>>
>>>       
>> _______________________________________________
>>
>> UPHPU mailing list
>> UPHPU at uphpu.org
>> http://uphpu.org/mailman/listinfo/uphpu
>> IRC: #uphpu on irc.freenode.net
>>
>>     
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>
>