WEEK 12 DAY 01 CONCEPT & ANALYSIS

RareCollect Auction

A high-trust auction platform for rare collectibles, featuring real-time bidding, blockchain provenance, and professional grading integration.

Buyer-Centric Functionalities

User Registration and Secure Login

Secure onboarding using email, phone, or social media accounts, enhanced with encryption and multi-factor or biometric authentication.

Advanced Search and Filtering

Smart search tools allowing users to find specific items by filtering through categories, condition, price range, and seller ratings.

Detailed Product Pages

Comprehensive item pages featuring high-resolution images with zoom capabilities, detailed descriptions, shipping info, and condition reports.

Real-Time Bidding and Live Streaming

Synchronized bidding engine with proxy bidding, countdown timers, and live video streams of the auction event.

Alert Messages and Notifications

Real-time push notifications for outbid alerts, upcoming auctions, and deadline reminders.

Watchlists, Carts & In-App Chat

Track interested items, consolidate checkout, and communicate directly with sellers to build trust.

Specialized Trust & Security

Authentication & Grading

Integration with third-party grading APIs (PSA, GIA) and AI-automated condition evaluators to guarantee authenticity.

Blockchain Provenance

Creating "digital twins" or NFT backing for physical assets to provide a tamper-proof digital record of ownership history.

Escrow Services

Secure payment mechanisms where funds are held until inspection periods are met.

Payment & Ratings

Encrypted multi-method processing and a robust community rating system.

Vendor Functionalities

Streamlined Listing: Tools for high-def video and provenance record uploads.
Seller Dashboard: Advanced analytics on sales, income, and traffic.

Admin & Governance

User Management: Strict background checks and profile approval.
Monitoring: Real-time bid management and dispute intervention.
Automated Financials: Commission calculation and automated invoicing.

Implementation Scope

RareCollect Feature Analysis Diagram

Core Development Focus

1. Buyer-Centric Stack

Secure Authentication (MFA/Biometric)
Smart Search & Category Filtering
High-Res Product Pages with Zoom
Real-time Synchronized Bidding
Live Auction Streaming Integration
Push Notifications & Watchlists

2. Governance & Monitoring

Vendor Background Checks & Verification
Real-time Auction Monitoring Dashboard
Bid Management & Dispute Intervention
Fraudulent Listing Prevention Controls

Note on Financial Components: To ensure focus on user experience and real-time synchronization, advanced financial processing (automated commissions, escrow fund holding, automated invoicing) will be deferred. The current scope will be limited to listing auction prices and processing current bids.

WEEK 12 DAY 02 ACTORS & INTERACTIONS

System Actors

Defining the roles and responsibilities of the participants within the RareCollect auction ecosystem.

Based on the specific functionalities provided and excluding any financial or payment-processing components, here is the list of Actors and their corresponding interactions with the rare collectible auction application:

1. Buyer (or Bidder)

The primary consumer interacting with the marketplace to find and bid on rare collectibles.

Account Registration & Authentication: Register for an account using email, phone, or social media, and log in securely using multi-factor or biometric authentication.
Search & Navigation: Use smart search tools to find specific rare items and apply filters based on categories, item condition, price ranges, and seller ratings.
Item Evaluation: View detailed product pages, zoom in on high-resolution images, and read comprehensive descriptions, condition reports, shipping info, and seller return policies.
Live Auction Participation: Watch live video streams of the auction event and monitor the dynamic countdown timer, current bids, and required increments in real-time.
Bidding: Place manual bids in real-time, set up proxy bidding (auto-bidding) to automatically outbid competitors up to a maximum valuation, or use the "Buy It Now" option to secure an item instantly.
Monitoring & Tracking: Add items of interest to a watchlist or shopping cart to track their status.
Receiving Alerts: Receive instant push notifications reminding them of auction deadlines, upcoming events, or alerting them if they have been outbid.
Communication: Use the in-app chat module to communicate directly with sellers to ask questions and clarify item details before placing a bid.

2. Seller (or Vendor)

The actor offering the rare collectible items for auction.

Profile Submission: Submit their vendor profile and necessary credentials to administrators for background checks and approval.
Communication: Use the in-app chat module to respond directly to buyer inquiries, clarifying details about their listings and building buyer trust.
Policy Definition: Define and provide the specific return policies and condition reports that are displayed on the detailed product pages.

