Messaging

Tables (20)

push_fail

  • seqno (seq_no) — NUMBER — Primary key — NOT NULL
  • psid (ps_id) — VARCHAR2(255) — Primary key — NOT NULL
  • cuid (user_id) — VARCHAR2(50)
  • appid (app_id) — VARCHAR2(50)
  • pnsid (pns_id) — VARCHAR2(10)
  • retry_cnt (retry_count) — NUMBER
  • result_code — VARCHAR2(10)
  • result_msg — VARCHAR2(4000)
  • reg_date — DATE
  • mode_date (mod_date) — DATE
  • is_sms_sent — CHAR(1)
  • csv_vars — VARCHAR2(2000)

push_msg_recv_master

  • seqno (seq_no) — NUMBER — Primary key — NOT NULL
  • reserve_seqno (reserve_seq_no) — NUMBER
  • sound_file — VARCHAR2(20)
  • badge_no — NUMBER
  • message — VARCHAR2(4000)
  • sub_title — VARCHAR2(4000)
  • ext — VARCHAR2(4000)
  • reserve_date — DATE
  • priority — NUMBER
  • sender_id — VARCHAR2(50)
  • reg_date — DATE
  • appid (app_id) — VARCHAR2(255)
  • service_code — VARCHAR2(20)
  • type — CHAR(1)
  • total_send_cnt — NUMBER
  • send_cnt — NUMBER
  • fail_cnt — NUMBER
  • rev_cnt — NUMBER
  • read_cnt — NUMBER
  • upns_cnt — NUMBER
  • apns_cnt — NUMBER
  • aom_cnt — NUMBER
  • gcm_cnt — NUMBER
  • db_in — CHAR(1)
  • original_seqno (original_seq_no) — NUMBER
  • group_seq — VARCHAR2(50)
  • start_timestamp — NUMBER
  • end_timestamp — NUMBER

push_pause_upns_history

  • seqno (seq_no) — NUMBER — Primary key — NOT NULL
  • source_upnsid (source_upns_id) — VARCHAR2(50)
  • target_upnsids (target_upns_id) — VARCHAR2(255)
  • move_allocate_cnts (move_allocate_count) — VARCHAR2(255)
  • moved_count — VARCHAR2(10)
  • moved_allocate_info — VARCHAR2(255)
  • start_user_seqno (start_user_seq_no) — VARCHAR2(30)
  • end_user_seqno (end_user_seq_no) — VARCHAR2(30)
  • reg_date — DATE

push_pitcher_completed_msg

  • pitcher_seqno (pitcher_seq_no) — NUMBER — Primary key — NOT NULL
  • app_id — VARCHAR2(255)
  • message — VARCHAR2(4000)
  • sound_file — VARCHAR2(20)
  • badge_no — NUMBER
  • priority — NUMBER
  • ext — VARCHAR2(255)
  • sender_code — VARCHAR2(50)
  • service_code — VARCHAR2(20)
  • reserve_date — DATE
  • type — CHAR(1)
  • db_in — CHAR(1)
  • attach_file — VARCHAR2(255)
  • group_seq — VARCHAR2(50)
  • cuid (user_id) — LONG
  • reg_date — DATE
  • process_flag — CHAR(1)
  • split_msg_cnt (split_message_count) — NUMBER
  • delay_second — NUMBER
  • reserve_type — VARCHAR2(2)
  • sub_title — VARCHAR2(4000)
  • push_fail_sms_send — CHAR(1)
  • sms_read_wait_minute — VARCHAR2(5)
  • doz_gcm_send — CHAR(1)
  • send_time_limit — VARCHAR2(20)
  • result_code — VARCHAR2(20)
  • result_msg — VARCHAR2(4000)

push_pitcher_msg

  • pitcher_seqno (pitcher_seq_no) — NUMBER — Primary key — NOT NULL
  • app_id — VARCHAR2(255)
  • message — VARCHAR2(4000)
  • sound_file — VARCHAR2(20)
  • badge_no — NUMBER
  • priority — NUMBER
  • ext — VARCHAR2(255)
  • sender_code — VARCHAR2(50)
  • service_code — VARCHAR2(20)
  • reserve_date — DATE
  • type — CHAR(1)
  • db_in — CHAR(1)
  • attach_file — VARCHAR2(255)
  • group_seq — VARCHAR2(50)
  • cuid (user_id) — LONG
  • reg_date — DATE
  • process_flag — CHAR(1)
  • split_msg_cnt (split_message_count) — NUMBER
  • delay_second — NUMBER
  • reserve_type — VARCHAR2(2)
  • sub_title — VARCHAR2(4000)
  • push_fail_sms_send — CHAR(1)
  • sms_read_wait_minute — VARCHAR2(5)
  • doz_gcm_send — CHAR(1)
  • send_time_limit — VARCHAR2(20)

