MASTER
CONTROL ROOM
● Database Engine
Sync: Active
STUDENT PARTICIPANTS ROSTER
Complete registered participant database records.
| STUDENT PARTICIPANT | GENDER | PHONE / WHATSAPP | SCHOOL / COLLEGE | CLASS / GRADE | REG IP | LAST LOGIN & IP | REF CODE | JOINED | ACTIONS |
|---|---|---|---|---|---|---|---|---|---|
| LOADING PARTICIPANTS... | |||||||||
SPONSOR & BRAND MEETINGS
Corporate bookings scheduled via sponsor desk.
| ID | COMPANY | DOMAIN | CONTACT NAME | EMAIL & PHONE | DATE & TIME (IST) | NOTES / OBJECTIVE | STATUS | ACTIONS |
|---|---|---|---|---|---|---|---|---|
| LOADING SPONSOR BOOKINGS... | ||||||||
SPONSOR MOU & DIGITAL AGREEMENTS DESK
Draft, type, and e-sign bilateral sponsorship contracts with cryptographic SHA-256 seal & shareable sponsor signing links.
| TOKEN / ID | SPONSOR COMPANY | CONTACT & EMAIL | TIER & COMMITMENT | STATUS | ADMIN SIGNER | SPONSOR SIGNER | SHARE & ACTIONS |
|---|---|---|---|---|---|---|---|
| LOADING SPONSOR MOUS... | |||||||
ORGANIZER INTERVIEW APPLICANTS
Student leaders applying to host campus hackathons.
| ID | CANDIDATE NAME | EMAIL & PHONE | INSTITUTION | EVENT FORMAT | ATTENDEES | DATE & TIME (IST) | STATUS | ACTIONS |
|---|---|---|---|---|---|---|---|---|
| LOADING ORGANIZER APPLICANTS... | ||||||||
LIVE HACKATHONS CMS
Manage upcoming hackathons displayed across the website.
GLOBAL SITE BROADCAST & TICKER CMS
Deploy high-priority broadcast banners and live tickers across the entire website.
LIVE MULTI-TAB EXCEL WORKBOOK
GermanCrab_Master_Database.xlsx · Real-Time Automatic Sync Active
Every single registration, BIC 2.0 team proposal, LPU verification code, referral squad join, sponsor meeting, organizer interview, and partner application is permanently recorded and synchronized into this 6-tab Excel workbook automatically.
GOOGLE SHEETS & EXCEL IMPORT DESK
Plug and play data synchronization. Push real-time data to Google Sheets or pull spreadsheets into SQLite.
PUSH ALL DATABASE RECORDS TO GOOGLE SHEETS
Dispatches all 140+ registered participants, BIC teams, and referral logs to your configured Google Sheet instantly.
METHOD 1: PASTE GOOGLE SHEET / CSV LINK
METHOD 2: UPLOAD CSV / EXCEL FILE
● IMPORT STATUS LOG:
DYNAMIC PAGE & FORM BUILDER
Generate custom application landing pages with custom questions without touching code.
| Page Name / Title | Public Route | Prize Pool | Template | Submissions | Status | Actions |
|---|---|---|---|---|---|---|
| Loading custom pages... | ||||||
MASTER USER DIRECTORY
Manage student profiles, elevate roles, and launch 1-click live support impersonation.
| User / GC-ID | Email & Phone | Institution & Class | Role | Provider | Registered | Actions |
|---|---|---|---|---|---|---|
| Loading user roster... | ||||||
n8n, DISCORD & TELEGRAM WEBHOOK ENGINE
Configure your central automation endpoint. Real-time JSON payloads are dispatched on key platform events.
DISPATCHED EVENT SIGNATURES:
- ●
USER_REGISTERED— New student profile created - ●
CUSTOM_PAGE_SUBMISSION— Dynamic form submitted - ●
HACKATHON_APPLIED— BIC / Hackathon proposal received - ●
SPONSOR_MEET_BOOKED— Calendar meeting confirmed
SYSTEM HEALTH & ENGINE COCKPIT
Real-time memory footprints, microsecond SQLite WAL probes, in-memory RAM cache rates, and disaster recovery.
TARGETED IN-APP NOTIFICATION BROADCASTER
Dispatch high-priority notifications to all users or specific roles.
HARDWARE & SYSTEM SPEC
SQLite WAL mode ensures non-blocking concurrent reads while transactional writes are safely flushed. Click "FULL DB JSON VAULT" at any time to instantly export the full relational snapshot.
ADMIN ACTIVITY AUDIT LOG STREAM
Real-time chronological ledger of all administrative logins, impersonations, cache flushes, and database changes.
| ID / Time | Operator Admin | Action Signature | Client IP | Action Details & Payload |
|---|---|---|---|---|
| Loading audit log stream... | ||||
E-CERTIFICATES & CREDENTIALS ENGINE
Mint tamper-evident hackathon credentials, award badges, and public verifiable certificates.
| CREDENTIAL ID | RECIPIENT & EMAIL | GC-ID | EVENT & TRACK | DISTINCTION | ISSUE DATE | SHA-256 SEAL | ACTIONS |
|---|---|---|---|---|---|---|---|
| LOADING CERTIFICATE LEDGER... | |||||||
EVENT GATE QR CHECK-IN STATION
Fast-track attendee ingress, barcode verification, and real-time attendance telemetry.