Please enable JavaScript.

Coggle requires JavaScript to display documents.

Rail MVP (Back-End (Node.js / Express) (Database Tables - PostgreSQL…

- - - - title (varchar(128))
        
        issues (jsonb)
        
        description (varchar(1000))
        
        creationDate (timestamp)
        
        modifiedDate (timestamp)
        
        isPublished (boolean)
        
        publishDate (timestamp)
        
        proposalId (uuid) (pk)
        
        userId (uuid) (fk)
    - - userId (uuid) (fk)
      - proposalId (uuid) (fk)
      - likeId (uuid) (pk)
    - - userId (uuid) (fk)
      - voteId (uuid) (pk)
      - itemId (uuid) (fk) [Could be Bill or Proposal]
      - yesVote (boolean)
    - - userId (uuid) (fk)
      - followId (uuid) (pk)
      - followType (serial)
        
        Proposals
        
        Representatives
        
        Rail Users
      - itemId (uuid) (fk)
    - - commentId (uuid) (pk)
      - userId (uuid) (fk)
      - comment (varchar(1000))
      - creationDate (timestamp)
      - targetId (uuid) (fk) [Could be bill or proposal]
      - reference (varchar(1000))
    - - ratingId (uuid) (pk)
      - comentId (uuid) (fk)
      - isLiked (boolean)
        
        True = Like
        
        False = Hidden
      - userId (uuid) (fk)
    - - location (zip code - int(5))
      - phoneNumber (int(10))
      - gender (boolean)
      - age (int(3))
      - userId (uuid) (pk)
      - filters (jsonb)
      - email (varchar(128))
      - isAnon (boolean)
      - lastName (varchar(128))
      - firstName (varchar(128))
    - - contextId (uuid) (pk)
      - context (varchar(1000))
- - - - Facebook / Google
      - LinkedIn (Optional)
      - ACTION, If User opts out of Facebook / Google Sign-Up
        
        Name Field
        
        Email Field
        
        Mobile Field
        
        Password Field
        
        ACTION, Recommend Password
        
        Confirm Password Field
      - Home / Profile Section
        
        News Section (Icon)
        
        ACTION, Tap on Icon
        
        ACTION, Info Icon
        
        Help Text via Modal will appear
        
        Title: News
        
        Search
        
        ACTION
        
        Tap into Input Field
        
        1 more item...
        
        Search Icon is Active when there is text
        
        Tap on Filter Icon
        
        1 more item...
        
        Display list of News Articles
        
        ACTION, Tap onto Article
        
        ACTION, Deep Link (I had to google this haha)
        
        Display Article Image (if any)
        
        Display Article Title
        
        Display News Source, Ex. AP, C-Span, Reuters
        
        Display Time, How Long ago it was Published
        
        Display Ads
        
        Use Google
        
        ACTION, Tap on Ad
        
        1 more item...
        
        Reps / Users Section (Icon)
        
        ACTION, Tap on Icon
        
        Display Title: Reps + Users
        
        Representatives Tab (Default View)
        
        Search
        
        Filter
        
        List of Reps
        
        Rail Users Tab
        
        ACTION, Tap
        
        Info Icon
        
        ACTION, Tap
        
        1 more item...
        
        Home / Profile Section
        
        ACTION, Tap on My Proposals Tab
        
        User's Proposals
        
        ACTION, Floating Button
        
        Create New Proposal
        
        6 more items...
        
        Display List of User's Proposals
        
        Display Draft or Publish
        
        Display Title as Header
        
        ACTION, Tap into Proposal
        
        8 more items...
        
        Likes (if any)
        
        Comments (if any)
        
        Following (if any)
        
        Display Date Created/Updated as Secondary
        
        ACTION, Filter
        
        ACTION, Search
        
        Typeahead & Fuzzy Search
        
        ACTION
        
        Add Profile Picture
        
        Use User's camera
        
        ACTION
        
        1 more item...
        
        Select from User's personal library of photos
        
        ACTION
        
        1 more item...
        
        Issues (Icon Button)
        
        ACTION, Tap on Icon
        
        Full Modal/Screen
        
        List of issues
        
        1 more item...
        
        Settings
        
        Change Password
        
        ACTION
        
        Authenticate email for change?
        
        Use Actual Name
        *Name cannot be changed
        
        Appear as Anonymous
        
        ACTION
        
        Radio button to turn On/Off
        
        ACTION, Tap on Following Tab
        
        Display list of people the user is following.
        *Can we display Reps they are following in the same list?
        
        Reps?
        
        Rail Users
        
        ACTION, Tap on User
        
        1 more item...
        
        ACTION, Unfollow Button
        
        Display % Overall Match with User
        
        Display % Match with User's Starred Issues
        
        Display # of Following
        
        Display # of Followers
        
        Display Name
        
        Bills Tab
        
        New Users
        
        Call to Action / Recommend Bills to vote on under Bills Tab
        
        ACTION
        
        1 more item...
        
        ACTION, Tap on Bill for more info
        
        1 more item...
        
        ACTION, Filter
        
        By Issues?
        
        ACTION
        
        1 more item...
        
        Show only what users have voted on
        
        By Date
        
        ACTION
        
        1 more item...
        
        ACTION, Search
        
        Typeahead & Fuzzy Search
        
        Show List of Bills User has voted on
        
        ACTION
        
        Re-Swipe on Bill
        
        2 more items...
        
        Bills / Proposals Section (Icon)
        
        ACTION, Tap on Icon
        
        Bills Tab (Default View)
        
        Filter
        
        Issues
        
        Date
        
        List of Bills
        
        Display Title
        
        Display Date of Bill Introduction
        
        Display Bill #
        
        Display Likes (if any)
        
        2 more items...
        
        Display Comments (if any)
        
        2 more items...
        
        Search
        
        ACTION, Tap into Field
        
        1 more item...
        
        ACTION, Tap on Proposals Tab
        
        Display Title
        
        Info Icon
        
        ACTION, Tap
        
        1 more item...
        
        Search
        
        ACTION, Tap into Field
        
        1 more item...
        
        Filter
        
        Issues
        
        Date?
        
        Display list of User and Other Users' Proposals
        
        Display Profile Picture
        
        1 more item...
        
        Display Stat Icon with Color indicating Match %
        
        1 more item...
        
        Display Title of Proposal
        
        1 more item...
        
        Display Latest Date of Proposal
        
        Display User's Name
        
        1 more item...
        
        Follow Button
        
        1 more item...
        
        Display # of Likes with Icon
        
        1 more item...
        
        Display # of Comments with Icon
        
        1 more item...
        
        Display # of Following
        
        Display floating Add New button
        
        Display Ads
        
        Use Google
        
        ACTION, Tap on Ad
        
        1 more item...
        
        ACTION, Info Icon
        
        Help Text via Modal will appear