model

type Cafeteria struct {
	Cafeteria int64   `gorm:"primary_key;AUTO_INCREMENT;column:cafeteria;type:int;not null;" json:"canteen" `
	Name      string  `gorm:"column:name;type:mediumtext;not null;" json:"name" `
	Address   string  `gorm:"column:address;type:text;not null;" json:"address" `
	Latitude  float32 `gorm:"column:latitude;type:float;not null;" json:"latitude" `
	Longitude float32 `gorm:"column:longitude;type:float;not null;" json:"longitude"`
}

type CafeteriaRating struct {
	CafeteriaRating int64     `gorm:"primary_key;AUTO_INCREMENT;column:cafeteriaRating;type:int;not null;" json:"canteenrating"`
	Points          int32     `gorm:"column:points;type:int;not null;" json:"points"`
	Comment         string    `gorm:"column:comment;type:text;" json:"comment" `
	CafeteriaID     int64     `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;" json:"canteenID"`
	Timestamp       time.Time `gorm:"column:timestamp;type:timestamp;not null;" json:"timestamp" `
	Image           string    `gorm:"column:image;type:text;" json:"image"`
}

type CafeteriaRatingStatistic struct {
	CafeteriaID int64   `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;"`
	Average     float64 `gorm:"column:average;type:float;not null;"`
	Min         int32   `gorm:"column:min;type:int;not null;"`
	Max         int32   `gorm:"column:max;type:int;not null;"`
	Std         float64 `gorm:"column:std;type:float;not null;"`
}

type CafeteriaRatingTag struct {
	CafeteriaRatingTag  int64 `gorm:"primary_key;AUTO_INCREMENT;column:CafeteriaRatingTag;type:int;not null;" json:"CanteenRatingTag" `
	CorrespondingRating int64 `gorm:"foreignKey:cafeteriaRatingID;column:correspondingRating;type:int;not null;" json:"correspondingRating"`
	Points              int32 `gorm:"column:points;type:int;not null;" json:"points"`
	TagID               int64 `gorm:"foreignKey:cafeteriaRatingTagOption;column:tagID;type:int;not null;" json:"tagID"`
}

type CafeteriaRatingTagOption struct {
	CafeteriaRatingsTagOption int64  `gorm:"primary_key;AUTO_INCREMENT;column:cafeteriaRatingTagOption;type:int;not null;" json:"canteenRatingTagOption"`
	DE                        string `gorm:"column:DE;text;default:de;not null;" json:"DE"`
	EN                        string `gorm:"column:EN;text;default:en;not null;" json:"EN"`
}

type CafeteriaRatingTagsStatistic struct {
	CafeteriaID int64   `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;" json:"canteenID"`
	TagID       int64   `gorm:"column:tagID;foreignKey:cafeteriaRatingTagOption;type:int;not null;" json:"tagID"`
	Average     float32 `gorm:"column:average;type:float;not null;" json:"average"`
	Min         int8    `gorm:"column:min;type:int;not null;" json:"min"`
	Max         int8    `gorm:"column:max;type:int;not null;" json:"max"`
	Std         float32 `gorm:"column:std;type:float;not null;" json:"std"`
}

type CanteenHeadCount struct {
	CanteenId string    `gorm:"primary_key;column:canteen_id;type:varchar(64);not null;" json:"canteen_id"`
	Count     uint32    `gorm:"column:count;type:int;not null;" json:"count"`
	MaxCount  uint32    `gorm:"column:max_count;type:int;not null;" json:"max_count"`
	Percent   float32   `gorm:"column:percent;type:float;not null;" json:"percent"`
	Timestamp time.Time `gorm:"column:timestamp;type:timestamp;not null;" json:"timestamp" `
}

type Crontab struct {
	Cron     int64       `gorm:"primary_key;AUTO_INCREMENT;column:cron;type:int;" json:"cron"`
	Interval int32       `gorm:"column:interval;type:int;default:7200;" json:"interval"`
	LastRun  int32       `gorm:"column:lastRun;type:int;default:0;" json:"last_run"`
	Type     null.String `` /* 208-byte string literal not displayed */
	ID       null.Int    `gorm:"column:id;type:int;" json:"id"`
}

