fcm

Tables (6)

alarm (Untitled6)

  • id (alarm_pk) — Primary key — NOT NULL
  • Field
  • member_id (user_fk) — Foreign key → member.id — NOT NULL

member (Untitled)

  • id (user_pk) — Primary key — NOT NULL
  • usernmae (Field)
  • password (Field2)

token (Untitled2)

  • id (fcm_token_pk) — Primary key — NOT NULL
  • token_value (Field)
  • expiration_date (Field2)
  • user_id (user_pk) — Foreign key → member.id — NOT NULL

topic (Untitled4)

  • id (topic_pk) — Primary key — NOT NULL
  • topic_name (Field)

topic_member (Untitled3)

  • id (user_topic_pk) — Primary key — NOT NULL
  • user_id (user_pk) — Foreign key → member.id — NOT NULL
  • topic_id (topic_pk) — Foreign key → topic.id — NOT NULL

topic_token (Untitled5)

  • id (fcm_token_topic_pk) — Primary key — NOT NULL
  • fcm_token_id (fcm_token_pk) — Foreign key → token.id — NOT NULL
  • topic_id (topic_pk) — Foreign key → topic.id — NOT NULL