My experience in DBMS structure creation PostgreSQL+Liquibase (constantly updated)

1. Create auto-incremental id field. It is suitable for inserting a new values.

 <addAutoIncrement tableName="TABLENAME" columnName="ID"/>

2. Сonsider to create field as NOT NULL if applicable