schemas.go

package models

import (
	"time"

	"github.com/google/uuid"
	"github.com/shopspring/decimal"
)

type CostSchema struct {
	CostID         *uuid.UUID      `json:"costId" db:"id"`
	Amount         decimal.Decimal `json:"amount" db:"amount"`
	Description    string          `json:"description" db:"description"`
	CreationDate   *time.Time      `json:"createdAt" db:"created_at"`
	DeductionDate  *time.Time      `json:"deductedAt" db:"deducted_at"`
	EndDate        *time.Time      `json:"endDate,omitempty" db:"end_date"`
	CostCategoryID *uuid.UUID      `json:"costCategoryId" db:"id_cost_category"`
}

type CostCategorySchema struct {
	CostCategoryID *uuid.UUID `json:"costCategoryId" db:"id"`
	Name           string     `json:"name" db:"name"`
	Description    string     `json:"description" db:"description"`
	Icon           string     `json:"icon" db:"icon"`
	Color          string     `json:"color" db:"color"`
	TripID         *uuid.UUID `json:"tripId" db:"id_trip"`
}

type TripSchema struct {
	TripID      *uuid.UUID `json:"tripId" db:"id"`
	Name        string     `json:"name" db:"name"`
	Description string     `json:"description" db:"description"`
	Location    string     `json:"location" db:"location"`
	StartDate   *time.Time `json:"startDate" db:"start_date"`
	EndDate     *time.Time `json:"endDate" db:"end_date"`
}

type UserSchema struct {
	UserID         *uuid.UUID `json:"userId" db:"id"`
	Username       string     `json:"userName" db:"username"`
	FirstName      string     `json:"firstName" db:"firstname"`
	LastName       string     `json:"lastName" db:"lastname"`
	Location       string     `json:"location" db:"location"`
	Email          string     `json:"email" db:"email"`
	Password       string     `json:"password" db:"password"`
	Activated      bool       `json:"activated" db:"activated"`
	ProfilePicture string     `json:"profilePicture" db:"profile_pic"`
	Birthday       *time.Time `json:"birthday" db:"birthday"`
	CreatedAt      *time.Time `json:"createdAt" db:"created_at"`
}

type TokenSchema struct {
	UserID      *uuid.UUID `json:"userId" db:"id_user"`
	Token       string     `json:"token" db:"token"`
	Type        string     `json:"type" db:"type"`
	CreatedAt   *time.Time `json:"createdAt" db:"created_at"`
	ConfirmedAt *time.Time `json:"confirmedAt" db:"confirmed_at"`
	ExpiresAt   *time.Time `json:"expiresAt" db:"expires_at"`
}

// CostContributionSchema Users are called contributors in the context of a cost.
// A user can be a creditor or a debtor: creditor means that the user has paid for the cost, debtor means that the user has to pay for the cost
type CostContributionSchema struct {
	UserID     *uuid.UUID      `json:"userId" db:"id_user"`
	CostID     *uuid.UUID      `json:"costId" db:"id_cost"`
	IsCreditor bool            `json:"isCreditor" db:"is_creditor"`
	Amount     decimal.Decimal `json:"amount" db:"amount"`
}

type UserTripSchema struct {
	UserID            *uuid.UUID `json:"id_user" db:"id_user"`
	TripID            *uuid.UUID `json:"id_trip" db:"id_trip"`
	HasAccepted       bool       `json:"accepted" db:"is_accepted"`
	PresenceStartDate *time.Time `json:"startDate" db:"presence_start_date"`
	PresenceEndDate   *time.Time `json:"endDate" db:"presence_end_date"`
}

type DebtSchema struct {
	DebtID       *uuid.UUID      `json:"debtId" db:"id"`
	CreditorId   *uuid.UUID      `json:"creditorId" db:"id_creditor"`
	DebtorId     *uuid.UUID      `json:"debtorId" db:"id_debtor"`
	TripId       *uuid.UUID      `json:"tripId" db:"id_trip"`
	Amount       decimal.Decimal `json:"amount" db:"amount"`
	CurrencyCode string          `json:"currency" db:"currency_code"`
	CreationDate *time.Time      `json:"createdAt" db:"created_at"`
	UpdateDate   *time.Time      `json:"updatedAt" db:"updated_at"`
}

type TransactionSchema struct {
	TransactionId *uuid.UUID      `json:"transactionId" db:"id"`
	CreditorId    *uuid.UUID      `json:"creditorId" db:"id_creditor"`
	DebtorId      *uuid.UUID      `json:"debtorId" db:"id_debtor"`
	TripId        *uuid.UUID      `json:"tripId" db:"id_trip"`
	Amount        decimal.Decimal `json:"amount" db:"amount"`
	CreationDate  *time.Time      `json:"createdAt" db:"created_at"`
	CurrencyCode  string          `json:"currency" db:"currency_code"`
	IsConfirmed   bool            `json:"isConfirmed" db:"is_confirmed"`
}