diegosouzapw 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
locationandprice. - Permissions: Ensure "Users" can only read their own bookings.