model

type Actor struct {
	ActorId    int          `gorm:"primaryKey" json:"actor_id"`
	FirstName  string       `json:"firt_name,omitempty"`
	LastName   string       `json:"last_name,omitempty"`
	FilmsActor []*FilmActor `json:"-"`
	Films      []*Film      `gorm:"-" json:"films,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Address struct {
	AddressId  int     `grom:"primaryKey" json:"address_id,omitempty"`
	Address    string  `json:"address,omitempty"`
	Address2   string  `json:"address2,omitempty"`
	District   string  `json:"district,omitempty"`
	CityId     int     `json:"-"`
	City       *Cities `gorm:"foreignKey:CityId;references:CityId" json:"city,omitempty"`
	PostalCode string  `json:"postal_code,omitempty"`
	Phone      string  `json:"phone,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Category struct {
	CategoryId int    `gorm:"primaryKey"`
	Name       string `gorm:"type:varchar(25)"`
	LastUpdate time.Time
}

type Cities struct {
	CityId    int        `gorm:"primaryKey" json:"city_id"`
	City      string     `json:"city,omitempty"`
	CountryId int        `json:"-"`
	Country   *Countries `gorm:"foreignKey:CountryId;references:CountryId" json:"country,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Countries struct {
	CountryId int      `gorm:"primaryKey" json:"country_id"`
	Country   string   `json:"country,omitempty"`
	CityId    int      `json:"-"`
	City      []Cities `gorm:"foreignKey:CityId;references:CityId" json:"city,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Customer struct {
	CustomerId int `gorm:"primaryKey"`

	LastUpdate time.Time
}

type Film struct {
	FilmId             int             `gorm:"primaryKey" json:"id"`
	Title              string          `json:"title"`
	Description        string          `json:"description,omitempty"`
	ReleaseYear        Year            `json:"release_year,omitempty"`
	LanguageId         int             `json:"-"`
	Language           *Languages      `gorm:"foreignKey:LanguageId;references:LanguageId" json:"laguage,omitempty"`
	OriginalLanguageId int             `json:"-"`
	OriginalLanguage   *Languages      `gorm:"foreignKey:OriginalLanguageId;references:LanguageId" json:"original_laguage,omitempty"`
	RentalDuration     int             `json:"rental_duration"`
	RentalRate         decimal.Decimal `json:"rental_rate"`
	Length             int             `json:"length,omitempty"`
	ReplacementCost    decimal.Decimal `json:"replacement_cost"`
	Rating             FilmRating      `json:"rating,omitempty"`
	SpecialFeatures    SpecialFeatures `json:"special_features,omitempty"`
	Actors             []*Actor        `gorm:"many2many:film_actor;joinForeignKey:film_id;" json:"actors,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type FilmActor struct {
	ActorId int
	Actor   []*Actor `gorm:"foreignKey:ActorId;references:ActorId"`
	FilmId  int
	Film    []*Film `gorm:"foreignKey:FilmId;references:FilmId"`

	LastUpdate time.Time
}

type FilmCategory struct {
	FilmId     int    `gorm:"primaryKey"`
	CategoryId string `gorm:"primaryKey"`
	LastUpdate time.Time
}

type FilmRating string

type FilmText struct {
	FilmId int `gorm:"primaryKey"`

	Title       string
	Description string
}

type Inventory struct {
	InventoryId int `gorm:"primaryKey"`

	Film  *Film
	Store *Store

	LastUpdate time.Time
}

type JSON json.RawMessage

type Languages struct {
	LanguageId int    `gorm:"primaryKey" json:"-"`
	Name       string `json:"name,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Location struct {
	X int `json:"x"`
	Y int `json:"y"`
}

type Payment struct {
	PaymentId int `gorm:"primaryKey"`

	Customer *Customer
	Staff    *Staff
	Rental   *Rental

	Amount      int
	PaymentDate time.Time

	LastUpdate time.Time
}

type Rental struct {
	RentalId int `gorm:"primaryKey"`

	RentalDate time.Time
	ReturnDate time.Time

	Customer *Customer
	Staff    *Staff

	LastUpdate time.Time
}

type SpecialFeatures string

type Staff struct {
	StaffId   int      `gorm:"primaryKey" json:"staff_id"`
	FirstName string   `json:"first_name,omitempty"`
	LastName  string   `json:"last_name,omitempty"`
	AddressId int      `json:"address_id,omitempty"`
	Address   *Address `gorm:"foreignKey:AddressId;references:AddressId" json:"address,omitempty"`
	StoreId   int      `json:"-"`
	Store     *Store   `gorm:"foreignKey:StoreId;references:StoreId"`
	Email     string   `json:"email,omitempty"`
	Active    int      `json:"active,omitempty"`
	Username  string   `json:"username,omitempty"`
	Password  string   `json:"-"`
	Picture   []byte   `json:"-"`

	LastUpdate time.Time `json:"-"`
}

type Store struct {
	StoreId        int      `gorm:"primaryKey" json:"store_id"`
	ManagerStaffId int      `json:"-"`
	ManagerStaff   *Staff   `gorm:"foreignKey:ManagerStaffId;references:StaffId" json:"manger_staff,omitempty"`
	AddressId      int      `json:"-"`
	Address        *Address `gorm:"foreignKey:AddressId;references:AddressId" json:"address,omitempty"`

	LastUpdate time.Time `json:"-"`
}

type Year struct {
	// contains filtered or unexported fields
}