3. Administrator

The platform operator responsible for maintaining the integrity, safety, and governance of the auction ecosystem.

Vendor Vetting: Run strict background checks on new vendors and manually approve or reject vendor profiles to prevent fraudulent listings from entering the platform.
User Management: Monitor and manage all registered participants (buyers and sellers) to ensure community guidelines are followed.
Live Auction Monitoring: Track real-time bidding activity across the platform.
Bid Governance: Intervene in active auctions to edit or remove invalid/fraudulent bids and resolve user disputes.
System Configuration: Configure and manage the overarching bid settings (such as defining proxy bid rules or countdown timer logic) for the platform.

Actor Interaction Model

RareCollect Actor & Interaction Diagram

WEEK 12 DAY 03 DATABASE SCHEMA

Database Entities

Core database entities required to support non-financial functionalities and manage the application's state.

Based on the core system design principles and data models outlined in the sources, implementing your non-financial functionalities requires defining several core database entities (tables or collections) to store and manage the application's state.

Here are the different database tables required to implement your chosen functionalities:

1. Users Table

Functionalities Mapped: User Registration and Secure Login, User and Seller Management.
Purpose: Stores all participant data and manages authentication.
Key Fields: User ID, Name, Contact Information, Authentication Credentials (encrypted passwords/biometric tokens), User Role (Buyer, Seller, Administrator), and Account Status (e.g., pending background check, approved, banned).

Column Name	Type	Attributes
user_id	UUID	PRIMARY KEY
name	VARCHAR(255)	NOT NULL
contact_info	VARCHAR(255)	UNIQUE NOT NULL
auth_credentials	VARCHAR(255)	NOT NULL
user_role	ENUM('Buyer', 'Seller', 'Admin')	NOT NULL
account_status	VARCHAR(50)	NOT NULL

2. Products / Auction Listings Table

Functionalities Mapped: Detailed Product Pages, Advanced Search and Filtering, Auction Monitoring.
Purpose: Houses all information regarding the rare collectibles being auctioned.
Key Fields: Item ID, Seller ID, Title, Detailed Description, Category, Condition Report, Media (high-resolution image/video URLs), Shipping Information, Seller Return Policies, Starting Price, Reserve Price, and Auction Start/End Times.

Column Name	Type	Attributes
item_id	UUID	PRIMARY KEY
seller_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
title	VARCHAR(255)	NOT NULL
description	TEXT	NOT NULL
category	VARCHAR(100)	NOT NULL
condition_report	TEXT
media_urls	JSON	NOT NULL
shipping_info	TEXT
return_policy	TEXT
starting_price	DECIMAL	NOT NULL
reserve_price	DECIMAL
auction_start_time	TIMESTAMP	NOT NULL
auction_end_time	TIMESTAMP	NOT NULL

3. Bids / Bid History Table

Functionalities Mapped: Real-Time Bidding, Auction Monitoring and Bid Management.
Purpose: Maintains a complete, thread-safe bid history for each auction item to determine the winner and resolve ties.
Key Fields: Bid ID, Item ID, Bidder ID (User ID), Bid Amount, Bid Type (Manual, Proxy/Auto-bid maximums, or "Buy It Now"), and Timestamp.

Column Name	Type	Attributes
bid_id	UUID	PRIMARY KEY
item_id	UUID	FOREIGN KEY REFERENCES Products(item_id)
bidder_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
bid_amount	DECIMAL	NOT NULL
bid_type	ENUM('Manual', 'Proxy', 'BuyItNow')	NOT NULL
timestamp	TIMESTAMP	NOT NULL

4. Watchlist & Cart Table

Functionalities Mapped: Watchlists and Shopping Carts.
Purpose: Allows users to track items of interest and consolidate won/desired items for checkout.
Key Fields: Record ID, User ID, Item ID, Date Added, and List Type (Watchlist tracking vs. Shopping Cart consolidation).

Column Name	Type	Attributes
record_id	UUID	PRIMARY KEY
user_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
item_id	UUID	FOREIGN KEY REFERENCES Products(item_id)
date_added	TIMESTAMP	NOT NULL
list_type	ENUM('Watchlist', 'Cart')	NOT NULL

