campaign

1232 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 8 null
campaign_group_association.campaign_id campaign_group_association_campaign_id_fkey R
campaign_notification.campaign_id campaign_notification_campaign_id_fkey R
video.campaign_id video_campaign_id_fkey R
customer_id varchar 16 null
customer.id campaign_customer_id_fkey R
created_by varchar 64 √ null
user.userid campaign_created_by_fkey R
name varchar 128 null
tag varchar 64 null
group_ids _varchar 2147483647 null
cover_photo_url varchar 512 √ null
description varchar 512 √ null
ref_link varchar 2048 √ null
ref_link_label varchar 128 √ null
start_time timestamptz 35,6 √ now()
end_time timestamptz 35,6 √ now()
status varchar 16 null
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()
campaign_category varchar 128 null
share_url varchar 512 √ null

Indexes

Constraint Name Type Sort Column(s)
campaign_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation