entities

type Business struct {
	ID            uuid.UUID      `gorm:"type:uuid;"`
	Name          string         `gorm:"not null;"`
	Description   string         `gorm:"not null;"`
	Type          string         `gorm:"not null;"`
	Level         string         `gorm:"not null;"`
	Founded       time.Time      `gorm:"not null;"`
	Growths       []Growth       `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	ContactPerson Contact        `gorm:"type:jsonb;"`
	Entrepreneurs []Entrepreneur `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	CreatedAt     time.Time      `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt     time.Time      `gorm:"default:CURRENT_TIMESTAMP"`
}

type Contact struct {
	Name  string `json:"name"`
	Phone string `json:"phone"`
}

type Entrepreneur struct {
	ID         uuid.UUID `gorm:"type:uuid;"`
	Forename   string    `gorm:"not null;"`
	Surname    string    `gorm:"not null;"`
	Gender     string    `gorm:"not null;"`
	BirthDate  time.Time `gorm:"not null;"`
	Phone      string    `gorm:"not null;"`
	Email      string    `gorm:"not null;"`
	BusinessID string    `gorm:"default:null;"`
	Business   Business
	CreatedAt  time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt  time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Event struct {
	ID            uuid.UUID `gorm:"type:uuid;"`
	Name          string    `gorm:"not null;"`
	Description   string    `gorm:"not null;"`
	StartDate     time.Time `gorm:"not null;"`
	EndDate       time.Time `gorm:"not null;"`
	InstitutionID string    `gorm:"not null;"`
	Institution   Institution
	Trainees      []Trainee `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	Teams         []Team    `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	Rewards       []Reward  `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	CreatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Growth struct {
	ID          uuid.UUID `gorm:"type:uuid;"`
	Year        int64     `gorm:"not null;"`
	NetWorth    float64   `gorm:"not null;"`
	Income      float64   `gorm:"not null;"`
	Expenditure float64   `gorm:"not null;"`
	Assets      string    `gorm:"default:null;"`
	BusinessID  string    `gorm:"not null;"`
	Business    Business
	CreatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Institution struct {
	ID            uuid.UUID `gorm:"type:uuid;"`
	Name          string    `gorm:"not null;"`
	Description   string    `gorm:"default:null;"`
	Address       string    `gorm:"not null;"`
	ContactPerson Contact   `gorm:"type:jsonb;"`
	CreatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Reward struct {
	ID          uuid.UUID `gorm:"type:uuid;"`
	Name        string    `gorm:"not null;"`
	Description string    `gorm:"default:null;"`
	EventID     string    `gorm:"not null;"`
	Event       Event
	Position    int       `gorm:"not null;"`
	CreatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Solution struct {
	ID          uuid.UUID `gorm:"type:uuid;"`
	Title       string    `gorm:"not null;"`
	Description string    `gorm:"default:null;"`
	EventID     string    `gorm:"not null;"`
	Event       Event
	TeamID      string `gorm:"not null;"`
	Team        Team
	RewardID    string `gorm:"default:null;"`
	Reward      Reward
	Position    int       `gorm:"default:0"`
	CreatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Team struct {
	ID          uuid.UUID `gorm:"type:uuid;"`
	Name        string    `gorm:"not null;"`
	Description string    `gorm:"default:null;"`
	EventID     string    `gorm:"not null;"`
	Event       Event
	Trainees    []Trainee `gorm:"constraint:OnUpdate:CASCADE,OnDelete:SET NULL;"`
	CreatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Trainee struct {
	ID            uuid.UUID `gorm:"type:uuid;"`
	Forename      string    `gorm:"not null;"`
	Surname       string    `gorm:"not null;"`
	Gender        string    `gorm:"not null;"`
	BirthDate     time.Time `gorm:"not null;"`
	Phone         string    `gorm:"not null;"`
	Email         string    `gorm:"not null;"`
	Qualification string    `gorm:"default:null;"`
	EventID       string    `gorm:"not null;"`
	Event         Event
	TeamID        string `gorm:"default:null;"`
	Team          Team
	CreatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt     time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type User struct {
	ID           uuid.UUID `gorm:"type:uuid;" json:"id"`
	FirstName    string    `gorm:"size:100;not null;"`
	LastName     string    `gorm:"size:100;not null;"`
	Phone        string    `gorm:"size:100;not null;unique;"`
	Password     string    `gorm:"size:100;"`
	BasePassword string    `gorm:"size:100;"`
	Status       string    `gorm:"size:100;"`
	Role         string    `gorm:"not null;"`
	CreatedAt    time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt    time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}