models

type CatalogItemModel struct {
	Id                uuid.UUID                 `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	ItemName          string                    `gorm:"column:item_name;type:varchar(255);not null;unique"`
	Description       string                    `gorm:"column:description;type:varchar(255);not null"`
	Reference         string                    `gorm:"column:reference;type:varchar(255);not null;unique"`
	Sku               string                    `gorm:"column:sku;type:varchar(20);not null;unique"`
	SupplierItemName  string                    `gorm:"column:supplier_item_name;type:varchar(255);not null;unique"`
	SupplierItemCode  string                    `gorm:"column:supplier_item_code;type:varchar(50);not null;unique"`
	MultiLangValues   []schemas.MultiLangSchema `gorm:"column:multi_lang_values;type:jsonb;default:'[]'"`
	MultiLangIsActive bool                      `gorm:"column:multi_lang_is_active;type:bool;not null;default:false"`
	BrandId           uuid.UUID                 `gorm:"column:brand_id;type;primaryKey"`
	CategoryId        uuid.UUID                 `gorm:"column:category_id;type;primaryKey"`
	SupplierId        uuid.UUID                 `gorm:"column:supplier_id;type;primaryKey"`
	IsActive          bool                      `gorm:"column:is_active;type:bool;not null;default:true"`
	CreatedAt         int64                     `gorm:"column:created_at;type:bigint;not null;"`
	UpdatedAt         int64                     `gorm:"column:updated_at;type:bigint;null;default:0"`
	Locations         []ItemHasLocationModel    `gorm:"foreignKey:item_id"`
	Files             []ItemHasFileModel        `gorm:"foreignKey:item_id"`
}

type CategoryModel struct {
	Id                uuid.UUID                 `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	CategoryName      string                    `gorm:"column:category_name;type:varchar(100);not null;unique"`
	Nomeclature       string                    `gorm:"column:nomeclature;type:varchar(10);not null;unique"`
	ParentId          sql.NullString            `gorm:"column:parent_id;type:uuid;null"`
	MultiLangValues   []schemas.MultiLangSchema `gorm:"column:multi_lang_values;type:jsonb;default:'[]'"`
	MultiLangIsActive bool                      `gorm:"column:multi_lang_is_active;type:bool;not null;default:false"`
	IsActive          bool                      `gorm:"column:is_active;type:bool;not null;default:true"`
	CreatedAt         int64                     `gorm:"column:created_at;type:bigint;not null;"`
	UpdatedAt         int64                     `gorm:"column:updated_at;type:bigint;null;default:0"`
	Items             []CatalogItemModel        `gorm:"foreignKey:category_id"`
}

type FileModel struct {
	Id       uuid.UUID          `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	FileType string             `gorm:"column:filetype;type:varchar(10);not null"`
	FileSize int32              `gorm:"column:filesize;type:bigint;not null"`
	Binary   []byte             `gorm:"column:binary;type:bytea;not null"`
	Items    []ItemHasFileModel `gorm:"foreignKey:file_id"`
}

type ItemBrandModel struct {
	Id        uuid.UUID          `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	BrandName string             `gorm:"column:brand_name;type:varchar(100);not null;unique"`
	IsActive  bool               `gorm:"column:is_active;type:bool;not null;default:true"`
	CreatedAt int64              `gorm:"column:created_at;type:bigint;not null;"`
	UpdatedAt int64              `gorm:"column:updated_at;type:bigint;null;default:0"`
	Items     []CatalogItemModel `gorm:"foreignKey:brand_id"`
}

type ItemHasFileModel struct {
	ItemId     uuid.UUID `gorm:"column:item_id;type;primaryKey"`
	LocationId uuid.UUID `gorm:"column:file_id;type;primaryKey"`
}

type ItemHasLocationModel struct {
	ItemId     uuid.UUID `gorm:"column:item_id;type;primaryKey"`
	LocationId uuid.UUID `gorm:"column:location_id;type;primaryKey"`
}

type LocationTypeModel struct {
	Id              uuid.UUID                 `gorm:"primaryKey;column:id;type:varchar(36);unique"`
	Name            string                    `gorm:"column:name;type:varchar(255);not null;unique"`
	SupplierCode    string                    `gorm:"column:supplier_code;type:varchar(10);not null;unique"`
	MultiLangValues []schemas.MultiLangSchema `gorm:"column:multi_lang_values;type:jsonb;default:'[]'"`
	Rules           pgtype.JSONB              `gorm:"column:rules;type:jsonb;default:'[]'"`
	Locations       []StorageLocationModel    `gorm:"foreignKey:location_type_id"`
}

type StorageLocationModel struct {
	Id             uuid.UUID              `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	LocatioName    string                 `gorm:"column:location_name;type:varchar(100);not null;unique"`
	Nomeclature    string                 `gorm:"column:nomeclature;type:varchar(10);not null;unique"`
	ParentId       sql.NullString         `gorm:"column:parent_id;type:uuid;null"`
	HasAccounting  bool                   `gorm:"column:has_accounting;type:bool;not null;default:true"`
	IsActive       bool                   `gorm:"column:is_active;type:bool;not null;default:true"`
	CreatedAt      int64                  `gorm:"column:created_at;type:bigint;not null;"`
	UpdatedAt      int64                  `gorm:"column:updated_at;type:bigint;null;default:0"`
	LocationTypeId uuid.UUID              `gorm:"column:location_type_id;type;primaryKey"`
	Items          []ItemHasLocationModel `gorm:"foreignKey:location_id"`
}

type SupplierModel struct {
	Id           uuid.UUID          `gorm:"primaryKey;column:id;type:uuid;unique;default:gen_random_uuid()"`
	SupplierName string             `gorm:"column:supplier_name;type:varchar(255);not null;unique"`
	SupplierCode string             `gorm:"column:supplier_code;type:varchar(10);not null;unique"`
	IsActive     bool               `gorm:"column:is_active;type:bool;not null;default:true"`
	CreatedAt    int64              `gorm:"column:created_at;type:bigint;not null;"`
	UpdatedAt    int64              `gorm:"column:updated_at;type:bigint;null;default:0"`
	Items        []CatalogItemModel `gorm:"foreignKey:supplier_id"`
}