Changes between Version 3 and Version 4 of P7

Timestamp:

04/25/26 23:02:41 (7 days ago)

Author:

211099

Comment:

--

P7

@@ -2 +2 @@
 
 == Custom Domains
-{{{
--- Check email format
+==== Automatically updates the story timestamp on every update
+{{{
 CREATE DOMAIN valid_email AS VARCHAR(255)
 CHECK (VALUE ~* '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$');
-
--- Check rating range from 0 to 5
+}}}
+==== Check rating range from 0 to 5
+{{{
 CREATE DOMAIN story_rating AS DECIMAL(3,2)
 CHECK (VALUE >= 0.00 AND VALUE <= 5.00);
-
--- Status of accepted values
+}}}
+==== Status of accepted values
+{{{
 CREATE DOMAIN story_status AS VARCHAR(50)
 CHECK (VALUE IN ('draft', 'published', 'archived'));
-
--- Permission level from 1 to 5
+}}}
+==== Permission level from 1 to 5
+{{{
 CREATE DOMAIN permission_lvl AS INTEGER
 CHECK (VALUE >= 1 AND VALUE <= 5);
-
--- URL / image path
+}}}
+==== URL / image path
+{{{
 CREATE DOMAIN valid_url AS VARCHAR(2048)
 CHECK (VALUE ~* '^https?://.+');
@@ -25 +29 @@
 
 == Views
-{{{
--- Detailed view for each story with statistic
+==== Detailed view for each story with statistic
+{{{
 CREATE OR REPLACE VIEW story_details_view AS
 SELECT
@@ -58 +62 @@
     s.image, s.story_created_at,
     u.username, u.user_name, u.surname, st.status;
--- Top 10 most popular stories by likes count =
+}}}
+==== Top 10 most popular stories by likes count 
+{{{
 CREATE MATERIALIZED VIEW top_stories_by_likes AS
 SELECT
@@ -81 +87 @@
 ORDER BY total_likes DESC
 LIMIT 10;
-
--- View for user profile with all his stories 
+}}}
+==== View for user profile with all his stories 
+{{{
 CREATE OR REPLACE VIEW writer_profile_view AS
 SELECT
@@ -108 +115 @@
 
 == Stored Procedures and Functions
-{{{
--- Table for daily top story
+==== Table for daily top story
+{{{
 CREATE TABLE daily_top_stories (
     day         DATE PRIMARY KEY,
@@ -115 +122 @@
     total_likes BIGINT
 );
-
--- Procedure: saves the most liked story of the previous day
+}}}
+==== Saves the most liked story of the previous day
+{{{
 CREATE OR REPLACE PROCEDURE get_daily_top_story()
 LANGUAGE plpgsql
@@ -146 +154 @@
 END;
 $$;
-
--- Procedure: sends a notification to all collaborators of a story
+}}}
+==== Procedure: sends a notification to all collaborators of a story
+{{{
 CREATE OR REPLACE PROCEDURE notify_collaborators(
     p_story_id  INTEGER,
@@ -183 +192 @@
 END;
 $$;
-
--- Function: calculates the engagement score for a given story
+}}}
+=== Function
+==== Calculates the engagement score for a given story
+{{{
 CREATE OR REPLACE FUNCTION calculate_engagement_score(p_story_id INTEGER)
 RETURNS DECIMAL