model

type Activities struct {
	ActivityID   int32      `sql:"primary_key" db:"activity_id"`
	ProjectID    int32      `db:"project_id"`
	Name         string     `db:"name"`
	Description  string     `db:"description"`
	IsProductive bool       `db:"is_productive"`
	DeletedAt    *time.Time `db:"deleted_at"`
}

type CacheDemoTwoWorkItems struct {
	CustomDateForProject2 *time.Time `db:"custom_date_for_project_2"`
	WorkItemID            int64      `sql:"primary_key" db:"work_item_id"`
	Title                 string     `db:"title"`
	Description           string     `db:"description"`
	WorkItemTypeID        int32      `db:"work_item_type_id"`
	Metadata              string     `db:"metadata"`
	TeamID                int32      `db:"team_id"`
	KanbanStepID          int32      `db:"kanban_step_id"`
	ClosedAt              *time.Time `db:"closed_at"`
	TargetDate            time.Time  `db:"target_date"`
	CreatedAt             time.Time  `db:"created_at"`
	UpdatedAt             time.Time  `db:"updated_at"`
	DeletedAt             *time.Time `db:"deleted_at"`
}

type CacheDemoWorkItems struct {
	Ref            string     `db:"ref"`
	Line           string     `db:"line"`
	LastMessageAt  time.Time  `db:"last_message_at"`
	Reopened       bool       `db:"reopened"`
	WorkItemID     int64      `sql:"primary_key" db:"work_item_id"`
	Title          string     `db:"title"`
	Description    string     `db:"description"`
	WorkItemTypeID int32      `db:"work_item_type_id"`
	Metadata       string     `db:"metadata"`
	TeamID         int32      `db:"team_id"`
	KanbanStepID   int32      `db:"kanban_step_id"`
	ClosedAt       *time.Time `db:"closed_at"`
	TargetDate     time.Time  `db:"target_date"`
	CreatedAt      time.Time  `db:"created_at"`
	UpdatedAt      time.Time  `db:"updated_at"`
	DeletedAt      *time.Time `db:"deleted_at"`
}

type DemoTwoWorkItems struct {
	WorkItemID            int64      `sql:"primary_key" db:"work_item_id"`
	CustomDateForProject2 *time.Time `db:"custom_date_for_project_2"`
}

type DemoWorkItems struct {
	WorkItemID    int64     `sql:"primary_key" db:"work_item_id"`
	Ref           string    `db:"ref"`
	Line          string    `db:"line"`
	LastMessageAt time.Time `db:"last_message_at"`
	Reopened      bool      `db:"reopened"`
}

type EntityNotifications struct {
	EntityNotificationID int32     `sql:"primary_key" db:"entity_notification_id"`
	ID                   string    `db:"id"`
	Message              string    `db:"message"`
	Topic                string    `db:"topic"`
	CreatedAt            time.Time `db:"created_at"`
}

type KanbanSteps struct {
	KanbanStepID  int32  `sql:"primary_key" db:"kanban_step_id"`
	ProjectID     int32  `db:"project_id"`
	StepOrder     int32  `db:"step_order"`
	Name          string `db:"name"`
	Description   string `db:"description"`
	Color         string `db:"color"`
	TimeTrackable bool   `db:"time_trackable"`
}

type Movies struct {
	MovieID  int32  `sql:"primary_key" db:"movie_id"`
	Title    string `db:"title"`
	Year     int32  `db:"year"`
	Synopsis string `db:"synopsis"`
}

type NotificationType string

type Notifications struct {
	NotificationID   int32            `sql:"primary_key" db:"notification_id"`
	ReceiverRank     *int16           `db:"receiver_rank"`
	Title            string           `db:"title"`
	Body             string           `db:"body"`
	Labels           string           `db:"labels"`
	Link             *string          `db:"link"`
	CreatedAt        time.Time        `db:"created_at"`
	Sender           uuid.UUID        `db:"sender"`
	Receiver         *uuid.UUID       `db:"receiver"`
	NotificationType NotificationType `db:"notification_type"`
}

type Projects struct {
	ProjectID          int32     `sql:"primary_key" db:"project_id"`
	Name               string    `db:"name"`
	Description        string    `db:"description"`
	WorkItemsTableName string    `db:"work_items_table_name"`
	BoardConfig        string    `db:"board_config"`
	CreatedAt          time.Time `db:"created_at"`
	UpdatedAt          time.Time `db:"updated_at"`
}

type Teams struct {
	TeamID      int32     `sql:"primary_key" db:"team_id"`
	ProjectID   int32     `db:"project_id"`
	Name        string    `db:"name"`
	Description string    `db:"description"`
	CreatedAt   time.Time `db:"created_at"`
	UpdatedAt   time.Time `db:"updated_at"`
}

