ㅅㄷㄴㅅ

Tables (3)

fcm_token

  • fcm_token_id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notification_subscription

  • subscription_id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • target_name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP

notifications

  • notification_id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • target_id — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • channel — VARCHAR(20) — NOT NULL
  • send_status — BOOLEAN — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • read_at — TIMESTAMP
  • clicked_at — TIMESTAMP