Search

Final Year Project

Tag
Figma
Flutter
FastAPI
PostgreSQL
Date
2024/03/26 → 2024/06/29
Description
OtterDram is a social media application for whisky enthusiasts to share tasting notes and insights on various whisky brands, collections, models, and releases. Additionally, it provides convenient features such as an automated consumption tracker, bottle condition recorder, and blind tasting features, which other liquor applications do not offer.
GitHub Link
Contributors

Proposal

FYP Proposal.pdf
2579.1KB
Loading PDF…

System Architecture Design

Use Case Diagram (UML Diagram)

Frontend

Prototype

Preview

UI (Figma)

Backend

Nested Categories

mindmap root((Alcoholic Beverages)) Fermented Beer Lager Pale_Lager Pilsner Helles Dortmunder Vienna_Lager Amber_Lager Dark_Lager Bock Doppelbock Eisbock Ale Pale_Ale American_Pale_Ale English_Pale_Ale India_Pale_Ale American_IPA English_IPA Double_IPA New_England_IPA West_Coast_IPA Brown_Ale American_Brown_Ale English_Brown_Ale Porter Stout Dry_Stout Sweet_Stout Oatmeal_Stout Russian_Imperial_Stout Belgian_Ale Belgian_Pale_Ale Belgian_Strong_Ale Dubbel Tripel Quadrupel Wheat_Ale Hefeweizen Witbier American_Wheat Hybrid_Beer Cream_Ale Kolsch Altbier Wild_Beer Lambic Gueuze Kriek Framboise Flanders_Red_Ale American_Wild_Ale Wine Red_Wine Cabernet_Sauvignon Merlot Pinot_Noir Syrah Malbec Sangiovese Zinfandel White_Wine Chardonnay Sauvignon_Blanc Riesling Pinot_Grigio Gewurztraminer Chenin_Blanc Semillon Rose_Wine Provence_Rose Pinot_Noir_Rose Grenache_Rose Syrah_Rose Tempranillo_Rose Sparkling_Wine Champagne Prosecco Cava Cremant Sekt Sparkling_Rose Dessert_Wine Sauternes Ice_Wine Tokaji Muscat Fortified_Wine Port Sherry Vinos_Generosos Manzanilla Fino Amontillado Palo_Cortado Oloroso Generosos_de_Licor Pale_Cream Medium Cream Vinos_Dulces_Naturales Pedro_Ximenez Moscatel Madeira Marsala Vermouth Distilled Rum English_Rum_Style Spanish_Ron_Style French_Rhum_Style Brandy Eau_de_vie Cognac Grande_Champagne Petite_Champagne Fine_Champagne Borderies Fins_Bois Bons_Bois Bois_Ordinaires Armagnac Bas_Armagnac Tenareze Haut_Armagnac Calvados AOC_Calvados AOC_Calvados_Domfrontais AOC_Calvados_Pays_dAuge Brandy_de_Jerez Pomace_Brandy Marc Grappa Pisco Peruvian_Pisco Chilean_Pisco Cut_Brandy Mezcal Tequila Mixto Full_Blue_Agave Artisanal_Mezcal Ancestral_Mezcal Destilado_de_Agave Whiskey Scotch_Whisky Single_Malt_Scotch Islay Highland Lowland Speyside Campbeltown Blended_Malt_Scotch Single_Grain_Scotch Blended_Grain_Scotch Blended_Scotch Irish_Whiskey Single_Malt_Irish Single_Pot_Still_Irish Grain_Irish Blended_Irish Peated_Irish American_Whiskey Bourbon Tennessee Rye Corn Wheat Malt Blended_American Canadian_Whisky Canadian_Rye Blended_Canadian Single_Malt_Canadian Japanese_Whisky Single_Malt_Japanese Blended_Japanese Grain_Japanese Gin London_Dry_Gin Plymouth_Gin New_American_Gin Dry_Gin Old_Tom_Gin Navy_Strength_Gin Genever Flavored_Gin Japanese_Gin Reserve_Gin Sloe_Gin Rose_Gin Craft_Gin
Mermaid
복사

Database Schema (dbdiagram.io)

FastAPI Code Structure

/BE ├── /alembic │ ├── /versions │ └── env.py ├── /app │ ├── /routers │ │ ├── __init__.py │ │ ├── auth.py │ │ ├── user.py │ │ ├── follow.py │ │ ├── company.py │ │ ├── distillery.py │ │ ├── brand.py │ │ ├── collection.py │ │ ├── model.py │ │ ├── release.py │ │ ├── company_keyword.py │ │ ├── distillery_keyword.py │ │ ├── brand_keyword.py │ │ ├── collection_keyword.py │ │ ├── model_keyword.py │ │ ├── release_keyword.py │ │ ├── brand_comment.py │ │ ├── collection_comment.py │ │ ├── model_comment.py │ │ ├── shelf.py │ │ ├── bottle.py │ │ ├── vial.py │ │ ├── consumption.py │ │ ├── review.py │ │ └── search.py │ ├── __init__.py │ ├── config.py │ ├── database.py │ ├── main.py │ ├── models.py │ ├── oauth2.py │ ├── schemas.py │ └── utils.py ├── .gitignore └── alembic.ini
Bash
복사