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