5. Messages / In-App Chat Table

Functionalities Mapped: In-App Chat.
Purpose: Powers the communication module allowing direct contact between buyers and sellers to clarify item details before bids are placed.
Key Fields: Message ID, Sender ID, Receiver ID, Associated Item ID (for context), Message Content, and Timestamp.

Column Name	Type	Attributes
message_id	UUID	PRIMARY KEY
sender_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
receiver_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
item_id	UUID	FOREIGN KEY REFERENCES Products(item_id)
content	TEXT	NOT NULL
timestamp	TIMESTAMP	NOT NULL

6. Notifications Table

Functionalities Mapped: Alert Messages and Notifications.
Purpose: Triggers and logs real-time push notifications sent to users.
Key Fields: Notification ID, User ID, Alert Type (e.g., outbid alert, auction deadline reminder, upcoming auction), Message Content, and Read/Unread Status.

Column Name	Type	Attributes
notification_id	UUID	PRIMARY KEY
user_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
alert_type	VARCHAR(100)	NOT NULL
content	TEXT	NOT NULL
is_read	BOOLEAN	DEFAULT FALSE

7. Ratings and Reviews Table

Functionalities Mapped: Advanced Search and Filtering (Seller Ratings).
Purpose: Supports the community trust system by allowing buyers to rate sellers.
Key Fields: Review ID, Buyer ID, Seller ID, Rating Score, and Feedback/Review Text.

Column Name	Type	Attributes
review_id	UUID	PRIMARY KEY
buyer_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
seller_id	UUID	FOREIGN KEY REFERENCES Users(user_id)
rating_score	INT	CHECK (rating_score >= 1 AND rating_score <= 5)
feedback_text	TEXT

Data Architecture Model

RareCollect Database Entity Relationship Diagram

WEEK 12 DAY 04 UX/UI DESIGN

Mobile Interface

High-converting, user-friendly mobile screens tailored for the Buyer, Seller, and Administrator personas.

Buyer Mobile Interfaces

Secure Registration & Login

Secure onboarding and authentication.

Discovery Dashboard

Browse upcoming and live auctions using personalized feeds.

Advanced Search & Filter

Smart search tools to find specific items.

Live Bidding Room

Evaluate items and participate in synchronized real-time bidding.

Watchlist & Cart

Track status of desired items.

Notifications Center

Instant alerts for outbids or auction deadlines.

In-App Chat

Clarify item details with the seller directly.

Leave a Review

Build community trust post-auction.

Seller Mobile Interfaces

Onboarding & Profile

Collect credentials for admin background checks.

Seller Dashboard

Analytics and overview of selling activity.

Create Auction

Upload detailed product and auction parameters.

In-App Chat

Answer buyer inquiries to build trust.

Admin Command Interfaces

Command Dashboard

High-level overview of platform health.

User Management

Vetting vendors and managing participants.

Bid Monitoring

Track real-time activity and intervene if necessary.

System Config

Set platform-wide auction rules.

WEEK 12 DAY 05 CODING PLAN

Complete Build Plan

Technical architecture and 3-day coding plan for the RareCollect Auction App.

🏷️ Application Overview

RareCollect is a high-trust mobile auction platform for rare collectibles (coins, cards, gems, memorabilia, etc.) featuring real-time bidding, live streaming, and blockchain provenance tracking.

Actor	Role
Buyer / Bidder	Browses, bids, tracks items, chats with sellers
Seller / Vendor	Lists items, defines policies, answers buyer inquiries
Administrator	Vets vendors, monitors live auctions, governs bids, configures platform

📱 Core Features (In Scope)

Buyer

✅ Secure login (MFA / Biometric via Firebase)
✅ Smart search & category filtering
✅ High-res product detail pages (zoom, condition reports)
✅ Real-time bidding (Manual, Proxy, Buy It Now)
✅ Live auction streaming with countdown timers
✅ Watchlist & cart
✅ Push notifications (outbid alerts, deadline reminders)
✅ In-app chat with sellers
✅ Seller ratings & reviews

Seller

✅ Profile submission & vendor approval workflow
✅ Listing with HD video/image uploads & provenance records
✅ Seller analytics dashboard
✅ In-app chat with buyers
✅ Return policy definition

