models

type AccessToken struct {
	ID         int64
	UserID     int64
	Name       string
	TokenHash  string
	LastUsedAt *int64
	CreatedAt  int64
}

type Contributor struct {
	ID           int64
	RepositoryID int64
	UserID       int64
	Role         string
	CreatedAt    int64
}

type DeviceAuthSession struct {
	ID          string // UUID
	Code        string // User-friendly code like "ABCD-1234"
	UserID      *int64
	AccessToken *string
	Status      string // pending, confirmed, expired
	CreatedAt   int64
	ExpiresAt   int64
}

type Organization struct {
	ID          int64
	Username    string
	DisplayName string
	CreatedAt   int64
	UpdatedAt   int64
}

type Repository struct {
	ID            int64
	Name          string
	Description   *string
	DefaultBranch string
	Visibility    string
	OwnerUserID   *int64
	OwnerOrgID    *int64
	CreatedAt     int64
	UpdatedAt     int64
}

type Star struct {
	ID           int64
	RepositoryID int64
	UserID       int64
	CreatedAt    int64
}

type Ticket struct {
	ID           int64
	RepositoryID int64
	Number       int64
	Title        string
	Body         *string
	Status       string // 'open' or 'closed'
	AuthorID     int64
	ClosedAt     *int64
	ClosedByID   *int64
	CreatedAt    int64
	UpdatedAt    int64
}

type TicketAssignee struct {
	ID           int64
	TicketID     int64
	UserID       int64
	AssignedByID int64
	CreatedAt    int64
}

type TicketComment struct {
	ID        int64
	TicketID  int64
	AuthorID  int64
	Body      string
	CreatedAt int64
	UpdatedAt int64
}

type TicketLabel struct {
	ID           int64
	RepositoryID int64
	Name         string
	Color        string
	Description  *string
	CreatedAt    int64
}

type TicketLabelAssignment struct {
	ID        int64
	TicketID  int64
	LabelID   int64
	CreatedAt int64
}

type TicketReaction struct {
	ID        int64
	TicketID  *int64
	CommentID *int64
	UserID    int64
	Emoji     string
	CreatedAt int64
}

type User struct {
	ID           int64
	Username     string
	Email        string
	DisplayName  string
	Password     *string
	GitHubUserID *string
	CreatedAt    int64
	UpdatedAt    int64
}