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