Administrator

✅ Vendor vetting & background check management
✅ User management (approve/ban accounts)
✅ Real-time auction monitoring dashboard
✅ Bid intervention (edit/remove fraudulent bids)
✅ Platform-wide system configuration

⚠️ Out of Scope (deferred): Automated commissions, escrow fund holding, automated invoicing. Only listing prices and processing current bids are in scope.

🗄️ Database Schema (Firebase Firestore)

Collection	Purpose
Users	All participants — buyers, sellers, admins
Products	Item details, media URLs, pricing, auction times
Bids	Full bid history per item (Manual, Proxy, BuyItNow)
Watchlist_Cart	User watchlists and shopping carts
Messages	In-app buyer-seller chat per item
Notifications	Push notification log (outbid, deadline, etc.)
Ratings_Reviews	Buyer-to-seller ratings (1–5 stars + text)

🏗️ Technical Architecture

RareCollect — End-to-End Technical Architecture (Flutter → API Gateway → Cloud Function → Firebase/GCS)

Layer	Technology
Frontend	Flutter (iOS) — com.weeklychallenges.myauctionapp
Auth	Firebase Authentication (email/password, native login screen)
API Gateway	Google API Gateway — myauctionapp
Backend Functions	Google Cloud Functions — myauctionappfunction (Python)
Database	Firebase Firestore (Native Mode)
Storage	Google Cloud Storage (images/videos)
Project	GCP Project: MyAuctionApp (myauctionapp-486709)

📁 Folder Structure & Scripts

Folder Structure to Create

/myauctionapp/
├── gcp_components/
│   # GCP Function, API config,
│   # deployment scripts
└── myauctionapp/
    # Flutter iOS application code

4 Scripts to Build

01
create_infrastructure.sh — GCP project, service accounts, Firebase, iOS app registration, Firestore, FlutterFire config
02
deploy.sh — Deploy GCP Function, API config, API Gateway, IAM permissions
03
update.sh — Incremental update with 4 options (function only / API only / both / infrastructure changes)
ENV
.env.local — Secrets & variables file (gitignored)

📄 MD Documentation Files

INFRASTRUCTURE.md

Step-by-step infrastructure creation guide

DEPLOYMENT.md

Complete deployment guide

APPLICATION.md

Full application documentation

🎨 Color Theme

#0F172A / #1E293B — Headers

#B45309 — Buyer / Primary Actions

#059669 — Seller / Trust Signals

#64748B — Admin / Governance

🔒 Security Principles

🔑 No secrets directly in code — all via .env.local (gitignored)
🛡️ Firebase JWT validation at API Gateway level
🔗 Service account-based IAM (gateway SA → function SA → Firestore)
✅ Only Firebase-authenticated users of this project can call the API

WEEK 12 DAY 06 INFRASTRUCTURE & SANITY CHECK

Infrastructure Setup

Execution of automated scripts to provision the GCP environment and verify the integrity of the provisioned infrastructure.

Infrastructure Provisioning

1. Automation Execution

Successful execution of the core provisioning scripts to initialize the application ecosystem.

Provisioned Google Cloud Project
Enabled Firebase Services & API Access
Deployed Google Cloud Functions

2. Sanity Validation

Verifying that all components are communicating correctly and the application state is consistent.

End-to-End API Connectivity Check
Firebase Auth & Firestore CRUD Verification
Mobile SDK Initialization & Auth Loop

# Execution log snippet

> bash create_infrastructure.sh --verbose

... [Project Initialized] ...

> bash deploy.sh

... [Function Deployed: myauctionappfunction] ...

> bash verify_sanity.sh

... [Sanity Check: PASS] ...

WEEK 12 DAY 07 FINAL PROTOTYPE & DEPLOYMENT

Deployment & Source Code

The complete codebase and automated deployment pipeline for the RareCollect Auction App.

GitLab Repository

Complete Source Code

The RareCollect Auction App repository contains all the components necessary for running the platform, including infrastructure automation, backend logic, and the mobile interface.

Infrastructure Creation Scripts (GCP)

Deployment Automation Pipelines

Flutter Mobile Application Code

View on GitLab