CREATE TABLE notifications (
	notification_id	 integer PRIMARY KEY NOT NULL,
	type_id	 integer,
	object_id	 integer,
	notif_date	 timestamptz NOT NULL,
	response_id	 integer,
	notif_user	 integer,
	notif_subject	 varchar(1000),
	notif_text	 text(-5),
	notif_html	 text(-5),
	file_ids	 text(-5),
	CONSTRAINT notifications_notif_user_fk REFERENCES users () ON DELETE CASCADE,
	CONSTRAINT notifications_notification_id_fk REFERENCES acs_objects () ON DELETE CASCADE,
	CONSTRAINT notifications_object_id_fk REFERENCES acs_objects () ON DELETE CASCADE,
	CONSTRAINT notifications_response_id_fk REFERENCES acs_objects (),
	CONSTRAINT notifications_type_id_fk REFERENCES notification_types ()
);

CREATE INDEX notifications_object_id_idx ON notifications (object_id);
CREATE INDEX notifications_response_id_idx ON notifications (response_id);
CREATE INDEX notifications_type_id_idx ON notifications (type_id);

-- Tables with foreign keys that refer to notifications:
--notification_user_map(notif_user_map_notif_id_fk)

-- Table size: 0 bytes
-- Table rows: 0

Tables: