# Database Schema Specification

## 1. Conventions
- **Engine:** InnoDB (MySQL/MariaDB)
- **Naming:** `snake_case` for tables and columns. Plural for table names (e.g., `users`, `bookings`).
- **Primary Keys:** BigInt Unsigned (`id`) with Auto Increment.
- **Timestamps:** Always include `created_at` and `updated_at`.
- **Soft Deletes:** Include `deleted_at` if records should be recoverable.

## 2. Table: `[table_name]`
**Description:** [What does this table store?]

| Column Name | Data Type | Modifiers | Description/Foreign Key |
|-------------|-----------|-----------|-------------------------|
| `id` | BIGINT | PK, AI, UNSIGNED | Primary ID |
| `name` | VARCHAR(255) | NOT NULL | Name field |
| `status` | TINYINT | DEFAULT 1 | 1 = Active, 0 = Inactive |
| `created_at` | TIMESTAMP | NULLABLE | Creation time |
| `updated_at` | TIMESTAMP | NULLABLE | Last update time |

## 3. Relationships & Foreign Keys
- `table_a.foreign_id` -> `table_b.id` (On Delete: Cascade | Restrict | Set Null)

## 4. Indexes & Performance
- Index `status` column for faster filtering.
- Index Foreign keys.