Create new table `ticket` in Tribes DB

[humansinstitute]

Context

• The Hive platform needs to support draft tickets as part of its feature development workflow
• This database change will enable both individual ticket creation and group organization by Phase
• This is a foundational change that will support future ticket management features
• The table structure needs to integrate with the existing GORM-based architecture

Task

1. Create a new migration file for the ticket table
2. Implement the table schema using GORM
3. Add necessary indexes for performance optimization
4. Include foreign key constraints for feature and phase references
5. Implement the GORM model struct
6. Add validation methods for the model
7. Create database migration test

Outcome

A new ticket table in the Tribes database that:

• Stores draft and completed tickets
• Links tickets to features and phases
• Maintains ticket sequences and dependencies
• Tracks ticket creation and updates

Design

Database Schema Implementation

The table should be implemented using the following GORM structure:

goCopytype Ticket struct {
    UUID        string       `gorm:"primaryKey;type:uuid;default:uuid_generate_v4()"`
    FeatureUUID string       `gorm:"type:uuid;not null;index"`
    PhaseUUID   string       `gorm:"type:uuid;not null;index"`
    Name        string       `gorm:"type:varchar(255);not null"`
    Sequence    int          `gorm:"type:integer;not null"`
    Dependency  []int        `gorm:"type:integer[]"`
    Description string       `gorm:"type:text"`
    Status      TicketStatus `gorm:"type:varchar(50);not null;default:'draft'"`
    CreatedAt   time.Time    `gorm:"type:timestamp;not null;default:current_timestamp"`
    UpdatedAt   time.Time    `gorm:"type:timestamp;not null;default:current_timestamp"`
}

Required Indexes

• Primary Key on uuid
• Foreign key index on feature_uuid
• Foreign key index on phase_uuid
• Index on status for filtering
• Composite index on (feature_uuid, sequence) for ordering

Acceptance Criteria

Functional Requirements

• [ ] Table is created with all specified columns and correct data types
• [ ] UUID is automatically generated for new records
• [ ] Foreign key constraints are properly enforced
• [ ] Timestamps are automatically managed by GORM
• [ ] Array type for dependencies is properly implemented

Technical Requirements

• [ ] All specified indexes are created
• [ ] GORM migrations run successfully
• [ ] Rollback functionality is implemented
• [ ] Table follows naming conventions of existing schema

Testing Requirements

• [ ] Unit tests for model validation
• [ ] Migration tests (up/down)
• [ ] Foreign key constraint tests
• [ ] Index performance tests with significant data volume

[MuhammadUmer44]

@humansinstitute Please assign me

[MahtabBukhari]

@humansinstitute could you please assign me?

[aliraza556]

@humansinstitute please assign me