Block Experience - onwardpath/demo-repo GitHub Wiki

Block Experience

Requirement:

  1. To Block specified URL
  2. To Block all subpages of URL

Use Cases:

  1. User need to block a particular URL for particular Geo location, i.e., segment (Geo)
  2. In case if user has been visited the websites more than certain times, website URL should be blocked, i.e., segment (Behaviour)

Design for Block Experience:

Block_exp_deisgn

Database design for Block Exeperience:

Table: Block

Columns:

  • id - Primary Key, Auto Increment (Stores a unique id for each entry)

  • experience_id - Foreign Key, To store the experience_id for a particular block experience.

  • segment_id - Foreign Key, To store the segment_id for a selected segment

  • block_url - To store the block url value

  • all_subpage - To store the subpage url value