model

type FivenetAccounts struct {
	ID               uint64     `sql:"primary_key" json:"id"`
	CreatedAt        *time.Time `json:"created_at"`
	UpdatedAt        *time.Time `json:"updated_at"`
	Enabled          *bool      `json:"enabled"`
	Username         *string    `json:"username"`
	Password         *string    `json:"password"`
	License          string     `json:"license"`
	RegToken         *string    `json:"reg_token"`
	OverrideJob      *string    `json:"override_job"`
	OverrideJobGrade *int32     `json:"override_job_grade"`
	Superuser        *bool      `json:"superuser"`
}

type FivenetAttrs struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	PermissionID uint64     `json:"permission_id"`
	Key          string     `json:"key"`
	Type         string     `json:"type"`
	ValidValues  *string    `json:"valid_values"`
}

type FivenetAuditLog struct {
	ID            uint64     `sql:"primary_key" json:"id"`
	CreatedAt     *time.Time `json:"created_at"`
	UserID        int32      `json:"user_id"`
	UserJob       string     `json:"user_job"`
	TargetUserID  *int32     `json:"target_user_id"`
	TargetUserJob *string    `json:"target_user_job"`
	Service       string     `json:"service"`
	Method        string     `json:"method"`
	State         int16      `json:"state"`
	Data          *string    `json:"data"`
}

type FivenetCentrumDispatches struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	Job         string     `json:"job"`
	Message     string     `json:"message"`
	Description *string    `json:"description"`
	Attributes  *string    `json:"attributes"`
	References  *string    `json:"references"`
	X           *float64   `json:"x"`
	Y           *float64   `json:"y"`
	Postal      *string    `json:"postal"`
	Anon        bool       `json:"anon"`
	CreatorID   int32      `json:"creator_id"`
}

type FivenetCentrumDispatchesAsgmts struct {
	DispatchID uint64     `sql:"primary_key" json:"dispatch_id"`
	UnitID     uint64     `sql:"primary_key" json:"unit_id"`
	CreatedAt  *time.Time `json:"created_at"`
	ExpiresAt  *time.Time `json:"expires_at"`
}

type FivenetCentrumDispatchesStatus struct {
	ID         uint64     `sql:"primary_key" json:"id"`
	CreatedAt  *time.Time `json:"created_at"`
	DispatchID uint64     `json:"dispatch_id"`
	UnitID     *uint64    `json:"unit_id"`
	Status     int16      `json:"status"`
	Reason     *string    `json:"reason"`
	Code       *string    `json:"code"`
	X          *float64   `json:"x"`
	Y          *float64   `json:"y"`
	Postal     *string    `json:"postal"`
	UserID     *int32     `json:"user_id"`
}

type FivenetCentrumMarkers struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	ExpiresAt   *time.Time `json:"expires_at"`
	Job         string     `json:"job"`
	Name        string     `json:"name"`
	Description *string    `json:"description"`
	X           *float64   `json:"x"`
	Y           *float64   `json:"y"`
	Postal      *string    `json:"postal"`
	Color       *string    `json:"color"`
	Icon        *string    `json:"icon"`
	MarkerType  int16      `json:"marker_type"`
	MarkerData  *[]byte    `json:"marker_data"`
	CreatorID   *int32     `json:"creator_id"`
}

type FivenetCentrumSettings struct {
	Job              string  `sql:"primary_key" json:"job"`
	Enabled          bool    `json:"enabled"`
	Mode             *int32  `json:"mode"`
	FallbackMode     *int32  `json:"fallback_mode"`
	PredefinedStatus *string `json:"predefined_status"`
}

type FivenetCentrumUnits struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	Job         string     `json:"job"`
	Name        string     `json:"name"`
	Initials    string     `json:"initials"`
	Color       string     `json:"color"`
	Description *string    `json:"description"`
	Attributes  *string    `json:"attributes"`
	HomePostal  *string    `json:"home_postal"`
}

type FivenetCentrumUnitsStatus struct {
	ID        uint64     `sql:"primary_key" json:"id"`
	CreatedAt *time.Time `json:"created_at"`
	UnitID    uint64     `json:"unit_id"`
	Status    int16      `json:"status"`
	Reason    *string    `json:"reason"`
	Code      *string    `json:"code"`
	UserID    *int32     `json:"user_id"`
	X         *float64   `json:"x"`
	Y         *float64   `json:"y"`
	Postal    *string    `json:"postal"`
	CreatorID *int32     `json:"creator_id"`
}

