Skip to main content

Stored Data

note

To understand how collections and documents work, see Data Sctructure

Location Data​

  • all_locations
    • location_id
      • location_type
      • location_name
      • `address
      • `city
      • state
      • country
      • Api_link (google link)
      • go_link
      • Verified: false
      • primary_location: true, false
      • billing: true, false

User Taste Data​

  • user taste
    • religion
    • products
    • style
    • food
    • content
      • female singing
      • female video
    • kashrut

Finance Data​

  • Finance
    • Method #1
      • Manager: core/finance app
      • method id
      • Method type: bank, credit, debit
      • Method thumbnail: id
      • Provider: stripe, visa
      • Provider logo: id
      • Primary: true
      • Address: location id
      • bank_name varchar(255) NOT NULL,
      • bank_code varchar(255) NOT NULL,
      • bank_address varchar(255) NOT NULL,
      • ifsc_no varchar(255) NOT NULL,
      • account_no varchar(255) NOT NULL,
      • Verified: false

Location​

  • Locations
    • country
      • name
      • population
      • jewish population
      • friendly score

      • capital

      • states

        • state1
          • name
          • population
          • jewish population
          • friendly score

          • capital

          • cities

            • city1
              • name
              • population
              • jewish population
              • friendly score
              • capital

Category Data​

  • Categories

    • locations
      • reference to locations collection
    • Politics
      • format_use_case (content, product, etc)
          • type_use_case (music, digital, etc.)
        • case1
          • content
          • product
        • custom / requests
          • number of retest
          • top request

  • requests

    • Custom / Request1
      • name
      • details
      • created by
      • votes

  • requests

    • request1
      • voter id
      • request timestamp
      • location id

Topics/Hashtags​

  • Topics
  • use case
    • case1
      • content
      • product
    • custom / requests
      • number of retest
      • top request
      • requests
        • Custom / Request1
          • name
          • details
          • created by
          • votes
      • requests
        • request1
          • voter id
          • request timestamp
          • location id

Repprt Types​

In the laravel code this is reperd to as repoert resion or "tbl_report_reason"

  • report_type
    • type_#1
      • name
      • description
      • reason varchar(255) NOT NULL,
      • status int(11) NOT NULL DEFAULT 1,
      • created_at timestamp NOT NULL DEFAULT current_timestamp(),
      • updated_at timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
      • created_by (user_id)

Reports​

  • report
    • report_#1
      • report_type: (report_type_id)
      • content (content_id)
      • created by (user_id)
      • status int(11) NOT NULL DEFAULT 1,
      • created_at timestamp NOT NULL DEFAULT current_timestamp(),
      • updated_at timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
      • votes/reports (number)
      • reporters
        • report_#1
          • user
          • time