G-3150: Try to use identity columns for surrogate keys.
Currently has this as the good example:
location_id number(10) generated always as identity
However, the most flexible identity configuration is actually this:
location_id number(10) generated by default on null as identity