type TimeEntries struct {
	TimeEntryID     int64     `sql:"primary_key" db:"time_entry_id"`
	WorkItemID      *int64    `db:"work_item_id"`
	ActivityID      int32     `db:"activity_id"`
	TeamID          *int32    `db:"team_id"`
	UserID          uuid.UUID `db:"user_id"`
	Comment         string    `db:"comment"`
	Start           time.Time `db:"start"`
	DurationMinutes *int32    `db:"duration_minutes"`
}

type UserAPIKeys struct {
	UserAPIKeyID int32     `sql:"primary_key" db:"user_api_key_id"`
	APIKey       string    `db:"api_key"`
	ExpiresOn    time.Time `db:"expires_on"`
	UserID       uuid.UUID `db:"user_id"`
}

type UserNotifications struct {
	UserNotificationID int64     `sql:"primary_key" db:"user_notification_id"`
	NotificationID     int32     `db:"notification_id"`
	Read               bool      `db:"read"`
	UserID             uuid.UUID `db:"user_id"`
}

type UserProject struct {
	ProjectID int32     `sql:"primary_key" db:"project_id"`
	Member    uuid.UUID `sql:"primary_key" db:"member"`
}

type UserTeam struct {
	TeamID int32     `sql:"primary_key" db:"team_id"`
	Member uuid.UUID `sql:"primary_key" db:"member"`
}

type Users struct {
	UserID                   uuid.UUID  `sql:"primary_key" db:"user_id"`
	Username                 string     `db:"username"`
	Email                    string     `db:"email"`
	Age                      *int32     `db:"age"`
	FirstName                *string    `db:"first_name"`
	LastName                 *string    `db:"last_name"`
	FullName                 *string    `db:"full_name"`
	ExternalID               string     `db:"external_id"`
	APIKeyID                 *int32     `db:"api_key_id"`
	Scopes                   string     `db:"scopes"`
	RoleRank                 int16      `db:"role_rank"`
	HasPersonalNotifications bool       `db:"has_personal_notifications"`
	HasGlobalNotifications   bool       `db:"has_global_notifications"`
	CreatedAt                time.Time  `db:"created_at"`
	UpdatedAt                time.Time  `db:"updated_at"`
	DeletedAt                *time.Time `db:"deleted_at"`
}

type WorkItemAssignee struct {
	WorkItemID int64        `sql:"primary_key" db:"work_item_id"`
	Assignee   uuid.UUID    `sql:"primary_key" db:"assignee"`
	Role       WorkItemRole `db:"role"`
}

type WorkItemComments struct {
	WorkItemCommentID int64     `sql:"primary_key" db:"work_item_comment_id"`
	WorkItemID        int64     `db:"work_item_id"`
	UserID            uuid.UUID `db:"user_id"`
	Message           string    `db:"message"`
	CreatedAt         time.Time `db:"created_at"`
	UpdatedAt         time.Time `db:"updated_at"`
}

type WorkItemRole string

type WorkItemTags struct {
	WorkItemTagID int32      `sql:"primary_key" db:"work_item_tag_id"`
	ProjectID     int32      `db:"project_id"`
	Name          string     `db:"name"`
	Description   string     `db:"description"`
	Color         string     `db:"color"`
	DeletedAt     *time.Time `db:"deleted_at"`
}

type WorkItemTypes struct {
	WorkItemTypeID int32  `sql:"primary_key" db:"work_item_type_id"`
	ProjectID      int32  `db:"project_id"`
	Name           string `db:"name"`
	Description    string `db:"description"`
	Color          string `db:"color"`
}

type WorkItemWorkItemTag struct {
	WorkItemTagID int32 `sql:"primary_key" db:"work_item_tag_id"`
	WorkItemID    int64 `sql:"primary_key" db:"work_item_id"`
}

type WorkItems struct {
	WorkItemID     int64      `sql:"primary_key" db:"work_item_id"`
	Title          string     `db:"title"`
	Description    string     `db:"description"`
	WorkItemTypeID int32      `db:"work_item_type_id"`
	Metadata       string     `db:"metadata"`
	TeamID         int32      `db:"team_id"`
	KanbanStepID   int32      `db:"kanban_step_id"`
	ClosedAt       *time.Time `db:"closed_at"`
	TargetDate     time.Time  `db:"target_date"`
	CreatedAt      time.Time  `db:"created_at"`
	UpdatedAt      time.Time  `db:"updated_at"`
	DeletedAt      *time.Time `db:"deleted_at"`
}