DATABASE_SCHEMA

Category: 04. No-Code / Low-Code
Section: Phase 2: Technical Blueprint

5. DATABASE_SCHEMA.md

Purpose: To design the no-code database schema for standard CRUD operations and relationships.

Act as a senior no-code database designer.
Using the PRD and System Architecture below, design the database schema for a no-code hackathon project.

PRD: [PASTE PRD]
ARCHITECTURE: [PASTE SYSTEM_ARCHITECTURE]

Provide:
1. Tables (Users, Core Entities, Lookup Tables)
2. Fields/Columns
3. Data types (Text, Number, Date, Boolean, Image, Reference)
4. Primary keys
5. Relationships (One-to-Many, Many-to-Many)
6. Required fields
7. Optional fields
8. Example records
9. Privacy rules (Who can see what data?)
10. A checklist for developers to verify data structure before the demo

Explain why each table exists.
Keep the database simple enough for a beginner no-code team to understand and maintain.
Avoid complex structures that are hard to debug visually.