Database Schema¶

This page documents the database schema and entity relationships in Arctyk ITSM.

Overview¶

Arctyk ITSM uses PostgreSQL as its primary database. The schema is organized around core entities: Tickets, Projects, Assets, and Users.

Core Models¶

Ticket Model¶

The central entity in the system.

Fields: - id (PK) - Auto-incrementing integer - title - Ticket title (max 200 chars) - description - Full description (TextField) - status - Current status (CharField, choices) - status_category - Derived category (todo/in_progress/done) - priority - Priority level (low/medium/high/critical) - issue_type - Type (bug/task/story/epic) - assignee (FK) - User assigned to ticket - reporter (FK) - User who created ticket - project (FK) - Associated project - created_at - Creation timestamp - updated_at - Last update timestamp

Related Documentation¶

• System Design
• Models Reference
• Database Migrations