push_reserve_msg

  • reserve_seqno (reserve_seq_no) — NUMBER — Primary key — NOT NULL
  • app_id — VARCHAR2(255)
  • message — VARCHAR2(4000)
  • sound_file — VARCHAR2(20)
  • badge_no — NUMBER
  • priority — NUMBER
  • ext — VARCHAR2(255)
  • sender_code — VARCHAR2(50)
  • service_code — VARCHAR2(20)
  • reserve_date — DATE
  • type — CHAR(1)
  • db_in — CHAR(1)
  • attach_file — VARCHAR2(255)
  • group_seq — VARCHAR2(50)
  • cuid (user_id) — LONG
  • reg_date — DATE
  • process_flag — CHAR(1)
  • split_msg_cnt (split_message_count) — NUMBER
  • delay_second — NUMBER
  • reserve_type — VARCHAR2(2)
  • is_condition — VARCHAR2(2)
  • sub_title — VARCHAR2(4000)
  • push_fail_sms_send — CHAR(1)
  • sms_read_wait_minute — VARCHAR2(5)
  • doz_gcm_send — CHAR(1)
  • send_time_limit — VARCHAR2(20)

push_sender_info

  • sender_seq — NUMBER(8) — Primary key — NOT NULL — 발신자
  • sender_name — VARCHAR2(50) — 발신자
  • sender_code — VARCHAR2(50) — 발신자
  • is_deleted — VARCHAR2(1) — 삭제
  • sender_desc — VARCHAR2(45)
  • reg_id — VARCHAR2(20)
  • reg_dt (reg_date) — DATE
  • mod_id — VARCHAR2(20)
  • mod_dt (mod_date) — DATE

push_server_group

  • group_id (server_group_id) — VARCHAR2(20) — Primary key — NOT NULL — 서버
  • group_name (server_group_name) — VARCHAR2(50) — 서버그룹이름
  • server_type — VARCHAR2(10) — 서버타입:
  • vip (ip) — VARCHAR2(30) — 클라이언트에게
  • port — VARCHAR2(6) — VIP

push_server_info

  • server_id — VARCHAR2(50) — Primary key — NOT NULL — 서버아이디
  • group_id (server_group_id) — VARCHAR2(20) — Foreign key → push_server_group.group_id — NOT NULL — 서버
  • ip — VARCHAR2(20) — 아이피
  • port — VARCHAR2(6) — 포트
  • internal_ip — VARCHAR2(20)
  • server_type — VARCHAR2(10) — 서버타입:
  • server_name — VARCHAR2(50) — 서버
  • url — VARCHAR2(1024) — 웹서버일
  • is_active — CHAR(1) — 사용여부

push_server_status

  • ip_address — VARCHAR2(15) — Primary key — NOT NULL
  • port — VARCHAR2(6) — Primary key — NOT NULL
  • status — VARCHAR2(1)
  • reg_date — DATE

push_service

  • service_name — VARCHAR2(100)
  • service_code — VARCHAR2(20) — NOT NULL
  • max_retry_cnt (max_retry_count) — NUMBER(2)
  • retry_flag — VARCHAR2(1)
  • resend_flag — VARCHAR2(1)
  • max_resend_cnt (max_resend_count) — NUMBER(2)
  • pnsid (pns_id) — VARCHAR2(4)
  • fail_sms_flag — VARCHAR2(1)

push_sms

  • appid (app_id) — VARCHAR2(255) — Primary key — NOT NULL
  • cuid (user_id) — VARCHAR2(50) — Primary key — NOT NULL
  • seqno (seq_no) — VARCHAR2(50) — Primary key — NOT NULL
  • title — VARCHAR2(4000)
  • sub_title — VARCHAR2(4000)
  • pnsid — VARCHAR2(10)
  • psid — VARCHAR2(255)
  • sms_read_wait_minute — VARCHAR2(5)
  • push_status — CHAR(1)
  • err_code — VARCHAR2(10)
  • reg_date — DATE
  • expire_date — DATE

push_success

  • seqno (seq_no) — NUMBER(20) — Primary key — NOT NULL
  • psid (ps_id) — VARCHAR2(255) — Primary key — NOT NULL
  • appid (app_id) — VARCHAR2(50)
  • pnsid (pns_id) — VARCHAR2(10)
  • status — NUMBER
  • cuid (user_id) — VARCHAR2(50)
  • reg_date — DATE
  • rev_date — DATE
  • read_date — DATE
  • is_sms_sent — CHAR(1)
  • csv_vars — VARCHAR2(2000)

