Objective is to build a module having a special reference field which will link data about bike numbers to any kind of Drupal entity like nodes. The reference field will have a field widget as well as a field formatter.
The information being referenced is that of bike numbers. Three database tables namely: bikenumber, bikenumbereservation and bikenumberregion are used to store the information. The bikenumber table has a corresponding revision table named bikenumber_revision. It is expected that a separate Field API table will also be created to link the bikenumber table to the entity (e.g a node).
CHECK MORE SCREENSHOTS AND MORE DETAILS IN THE FILES ATTACHED.