Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
ダウンロードID(zip内にも記載する追跡子。セッションIDを兼ねる) |
||||
| actor_user_id | VARCHAR | 64 | null |
|
|
実行者のCognito Sub |
||||
| actor_email | VARCHAR | 255 | null |
|
|
実行者のメールアドレス(実行当時の値をスナップショット) |
||||
| organization_id | VARCHAR | 100 | null |
|
|
対象組織ID |
||||
| organization_name | VARCHAR | 255 | null |
|
|
対象組織名(実行当時の値をスナップショット) |
||||
| period_start | BIGINT UNSIGNED | 20 | null |
|
|
対象期間の開始(Unix秒) |
||||
| period_end | BIGINT UNSIGNED | 20 | null |
|
|
対象期間の終了(Unix秒。半開区間の排他的上限) |
||||
| scopes | VARCHAR | 255 | null |
|
|
取得対象種別のカンマ区切り(TEAM_REPORTS,USER_REPORTS,GOALS,CHATS) |
||||
| masking_policy | VARCHAR | 32 | null |
|
|
適用したマスキングポリシー(例: masked_v1) |
||||
| status | enum('STARTED', 'COMPLETED', 'FAILED') | 9 | null |
|
|
実行状態 |
||||
| error_message | TEXT | 65535 | √ | null |
|
|
失敗理由(status=FAILEDのとき) |
|||
| ip_address | VARCHAR | 45 | √ | null |
|
|
実行元IPアドレス(CF-Connecting-IP) |
|||
| user_agent | VARCHAR | 512 | √ | null |
|
|
実行元User-Agent |
|||
| started_at | BIGINT UNSIGNED | 20 | unix_timestamp(now()) |
|
|
開始日時(Unix秒) |
||||
| expires_at | BIGINT UNSIGNED | 20 | null |
|
|
セッション有効期限(Unix秒) |
||||
| finished_at | BIGINT UNSIGNED | 20 | √ | null |
|
|
終了日時(Unix秒) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_admin_dl_audit_actor_started | Performance | Asc/Desc | actor_user_id + started_at |
| idx_admin_dl_audit_org_started | Performance | Asc/Desc | organization_id + started_at |
| idx_admin_dl_audit_started | Performance | Desc | started_at |
Relationships
Close relationships within degrees of separation
