postgresql

type Account struct {
	ID        AccountID       `db:"id,autoincrement,primarykey"`
	Name      string          `db:"name"`
	Embedding pgvector.Vector `db:"embedding,type=vector(3)"`
	CreatedAt time.Time       `db:"created_at"`
	UpdatedAt time.Time       `db:"updated_at"`
}

type AccountID int64

type Group struct {
	ID                 GroupID             `db:"id,primarykey,autoincrement"`
	Name               string              `db:"name"`
	LeaderAccountID    AccountID           `db:"leader_account_id"`
	SubLeaderAccountID sql.Null[AccountID] `db:"sub_leader_account_id"`
	ChildGroupID       sql.Null[GroupID]   `db:"child_group_id"`

	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type GroupID int64

type Identity struct {
	ID        IdentityID `db:"id,autoincrement,primarykey"`
	AccountID AccountID  `db:"account_id"`
	Email     string     `db:"email"`
	CreatedAt time.Time  `db:"created_at"`
	UpdatedAt time.Time  `db:"updated_at"`
}

type IdentityID int64