type Device struct {
	Device          int64       `gorm:"primary_key;AUTO_INCREMENT;column:device;type:int;" json:"device"`
	Member          null.Int    `gorm:"column:member;type:int;" json:"member"`
	UUID            string      `gorm:"column:uuid;type:varchar(50);" json:"uuid"`
	Created         null.Time   `gorm:"column:created;type:timestamp;" json:"created"`
	LastAccess      time.Time   `gorm:"column:lastAccess;type:timestamp;default:'0000-00-00 00:00:00';" json:"last_access"`
	LastAPI         string      `gorm:"column:lastApi;type:text;size:16777215;" json:"last_api"`
	Developer       string      `gorm:"column:developer;type:enum('true','false');default:'false';" json:"developer"`
	OsVersion       string      `gorm:"column:osVersion;type:text;size:16777215;" json:"os_version"`
	AppVersion      string      `gorm:"column:appVersion;type:text;size:16777215;" json:"app_version"`
	Counter         int32       `gorm:"column:counter;type:int;default:0;" json:"counter"`
	Pk              null.String `gorm:"column:pk;type:text;size:4294967295;" json:"pk"`
	PkActive        string      `gorm:"column:pkActive;type:enum('true', 'false');default:'false';" json:"pk_active"`
	GcmToken        null.String `gorm:"column:gcmToken;type:text;size:65535;" json:"gcm_token"`
	GcmStatus       null.String `gorm:"column:gcmStatus;type:varchar(200);" json:"gcm_status"`
	ConfirmationKey null.String `gorm:"column:confirmationKey;type:varchar(35);" json:"confirmation_key"`
	KeyCreated      null.Time   `gorm:"column:keyCreated;type:datetime;" json:"key_created"`
	KeyConfirmed    null.Time   `gorm:"column:keyConfirmed;type:datetime;" json:"key_confirmed"`
}

type Dish struct {
	Dish        int64  `gorm:"primary_key;AUTO_INCREMENT;column:dish;type:int;not null;" json:"dish"`
	Name        string `gorm:"column:name;type:text;not null;uniqueIndex:dish_name_cafeteriaID_uindex" json:"name" `
	Type        string `gorm:"column:type;type:text;not null;" json:"type" `
	CafeteriaID int64  `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;uniqueIndex:dish_name_cafeteriaID_uindex" json:"cafeteriaID"`
}

type DishNameTag struct {
	DishNameTag         int64 `gorm:"primary_key;AUTO_INCREMENT;column:DishNameTag;type:int;not null;" json:"DishNameTag"`
	CorrespondingRating int64 `gorm:"foreignKey:dish;column:correspondingRating;type:int;not null;" json:"correspondingRating"`
	Points              int32 `gorm:"column:points;type:int;not null;" json:"points"`
	TagNameID           int64 `gorm:"foreignKey:tagRatingID;column:tagNameID;type:int;not null;" json:"tagnameID"`
}

type DishNameTagOption struct {
	DishNameTagOption int64  `gorm:"primary_key;AUTO_INCREMENT;column:dishNameTagOption;type:int;not null;" json:"dishNameTagOption"`
	DE                string `gorm:"column:DE;type:text;not null;" json:"DE"`
	EN                string `gorm:"column:EN;type:text;not null;" json:"EN"`
}

type DishNameTagOptionExcluded struct {
	DishNameTagOptionExcluded int64  `gorm:"primary_key;AUTO_INCREMENT;column:dishNameTagOptionExcluded;type:int;not null;" json:"dishNameTagOptionExcluded"`
	NameTagID                 int64  `gorm:"foreignKey:dishNameTagOption;column:nameTagID;type:int;not null;" json:"nameTagID"`
	Expression                string `gorm:"column:expression;type:text;" json:"expression"`
}

type DishNameTagOptionIncluded struct {
	DishNameTagOptionIncluded int64  `gorm:"primary_key;AUTO_INCREMENT;column:dishNameTagOptionIncluded;type:int;not null;" json:"dishNameTagOptionIncluded"`
	NameTagID                 int64  `gorm:"foreignKey:dishNameTagOption;column:nameTagID;type:int;not null;" json:"nameTagID"`
	Expression                string `gorm:"column:expression;type:text;" json:"expression"`
}

