postgres

type Area struct {
	Id           string `pg:"type:uuid"`
	CurriculumId string `pg:"type:uuid,on_delete:CASCADE"`
	Curriculum   Curriculum
	Name         string
	Subjects     []Subject `pg:"fk:area_id"`
}

type AuthStore struct {
	DB *pg.DB
}

type Class struct {
	Id       string `pg:"type:uuid"`
	SchoolId string `pg:"type:uuid,on_delete:CASCADE"`
	School   School
	Name     string
	// Only use the time of day and timezone (WIB 8.30AM).
	// Ignore other data
	StartTime time.Time `pg:",notnull"`
	EndTime   time.Time `pg:",notnull"`
	Weekdays  []Weekday
	Students  []Student `pg:"many2many:student_to_class,joinFK:class_id"`
}

type ClassStore struct {
	DB *pg.DB
}

type Curriculum struct {
	Id      string `pg:"type:uuid"`
	Name    string
	Areas   []Area `pg:"fk:curriculum_id"`
	Schools []School
}

type CurriculumStore struct {
	*pg.DB
}

type EmptyCurriculumError struct{}

type Gender int

type Guardian struct {
	Id       string `pg:"type:uuid"`
	Name     string `pg:",notnull"`
	Email    string
	Phone    string
	Note     string
	SchoolId string `pg:"type:uuid"`
	School   School
	Children []Student `pg:"many2many:guardian_to_student,joinFK:guardian_id"`
}

type GuardianRelationship int

type GuardianStore struct {
	*pg.DB
}

type GuardianToStudent struct {
	StudentId    string `pg:"type:uuid,on_delete:CASCADE"`
	Student      Student
	GuardianId   string `pg:"type:uuid,on_delete:CASCADE"`
	Guardian     Guardian
	Relationship GuardianRelationship `pg:"type:int"`
}

type Material struct {
	Id        string `pg:"type:uuid"`
	SubjectId string `pg:"type:uuid,on_delete:CASCADE"`
	Subject   Subject
	Name      string
	Order     int `pg:",use_zero"`
}

type Observation struct {
	Id          string `json:"id" pg:",type:uuid"`
	StudentId   string `pg:",type:uuid,on_delete:CASCADE"`
	Student     *Student
	ShortDesc   string    `json:"shortDesc"`
	LongDesc    string    `json:"longDesc"`
	CategoryId  string    `json:"categoryId"`
	CreatedDate time.Time `json:"createdDate"`
	EventTime   *time.Time
	CreatorId   string `pg:",type:uuid,on_delete:SET NULL"`
	Creator     *User
}

type ObservationStore struct {
	*pg.DB
}

type PasswordResetToken struct {
	Token     string    `pg:",pk,type:uuid"`
	CreatedAt time.Time `pg:",notnull"`
	ExpiredAt time.Time `pg:",notnull"`
	UserId    string    `pg:",type:uuid,on_delete:CASCADE,notnull"`
	User      User
}

type School struct {
	Id           string `json:"id" pg:",type:uuid"`
	Name         string `json:"name"`
	InviteCode   string `json:"inviteCode"`
	Users        []User `pg:"many2many:user_to_schools,joinFK:user_id"`
	CurriculumId string `pg:",type:uuid,on_delete:SET NULL"`
	Curriculum   Curriculum
	Guardian     []Guardian
}

type SchoolStore struct {
	*pg.DB
}

type Session struct {
	Token  string `pg:",pk" pg:",type:uuid"`
	UserId string
}

type Student struct {
	Id          string `json:"id" pg:",type:uuid"`
	Name        string `json:"name"`
	SchoolId    string `pg:"type:uuid,on_delete:CASCADE"`
	School      School
	DateOfBirth *time.Time
	Classes     []Class `pg:"many2many:student_to_class,joinFK:student_id"`
	Gender      Gender  `pg:"type:int"`
	DateOfEntry *time.Time
	Note        string
	CustomId    string
	Active      bool
	ProfilePic  string
	Guardians   []Guardian `pg:"many2many:guardian_to_student,joinFK:student_id"`
}

type StudentMaterialProgress struct {
	MaterialId string `pg:",pk,type:uuid,on_delete:CASCADE"`
	Material   Material
	StudentId  string `pg:",pk,type:uuid,on_delete:CASCADE"`
	Student    Student
	Stage      int
	UpdatedAt  time.Time
}

type StudentStore struct {
	*pg.DB
}

type StudentToClass struct {
	StudentId string `pg:"type:uuid,on_delete:CASCADE"`
	Student   Student
	ClassId   string `pg:"type:uuid,on_delete:CASCADE"`
	Class     Class
}

type Subject struct {
	Id        string `pg:"type:uuid"`
	AreaId    string `pg:"type:uuid,on_delete:CASCADE"`
	Area      Area
	Name      string
	Materials []Material `pg:"fk:subject_id"`
	Order     int        `pg:",use_zero"`
}

type User struct {
	Id       string `json:"id" pg:",type:uuid"`
	Email    string `pg:",unique"`
	Name     string
	Password []byte
	Schools  []School `pg:"many2many:user_to_schools,joinFK:school_id"`
}

type UserStore struct {
	*pg.DB
}

type UserToSchool struct {
	SchoolId string `pg:",type:uuid"`
	School   School
	UserId   string `pg:",type:uuid"`
	User     User
}

type Weekday struct {
	ClassId string       `pg:",pk,type:uuid,on_delete:CASCADE"`
	Day     time.Weekday `pg:",pk,use_zero"`
	Class   Class
}