Xyon (xyon) wrote,
Xyon
xyon

So in my nearly infinite niceness I'm going to get WebSoda running again. The only thing that was truly lost was the database schema; and there were some changes that needed to be made so I'm going to make them and update the controller program at the same time.

So, from a maintainance/standards/whatever point of view, which names are the best? This will be on a Linux box running MySQL.

Poll #579689 SQL Naming Preferences

Which of these is the best name for a database table

DispensingBin
4(57.1%)
DispensingBins
3(42.9%)
dispensing_bin
0(0.0%)
dispensing_bins
0(0.0%)

What is the best name for the primary key of that table?

DispensingBinID
5(71.4%)
dispensing_bin_id
0(0.0%)
BinID
2(28.6%)
bin_id
0(0.0%)
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 4 comments