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