> ## Documentation Index
> Fetch the complete documentation index at: https://docs.parvej.me/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Setup

> Create collections and attributes in Appwrite

# 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.

| Attribute         | Type      | Size   | Required |
| ----------------- | --------- | ------ | -------- |
| `title`           | String    | 255    | Yes      |
| `category`        | String    | 100    | Yes      |
| `description`     | String    | 500    | Yes      |
| `thumbnailUrl`    | String    | 2000   | Yes      |
| `galleryUrls`     | String\[] | 2000   | No       |
| `likes`           | Integer   | -      | No       |
| `featured`        | Boolean   | -      | No       |
| `fullDescription` | String    | 100000 | Yes      |
| `customSlug`      | String    | 255    | Yes      |
| `authorNames`     | String\[] | 255    | No       |
| `authorImages`    | String\[] | 2000   | No       |
| `publishDate`     | String    | 50     | Yes      |

**Indexes:**

* `slug_idx` (unique) on `customSlug`
* `category_idx` on `category`
* `featured_idx` on `featured`

### projects

Portfolio projects collection.

| Attribute          | Type      | Size   | Required |
| ------------------ | --------- | ------ | -------- |
| `title`            | String    | 255    | Yes      |
| `category`         | String    | 100    | Yes      |
| `description`      | String    | 500    | Yes      |
| `thumbnailUrl`     | String    | 2000   | Yes      |
| `galleryUrls`      | String\[] | 2000   | No       |
| `likes`            | Integer   | -      | No       |
| `featured`         | Boolean   | -      | No       |
| `fullDescription`  | String    | 100000 | Yes      |
| `customSlug`       | String    | 100    | Yes      |
| `useProjectPrefix` | Boolean   | -      | Yes      |
| `projectLink`      | String    | 2000   | No       |
| `projectDetails`   | String\[] | 500    | No       |

### products

Shop products collection.

| Attribute         | Type      | Size  | Required |
| ----------------- | --------- | ----- | -------- |
| `name`            | String    | 255   | Yes      |
| `price`           | Float     | -     | Yes      |
| `discountedPrice` | Float     | -     | No       |
| `onSale`          | Boolean   | -     | No       |
| `featured`        | Boolean   | -     | No       |
| `imageUrl`        | String    | 2048  | No       |
| `category`        | String    | 255   | No       |
| `tags`            | String\[] | -     | No       |
| `description`     | String    | 10000 | No       |
| `additionalInfo`  | String    | 10000 | No       |
| `galleryUrls`     | String\[] | -     | No       |

### orders

Customer orders collection.

| Attribute       | Type   | Size  | Required |
| --------------- | ------ | ----- | -------- |
| `orderId`       | String | 100   | Yes      |
| `customerId`    | String | 50    | Yes      |
| `customerName`  | String | 200   | No       |
| `customerEmail` | String | 200   | Yes      |
| `items`         | String | 10000 | Yes      |
| `subtotal`      | Float  | -     | Yes      |
| `discount`      | Float  | -     | No       |
| `couponCode`    | String | 50    | No       |
| `total`         | Float  | -     | Yes      |
| `status`        | String | 20    | Yes      |
| `paypalOrderId` | String | 100   | No       |

**Status values:** `placed`, `processing`, `completed`, `cancelled`

### shortlinks

URL shortener collection.

| Attribute         | Type     | Size | Required |
| ----------------- | -------- | ---- | -------- |
| `customPath`      | String   | 100  | Yes      |
| `destinationUrl`  | URL      | -    | Yes      |
| `previewImageUrl` | URL      | -    | No       |
| `title`           | String   | 255  | No       |
| `description`     | String   | 500  | No       |
| `isActive`        | Boolean  | -    | Yes      |
| `clickCount`      | Integer  | -    | No       |
| `createdAt`       | Datetime | -    | Yes      |

**Indexes:**

* `customPath_idx` (unique) on `customPath`

## Category Collections

For `blog_categories`, `project_categories`, `shop_categories`:

| Attribute | Type    | Size | Required |
| --------- | ------- | ---- | -------- |
| `name`    | String  | 100  | Yes      |
| `color`   | String  | 20   | No       |
| `order`   | Integer | -    | No       |

## Settings Collections

### header\_section

| Attribute         | Type      | Size | Required |
| ----------------- | --------- | ---- | -------- |
| `name`            | String    | 100  | Yes      |
| `roles`           | String\[] | 100  | No       |
| `description`     | String    | 1000 | No       |
| `nameFont`        | String    | 200  | No       |
| `rolesFont`       | String    | 200  | No       |
| `descriptionFont` | String    | 200  | No       |

### custom\_fonts

| Attribute | Type   | Size | Required |
| --------- | ------ | ---- | -------- |
| `name`    | String | 100  | Yes      |
| `fileId`  | String | 100  | Yes      |
| `fileUrl` | String | 2000 | Yes      |