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