Create Documentation for Database Schema

[xDDoubleTea]

Task

Create a DATABASE.md file in the root of the project to document the database schema, including all tables and their columns.

Acceptance Criteria

• A DATABASE.md file exists.
• The file documents the tickets table.
• The file documents the ticket_participants table.
• Each table's documentation includes a description of its purpose and a breakdown of each column (name, type, constraints, description).
• The file documents the keywords table.
• The file documents the keyword_channel.
• The file documents the ticket_panels table.

Example Template to Use

Table: tickets

Purpose: Stores the primary state and metadata for each customer support ticket channel.

Column Name	Data Type	Constraints	Description	Example
id	SERIAL	PRIMARY KEY	Auto-incrementing unique identifier.	125
channel_id	NUMERIC(20,0)	NOT NULL	The Discord ID of the text channel.	1234...
status	INTEGER	NOT NULL	The current status of the ticket.	1

(Continue for all columns and tables)

[xDDoubleTea]

commit 965ebbc adds documentation for tickets and ticket_participants

[xDDoubleTea]

• The file documents the role_request table
• The file documents the guild_requestable_roles tables