type DishNameTagStatistic struct {
	CafeteriaID int64   `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;" json:"cafeteriaID"`
	TagID       int64   `gorm:"column:tagID;foreignKey:DishNameTagOption;type:int;not null;" json:"tagID"`
	Average     float32 `gorm:"column:average;type:float;not null;" json:"average" `
	Min         int8    `gorm:"column:min;type:int;not null;" json:"min"`
	Max         int8    `gorm:"column:max;type:int;not null;" json:"max"`
	Std         float32 `gorm:"column:std;type:float;not null;" json:"std"`
}

type DishRating struct {
	DishRating int64     `gorm:"primary_key;AUTO_INCREMENT;column:dishRating;type:int;not null;" json:"dishRating"`
	Points     int32     `gorm:"column:points;type:int;not null;" json:"points"`
	DishID     int64     `gorm:"column:dishID;type:int;not null;" json:"dishID"`
	Dish       Dish      `gorm:"foreignKey:dishID;references:dish;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	Comment    string    `gorm:"column:comment;type:text;" json:"comment"`
	Timestamp  time.Time `gorm:"column:timestamp;type:timestamp;not null;" json:"timestamp"`
	Image      string    `gorm:"column:image;type:text;" json:"image"`
}

type DishRatingStatistic struct {
	CafeteriaID int64   `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;"`
	DishID      int64   `gorm:"column:dishID;foreignKey:dish;type:int;not null;"`
	Average     float64 `gorm:"column:average;type:float;not null;"`
	Min         int32   `gorm:"column:min;type:int;not null;"`
	Max         int32   `gorm:"column:max;type:int;not null;"`
	Std         float64 `gorm:"column:std;type:float;not null;"`
}

type DishRatingTag struct {
	DishRatingTag       int64 `gorm:"primary_key;AUTO_INCREMENT;column:dishRatingTag;type:int;not null;" json:"dishRatingTag"`
	CorrespondingRating int64 `gorm:"foreignKey:cafeteriaRating;column:parentRating;type:int;not null;" json:"parentRating"`
	Points              int32 `gorm:"column:points;type:int;not null;" json:"points"`
	TagID               int64 `gorm:"foreignKey:dishRatingTagOption;column:tagID;type:int;not null;" json:"tagID"`
}

type DishRatingTagOption struct {
	DishRatingTagOption int64  `gorm:"primary_key;AUTO_INCREMENT;column:dishRatingTagOption;type:int;not null;" json:"dishRatingTagOption"`
	DE                  string `gorm:"column:DE;type:text;default:de;not null;" json:"DE"`
	EN                  string `gorm:"column:EN;type:text;default:en;not null;" json:"EN"`
}

type DishRatingTagStatistic struct {
	CafeteriaID int64   `gorm:"column:cafeteriaID;foreignKey:cafeteria;type:int;not null;" json:"cafeteriaID"`
	TagID       int64   `gorm:"column:tagID;foreignKey:tagID;type:int;not null;" json:"tagID"`
	DishID      int64   `gorm:"column:dishID;foreignKey:dishID;type:int;not null;" json:"dishID"`
	Average     float32 `gorm:"column:average;type:float;not null;" json:"average" `
	Min         int8    `gorm:"column:min;type:int;not null;" json:"min"`
	Max         int8    `gorm:"column:max;type:int;not null;" json:"max"`
	Std         float32 `gorm:"column:std;type:float;not null;" json:"std"`
}

type DishToDishNameTag struct {
	DishToDishNameTag int64 `gorm:"primary_key;AUTO_INCREMENT;column:dishToDishNameTag;type:int;not null;" json:"dishToDishNameTag"`
	DishID            int64 `gorm:"column:dishID;foreignKey:dish;type:int;not null;" json:"dishID"`
	NameTagID         int64 `gorm:"foreignKey:dishNameTagOption;column:nameTagID;type:int;not null;" json:"nameTagID"`
}

