product

type Order struct {
	Metadata    metadata.Metadata `picard:"tablename=orders"`
	ID          string            `picard:"primary_key,column=id"`
	StoreID     string            `picard:"multitenancy_key,column=store_id"`
	ProductID   string            `picard:"foreign_key,required,related=Product,column=product_id"`
	Product     Product
	Quantity    int       `picard:"column=quantity"`
	CustomerID  string    `picard:"column=customer_id"`
	CreatedDate time.Time `picard:"column=created_at,audit=created_at"`
	UpdatedDate time.Time `picard:"column=updated_at,audit=updated_at"`
}

type Product struct {
	Metadata metadata.Metadata `picard:"tablename=products"`
	ID       string            `picard:"primary_key,column=id"`
	StoreID  string            `picard:"multitenancy_key,column=store_id"`
	Name     string            `picard:"column=username"`
	Price    float64           `picard:"column=price"`
	Orders   []Order           `picard:"child,foreign_key=ProductID"`

	CreatedByID string    `picard:"column=created_by_id,audit=created_by"`
	UpdatedByID string    `picard:"column=updated_by_id,audit=updated_by"`
	CreatedDate time.Time `picard:"column=created_at,audit=created_at"`
	UpdatedDate time.Time `picard:"column=updated_at,audit=updated_at"`
}