type FivenetCentrumUnitsUsers struct {
	UnitID uint64 `sql:"primary_key" json:"unit_id"`
	UserID int32  `sql:"primary_key" json:"user_id"`
}

type FivenetCentrumUsers struct {
	Job        string `json:"job"`
	UserID     int32  `sql:"primary_key" json:"user_id"`
	Identifier string `json:"identifier"`
}

type FivenetConfig struct {
	Key          int64      `sql:"primary_key" json:"key"`
	CreatedAt    *time.Time `json:"created_at"`
	UpdatedAt    *time.Time `json:"updated_at"`
	AppConfig    *string    `json:"app_config"`
	PluginConfig *string    `json:"plugin_config"`
}

type FivenetDocuments struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	DeletedAt   *time.Time `json:"deleted_at"`
	CategoryID  *uint64    `json:"category_id"`
	Title       string     `json:"title"`
	Summary     string     `json:"summary"`
	ContentType int16      `json:"content_type"`
	Content     string     `json:"content"`
	Data        *string    `json:"data"`
	CreatorID   *int32     `json:"creator_id"`
	CreatorJob  string     `json:"creator_job"`
	State       string     `json:"state"`
	Closed      *bool      `json:"closed"`
	Public      bool       `json:"public"`
	TemplateID  *uint64    `json:"template_id"`
}

type FivenetDocumentsActivity struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	DocumentID   uint64     `json:"document_id"`
	ActivityType int16      `json:"activity_type"`
	CreatorID    *int32     `json:"creator_id"`
	CreatorJob   string     `json:"creator_job"`
	Reason       *string    `json:"reason"`
	Data         *string    `json:"data"`
}

type FivenetDocumentsCategories struct {
	ID          uint64  `sql:"primary_key" json:"id"`
	Name        string  `json:"name"`
	Description *string `json:"description"`
	Job         string  `json:"job"`
}

type FivenetDocumentsComments struct {
	ID         uint64     `sql:"primary_key" json:"id"`
	CreatedAt  *time.Time `json:"created_at"`
	UpdatedAt  *time.Time `json:"updated_at"`
	DeletedAt  *time.Time `json:"deleted_at"`
	DocumentID uint64     `json:"document_id"`
	Comment    *string    `json:"comment"`
	CreatorID  int32      `json:"creator_id"`
	CreatorJob string     `json:"creator_job"`
}

type FivenetDocumentsJobAccess struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	DocumentID   uint64     `json:"document_id"`
	Job          string     `json:"job"`
	MinimumGrade int32      `json:"minimum_grade"`
	Access       int16      `json:"access"`
}

type FivenetDocumentsReferences struct {
	ID               uint64     `sql:"primary_key" json:"id"`
	CreatedAt        *time.Time `json:"created_at"`
	DeletedAt        *time.Time `json:"deleted_at"`
	SourceDocumentID uint64     `json:"source_document_id"`
	Reference        int16      `json:"reference"`
	TargetDocumentID uint64     `json:"target_document_id"`
	CreatorID        *int32     `json:"creator_id"`
}

type FivenetDocumentsRelations struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	DeletedAt    *time.Time `json:"deleted_at"`
	DocumentID   uint64     `json:"document_id"`
	SourceUserID *int32     `json:"source_user_id"`
	Relation     int16      `json:"relation"`
	TargetUserID int32      `json:"target_user_id"`
}

type FivenetDocumentsRequests struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	DocumentID  uint64     `json:"document_id"`
	RequestType int16      `json:"request_type"`
	CreatorID   *int32     `json:"creator_id"`
	CreatorJob  string     `json:"creator_job"`
	Reason      *string    `json:"reason"`
	Data        *string    `json:"data"`
	Accepted    *bool      `json:"accepted"`
}

type FivenetDocumentsTemplates struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	UpdatedAt    *time.Time `json:"updated_at"`
	DeletedAt    *time.Time `json:"deleted_at"`
	Weight       *uint32    `json:"weight"`
	CategoryID   *uint64    `json:"category_id"`
	Title        string     `json:"title"`
	Description  string     `json:"description"`
	ContentTitle string     `json:"content_title"`
	Content      string     `json:"content"`
	State        string     `json:"state"`
	Access       *string    `json:"access"`
	Schema       *string    `json:"schema"`
	CreatorJob   string     `json:"creator_job"`
}

type FivenetDocumentsTemplatesJobAccess struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	UpdatedAt    *time.Time `json:"updated_at"`
	TemplateID   uint64     `json:"template_id"`
	Job          string     `json:"job"`
	MinimumGrade int32      `json:"minimum_grade"`
	Access       int16      `json:"access"`
}

type FivenetDocumentsUserAccess struct {
	ID         uint64     `sql:"primary_key" json:"id"`
	CreatedAt  *time.Time `json:"created_at"`
	DocumentID *uint64    `json:"document_id"`
	UserID     int32      `json:"user_id"`
	Access     int16      `json:"access"`
}

type FivenetJobAttrs struct {
	Job       string  `sql:"primary_key" json:"job"`
	AttrID    uint64  `sql:"primary_key" json:"attr_id"`
	MaxValues *string `json:"max_values"`
}

type FivenetJobPermissions struct {
	Job          string `sql:"primary_key" json:"job"`
	PermissionID uint64 `sql:"primary_key" json:"permission_id"`
	Val          bool   `json:"val"`
}

type FivenetJobProps struct {
	Job                 string     `json:"job"`
	UpdatedAt           *time.Time `json:"updated_at"`
	Theme               *string    `json:"theme"`
	LivemapMarkerColor  *string    `json:"livemap_marker_color"`
	QuickButtons        *string    `json:"quick_buttons"`
	RadioFrequency      *string    `json:"radio_frequency"`
	DiscordGuildID      *uint64    `json:"discord_guild_id"`
	DiscordLastSync     *time.Time `json:"discord_last_sync"`
	DiscordSyncSettings *string    `json:"discord_sync_settings"`
	Motd                *string    `json:"motd"`
	LogoURL             *string    `json:"logo_url"`
	Settings            *string    `json:"settings"`
}

type FivenetJobsConduct struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	UpdatedAt    *time.Time `json:"updated_at"`
	Job          string     `json:"job"`
	Type         int16      `json:"type"`
	Message      *string    `json:"message"`
	ExpiresAt    *time.Time `json:"expires_at"`
	TargetUserID *int32     `json:"target_user_id"`
	CreatorID    *int32     `json:"creator_id"`
}

type FivenetJobsTimeclock struct {
	Job       string     `sql:"primary_key" json:"job"`
	UserID    int32      `sql:"primary_key" json:"user_id"`
	Date      time.Time  `sql:"primary_key" json:"date"`
	StartTime *time.Time `json:"start_time"`
	EndTime   *time.Time `json:"end_time"`
	SpentTime *float64   `json:"spent_time"`
}

type FivenetJobsUserActivity struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	Job          string     `json:"job"`
	SourceUserID *int32     `json:"source_user_id"`
	TargetUserID int32      `json:"target_user_id"`
	ActivityType int16      `json:"activity_type"`
	Reason       *string    `json:"reason"`
	Data         *string    `json:"data"`
}

type FivenetJobsUserProps struct {
	UserID       int32      `json:"user_id"`
	AbsenceBegin *time.Time `json:"absence_begin"`
	AbsenceEnd   *time.Time `json:"absence_end"`
}

type FivenetLawbooks struct {
	ID          uint64     `sql:"primary_key" json:"id"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	Name        string     `json:"name"`
	Description *string    `json:"description"`
}

type FivenetLawbooksLaws struct {
	ID            uint64     `sql:"primary_key" json:"id"`
	CreatedAt     *time.Time `json:"created_at"`
	UpdatedAt     *time.Time `json:"updated_at"`
	LawbookID     uint64     `json:"lawbook_id"`
	Name          string     `json:"name"`
	Description   *string    `json:"description"`
	Fine          *uint64    `json:"fine"`
	DetentionTime *uint64    `json:"detention_time"`
	StvoPoints    *uint64    `json:"stvo_points"`
}

type FivenetNotifications struct {
	ID        uint64     `sql:"primary_key" json:"id"`
	CreatedAt *time.Time `json:"created_at"`
	ReadAt    *time.Time `json:"read_at"`
	UserID    *int32     `json:"user_id"`
	Job       *string    `json:"job"`
	Title     string     `json:"title"`
	Type      string     `json:"type"`
	Content   *string    `json:"content"`
	Category  int16      `json:"category"`
	Data      *string    `json:"data"`
	Starred   *bool      `json:"starred"`
}

type FivenetOauth2Accounts struct {
	AccountID  uint64     `json:"account_id"`
	CreatedAt  *time.Time `json:"created_at"`
	Provider   string     `json:"provider"`
	ExternalID string     `json:"external_id"`
	Username   string     `json:"username"`
	Avatar     string     `json:"avatar"`
}

type FivenetPermissions struct {
	ID        uint64     `sql:"primary_key" json:"id"`
	CreatedAt *time.Time `json:"created_at"`
	Category  string     `json:"category"`
	Name      string     `json:"name"`
	GuardName string     `json:"guard_name"`
}

type FivenetQualifications struct {
	ID              uint64     `sql:"primary_key" json:"id"`
	CreatedAt       *time.Time `json:"created_at"`
	UpdatedAt       *time.Time `json:"updated_at"`
	DeletedAt       *time.Time `json:"deleted_at"`
	Job             string     `json:"job"`
	Weight          *uint32    `json:"weight"`
	Closed          *bool      `json:"closed"`
	Abbreviation    string     `json:"abbreviation"`
	Title           string     `json:"title"`
	Description     *string    `json:"description"`
	Content         *string    `json:"content"`
	CreatorID       *int32     `json:"creator_id"`
	CreatorJob      string     `json:"creator_job"`
	DiscordSettings *string    `json:"discord_settings"`
}

type FivenetQualificationsJobAccess struct {
	ID              uint64     `sql:"primary_key" json:"id"`
	CreatedAt       *time.Time `json:"created_at"`
	QualificationID uint64     `json:"qualification_id"`
	Job             string     `json:"job"`
	MinimumGrade    int32      `json:"minimum_grade"`
	Access          int16      `json:"access"`
}

type FivenetQualificationsRequests struct {
	CreatedAt       *time.Time `json:"created_at"`
	DeletedAt       *time.Time `json:"deleted_at"`
	QualificationID uint64     `json:"qualification_id"`
	UserID          int32      `json:"user_id"`
	UserComment     *string    `json:"user_comment"`
	Status          *int16     `json:"status"`
	ApprovedAt      *time.Time `json:"approved_at"`
	ApproverComment *string    `json:"approver_comment"`
	ApproverID      *int32     `json:"approver_id"`
	ApproverJob     *string    `json:"approver_job"`
}

type FivenetQualificationsRequirements struct {
	ID                    uint64     `sql:"primary_key" json:"id"`
	CreatedAt             *time.Time `json:"created_at"`
	QualificationID       uint64     `json:"qualification_id"`
	TargetQualificationID uint64     `json:"target_qualification_id"`
}

type FivenetQualificationsResults struct {
	ID              uint64     `sql:"primary_key" json:"id"`
	CreatedAt       *time.Time `json:"created_at"`
	DeletedAt       *time.Time `json:"deleted_at"`
	QualificationID uint64     `json:"qualification_id"`
	UserID          int32      `json:"user_id"`
	Status          *int16     `json:"status"`
	Score           *int32     `json:"score"`
	Summary         *string    `json:"summary"`
	CreatorID       *int32     `json:"creator_id"`
	CreatorJob      string     `json:"creator_job"`
}

type FivenetRoleAttrs struct {
	RoleID    uint64     `sql:"primary_key" json:"role_id"`
	CreatedAt *time.Time `json:"created_at"`
	UpdatedAt *time.Time `json:"updated_at"`
	AttrID    uint64     `sql:"primary_key" json:"attr_id"`
	Value     *string    `json:"value"`
}

type FivenetRolePermissions struct {
	RoleID       uint64 `sql:"primary_key" json:"role_id"`
	PermissionID uint64 `sql:"primary_key" json:"permission_id"`
	Val          bool   `json:"val"`
}

type FivenetRoles struct {
	ID        uint64     `sql:"primary_key" json:"id"`
	CreatedAt *time.Time `json:"created_at"`
	Job       string     `json:"job"`
	Grade     int32      `json:"grade"`
}

type FivenetUserActivity struct {
	ID           uint64     `sql:"primary_key" json:"id"`
	CreatedAt    *time.Time `json:"created_at"`
	SourceUserID *int32     `json:"source_user_id"`
	TargetUserID int32      `json:"target_user_id"`
	Type         int16      `json:"type"`
	Key          string     `json:"key"`
	OldValue     *string    `json:"old_value"`
	NewValue     *string    `json:"new_value"`
	Reason       *string    `json:"reason"`
}

type FivenetUserLocations struct {
	Identifier string     `sql:"primary_key" json:"identifier"`
	Job        string     `json:"job"`
	X          *float64   `json:"x"`
	Y          *float64   `json:"y"`
	Hidden     *bool      `json:"hidden"`
	UpdatedAt  *time.Time `json:"updated_at"`
}

type FivenetUserProps struct {
	UserID                  int32   `json:"user_id"`
	Wanted                  *bool   `json:"wanted"`
	Job                     *string `json:"job"`
	JobGrade                *int32  `json:"job_grade"`
	TrafficInfractionPoints *uint32 `json:"traffic_infraction_points"`
	OpenFines               *int64  `json:"open_fines"`
	BloodType               *string `json:"blood_type"`
	Avatar                  *string `json:"avatar"`
	MugShot                 *string `json:"mug_shot"`
}

type GksphoneJobMessage struct {
	ID      int32     `sql:"primary_key" json:"id"`
	Name    *string   `json:"name"`
	Number  *string   `json:"number"`
	Message *string   `json:"message"`
	Photo   *string   `json:"photo"`
	Gps     *string   `json:"gps"`
	Owner   int32     `json:"owner"`
	Jobm    *string   `json:"jobm"`
	Anon    *string   `json:"anon"`
	Time    time.Time `json:"time"`
}

type GksphoneSettings struct {
	ID          int32   `sql:"primary_key" json:"id"`
	Identifier  *string `json:"identifier"`
	Crypto      *string `json:"crypto"`
	PhoneNumber *string `json:"phone_number"`
	AvatarURL   *string `json:"avatar_url"`
}

type JobGrades struct {
	JobName    string `sql:"primary_key" json:"job_name"`
	Grade      int32  `sql:"primary_key" json:"grade"`
	Name       string `json:"name"`
	Label      string `json:"label"`
	Salary     int32  `json:"salary"`
	SkinMale   string `json:"skin_male"`
	SkinFemale string `json:"skin_female"`
}

type Jobs struct {
	Name  string  `sql:"primary_key" json:"name"`
	Label *string `json:"label"`
}

type Licenses struct {
	Type  string `sql:"primary_key" json:"type"`
	Label string `json:"label"`
}

type OwnedVehicles struct {
	Owner     *string `json:"owner"`
	Plate     string  `sql:"primary_key" json:"plate"`
	Model     string  `json:"model"`
	Vehicle   *string `json:"vehicle"`
	Type      string  `json:"type"`
	Stored    bool    `json:"stored"`
	Carseller *int32  `json:"carseller"`
	Owners    *string `json:"owners"`
	Trunk     *string `json:"trunk"`
	Glovebox  *string `json:"glovebox"`
}

type UserLicenses struct {
	Type  string `sql:"primary_key" json:"type"`
	Owner string `sql:"primary_key" json:"owner"`
}

type Users struct {
	ID           int32      `json:"id"`
	Identifier   string     `sql:"primary_key" json:"identifier"`
	Group        *string    `json:"group"`
	Skin         *string    `json:"skin"`
	Job          *string    `json:"job"`
	JobGrade     *int32     `json:"job_grade"`
	Loadout      *string    `json:"loadout"`
	Position     *string    `json:"position"`
	Firstname    *string    `json:"firstname"`
	Lastname     *string    `json:"lastname"`
	Dateofbirth  *string    `json:"dateofbirth"`
	Sex          *string    `json:"sex"`
	Height       *string    `json:"height"`
	IsDead       *bool      `json:"is_dead"`
	LastProperty *string    `json:"last_property"`
	Jail         int32      `json:"jail"`
	Inventory    *string    `json:"inventory"`
	PhoneNumber  *string    `json:"phone_number"`
	Accounts     *string    `json:"accounts"`
	Tattoos      *string    `json:"tattoos"`
	Disabled     *bool      `json:"disabled"`
	Visum        *int32     `json:"visum"`
	Playtime     *int32     `json:"playtime"`
	LevelData    *string    `json:"levelData"`
	OnDuty       *int8      `json:"onDuty"`
	Health       *int32     `json:"health"`
	Armor        *int32     `json:"armor"`
	CreatedAt    *time.Time `json:"created_at"`
	LastSeen     *time.Time `json:"last_seen"`
	Metadata     *string    `json:"metadata"`
}