a

Tables (3)

A Table (Untitled)

  • Code_1 — varchar(8) — Primary key — NOT NULL
  • Code_2 — varchar(8) — Primary key — NOT NULL

B Table (History Table)

  • id — int(10) — Primary key — NOT NULL
  • Code_2 — varchar(8) — Foreign key → A Table.Code_2 — NOT NULL
  • Code_1 — varchar(8) — Foreign key → A Table.Code_1 — NOT NULL
  • Scode_1 — char(8) — Foreign key → C Table.Scode_1 — NOT NULL
  • Scode_2 — varchar(8) — Foreign key → C Table.Scode_2 — NOT NULL
  • table Flag (tbl_flag) — char(1)

C Table (Untitled2)

  • Scode_1 — char(8) — Primary key — NOT NULL
  • Scode_2 — varchar(8) — Primary key — NOT NULL