models

type BaseModel struct {
	Id int `gorm:"primarykey"`

	CreatedAt  time.Time    `gorm:"type:TIMESTAMP with time zone;not null"`
	ModifiedAt sql.NullTime `gorm:"type:TIMESTAMP with time zone;null"`
	DeletedAt  sql.NullTime `gorm:"type:TIMESTAMP with time zone;null"`

	CreatedBy  int            `gorm:"not null"`
	ModifiedBy *sql.NullInt64 `gorm:"null"`
	DeletedBy  *sql.NullInt64 `gorm:"null"`
}

type BaseTable struct {
	Id   int    `gorm:"primarykey"`
	Name string `gorm:"not null"`
}

type Brands struct {
	BaseModel
	BaseTable
}

type Categories struct {
	BaseModel
	BaseTable
}

type Colors struct {
	BaseModel
	BaseTable
}

type Materials struct {
	BaseModel
	BaseTable
}

type Products struct {
	BaseModel
	BaseTable
	CategoryID int
	BrandID    int
	SizeID     int
	ColorID    int
	MaterialID int
	Price      float64

	Category Categories `gorm:"foreignKey:CategoryID"`
	Brand    Brands     `gorm:"foreignKey:BrandID"`
	Size     Sizes      `gorm:"foreignKey:SizeID"`
	Color    Colors     `gorm:"foreignKey:ColorID"`
	Material Materials  `gorm:"foreignKey:MaterialID"`
}

type Sizes struct {
	BaseModel
	BaseTable
}