Database Schema Architecture

When to use this skill

• When creating new collections in the Appwrite Console.
• When defining TypeScript interfaces for database documents.

Schema Definition

Users (Private Data)

• userId (string, required)
• name (string)
• email (string, required)
• role (enum: user, admin)

Tours

• title (string, required)
• description (markdown/text)
• location (string, required)
• price (float, required)
• images (string array, storage IDs)
• rating (float)
• availableDates (datetime array)

Bookings

• userId (string, required)
• tourId (string, required)
• status (enum: pending, confirmed, cancelled)
• totalPrice (float)

Instructions

• Indexes: Add indexes for searchable fields like location and price.
• Permissions: Ensure "Users" can only read their own bookings.