iBxmCK3n

1-- non enhanced type, channel and initiated by mapping
2CREATE TABLE IF NOT EXISTS interaction_migration_mapping.standard_channel_type_initiated_by_mapping (
3  id BIGINT NOT NULL,
4  new_type TEXT REFERENCES interactions.interaction_type (NAME),
5  new_channel TEXT REFERENCES interactions.channel (NAME),
6  new_initiated_by TEXT REFERENCES interactions.initiated_by (NAME),
7  interaction_category CHARACTER VARYING,
8  CONSTRAINT standard_channel_type_initiated_by_mapping_pk PRIMARY KEY (id)
9);
10 
11-- enhanced type, channel and initiated mapping
12CREATE TABLE IF NOT EXISTS interaction_migration_mapping.enhanced_channel_type_initiated_by_mapping (
13  id BIGINT NOT NULL,
14  new_type TEXT REFERENCES interactions.interaction_type (NAME),
15  new_channel TEXT REFERENCES interactions.channel (NAME),
16  new_initiated_by TEXT REFERENCES interactions.initiated_by (NAME),
17  old_type CHARACTER VARYING,
18  CONSTRAINT enhanced_channel_type_initiated_by_mapping_pk PRIMARY KEY (id)
19);