[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


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?


More information about the Mapbender_dev mailing list