Index

public.marketing_mailing_list_access_tokens

Description

This table is used to keep a record of marketing mailing lists access tokens for each course language group

Columns

Name Type Default Nullable Children Parents Comment
access_token varchar(255) false Token used for access authentication.
course_id uuid false public.courses The course id that the the mailing list is related to
course_language_group_id uuid false public.course_language_groups The course language group id that the mailing list is related to
created_at timestamp with time zone now() false Timestamp when the record was created.
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
id uuid uuid_generate_v4() false public.mailchimp_course_tags A unique, stable identifier for the record.
mailchimp_mailing_list_id varchar(255) false Id of the mailing list used for marketing in Mailchimp
server_prefix varchar(255) false This value is used to configure API requests to the correct Mailchimp server.
updated_at timestamp with time zone now() false Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.

Constraints

Name Type Definition
marketing_mailing_list_access_tok_course_language_group_id_fkey FOREIGN KEY FOREIGN KEY (course_language_group_id) REFERENCES course_language_groups(id)
marketing_mailing_list_access_tokens_course_id_fkey FOREIGN KEY FOREIGN KEY (course_id) REFERENCES courses(id)
marketing_mailing_list_access_tokens_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
marketing_mailing_list_access_tokens_pkey CREATE UNIQUE INDEX marketing_mailing_list_access_tokens_pkey ON public.marketing_mailing_list_access_tokens USING btree (id)

Triggers

Name Definition
set_timestamp CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.marketing_mailing_list_access_tokens FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls