postgres

type DBUser struct {
	ID              string           `db:"id"`
	Domain          string           `db:"domain_id"`
	Secret          string           `db:"secret"`
	Metadata        []byte           `db:"metadata,omitempty"`
	PrivateMetadata []byte           `db:"private_metadata,omitempty"`
	Tags            pgtype.TextArray `db:"tags,omitempty"` // Tags
	CreatedAt       time.Time        `db:"created_at,omitempty"`
	UpdatedAt       sql.NullTime     `db:"updated_at,omitempty"`
	UpdatedBy       *string          `db:"updated_by,omitempty"`
	Groups          []groups.Group   `db:"groups,omitempty"`
	Status          users.Status     `db:"status,omitempty"`
	Role            *users.Role      `db:"role,omitempty"`
	Username        sql.NullString   `db:"username, omitempty"`
	FirstName       sql.NullString   `db:"first_name, omitempty"`
	LastName        sql.NullString   `db:"last_name, omitempty"`
	ProfilePicture  sql.NullString   `db:"profile_picture, omitempty"`
	Email           string           `db:"email,omitempty"`
	VerifiedAt      sql.NullTime     `db:"verified_at,omitempty"`
	AuthProvider    sql.NullString   `db:"auth_provider,omitempty"`
	TotalCount      uint64           `db:"total_count"`
}

type DBUsersPage struct {
	Total       uint64           `db:"total"`
	Limit       uint64           `db:"limit"`
	Offset      uint64           `db:"offset"`
	FirstName   string           `db:"first_name"`
	LastName    string           `db:"last_name"`
	Username    string           `db:"username"`
	Id          string           `db:"id"`
	Email       string           `db:"email"`
	Metadata    []byte           `db:"metadata"`
	Tags        pgtype.TextArray `db:"tags"`
	GroupID     string           `db:"group_id"`
	Role        users.Role       `db:"role"`
	Status      users.Status     `db:"status"`
	IDs         pq.StringArray   `db:"ids"`
	CreatedFrom time.Time        `db:"created_from"`
	CreatedTo   time.Time        `db:"created_to"`
}