[Mapbender-dev] Column names

Karim Malhas karim at malhas.de
Wed Apr 28 09:37:36 EDT 2010


Hi all,

quick question:

Our database columnames follow the schema

  <tablename>.<tablename>_<columname>

which has me typing endless queryies like:
  
  "WHERE gui_layer.gui_layer_wms_id = wms.wms_id"

where I would much rather be typing:

  "WHERE gui_layer.wms_id = wms.id"


// The obvious solution to ease typing would be this:
//
//  "WHERE gui_layer_wms_id = wms_id"
//
// But this makes the column name convention only, instead of actually
// specifying the table-column relationship



Is there an advantage I am not aware of for naming columns this way?

  Karim


More information about the Mapbender_dev mailing list