Skip to content

Zero(0) trade id in g_fill table #16

Open

Description

@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.

Screenshot 2019-11-13 at 4 55 45 PM

Activity

  1. changed the title [-]Trade id zero in g_fill table[/-] [+]Zero(0) trade id in g_fill table[/+] on Nov 13, 2019
  2. greensheng commented on Nov 14, 2019

    @greensheng
    Member

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

  3. amitsharma8891 commented on Nov 14, 2019

    @amitsharma8891
    Author

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

  4. greensheng commented on Nov 14, 2019

    @greensheng
    Member

    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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions