Since most of the databases in the market support much bigger capacity than integer, Is there any specific reason to use serial as a primary key data type instead of big serial or big int? I foresee there will be an issue in future when id exceeded the max value of serial data type 2147483647. Furthermore, serial data type does not allows negative values.
Is there any plan to switch the primary key data type to big serial or big int data type?
Or I can just change the data type straight away (but it depends on what the scala or java primitive data type use in orbeon)?