The DDL used SERIAL (actually it will be an INTEGER) as datatype for id columns but these columns are referenced as BIGINT from its child table. these id columns should be BIGSERIAL (it will be an BIGINT) instead of SERIAL.