REMICON
Tables (4)
MIXA
- id — PRIMARY KEY — Primary key — NOT NULL
- KEY — FOREIGN KEY — Foreign key → OD.KEY
- id (id2) — VARCHAR(6) — Foreign key → OD.id — NOT NULL
- SNO — VARCHAR(4)
- BNO — VARCHAR(4)
- MA — VARCHAR(5)
- TM — VARCHAR(20)
MIXS
- id — PRIMARY KEY — Primary key — NOT NULL
- STAT — VARCHAR(3)
- TM — VARCHAR(20)
OD
- KEY — KEY — Primary key
- id — PRIMARY KEY — Primary key — NOT NULL
- SNO — VARCHAR(4)
- BNO — VARCHAR(4)
- CNO — VARCHAR(9)
- TP — VARCHAR(4)
- M3 — VARCHAR(4)
- DST — VARCHAR(20)
- TM — VARCHAR(20)
VID
- id — PRIMARY KEY — Primary key — NOT NULL
- KEY — FOREIGN KEY — Foreign key → OD.KEY
- id (id2) — VARCHAR(6) — Foreign key → OD.id — NOT NULL
- SNO — VARCHAR(4)
- BNO — VARCHAR(4)
- FN — VARCHAR(20)
- TM — VARCHAR(20)