FCM_Test

Tables (7)

COMPANY (Untitled6)

  • id (메시지번호) — Primary key — NOT NULL
  • company_name (회사명) — Foreign key → USER.id — NOT NULL
  • notification_token (그룹토큰)

CREATE_GROUP_FCM (Untitled)

  • group_id (그룹번호) — bigint(20) — Primary key — NOT NULL
  • group_name (그룹이름(에이전트)) — varchar(20) — NOT NULL
  • group_token (그룹토큰)
  • start_date (전송시간) — date

FCM_GROUP_TOKEN (Untitled4)

  • token_id (Key) — bigint(20) — Primary key — NOT NULL
  • group_id (그룹번호) — bigint(20) — Foreign key → CREATE_GROUP_FCM.group_id — NOT NULL
  • registration_ids (사용자별 토큰 (key)) — varch(100)

MESSAGE_GROUP (Untitled3)

  • group_id (그룹ID) — bigint(20) — Foreign key → CREATE_GROUP_FCM.group_id — NOT NULL
  • msg_id (메시지ID) — int — Foreign key → SEND_GROUP_MESSAGE.msg_id — NOT NULL

Message (Untitled7)

  • id — Primary key — NOT NULL
  • id (메시지번호) — Foreign key → COMPANY.id — NOT NULL
  • company_name (회사명) — Foreign key → COMPANY.company_name — NOT NULL
  • msg_title (메시지 제목)
  • msg_body (메시지 내용)
  • msg_img (이미지)
  • start_date (전송시간)

SEND_GROUP_MESSAGE (Untitled2)

  • msg_id (ID) — int — Primary key — NOT NULL
  • group_token (그룹의 공통토큰) — varchar(100)
  • msg_title (메시지 제목) — varchar(100)
  • msg_body (메시지body)
  • msg (hellow111) — varchar(200)
  • msg_img (이미지파일)
  • start_date (전송시간) — date

USER (Untitled5)

  • id (그룹번호) — int — Primary key — NOT NULL
  • user_info (사용자 정보) — data
  • group_name (그룹이름(에이전트)) — varchar(20)
  • user_key (APP토큰) — varchar(100)