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