I am trying to generate the database from my model, but some things are missing.
cayenne currently does create sequence for all tables.
CREATE SEQUENCE pk_person INCREMENT 20 START 200;
for tables with db-generated primary key cayenne should do something like:
create sequence pk_person;
alter table person alter person_id set default nextval('pk_person');