ALTER SEQUENCE public.note_comments_id_seq OWNED BY public.note_comments.id;
+--
+-- Name: note_subscriptions; Type: TABLE; Schema: public; Owner: -
+--
+
+CREATE TABLE public.note_subscriptions (
+ user_id bigint NOT NULL,
+ note_id bigint NOT NULL
+);
+
+
--
-- Name: notes; Type: TABLE; Schema: public; Owner: -
--
pass_salt character varying,
email_valid boolean DEFAULT false NOT NULL,
new_email character varying,
- creation_ip character varying,
languages character varying,
status public.user_status_enum DEFAULT 'pending'::public.user_status_enum NOT NULL,
terms_agreed timestamp without time zone,
ADD CONSTRAINT note_comments_pkey PRIMARY KEY (id);
+--
+-- Name: note_subscriptions note_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.note_subscriptions
+ ADD CONSTRAINT note_subscriptions_pkey PRIMARY KEY (user_id, note_id);
+
+
--
-- Name: notes notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
CREATE INDEX index_note_comments_on_created_at ON public.note_comments USING btree (created_at);
+--
+-- Name: index_note_subscriptions_on_note_id; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_note_subscriptions_on_note_id ON public.note_subscriptions USING btree (note_id);
+
+
--
-- Name: index_oauth_access_grants_on_application_id; Type: INDEX; Schema: public; Owner: -
--
ADD CONSTRAINT diary_entry_subscriptions_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);
+--
+-- Name: note_subscriptions fk_rails_2c1913f293; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.note_subscriptions
+ ADD CONSTRAINT fk_rails_2c1913f293 FOREIGN KEY (note_id) REFERENCES public.notes(id);
+
+
--
-- Name: oauth_access_grants fk_rails_330c32d8d9; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ADD CONSTRAINT fk_rails_993965df05 FOREIGN KEY (blob_id) REFERENCES public.active_storage_blobs(id);
+--
+-- Name: note_subscriptions fk_rails_a352f4eced; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.note_subscriptions
+ ADD CONSTRAINT fk_rails_a352f4eced FOREIGN KEY (user_id) REFERENCES public.users(id);
+
+
--
-- Name: oauth_access_grants fk_rails_b4b53e07b8; Type: FK CONSTRAINT; Schema: public; Owner: -
--
('23'),
('22'),
('21'),
+('20241022141247'),
+('20240913171951'),
+('20240912181413'),
('20240910175616'),
('20240822121603'),
('20240813070506'),