Best practice on generating primary keys with table name based prefix?

[vinod-canihelp]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from nanoid import generate
from datetime import datetime, timezone
from sqlmodel import AutoString, Field, Relationship, SQLModel

# Define the character set and length
characters = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"
length = 15

# Generate a unique ID
def generate_id() -> str:
    return str(generate(characters, length))

def get_utc_now() -> datetime:
    return datetime.now(timezone.utc)

class Base(SQLModel, revalidate_instances="always", validate_assignment=True):
    class Config:
        alias_generator = to_camel
        populate_by_name = True
        extra = "forbid"

class TableIds:
    # All tables will have unique randomly generated id. I want them to have a prefix based on table names.
    id: str = Field(primary_key=True, default_factory=generate_id)
    created_at: datetime = Field(  # type: ignore[call-overload]
        default_factory=get_utc_now, sa_type=DateTime(timezone=True)
    )
    updated_at: datetime = Field(  # type: ignore[call-overload]
        default_factory=get_utc_now,
        sa_type=DateTime(timezone=True),
        sa_column_kwargs={"onupdate": get_utc_now},
    )
    deleted_at: Optional[datetime] = Field(  # type: ignore[call-overload]
        default=None,
        sa_type=DateTime(timezone=True),
    )

class UserBase(Base):
    full_name: Optional[str] = None
    email: Optional[EmailStr] = Field(default=None, index=True, unique=True, sa_type=AutoString)
    is_email_verified: bool = False
    image_url: Optional[HttpUrlString] = Field(default=None, sa_type=AutoString)

class User(UserBase, TableIds, table=True):
    pass

class OrganizationBase(Base):
    name: str

class Organization(OrganizationBase, TableIds, table=True):
    pass

Description

The code shared above is great for creating unique randomly generated ids as primary key for all tables. I want to have a prefix based on the table name. How can I do it?

Current ids are like "bZwYnlG1kdGMCbx" and "DuDvRnZOXIDvvqs" for User and Organization table.
I want the ids to be "user_bZwYnlG1kdGMCbx" and "organization_DuDvRnZOXIDvvqs" for the User and Organization tables respectively.

Ideally the code for this is refactored like the TableIds class

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.11.8

Additional Context

No response