telegram_users
telegram_users
Таблица аутентифицированных пользователей Telegram
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | - | NO | agent_tokens.owner_id, bot_projects.owner_id, bot_templates.owner_id, bot_tokens.owner_id, media_files.uploaded_by, project_collaborators.user_id, project_collaborators.invited_by, project_versions.author_id, user_project_archives.user_id | - | Уникальный идентификатор пользователя в Telegram |
| first_name | text | - | NO | - | - | Имя пользователя |
| last_name | text | - | YES | - | - | Фамилия пользователя |
| username | text | - | YES | - | - | Имя пользователя в Telegram (username) |
| photo_url | text | - | YES | - | - | URL фотографии пользователя |
| auth_date | bigint | - | YES | - | - | Дата аутентификации |
| created_at | timestamp | now() | YES | - | - | Дата создания записи |
| updated_at | timestamp | now() | YES | - | - | Дата последнего обновления записи |
Relations
| Parent | Child | Type |
|---|---|---|
| telegram_users.id | agent_tokens.owner_id | Many to One |
| telegram_users.id | bot_projects.owner_id | Many to One |
| telegram_users.id | bot_templates.owner_id | Many to One |
| telegram_users.id | bot_tokens.owner_id | Many to One |
| telegram_users.id | media_files.uploaded_by | Many to One |
| telegram_users.id | project_collaborators.user_id | Many to One |
| telegram_users.id | project_collaborators.invited_by | Many to One |
| telegram_users.id | project_versions.author_id | Many to One |
| telegram_users.id | user_project_archives.user_id | Many to One |