cockroachdb

type CMSCodeStats struct {
	ID               string `gorm:"primary_key"` // UserID + GithubName + Month + Year
	GitHubName       string `gorm:"not null"`    // GithubName
	Repository       string `gorm:"not null"`    // Repository
	Month            int    `gorm:"not null"`    // Month of code stats
	Year             int    `gorm:"not null"`    // Year of code stats
	PRs              string `gorm:"not null"`    // String of all PR URLs separated by commas
	Reviews          string `gorm:"not null"`    // String of all Reviewed PR URLS separated by commas
	Commits          string `gorm:"not null"`    // String of all commit URL separated by commas
	MergedAdditions  int64  `gorm:"not null"`    // Total merged code additions
	MergedDeletions  int64  `gorm:"not null"`    // Total merged code deletions
	UpdatedAdditions int64  `gorm:"not null"`    // Total updated code additions
	UpdatedDeletions int64  `gorm:"not null"`    // Total updated code deletions
	ReviewAdditions  int64  `gorm:"not null"`    // Total reviewed code additions
	ReviewDeletions  int64  `gorm:"not null"`    // Total reviewed code deletions
	CommitAdditions  int64  `gorm:"not null"`    // Total commit additions
	CommitDeletions  int64  `gorm:"not null"`    // Total commit deletions
}

type CMSUser struct {
	ID                 uuid.UUID `gorm:"primary_key"`            // UUID (User foreign key)
	User               User      `gorm:"not null;foreignkey:ID"` // politeiawww user
	Domain             int       `gorm:"not null"`               // Contractor domain
	GitHubName         string    `gorm:"not null"`               // Github Name/ID
	MatrixName         string    `gorm:"not null"`               // Matrix Name/ID
	ContractorType     int       `gorm:"not null"`               // Type of Contractor
	ContractorName     string    `gorm:"not null"`               // IRL Contractor Name or identity
	ContractorLocation string    `gorm:"not null"`               // General IRL Contractor Location
	ContractorContact  string    `gorm:"not null"`               // Point of contact outside of matrix
	SupervisorUserID   string    `gorm:"not null"`               // This is can either be 1 SupervisorUserID or a comma separated string of many supervisor user ids
	ProposalsOwned     string    `gorm:"not null"`               // This can either be 1 Proposal or a comma separated string of many.

	// Set by gorm
	CreatedAt time.Time // Time of record creation
	UpdatedAt time.Time // Time of last record update
}

type EmailHistory struct {
	UserID uuid.UUID `gorm:"primary_key"` // User UUID
	Blob   []byte    `gorm:"not null"`    // Encrypted email history
}

type Identity struct {
	PublicKey   string    `gorm:"primary_key;size:64"` // ed25519 public key
	UserID      uuid.UUID `gorm:"not null"`            // User UUID (User foreign key)
	Activated   int64     `gorm:"not null"`            // UNIX timestamp of activation
	Deactivated int64     `gorm:"not null"`            // UNIX timestamp of deactivation
}

type KeyValue struct {
	Key   string `gorm:"primary_key"`
	Value []byte `gorm:"not null"`
}

type Session struct {
	Key       string    `gorm:"primary_key"` // SHA256 hash of the session ID
	UserID    uuid.UUID `gorm:"not null"`    // User UUID
	CreatedAt int64     `gorm:"not null"`    // Created at UNIX timestamp
	Blob      []byte    `gorm:"not null"`    // Encrypted user session
}

type User struct {
	ID         uuid.UUID  `gorm:"primary_key"`       // UUID
	Username   string     `gorm:"not null;unique"`   // Unique username
	Identities []Identity `gorm:"foreignkey:UserID"` // User identity history
	Blob       []byte     `gorm:"not null"`          // Encrypted blob of user data

	// Set by gorm
	CreatedAt time.Time // Time of record creation
	UpdatedAt time.Time // Time of last record update
}