ㅅㄷㄴㅅ
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