​

Database Collections Setup

​

Create Database

1. Go to Appwrite Console → Databases
2. Click Create Database
3. Set ID: portfolio_db
4. Name: Portfolio Database

​

Core Collections

​

blogs

Main blog posts collection. Indexes:

• slug_idx (unique) on customSlug
• category_idx on category
• featured_idx on featured

​

projects

Portfolio projects collection.

​

products

Shop products collection.

​

orders

Customer orders collection. Status values: placed, processing, completed, cancelled

​

shortlinks

URL shortener collection. Indexes:

• customPath_idx (unique) on customPath

​

Category Collections

For blog_categories, project_categories, shop_categories:

​

Settings Collections

​

header_section

​

custom_fonts