SafeOps
Tables (13)
alert
- id — bigint — Primary key — NOT NULL
- source_type — varchar(20) — NOT NULL
- event_type — varchar(50) — NOT NULL
- title — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- festival_id — bigint — Foreign key → festival.id — NOT NULL
- guard_id — bigint — Foreign key → guard.id
- batch_id — char(32)
- confirmed_at — datetime(6)
app_version
- id — bigint — Primary key — NOT NULL
- latest_version — varchar(20) — NOT NULL
- min_supported_version — varchar(20) — NOT NULL
- store_url_ios — varchar(255) — NOT NULL
- store_url_android — varchar(255) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- created_at — datetime(6) — NOT NULL
auth_custom_user
- id — bigint — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
- name — varchar(50)
- birth — date
- gender — varchar(10)
- phone_encrypted — varchar(255)
- phone_hash — varchar(64)
auth_custom_user_festivals
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → auth_custom_user.id — NOT NULL
- festival_id — bigint — Foreign key → festival.id — NOT NULL
festival
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- start_date — datetime(6)
- end_date — datetime(6)
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- image — varchar(255)
- address — varchar(255)
- description — longtext
- code — varchar(5) — NOT NULL
guard
- id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- phone_encrypted — varchar(255)
- phone_hash — varchar(64)
- password — varchar(128) — NOT NULL
- birth — date
- gender — varchar(10)
- token — varchar(64)
- last_login — datetime(6)
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- festival_id — bigint — Foreign key → festival.id — NOT NULL
- team_id — bigint — Foreign key → team.id
- device_type — varchar(10)
- fcm_token — varchar(255)
- zone_id — bigint — Foreign key → zone.id
- role — varchar(10) — NOT NULL
guard_bulk_job
- id — bigint — Primary key — NOT NULL
- task_id — varchar(64)
- status — varchar(10) — NOT NULL
- requested_count — int — NOT NULL
- created_count — int — NOT NULL
- errors — json
- created_at — datetime(6) — NOT NULL
- finished_at — datetime(6)
- festival_id — bigint — Foreign key → festival.id — NOT NULL
guard_location
- id — bigint — Primary key — NOT NULL
- latitude — decimal(9,6) — NOT NULL
- longitude — decimal(9,6) — NOT NULL
- is_moving — tinyint(1)
- recorded_at — datetime(6) — NOT NULL
- guard_id — bigint — Foreign key → guard.id
- guard_name — varchar(20) — NOT NULL
guard_notification
- id — bigint — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- body — varchar(500) — NOT NULL
- delivery_status — varchar(10) — NOT NULL
- created_at — datetime(6) — NOT NULL
- guard_id — bigint — Foreign key → guard.id
- sent_by_id — bigint — Foreign key → auth_custom_user.id
- data — json
- guard_name — varchar(20) — NOT NULL
- content — longtext
- progress_status — varchar(15) — NOT NULL
- rejection_reason — varchar(500)
- type — varchar(20) — NOT NULL
- completion_note — varchar(500)
- label — varchar(100)
- batch_id — char(32) — NOT NULL
- confirmed_at — datetime(6)
- done_at — datetime(6)
- in_progress_at — datetime(6)
- rejected_at — datetime(6)
team
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- festival_id — bigint — Foreign key → festival.id — NOT NULL
token_blacklist_blacklistedtoken
- id — bigint — Primary key — NOT NULL
- blacklisted_at — datetime(6) — NOT NULL
- token_id — bigint — Foreign key → token_blacklist_outstandingtoken.id — NOT NULL
token_blacklist_outstandingtoken
- id — bigint — Primary key — NOT NULL
- token — longtext — NOT NULL
- created_at — datetime(6)
- expires_at — datetime(6) — NOT NULL
- user_id — bigint — Foreign key → auth_custom_user.id
- jti — varchar(255) — NOT NULL
zone
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- festival_id — bigint — Foreign key → festival.id — NOT NULL