ody

Tables (4)

meeting_log (약속 로그)

  • id (로그id) — biginteger — Primary key — NOT NULL
  • mate_id (참여자id) — biginteger
  • type (로그 타입) — varchar(255)
  • created_at (생성시각) — timestamp(6)
  • updated_at (편집시각) — timestamp(6)

notice (공지)

  • id (알림id) — biginteger — Primary key — NOT NULL
  • mate_id (참여자id) — biginteger
  • fcmtopic (약속주제) — varchar(255)
  • type (알림유형) — varchar(255)
  • send_at (발송시각) — timestamp(6)
  • created_at (생성시각) — timestamp(6)
  • updated_at (변경시각) — timestamp(6)

notification (알림)

  • id (알림id) — biginteger — Primary key — NOT NULL
  • receiver_id (수신자 id) — biginteger
  • type (알림유형) — varchar(255)
  • fcmtopic (발송주제) — varchar(255)
  • created_at (생성시각) — timestamp(6)
  • updated_at (변경시각) — timestamp(6)

reserved_notification (예약 알림)

  • id (알림id) — biginteger — Primary key — NOT NULL
  • mateid (참여자id) — biginteger
  • type (알림유형) — varchar(255)
  • fcmtopic (발송주제) — varchar(255)
  • status (상태) — varchar(255)
  • send_at (발송시각) — timestamp(6)
  • created_at (생성시각) — timestamp(6)
  • updated_at (변경시각) — timestamp(6)