db

type Database struct {
	SchoolServerDB *gorm.DB
	Logger         *log.Logger
}

type Day struct {
	gorm.Model
	StudentID uint     // parent id
	Date      string   `sql:"size:255"`
	Tasks     []Task   // has-many relation
	Lessons   []Lesson // has-many relation
}

type Device struct {
	gorm.Model
	UserID                uint       // parent id
	SystemType            int        // android/ios
	Token                 string     // unique device token (FCM)
	DoNotDisturbUntil     *time.Time // для push
	MarksNotification     int        `sql:"DEFAULT:1"`
	TasksNotification     int        `sql:"DEFAULT:1"`
	ReportsNotification   bool       `sql:"DEFAULT:true"`
	ScheduleNotification  bool       `sql:"DEFAULT:true"`
	MailNotification      bool       `sql:"DEFAULT:true"`
	ForumNotification     bool       `sql:"DEFAULT:true"`
	ResourcesNotification bool       `sql:"DEFAULT:true"`
	JustRegistered        bool       `sql:"DEFAULT:true"` // for not to ddos with pushes at first login
}

type ForumPost struct {
	gorm.Model
	ForumTopicID uint // parent id
	Date         string
	Author       string
	Message      string
	Unread       bool
}

type ForumTopic struct {
	gorm.Model
	UserID      uint // parent id
	NetschoolID int
	Date        string
	Creator     string
	Title       string
	Unread      bool
	Answers     int
	Posts       []ForumPost // has-many relation
}

type Lesson struct {
	gorm.Model
	DayID     uint // parent id
	Begin     string
	End       string
	Name      string
	Classroom string
}

type Letter struct {
	Date   string `json:"date"`
	ID     int    `json:"id"`
	Author string `json:"author"`
	Topic  string `json:"topic"`
	Unread bool   `json:"unread"`
}

type MailMessage struct {
	gorm.Model
	UserID      uint //  parent id
	NetschoolID int
	Date        string
	Author      string
	Topic       string
	Section     int
	Unread      bool
}

type Post struct {
	gorm.Model
	UserID   uint // parent id
	Unread   bool
	Author   string
	Title    string
	Date     string
	Message  string
	File     string
	FileName string
}

type Resource struct {
	gorm.Model
	OwnerID   uint   // parent id
	OwnerType string // parent polymorhic type
	Name      string
	Link      string
}

type ResourceGroup struct {
	gorm.Model
	SchoolID          uint // belongs-to relation
	Title             string
	Resources         []Resource         `gorm:"polymorphic:Owner;"`
	ResourceSubgroups []ResourceSubgroup // has-many relation
}

type ResourceSubgroup struct {
	gorm.Model
	ResourceGroupID uint
	Title           string
	Resources       []Resource `gorm:"polymorphic:Owner;"`
}

type School struct {
	gorm.Model
	Name       string `sql:"size:255;unique"`
	Type       int    // тип netschool'а
	Initials   string `sql:"size:255"`
	Address    string `sql:"size:255;unique"`
	Permission bool   `sql:"DEFAULT:true"`
	Users      []User // has-many relation
}

type Student struct {
	gorm.Model
	UserID      uint   // parent id
	Name        string `sql:"size:255"`
	NetSchoolID int    // id ученика в системе NetSchool
	ClassID     string // id класса, в котором учится ученик
	Days        []Day  // has-many relation
}

type Task struct {
	gorm.Model
	DayID  uint // parent id
	CID    int
	AID    int
	TP     int
	Status int // новое\просмотренное\выполненное
	InTime bool
	Name   string // название предмета
	Title  string // тема
	Type   string
	Mark   string
	Weight string
	Author string
}

type User struct {
	gorm.Model
	SchoolID     uint // parent id
	UID          int
	Login        string        `sql:"size:255;index"`
	Password     string        `sql:"size:255"`
	Permission   bool          `sql:"DEFAULT:false"`
	FirstName    string        `sql:"size:255"`
	LastName     string        `sql:"size:255"`
	TrueLogin    string        `sql:"size:255"`
	Role         string        `sql:"size:255"`
	Year         string        `sql:"size:255"`
	Students     []Student     // has-many relation
	Devices      []Device      // has-many relation
	ForumTopics  []ForumTopic  // has-many relation
	MailMessages []MailMessage // has-many relation
	Posts        []Post        // has-many realtion
}