Maps old course language codes to Mailchimp language codes for a given mailing list access token.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | now() | false | Timestamp when the entry was created. | ||
| deleted_at | timestamp with time zone | true | Timestamp when the entry was marked as deleted. If null, the record is not deleted. | |||
| id | uuid | gen_random_uuid() | false | A unique identifier. | ||
| mailchimp_language_code | varchar(10) | false | The language code used in Mailchimp. | |||
| marketing_mailing_list_access_token_id | uuid | false | public.marketing_mailing_list_access_tokens | References the marketing mailing list access token this mapping belongs to. | ||
| our_language_code | varchar(10) | false | The language code used in mooc. | |||
| updated_at | timestamp with time zone | now() | false | Timestamp when the entry was last updated. Automatically maintained by trigger. |
| Name | Type | Definition |
|---|---|---|
| mailchimp_language_code_map_marketing_mailing_list_acc_not_null | n | NOT NULL marketing_mailing_list_access_token_id |
| mailchimp_language_code_mappi_marketing_mailing_list_acces_fkey | FOREIGN KEY | FOREIGN KEY (marketing_mailing_list_access_token_id) REFERENCES marketing_mailing_list_access_tokens(id) |
| mailchimp_language_code_mappin_mailchimp_language_code_not_null | n | NOT NULL mailchimp_language_code |
| mailchimp_language_code_mappings_created_at_not_null | n | NOT NULL created_at |
| mailchimp_language_code_mappings_id_not_null | n | NOT NULL id |
| mailchimp_language_code_mappings_our_language_code_not_null | n | NOT NULL our_language_code |
| mailchimp_language_code_mappings_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| mailchimp_language_code_mappings_updated_at_not_null | n | NOT NULL updated_at |
| Name | Definition |
|---|---|
| mailchimp_language_code_mappings_pkey | CREATE UNIQUE INDEX mailchimp_language_code_mappings_pkey ON public.mailchimp_language_code_mappings USING btree (id) |
| mailchimp_language_code_mappings_unique | CREATE UNIQUE INDEX mailchimp_language_code_mappings_unique ON public.mailchimp_language_code_mappings USING btree (marketing_mailing_list_access_token_id, our_language_code) WHERE (deleted_at IS NULL) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.mailchimp_language_code_mappings FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls