model

type Alliance struct {
	AllianceId     int64  `gorm:"primary_key"`
	AllianceName   string `gorm:"varchar(100)"`
	AllianceTicker string `gorm:"varchar(5)"`
	InsertedDt     *time.Time
	UpdatedDt      *time.Time
}

type AuthenticationCode struct {
	CharacterId        int64 `gorm:"primary_key"`
	AuthenticationCode string
	Character          Character `gorm:"ForeignKey:CharacterId;save_associations:false;"`
	IsUsed             bool
}

type Character struct {
	CharacterId   int64       `gorm:"primary_key"`
	CharacterName string      `gorm:"varchar(100)"`
	Corporation   Corporation `gorm:"ForeignKey:corporation_id;AssociationForeignKey:corporation_id;save_associations:false;"`
	CorporationId int64
	Token         string
	// this really isn't meant as a many to many but the flow of auth linking forces this or another method
	// which I didn't want to use
	Users      []User               `gorm:"many2many:user_character_map;save_associations:false;"` //AssociationForeignKey:user_id;ForeignKey:character_id;"`
	AuthCodes  []AuthenticationCode `gorm:"ForeignKey:character_id"`
	InsertedDt *time.Time
	UpdatedDt  *time.Time
}

type Corporation struct {
	CorporationId     int64    `gorm:"primary_key"`
	CorporationName   string   `gorm:"varchar(100)"`
	CorporationTicker string   `gorm:"varchar(5)"`
	Alliance          Alliance `gorm:"ForeignKey:alliance_id;AssociationForeignKey:alliance_id;save_associations:false;"`
	AllianceId        *int64
	InsertedDt        *time.Time
	UpdatedDt         *time.Time
}

type Role struct {
	RoleId           int64  `gorm:"primary_key;AUTO_INCREMENT"`
	RoleName         string `gorm:"varchar(70)"`
	ChatServiceGroup string `gorm:"varchar(70);column:chatservice_group"`
	InsertedDt       *time.Time
	UpdatedDt        *time.Time
}

type User struct {
	UserId     int64       `gorm:"primary_key;AUTO_INCREMENT"`
	ChatId     string      `gorm:"varchar(255)"`
	Characters []Character `gorm:"many2many:user_character_map;"` //AssociationForeignKey:character_id;ForeignKey:user_id;"`
}