To support scalability and prevent sequence overflow, please update the data type of the sequence fields in the CCL, FTF, FTT, and CCD tables from smallint to int. The current smallint type limits the number of records to 32,767, which is insufficient for long-term use. Changing these fields to int will enable the system to accommodate over 2 billion records, ensuring it can handle future growth without requiring manual intervention or risking failure.