Create Database Schema / Structure for Quick Search
Budget: $30 – $250 USD
I'm looking for someone to recommend and set up a database schema or structure for an app search function that allows heavy filtering along with keyword searches. Searches should be quick and allow for advanced queries.
Open to use either SQL or NoSQL so long as searches can be performed quickly with a lot of users and able to return paginated results. Note this database will be sycing with a firestore database. Not sure if that makes a difference.
Below are our required storage fields and what will need to be filtered.
===================
UserID
General User Info
Name
Phone
Email
Etc
“Personality” - Filter
Charismatic, Shy, Feminine, Masculine, Agreeable, Disagreeable, Humorous, Creative, Rebellious, Business, Minded, Casual, Dark, Light, Seductive, Carefree, Humble, Fiery, Cocky, Pure, Outgoing, Skeptical, Cute, Traditional, Laid Back, Romantic, Intelligent, Smooth, Articulate, Serious, Reserved, Playful, Weird, Risk Taker, Mature, Youthful, Safe, Conservative, Liberal, Crude, Sexy, Modest, Flamboyant, Deep, Opinionated, Quirky, Wishful, Sophisticated, Gloomy.
"Ethnicity" - Filter
Native American, Asian, Black, Hispanic, Native Hawaiian, Pacific Islander, Hawaii, Guam, Samoa, or other Pacific Islands, Caucasian.
"Category” - Filter
Beauty/Makeup, Fitness, Health, Photography, Food, Education, Science, Law, Women’s Fashion, Men’s Fashion, Kid’s Fashion, Cards, Technology, Dance, Social Media, Home & Garden, Interior Design, Music, Arts & Crafts, DIY, Politics, Women’s Issues, Men’s Issues, Self Help, Outdoors, Nature, Survival, Motivation, Green, Vegan, Spiritual/Religious, Marketing, Memes, Grooming, Books, Motivation, Family/Parenting, Business, Entertainment, Cars, News, Musician, Relationships, Singer, Rapper, DJ, Podcast, Gaming, Family, Meme, Lifestyle, Travel, History, Athletics/Sports, Pets, Comedy, Finance, Crypto, LGBT, Virtual Influencer, Adult Themes,
Custom tags (up to 3) - Searchable
(IE: Fine dining, Tattoos, Guitar, Anime, Watches, Shoes)”
"Active Social media” - Filter
Instagram, Facebook, Twitter, YouTube, Pinterest, Tik Tok, Snapchat, Telegram, Website, Podcast
"Gender" - Filter
Male, Female, Neutral
"Age of audience" - Filter
10 options
"Gender of the audience" - Filter
"Location Country" - Searchable / Filter
"Location State - Searchable / Filter
"Location City" Searchable / Flter
"Style”: - Filter
Casual, Chic, Sporty, Urban, Vintage, Bohemian, Trendy, Punk, Artsy, Sexy, Modest, Country, Street, Grunge, Eccentric, Exotic, Ethnic, Preppy, Cosplay, Elegant, Goth, Party/Rave, Formal, Geek, Biker, Vacation, Military.
"Gendered Appearance”: - Filter
Feminine, Masculine, Neutral.
“Physique”: - Filter
Small, Slender, Average, Toned, Athletic, Curvy, Stocky, Plus+ Size, Heavy Set
Open to use either SQL or NoSQL so long as searches can be performed quickly with a lot of users and able to return paginated results. Note this database will be sycing with a firestore database. Not sure if that makes a difference.
Below are our required storage fields and what will need to be filtered.
===================
UserID
General User Info
Name
Phone
Etc
“Personality” - Filter
Charismatic, Shy, Feminine, Masculine, Agreeable, Disagreeable, Humorous, Creative, Rebellious, Business, Minded, Casual, Dark, Light, Seductive, Carefree, Humble, Fiery, Cocky, Pure, Outgoing, Skeptical, Cute, Traditional, Laid Back, Romantic, Intelligent, Smooth, Articulate, Serious, Reserved, Playful, Weird, Risk Taker, Mature, Youthful, Safe, Conservative, Liberal, Crude, Sexy, Modest, Flamboyant, Deep, Opinionated, Quirky, Wishful, Sophisticated, Gloomy.
"Ethnicity" - Filter
Native American, Asian, Black, Hispanic, Native Hawaiian, Pacific Islander, Hawaii, Guam, Samoa, or other Pacific Islands, Caucasian.
"Category” - Filter
Beauty/Makeup, Fitness, Health, Photography, Food, Education, Science, Law, Women’s Fashion, Men’s Fashion, Kid’s Fashion, Cards, Technology, Dance, Social Media, Home & Garden, Interior Design, Music, Arts & Crafts, DIY, Politics, Women’s Issues, Men’s Issues, Self Help, Outdoors, Nature, Survival, Motivation, Green, Vegan, Spiritual/Religious, Marketing, Memes, Grooming, Books, Motivation, Family/Parenting, Business, Entertainment, Cars, News, Musician, Relationships, Singer, Rapper, DJ, Podcast, Gaming, Family, Meme, Lifestyle, Travel, History, Athletics/Sports, Pets, Comedy, Finance, Crypto, LGBT, Virtual Influencer, Adult Themes,
Custom tags (up to 3) - Searchable
(IE: Fine dining, Tattoos, Guitar, Anime, Watches, Shoes)”
"Active Social media” - Filter
Instagram, Facebook, Twitter, YouTube, Pinterest, Tik Tok, Snapchat, Telegram, Website, Podcast
"Gender" - Filter
Male, Female, Neutral
"Age of audience" - Filter
10 options
"Gender of the audience" - Filter
"Location Country" - Searchable / Filter
"Location State - Searchable / Filter
"Location City" Searchable / Flter
"Style”: - Filter
Casual, Chic, Sporty, Urban, Vintage, Bohemian, Trendy, Punk, Artsy, Sexy, Modest, Country, Street, Grunge, Eccentric, Exotic, Ethnic, Preppy, Cosplay, Elegant, Goth, Party/Rave, Formal, Geek, Biker, Vacation, Military.
"Gendered Appearance”: - Filter
Feminine, Masculine, Neutral.
“Physique”: - Filter
Small, Slender, Average, Toned, Athletic, Curvy, Stocky, Plus+ Size, Heavy Set