notification-service
Tables (5)
device_token
- device_token_id — INT — Primary key — NOT NULL
- user_id — SMALLINT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
notification
- notification_id — INT — Primary key — NOT NULL
- user_id — SMALLINT — NOT NULL
- type_id — SMALLINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — VARCHAR(255)
- link — VARCHAR(255)
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
notification_target
- notification_target_id — INT — Primary key — NOT NULL
- notification_id — INT — NOT NULL
- entity_id — INT — NOT NULL
- entity_type — ENUM('LINE_SHEET', 'ORDER') — NOT NULL
notification_type
- notification_type_id — SMALLINT — Primary key — NOT NULL
- code — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- default_enabled — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
user_notification_setting
- user_notification_setting_id — INT — Primary key — NOT NULL
- user_id — SMALLINT — NOT NULL
- type_id — SMALLINT — NOT NULL
- enabled — BOOLEAN — NOT NULL