[rnavi]

Thank you for taking time out of your holiday and writing this.

2) If you create the tables from noco interface you get those fields else not as these fields are abstracted fields on top of your DB fields. 3) not sure what you mean here - noco is known for abstracting these IDs away and are hidden as system fields (see field menu). The role of lookup etc is what you need.

1 & 4 are feature requests pending on us.