Zero(0) trade id in g_fill table

[amitsharma8891]

Hi,

In g_fill table, there are records with trade id as, while there is no such trade id exist in g_trade table.

Please find the attached screenshot.

[greensheng]

The fill record with trade_id = 0 is a done record (fill. Done = true), indicating that the order has been completed

[amitsharma8891]

It causing foreign key constraints error...any solution for this?

[greensheng]

Usually in large-scale systems, we do not use foreign key constraints to ensure data consistency. Imagine that if we need to split tables and databases because of the huge amount of data, foreign key constraints will lead to the implementation of the above scheme is very complex.