type DishesOfTheWeek struct {
	DishesOfTheWeek int64 `gorm:"primary_key;AUTO_INCREMENT;column:dishesOfTheWeek;type:int;not null;" json:"dishesOfTheWeek"`
	Year            int32 `gorm:"column:year;type:int;not null;" json:"year"`
	Week            int32 `gorm:"column:week;type:int;not null;" json:"week"`
	Day             int32 `gorm:"column:day;type:int;not null;" json:"day"`
	DishID          int64 `gorm:"column:dishID;foreignKey:dish;type:int;not null;" json:"dishID"`
}

type Feedback struct {
	Id           int64       `gorm:"column:id;primary_key;AUTO_INCREMENT;type:int;not null;"`
	ImageCount   int32       `gorm:"column:image_count;type:int;not null;"`
	EmailId      string      `gorm:"column:email_id;type:text;not null"`
	Recipient    string      `gorm:"column:receiver;type:text;not null;uniqueIndex:receiver_reply_to_feedback_app_version_uindex"`
	ReplyToEmail null.String `gorm:"column:reply_to_email;type:text;null;uniqueIndex:receiver_reply_to_feedback_app_version_uindex"`
	ReplyToName  null.String `gorm:"column:reply_to_name;type:text;null"`
	Feedback     string      `gorm:"column:feedback;type:text;not null;uniqueIndex:receiver_reply_to_feedback_app_version_uindex"`
	Latitude     null.Float  `gorm:"column:latitude;type:float;null;"`
	Longitude    null.Float  `gorm:"column:longitude;type:float;null;"`
	OsVersion    null.String `gorm:"column:os_version;type:text;null;"`
	AppVersion   null.String `gorm:"column:app_version;type:text;null;uniqueIndex:receiver_reply_to_feedback_app_version_uindex"`
	Processed    bool        `gorm:"column:processed;type:boolean;default:false;not null;"`
	Timestamp    null.Time   `gorm:"column:timestamp;type:timestamp;default:CURRENT_TIMESTAMP;null;"`
}

type File struct {
	File       int64       `gorm:"primary_key;AUTO_INCREMENT;column:file;type:int;" json:"file"`
	Name       string      `gorm:"column:name;type:text;size:16777215;" json:"name"`
	Path       string      `gorm:"column:path;type:text;size:16777215;" json:"path"`
	Downloads  int32       `gorm:"column:downloads;type:int;default:0;" json:"downloads"`
	URL        null.String `gorm:"column:url;default:null;" json:"url"`                         // URL of the files source (if any)
	Downloaded null.Bool   `gorm:"column:downloaded;type:boolean;default:1;" json:"downloaded"` // true when file is ready to be served, false when still being downloaded
}

type Kino struct {
	Id          int64       `gorm:"primary_key;AUTO_INCREMENT;column:kino;type:int;not null;"`
	Date        time.Time   `gorm:"column:date;type:datetime;not null;"`
	Created     time.Time   `gorm:"column:created;type:timestamp;not null;default:CURRENT_TIMESTAMP"`
	Title       string      `gorm:"column:title;type:text;not null;"`
	Year        null.String `gorm:"column:year;type:varchar(4)"`
	Runtime     null.String `gorm:"column:runtime;type:varchar(40)"`
	Genre       null.String `gorm:"column:genre;type:varchar(100)"`
	Director    null.String `gorm:"column:director;type:text"`
	Actors      null.String `gorm:"column:actors;type:text"`
	ImdbRating  null.String `gorm:"column:rating;type:varchar(4)"`
	Description string      `gorm:"column:description;type:text;not null;"`
	Trailer     null.String `gorm:"column:trailer"`
	FileID      int64       `gorm:"column:cover"`
	File        File        `gorm:"foreignKey:FileID;references:file"`
	Link        string      `gorm:"column:link;type:varchar(190);not null;unique;"`
	Location    null.String `gorm:"column:location;default:null"`
}

type NewExamResultsSubscriber struct {
	CallbackUrl    string      `gorm:"primary_key" json:"callbackUrl"`
	ApiKey         null.String `json:"-"`
	CreatedAt      time.Time   `gorm:"autoCreateTime" json:"createdAt"`
	LastNotifiedAt null.Time   `json:"lastNotifiedAt"`
}