push_supervisor

  • supervisor_seq — NUMBER(8) — Primary key — NOT NULL
  • name — VARCHAR2(50)
  • phone_no — VARCHAR2(20)
  • is_deleted — VARCHAR2(1)
  • reg_date — DATE
  • mod_date — DATE
  • tel_comp — VARCHAR2(4)

push_sysmsg_sentinfo

  • send_date — CHAR(8) — Primary key — NOT NULL
  • sender_code — VARCHAR2(50) — Primary key — NOT NULL
  • sent_cnt (sent_count) — NUMBER
  • fail_cnt (fail_count) — NUMBER
  • read_cnt (read_count) — NUMBER
  • upns_sent_cnt (upns_sent_count) — NUMBER
  • upns_fail_cnt (upns_fail_count) — NUMBER
  • apns_sent_cnt (apns_sent_count) — NUMBER
  • apns_fail_cnt (apns_fail_count) — NUMBER
  • gcm_sent_cnt (gcm_sent_count) — NUMBER
  • gcm_fail_cnt (gcm_fail_count) — NUMBER
  • aom_sent_cnt (aom_sent_count) — NUMBER
  • aom_fail_cnt (aom_fail_count) — NUMBER
  • time00 — NUMBER
  • time01 — NUMBER
  • time02 — NUMBER
  • time03 — NUMBER
  • time04 — NUMBER
  • time05 — NUMBER
  • time06 — NUMBER
  • time07 — NUMBER
  • time08 — NUMBER
  • time09 — NUMBER
  • time10 — NUMBER
  • time11 — NUMBER
  • time12 — NUMBER
  • time13 — NUMBER
  • time14 — NUMBER
  • time15 — NUMBER
  • time16 — NUMBER
  • time17 — NUMBER
  • time18 — NUMBER
  • time19 — NUMBER
  • time20 — NUMBER
  • time21 — NUMBER
  • time22 — NUMBER
  • time23 — NUMBER

push_user

  • cuid (user_id) — VARCHAR2(50) — Primary key — NOT NULL
  • cname — VARCHAR2(50)
  • val1 — VARCHAR2(50) — 타게팅
  • val2 — VARCHAR2(50) — 타게팅
  • val3 — VARCHAR2(50) — 타게팅
  • val4 — VARCHAR2(50) — 타게팅
  • val5 — VARCHAR2(50) — 타게팅
  • val6 — VARCHAR2(50) — 타게팅
  • val7 — VARCHAR2(50) — 타게팅
  • val8 — VARCHAR2(50) — 타게팅
  • val9 — VARCHAR2(50) — 타게팅
  • reg_dt (reg_date) — DATE
  • mod_dt (mod_date) — DATE

push_user_group

  • group_seq — NUMBER(6) — Primary key — NOT NULL
  • cuid (user_id) — VARCHAR2(50) — Foreign key → push_user.cuid — NOT NULL

push_user_group_info

  • group_seq — NUMBER(6) — NOT NULL
  • group_name — VARCHAR2(50)
  • is_deleted — VARCHAR2(1)
  • reg_date — DATE
  • mod_date — DATE
  • parent_group_seq — NUMBER(6)
  • group_desc — VARCHAR2(100) — 그룹설명
  • reg_id — VARCHAR2(20) — 등록자ID
  • group_type — VARCHAR2(1) — (N:normal

push_user_info

  • push_key — VARCHAR2(40) — Primary key — NOT NULL — 고유키(디바이스아이디+앱아이디+PNSID)
  • user_seqno (user_seq_no) — NUMBER
  • psid — VARCHAR2(255) — 푸쉬발송토큰
  • pnsid — VARCHAR2(4) — 푸쉬서버종류
  • device_id — VARCHAR2(50) — 디바이스고유번호
  • cuid — VARCHAR2(50) — 아이디
  • cname — VARCHAR2(50) — 이름
  • appid (app_id) — VARCHAR2(255) — 팩키지명
  • phone_no — VARCHAR2(20) — 전화번호
  • os_ver — VARCHAR2(50) — OS
  • device_md — VARCHAR2(100) — 디바이스
  • app_ver — VARCHAR2(50) — 앱버전
  • apns_mode — VARCHAR2(10) — APNS
  • upnsid (upns_id) — VARCHAR2(20) — 할당된
  • org_upnsid (org_upns_id) — VARCHAR2(20)
  • reg_date — DATE — 등록일
  • mod_date — DATE — 수정일

push_variables

  • v_group — VARCHAR2(20) — Primary key — NOT NULL
  • v_name — VARCHAR2(40) — Primary key — NOT NULL
  • v_value — VARCHAR2(256)