Created question in FIWARE Q/A platform on 11-12-2015 at 14:12
Please, ANSWER this question AT http://stackoverflow.com/questions/34224386/how-to-properly-set-up-column-mode-in-cygnus

Question:
How to properly set up column mode in cygnus?

Description:

I have cygnus working automatically just fine in row mode. But I want to switch to column mode, this means that I now have to manually set up my tables with appropriate column types (right?).
I figured that the column type of the attributes should correspond to the ones I specified in context broker (i.e Temperature: float; pressure: integer; and so on), am I correct?.
BUT what about these types:

recvTime (Im guessing datetime?)
fiwareservicepath (string?)
entityId (integer?)
entityType (string?)
temperature_md (is float same as Temperature or what?)
pressure_md (is it integer same as pressure or what?)

Furthermore I could really do without the following columns:

_md columns if possible
fiwareservicepath

Can I remove those?

And finally where is the primary key in this scenario? Can I just manually add ID and set it as auto-increment without encountering any conflicts with Cygnus?

I should here stress that my DB of choice here is only MySql.