database

type Role struct {
	ID        uint            `gorm:"primaryKey" json:"id"`
	CreatedAt time.Time       `json:"createdAt"`
	UpdatedAt time.Time       `json:"updatedAt"`
	DeletedAt *gorm.DeletedAt `gorm:"index" json:"deletedAt,omitempty"`
	Name      string          `gorm:"uniqueIndex;not null" json:"name"`
	IsAdmin   bool            `json:"isAdmin"`
}

type Session struct {
	ID        uuid.UUID `gorm:"type:uuid;primaryKey" json:"-"`
	UpdatedAt time.Time `json:"-"`
	UserID    uuid.UUID `gorm:"type:uuid;uniqueIndex" json:"id"`
	FirstName string    `gorm:"-" json:"firstName"`
	LastName  string    `gorm:"-" json:"lastName"`
	Role      string    `gorm:"-" json:"role"`
	Token     string    `json:"token,omitempty"`
}

type Setting struct {
	ID        uint              `gorm:"primaryKey" json:"id"`
	CreatedAt time.Time         `json:"createdAt"`
	UpdatedAt time.Time         `json:"updatedAt"`
	DeletedAt *gorm.DeletedAt   `gorm:"index" json:"deletedAt,omitempty"`
	Key       string            `gorm:"uniqueIndex;not null"`
	Value     datatypes.JSONMap `gorm:"uniqueIndex"`
}

type User struct {
	ID          uuid.UUID       `gorm:"type:uuid;primaryKey" json:"id"`
	CreatedAt   time.Time       `json:"createdAt"`
	UpdatedAt   time.Time       `json:"updatedAt"`
	DeletedAt   *gorm.DeletedAt `gorm:"index" json:"deletedAt,omitempty"`
	FirstName   string          `gorm:"not null" json:"firstName"`
	LastName    string          `gorm:"not null" json:"lastName"`
	Email       string          `gorm:"uniqueIndex;not null" json:"email"`
	Password    string          `gorm:"not null" json:"-"`
	RoleID      uint            `json:"-"`
	Role        *Role           `gorm:"constraint:OnDelete:SET NULL" json:"role,omitempty"`
	Session     *Session        `gorm:"constraint:OnDelete:SET NULL" json:"session,omitempty"`
	RawPassword string          `gorm:"-" json:"password,omitempty"`
}