btg845eJ

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);