models

type Customer struct {
	ID        uint32    `gorm:"primary_key;auto_increment" json:"id"`
	Name      string    `gorm:"size:255;not null;unique" json:"name"`
	Status    bool      `gorm:"false" json:"status"`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"updated_at"`
}

type CustomerSubscriptionsList struct {
	ID           uint32    `json:"id"`
	StripeID     string    `json:"stripe_id"`
	CustomerID   string    `json:"customer_id"`
	CustomerName string    `json:"customer_name"`
	TariffID     uint32    `json:"tariff_id"`
	TariffName   string    `json:"tariff_name"`
	Status       bool      `json:"status"`
	CreatedAt    time.Time `json:"created_at"`
	UpdatedAt    time.Time `json:"updated_at"`
}

type License struct {
	ID             uint32    `gorm:"primary_key;auto_increment" json:"id"`
	SubscriptionID uint32    `sql:"type:int REFERENCES subscriptions(id)" json:"subscription_id"`
	License        []byte    `gorm:"null" json:"license"`
	Hash           string    `gorm:"null" json:"hash"`
	Status         bool      `gorm:"false" json:"status"`
	CreatedAt      time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt      time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"updated_at"`
}

type Subscription struct {
	ID         uint32    `gorm:"primary_key;auto_increment" json:"id"`
	StripeID   string    `gorm:"size:18;not null;unique" json:"stripe_id"`
	CustomerID uint32    `sql:"type:int REFERENCES customers(id)" json:"customer_id"`
	TariffID   uint32    `sql:"type:int REFERENCES tariffs(id)" json:"tariff_id"`
	Status     bool      `gorm:"false" json:"status"`
	CreatedAt  time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt  time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"updated_at"`
}

type Tariff struct {
	ID        uint32    `gorm:"primary_key;auto_increment" json:"id"`
	Name      string    `gorm:"size:255;not null;unique" json:"name"`
	Price     int       `gorm:"size:6;not null" json:"price"`
	Tandem    bool      `gorm:"size:1;not null" json:"crossbar"`
	Triaxis   bool      `gorm:"size:1;not null" json:"triaxis"`
	Robots    bool      `gorm:"size:1;not null" json:"robots"`
	Users     int       `gorm:"size:6;not null" json:"users"`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"updated_at"`
}