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)