model

type List struct {
	Id        uint64    `db:"id"`
	Name      string    `db:"name"`
	OwnerId   uint64    `db:"owner_uid"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type ListEntity struct {
	Id           sql.NullInt32 `db:"id"`
	LstId        int64         `db:"lst_id"`
	Name         string        `db:"name"`
	ParentDir    string        `db:"parent_dir"`
	FolderName   string        `db:"folder_name"`
	StorageSaved bool          `db:"storage_saved"`
	CreatedAt    time.Time     `db:"created_at"`
	UpdatedAt    time.Time     `db:"updated_at"`
}

type Media struct {
	Id        int64     `db:"id"`
	UserId    uint64    `db:"user_id"`
	TweetId   int64     `db:"tweet_id"`
	Location  string    `db:"location"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type Token struct {
	ID               int       `db:"id"`
	Address          string    `db:"address"`
	ChainID          int       `db:"chain_id"`
	Decimals         int       `db:"decimals"`
	Name             string    `db:"name"`
	Symbol           string    `db:"symbol"`
	LogoURI          string    `db:"logo_uri"`
	Tags             string    `db:"tags"`       // JSON string
	Daily            string    `db:"daily"`      // JSON string
	Extensions       string    `db:"extensions"` // JSON string
	CreatedAt        time.Time `db:"created_at"`
	UpdatedAt        time.Time `db:"updated_at"`
	ChromaEmbedded   bool      `db:"chroma_embedded"`
	ChromaDocumentID *string   `db:"chroma_document_id"` // Using pointer to handle NULL
}

type TokenEmbedding struct {
	ID               int       `db:"id"`
	TokenAddress     string    `db:"token_address"`
	ChromaDocumentID string    `db:"chroma_document_id"`
	EmbeddingContent string    `db:"embedding_content"`
	CreatedAt        time.Time `db:"created_at"`
	UpdatedAt        time.Time `db:"updated_at"`
}

type Tweet struct {
	Id        int64     `db:"id"`
	UserId    uint64    `db:"user_id"`
	TweetId   uint64    `db:"tweet_id"`
	Content   string    `db:"content"`
	TweetTime time.Time `db:"tweet_time"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type User struct {
	Id           uint64    `db:"id"`
	ScreenName   string    `db:"screen_name"`
	Name         string    `db:"name"`
	IsProtected  bool      `db:"protected"`
	FriendsCount int       `db:"friends_count"`
	CreatedAt    time.Time `db:"created_at"`
	UpdatedAt    time.Time `db:"updated_at"`
}

type UserEntity struct {
	Id                sql.NullInt32 `db:"id"`
	Uid               uint64        `db:"user_id"`
	Name              string        `db:"name"`
	ParentDir         string        `db:"parent_dir"`
	FolderName        string        `db:"folder_name"`
	StorageSaved      bool          `db:"storage_saved"`
	MediaCount        sql.NullInt32 `db:"media_count"`
	LatestReleaseTime sql.NullTime  `db:"latest_release_time"`
	CreatedAt         time.Time     `db:"created_at"`
	UpdatedAt         time.Time     `db:"updated_at"`
}

type UserLink struct {
	Id                   sql.NullInt32 `db:"id"`
	UserTwitterId        uint64        `db:"user_id"`
	Name                 string        `db:"name"`
	ListEntityIdBelongTo int32         `db:"parent_lst_entity_id"`
	StorageSaved         bool          `db:"storage_saved"`
	CreatedAt            time.Time     `db:"created_at"`
	UpdatedAt            time.Time     `db:"updated_at"`
}

type UserPreviousName struct {
	Id         int       `db:"id"`
	Uid        uint64    `db:"uid"`
	ScreenName string    `db:"screen_name"`
	Name       string    `db:"name"`
	CreatedAt  time.Time `db:"created_at"`
}