type News struct {
	News         int64       `gorm:"primary_key;AUTO_INCREMENT;column:news;type:int;"`
	Date         time.Time   `gorm:"column:date;type:datetime;"`
	Created      time.Time   `gorm:"column:created;type:timestamp;default:CURRENT_TIMESTAMP;"`
	Title        string      `gorm:"column:title;type:text;size:255;"`
	Description  string      `gorm:"column:description;type:text;size:65535;"`
	NewsSourceID int64       `gorm:"column:src;type:int;"`
	NewsSource   NewsSource  `gorm:"foreignKey:NewsSourceID;references:source;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	Link         string      `gorm:"column:link;type:varchar(190);"`
	Image        null.String `gorm:"column:image;type:text;size:65535;"`
	FileID       null.Int    `gorm:"column:file;type:int;"`
	File         *File       `gorm:"foreignKey:FileID;references:file;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type NewsAlert struct {
	NewsAlert int64       `gorm:"primary_key;AUTO_INCREMENT;column:news_alert;type:int;" json:"news_alert"`
	FileID    int64       `gorm:"column:file;not null"`
	File      File        `gorm:"foreignKey:FileID;references:file;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	Name      null.String `gorm:"column:name;type:varchar(100);" json:"name"`
	Link      null.String `gorm:"column:link;type:text;size:65535;" json:"link"`
	Created   time.Time   `gorm:"column:created;type:timestamp;default:CURRENT_TIMESTAMP;" json:"created"`
	From      time.Time   `gorm:"column:from;type:datetime;default:CURRENT_TIMESTAMP;" json:"from"`
	To        time.Time   `gorm:"column:to;type:datetime;default:CURRENT_TIMESTAMP;" json:"to"`
}

type NewsSource struct {
	Source int64       `gorm:"primary_key;AUTO_INCREMENT;column:source;type:int;"`
	Title  string      `gorm:"column:title;type:text;size:16777215;"`
	URL    null.String `gorm:"column:url;type:text;size:16777215;"`
	FileID int64       `gorm:"column:icon;not null;type:int;"`
	File   File        `gorm:"foreignKey:FileID;references:file;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	Hook   null.String `gorm:"column:hook;type:char;size:12;"`
}

type Notification struct {
	Notification int64       `gorm:"primary_key;AUTO_INCREMENT;column:notification;type:int;" json:"notification"`
	Type         int32       `gorm:"column:type;type:int;" json:"type"`
	Location     null.Int    `gorm:"column:location;type:int;" json:"location"`
	Title        string      `gorm:"column:title;type:text;size:65535;" json:"title"`
	Description  string      `gorm:"column:description;type:text;size:65535;" json:"description"`
	Created      time.Time   `gorm:"column:created;type:timestamp;default:CURRENT_TIMESTAMP;" json:"created"`
	Signature    null.String `gorm:"column:signature;type:text;size:65535;" json:"signature"`
	Silent       int32       `gorm:"column:silent;type:tinyint;default:0;" json:"silent"`
}

type NotificationConfirmation struct {
	Notification int64     `gorm:"primary_key;column:notification;type:int;" json:"notification"`
	Device       int64     `gorm:"primary_key;column:device;type:int;" json:"device"`
	Sent         int32     `gorm:"column:sent;type:tinyint;default:0;" json:"sent"`
	Created      time.Time `gorm:"column:created;type:timestamp;default:CURRENT_TIMESTAMP;" json:"created"`
	Received     null.Time `gorm:"column:received;type:timestamp;" json:"received"`
}

type NotificationType struct {
	Type         int64  `gorm:"primary_key;AUTO_INCREMENT;column:type;type:int;" json:"type"`
	Name         string `gorm:"column:name;type:text;size:65535;" json:"name"`
	Confirmation string `gorm:"column:confirmation;type:enum('true', 'false');default:'false';" json:"confirmation"`
}

type UpdateNote struct {
	VersionCode int64  `gorm:"primary_key;AUTO_INCREMENT;column:version_code;type:int;"`
	VersionName string `gorm:"column:version_name;type:text;"`
	Message     string `gorm:"column:message;type:text;"`
}