# Appendix

### Environment Variable Reference

| Variable | Type | Required | Description |
|----------|------|----------|-------------|
| ENV | string | Yes | Environment (DEVELOPMENT/PRODUCTION) |
| API_PORT | number | Yes | Server port (default: 3610) |
| BASE_DOMAIN | string | Yes | API base URL |
| DB_HOST | string | Yes | PostgreSQL host |
| DB_PORT | number | Yes | PostgreSQL port |
| DB_USER | string | Yes | PostgreSQL username |
| DB_PASSWORD | string | Yes | PostgreSQL password |
| DB | string | Yes | PostgreSQL database name |
| MONGO_DB | string | Yes | MongoDB connection string |
| REDIS_HOST | string | Yes | Redis host |
| REDIS_PORT | number | Yes | Redis port |
| REDIS_PASSWORD | string | No | Redis password |
| JWT_SECRET | string | Yes | JWT signing secret |
| XENDIT_SECRET_KEY | string | Yes | Xendit API secret key |
| XENDIT_CALLBACK_TOKEN | string | Yes | Xendit webhook token |
| GOSEND_CLIENT_ID | string | Yes | GoSend API client ID |
| GOSEND_KEY | string | Yes | GoSend API key |
| GOSEND_ADDRESS | string | Yes | GoSend API base URL |
| MINIO_ENDPOINT | string | Yes | Minio server endpoint |
| MINIO_PORT | number | Yes | Minio server port |
| MINIO_ACCESS_KEY | string | Yes | Minio access key |
| MINIO_SECRET_KEY | string | Yes | Minio secret key |
| EMAIL_HOST | string | Yes | SMTP host |
| EMAIL_PORT | number | Yes | SMTP port |
| EMAIL_USER | string | Yes | SMTP username |
| EMAIL_PASSWORD | string | Yes | SMTP password |

### Database Schema Overview

#### Key PostgreSQL Tables

- **store**: Store information and settings
- **user_info**: User profiles and authentication
- **product**: Product catalog
- **product_variant**: Product variations (size, color, etc.)
- **store_order**: Order records
- **store_order_details**: Line items in orders
- **cart**: Shopping cart items
- **address_list**: Delivery addresses
- **balance_mutation**: Financial transactions
- **affiliate_account**: Affiliate user accounts
- **affiliate_commissions**: Commission records
- **affiliate_invitations**: Referral relationships
- **review**: Product reviews
- **voucher**: Discount codes
- **virtual_account**: Payment virtual accounts
- **xendit_invoice**: Payment invoices
- **bank_info**: Bank account information
- **payout_record**: Payout history

#### Key MongoDB Collections

- **store_chat**: Chat messages
- **store_chat_room**: Chat room metadata
- **affiliate_category**: Affiliate product categories
- **affiliate_clicks**: Click tracking for affiliate links
- **affiliate_links**: Generated affiliate links
- **order_info_cached**: Cached order data
- **shipping_info_cached**: Cached shipping calculations
- **price_info_cached**: Cached price calculations

### API Response Status Codes

| Code | Meaning | Usage |
|------|---------|-------|
| 200 | OK | Successful request |
| 201 | Created | Resource created successfully |
| 400 | Bad Request | Invalid request parameters |
| 401 | Unauthorized | Authentication required |
| 403 | Forbidden | Insufficient permissions |
| 404 | Not Found | Resource not found |
| 422 | Unprocessable Entity | Validation errors |
| 500 | Internal Server Error | Server error |
| 503 | Service Unavailable | Service temporarily unavailable |