This question is locked. New answers and comments are not allowed.
I have an extract_job table which is the header table for a job to extract data. The table contains a few dozen columns of which most are processing and post extract information. When I create the job I only need a few basic columns to send to the UI and for another use case where the user can choose to re-run a job I again only need a few of the columns.
If I was starting from the Oracle DB I would create the base table, and three views (full, new, re_run).
How do I start this from the modelling side? Is it a partial inheritance? How do I tell OpenAccess that I want a view?
Thanks
jack
If I was starting from the Oracle DB I would create the base table, and three views (full, new, re_run).
How do I start this from the modelling side? Is it a partial inheritance? How do I tell OpenAccess that I want a view?
Thanks
jack