asd

Tables (10)

auth_user_notification_preference

  • user_id — BINARY(16) — Primary key — NOT NULL
  • enabled — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

greenroom_notification_history

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • ticket_id — BINARY(16) — NOT NULL
  • sequence — INT — NOT NULL
  • attempt — INT — NOT NULL
  • channel — VARCHAR(255) — NOT NULL
  • idempotency_key — VARCHAR(255) — NOT NULL
  • sent_at — TIMESTAMP(6) — NOT NULL
  • result — VARCHAR(255) — NOT NULL
  • is_checked — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

greenroom_notification_processed_event

  • event_id — BINARY(16) — Primary key — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

greenroom_notification_target

  • ticket_id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • ticket_created_at — DATETIME(6) — NOT NULL
  • enabled — BIT(1) — NOT NULL
  • resolved — BIT(1) — NOT NULL
  • next_sequence — INT — NOT NULL
  • next_send_at — TIMESTAMP(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

greenroom_notification_user_preference

  • user_id — BINARY(16) — Primary key — NOT NULL
  • enabled — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

profile_image

  • id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL

recent_profile_image

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • image_id — BIGINT — Foreign key → profile_image.id — NOT NULL
  • used_at — DATETIME(6) — NOT NULL
  • INDEX — idx_recent_user_used_at

tickets

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • name — VARCHAR(255)
  • situation — VARCHAR(255) — NOT NULL
  • thought — VARCHAR(255) — NOT NULL
  • action — VARCHAR(255) — NOT NULL
  • colleague_reaction — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL

tracking

  • id — BINARY(16) — Primary key — NOT NULL
  • ticket_id — BINARY(16) — NOT NULL
  • user_id — BINARY(16) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • resolved_help_type — VARCHAR(255)
  • resolved_help_other — VARCHAR(255)
  • resolved_state_type — VARCHAR(255)
  • unresolved_blocker_type — VARCHAR(255)
  • unresolved_blocker_other — VARCHAR(255)
  • unresolved_need_type — VARCHAR(255)
  • note — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL

users

  • id — BINARY(16) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255)
  • profile_image_id — BIGINT — Foreign key → profile_image.id
  • provider — VARCHAR(255)
  • provider_user_id — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255) — NOT NULL
  • is_active — BIT(1) — NOT NULL
  • first_login — BIT(1) — NOT NULL
  • is_deleted — BIT(1) — NOT NULL
  • deleted_at — DATETIME(6)
  • agreed_terms_of_service — BIT(1) — NOT NULL
  • agreed_privacy_policy — BIT(1) — NOT NULL
  • agreed_marketing — BIT(1) — NOT NULL