psql

type Base struct {
	ID        *string    `gorm:"primaryKey;unique;column:id"`
	CreatedAt time.Time  `gorm:"column:created_at"`
	UpdatedAt time.Time  `gorm:"column:updated_at"`
	CreatedBy *string    `gorm:"column:created_by"`
	UpdatedBy *string    `gorm:"column:updated_by"`
	DeletedAt *time.Time `gorm:"column:deleted_at"`
	Active    bool       `gorm:"column:active"`
}

type BaseService struct {
	Base
	CommonModel

	BusinessProfile string     `json:"business_profile"`
	Services        []*Service `gorm:"ForeignKey:base_service;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type BusinessPartner struct {
	Base

	Name      string  `gorm:"column:name"`
	Logo      string  `gorm:"column:logo"`
	PartnerID *string `gorm:"column:partner_id"`
}

type BusinessProfile struct {
	Base

	Name           string `gorm:"column:name"`
	Logo           string `gorm:"column:logo"`
	Description    string `gorm:"column:description"`
	IntroStatement string `gorm:"column:intro_statement"`
	Mission        string `gorm:"column:mission"`
	Vision         string `gorm:"column:vision"`
	Slogan         string `gorm:"column:slogan"`
	PhoneNumber    string `gorm:"column:phone_number"`
	Email          string `gorm:"column:email"`
	Facebook       string `gorm:"column:facebook"`
	X              string `gorm:"column:x"`
	Instagram      string `gorm:"column:instagram"`
	TikTok         string `gorm:"column:tiktok"`
	WhatsApp       string `gorm:"column:whats_app"`
	LinkedIn       string `gorm:"column:linkedin"`
	PostalAddress  string `gorm:"column:postal_address"`
	City           string `gorm:"column:city"`
	Country        string `gorm:"column:country"`
	Building       string `gorm:"column:building"`
	FloorNumber    string `gorm:"column:floor_number"`

	Partner    *Partner     `gorm:"ForeignKey:business_profile;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	Services   *BaseService `gorm:"ForeignKey:business_profile;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	Commitment *Commitment  `gorm:"ForeignKey:business_profile;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type Commitment struct {
	Base
	CommonModel

	BusinessProfile string   `json:"business_profile"`
	WhyUs           []*WhyUs `gorm:"ForeignKey:commitment;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type CommonModel struct {
	Heading            string `gorm:"heading"`
	HeadingSupportText string `json:"heading_support_text" gorm:"heading_support_text"`
}

type Content struct {
	Base

	Title         string         `gorm:"column:title"`
	Description   string         `gorm:"column:description"`
	Body          string         `gorm:"column:body"`
	HeroImage     string         `gorm:"column:hero_image"`
	GalleryImages pq.StringArray `gorm:"type:text[];column:gallery_images"`
	Category      string         `gorm:"column:category"`
	Tags          pq.StringArray `gorm:"type:text[];column:tags"`
	ContentType   string         `gorm:"column:content_type"`
	Media         string         `gorm:"column:media"`
	Price         float64        `gorm:"column:price"`
	Story         *string        `gorm:"column:story_id"`
}

type PGInstance struct {
	DB *gorm.DB
}

type Partner struct {
	Base
	CommonModel

	BusinessProfile  string             `json:"business_profile"`
	BusinessPartners []*BusinessPartner `gorm:"ForeignKey:PartnerID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type Service struct {
	Base

	Title       string  `gorm:"title"`
	Description string  `gorm:"description"`
	BaseService *string `gorm:"base_service"`
}

type Story struct {
	Base
	CommonModel

	BusinessProfile string     `json:"business_profile"`
	Content         []*Content `gorm:"ForeignKey:story_id;constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type Update interface {
}

type User struct {
	Base

	Username  string `gorm:"column:username"`
	FirstName string `gorm:"column:first_name"`
	LastName  string `gorm:"column:last_name"`
	Email     string `gorm:"column:email"`
	UserType  string `gorm:"column:user_type"`
}

type UserCredentials struct {
	Base

	ValidFrom time.Time `gorm:"column:valid_from"`
	ValidTo   time.Time `gorm:"column:valid_to"`
	HashedPin string    `gorm:"column:hashed_pin"`
	Salt      string    `gorm:"column:salt"`
	UserID    *string   `gorm:"column:user_id"`
}

type WhyUs struct {
	Base

	Title       string  `gorm:"title"`
	Description string  `gorm:"description"`
	Commitment  *string `gorm:"commitment"`
}