Simple as possible where view have all config, just generate view and column and you DONE, no other table/config etc.. KISS (KEEP IT SIMPLE STUPID )
Columns types:
W_*= writable columns,W_will not be shown in GUI/GRIDR_*= readonly columns,R_will not be shown in GUI/GRID , but stop user for editing columnRG_= writable in api, but only read in grid