create table public.port_smith_notifications (
  id bigint generated by default as identity not null,
  created_at timestamp with time zone not null default now(),
  active boolean null default false,
  dismissable boolean null,
  title text null,
  description character varying null,
  image character varying null,
  type public.notification_types null default 'app_update_info'::notification_types,
  action_text text null default 'Click Here'::text,
  constraint port_smith_notifications_pkey primary key (id)
) TABLESPACE pg_default;


"notification_types" -- will READ from db "portsmith_notifications"
1. Rating mechanism (short lived) (Priority 6)
    1. Text, Stars (5) -- will be inserted into db "portsmith_reviews"
2. Bug report mechanism (Priority 0)
    1. Image, text (area), action -- will be inserted into db "portsmith_bugs"
3. App Notifications -- will READ from db "portsmith_notifications"
    1. Updates — Info (Priority 3), Deprecation (Priority 2), Force (Priority 1)
        1. Image, text, Action
    2. App Promotions  — New Features (Priority 4), New apps - (Priority 5)
        1. Image, text, action