model

type Activity struct {
	gorm.Model
	Type        ActivityType `gorm:"size:50;not null;"`
	CampID      uint         `gorm:"not null"`
	Camp        *Camp        `gorm:"foreignKey:CampID;references:ID;constraint:OnDelete:CASCADE"`
	UserID      *string      `gorm:"size:32"` // payment_* のみ使用
	User        *User        `gorm:"foreignKey:UserID;references:ID"`
	ReferenceID uint         `gorm:"not null"` // RoomID / PaymentID / RollCallID / QuestionGroupID
	Amount      *int         // payment_* のみ使用
}

type ActivityType string

type Answer struct {
	gorm.Model
	QuestionID        uint         `gorm:"uniqueIndex:idx_question_id_user_id"`
	UserID            string       `gorm:"uniqueIndex:idx_question_id_user_id"`
	Type              QuestionType `gorm:"type:enum('free_text', 'free_number', 'single', 'multiple')"`
	FreeTextContent   *string
	FreeNumberContent *float64
	SelectedOptions   []Option `gorm:"many2many:answer_options;ForeignKey:id;References:id"`
}

type Camp struct {
	gorm.Model
	DisplayID          string
	Name               string
	Guidebook          string
	IsDraft            bool
	IsPaymentOpen      bool
	IsRegistrationOpen bool
	DateStart          time.Time
	DateEnd            time.Time

	Participants   []User `gorm:"many2many:camp_participants;"`
	Payments       []Payment
	Events         []Event
	QuestionGroups []QuestionGroup
	RollCalls      []RollCall
	RoomGroups     []RoomGroup
	Images         []Image
}

type Event struct {
	gorm.Model
	Type         EventType `gorm:"type:enum('duration', 'moment', 'official')"`
	Name         string
	Description  string
	Location     string
	TimeStart    time.Time // MomentEventのtimeもTimeStartとして扱う
	TimeEnd      *time.Time
	OrganizerID  *string
	DisplayColor *string

	CampID uint
}

type EventType string

type Image struct {
	gorm.Model

	CampID uint
}

type Message struct {
	gorm.Model
	TargetUserID string
	Content      string
	SendAt       time.Time
	SentAt       *time.Time // 送信時刻。nilの場合は未送信
}

type Option struct {
	gorm.Model
	QuestionID uint
	Content    string
}

type Payment struct {
	gorm.Model
	Amount     int
	AmountPaid int
	UserID     string

	CampID uint
}

type Question struct {
	gorm.Model
	Type            QuestionType `gorm:"type:enum('free_text', 'free_number', 'single', 'multiple')"`
	QuestionGroupID uint
	Title           string
	Description     *string
	IsPublic        bool
	IsOpen          bool
	IsRequired      bool `gorm:"not null;default:false"`
	Options         []Option

	Answers []Answer
}

type QuestionGroup struct {
	gorm.Model
	Name        string
	Description *string
	Due         time.Time
	Questions   []Question

	CampID uint
}

type QuestionType string

type RollCall struct {
	gorm.Model
	Name        string
	Description string
	Options     []string `gorm:"serializer:json"`
	Subjects    []User   `gorm:"many2many:roll_call_subjects;"`

	Reactions []RollCallReaction

	CampID uint `gorm:"not null"`
}

type RollCallReaction struct {
	gorm.Model
	Content string
	UserID  string

	RollCallID uint `gorm:"index"`
}

type Room struct {
	gorm.Model
	Name    string
	Members []User     `gorm:"many2many:room_members"`
	Status  RoomStatus `gorm:"constraint:OnDelete:CASCADE"`

	RoomGroupID uint
}

type RoomGroup struct {
	gorm.Model
	Name  string
	Rooms []Room

	CampID uint
}

type RoomStatus struct {
	gorm.Model
	RoomID uint    `gorm:"not null;uniqueIndex"`
	Room   *Room   `gorm:"foreignKey:RoomID;references:ID;constraint:OnDelete:CASCADE"`
	Type   *string `gorm:"size:8"`
	Topic  string  `gorm:"not null;size:64"`
}

type RoomStatusLog struct {
	gorm.Model
	RoomID     uint    `gorm:"not null"`
	Room       *Room   `gorm:"foreignKey:RoomID;references:ID;constraint:OnDelete:CASCADE"`
	Type       *string `gorm:"size:8"`
	Topic      string  `gorm:"not null;size:64"`
	OperatorID string  `gorm:"not null;size:32"`
	Operator   *User   `gorm:"foreignKey:OperatorID;references:ID;constraint:OnDelete:RESTRICT"`
}

type User struct {
	ID        string `gorm:"primaryKey;size:32"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`
	IsStaff   bool           `gorm:"index"`

	Answers         []Answer
	Payments        []Payment
	OrganizedEvents []Event   `gorm:"foreignKey:OrganizerID"`
	TargetMessages  []Message `gorm:"foreignKey:TargetUserID"`
}