CC
Tables (9)
isac_cc_app.cs_msg_request (cs_msg_request)
- msg_id — int8 — Primary key — NOT NULL
- msg_type — varchar(10) — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- emp_no — varchar(30) — NOT NULL
- site_id — varchar(30)
- service_cd — bpchar(5)
- subject — varchar(64)
- message — text
- send_date — varchar(16)
- callback — varchar(20)
- dest_name — varchar(30)
- dest_tel_no — varchar(30)
- content_type — varchar(10)
- content_file1 — varchar(100)
- content_file2 — varchar(100)
- content_file3 — varchar(100)
- sys_file1 — varchar(100)
- sys_file2 — varchar(100)
- sys_file3 — varchar(100)
- result — int4
- errcode — int4
- deliver_date — varchar(20)
- request_date — varchar(16) — NOT NULL
message_inticube.tb_msg_request (tb_msg_request)
- MSG_ID — bigint(20) — Primary key — NOT NULL
- MSG_TYPE — varchar(10) — Primary key — NOT NULL
- USER_ID — varchar(20) — Primary key — NOT NULL
- EMP_NO — varchar(30) — NOT NULL
- SUBJECT — varchar(64)
- MESSAGE — text
- REQUEST_DATE — varchar(16)
- SEND_DATE — varchar(16)
- CALLBACK — varchar(20)
- DEST_NAME — varchar(30)
- DEST_TEL_NO — varchar(30)
- CONTENT_TYPE — varchar(10)
- CONTENT_FILE1 — mediumblob
- CONTENT_FILE2 — mediumblob
- CONTENT_FILE3 — mediumblob
- RESULT — int(11)
- DELIVER_DATE — varchar(20)
message_surem.mmscontents (mmscontents)
- SEQNO — int(11) — Primary key — NOT NULL
- FileCnt — int(11) — NOT NULL
- FilePath1 — varchar(255)
- FilePath2 — varchar(255)
- FilePath3 — varchar(255)
message_surem.suredata (suredata)
- SEQNO — int(11) — Primary key — NOT NULL
- INTIME — char(14) — NOT NULL
- USERCODE — char(30) — NOT NULL
- DEPTCODE — char(30)
- BIZTYPE — varchar(2)
- YELLOWID_KEY — varchar(40)
- REQNAME — varchar(32)
- REQPHONE — varchar(20) — NOT NULL
- CALLNAME — varchar(32)
- COUNTRY — varchar(10)
- CALLPHONE — varchar(20) — NOT NULL
- SUBJECT — varchar(120)
- MSG — text — NOT NULL
- REQTIME — char(14) — NOT NULL
- SENTTIME — char(14)
- RECVTIME — char(14)
- RESULT — char(1) — NOT NULL
- ERRCODE — int(11)
- KIND — char(1) — NOT NULL
- FKCONTENT — int(11)
- IMAGE_URL — varchar(1000)
- BATCHFLAG — int(11) — NOT NULL
- RETRY — int(11)
- RESEND — varchar(1)
- TEMPLATECODE — char(40)
- RETEXT — varchar(2000)
- RESENTFLAG — varchar(1)
- SENTMEDIA — varchar(1)
- MEDIATYPE — char(1)
- BTN_TYPE_01 — varchar(2)
- BTN_NM_01 — varchar(56)
- BTN_01_URL_01 — varchar(1000)
- BTN_01_URL_02 — varchar(1000)
- BTN_TYPE_02 — varchar(2)
- BTN_NM_02 — varchar(56)
- BTN_02_URL_01 — varchar(1000)
- BTN_02_URL_02 — varchar(1000)
- BTN_TYPE_03 — varchar(2)
- BTN_NM_03 — varchar(56)
- BTN_03_URL_01 — varchar(1000)
- BTN_03_URL_02 — varchar(1000)
- BTN_TYPE_04 — varchar(2)
- BTN_NM_04 — varchar(56)
- BTN_04_URL_01 — varchar(1000)
- BTN_04_URL_02 — varchar(1000)
- BTN_TYPE_05 — varchar(2)
- BTN_NM_05 — varchar(56)
- BTN_05_URL_01 — varchar(1000)
- BTN_05_URL_02 — varchar(1000)
- KAKAO_ERRCODE — char(10)
message_surem.suredata_log (suredata_log)
- SEQNO — int(11) — Primary key — NOT NULL
- INTIME — char(14) — NOT NULL
- USERCODE — char(30) — NOT NULL
- DEPTCODE — char(30)
- BIZTYPE — varchar(2)
- YELLOWID_KEY — varchar(40)
- REQNAME — varchar(32)
- REQPHONE — varchar(20) — NOT NULL
- CALLNAME — varchar(32)
- COUNTRY — varchar(10)
- CALLPHONE — varchar(20) — NOT NULL
- SUBJECT — varchar(120)
- MSG — text — NOT NULL
- REQTIME — char(14) — NOT NULL
- SENTTIME — char(14)
- RECVTIME — char(14)
- RESULT — char(1) — NOT NULL
- ERRCODE — int(11)
- KIND — char(1) — NOT NULL
- FKCONTENT — int(11)
- IMAGE_URL — varchar(1000)
- BATCHFLAG — int(11) — NOT NULL
- RETRY — int(11)
- RESEND — varchar(1)
- TEMPLATECODE — char(40)
- RETEXT — varchar(2000)
- RESENTFLAG — varchar(1)
- SENTMEDIA — varchar(1)
- MEDIATYPE — char(1)
- BTN_TYPE_01 — varchar(2)
- BTN_NM_01 — varchar(56)
- BTN_01_URL_01 — varchar(1000)
- BTN_01_URL_02 — varchar(1000)
- BTN_TYPE_02 — varchar(2)
- BTN_NM_02 — varchar(56)
- BTN_02_URL_01 — varchar(1000)
- BTN_02_URL_02 — varchar(1000)
- BTN_TYPE_03 — varchar(2)
- BTN_NM_03 — varchar(56)
- BTN_03_URL_01 — varchar(1000)
- BTN_03_URL_02 — varchar(1000)
- BTN_TYPE_04 — varchar(2)
- BTN_NM_04 — varchar(56)
- BTN_04_URL_01 — varchar(1000)
- BTN_04_URL_02 — varchar(1000)
- BTN_TYPE_05 — varchar(2)
- BTN_NM_05 — varchar(56)
- BTN_05_URL_01 — varchar(1000)
- BTN_05_URL_02 — varchar(1000)
- KAKAO_ERRCODE — char(10)
public.mmscontents_isac (mmscontents_isac)
- seqno — int4 — Primary key — NOT NULL
- filecnt — int4 — NOT NULL
- filepath1 — varchar(255)
- filepath2 — varchar(255)
- filepath3 — varchar(255)
- fkcontent — float8
- biztype — varchar(2)
- kakao_img_url — varchar(200)
- flag — bpchar(1)
- upload_message — varchar(200)
- deptcode — bpchar(9)
- regtime — varchar(14)
- expirytime — varchar(14)
public.suredata_isac (suredata_isac)
- seqno — int4 — Primary key — NOT NULL
- intime — bpchar(14) — NOT NULL
- usercode — varchar(30) — NOT NULL
- deptcode — bpchar(9)
- biztype — varchar(7)
- yellowid_key — varchar(40)
- reqname — varchar(32)
- reqphone — varchar(20) — NOT NULL
- callname — varchar(32)
- country — varchar(10)
- callphone — varchar(20) — NOT NULL
- subject — varchar(120)
- msg — varchar(3000) — NOT NULL
- reqtime — bpchar(14) — NOT NULL
- senttime — bpchar(14)
- recvtime — bpchar(14)
- result — bpchar(1) — NOT NULL
- errcode — int4
- kind — bpchar(1) — NOT NULL
- fkcontent — int4
- batchflag — int4 — NOT NULL
- retry — int4
- resend — varchar(1)
- templatecode — varchar(40)
- retext — varchar(2000)
- sentmedia — varchar(1)
- mediatype — bpchar(1)
- attachment — varchar(4000)
- supplement — varchar(4000)
- carousel — varchar(4000)
- header — varchar(25)
- kakaoerrcode — bpchar(10)
- template_title — varchar(500)
- ad_flag — bpchar(1)
- etc1 — bpchar(10)
- etc2 — bpchar(10)
- etc3 — bpchar(10)
- etc4 — bpchar(10)
- etc5 — bpchar(10)
public.suredata_log_202404_isac (suredata_log_202404_isac)
- seqno — int4
- intime — bpchar(14)
- usercode — varchar(30)
- deptcode — bpchar(9)
- biztype — varchar(7)
- yellowid_key — varchar(40)
- reqname — varchar(32)
- reqphone — varchar(20)
- callname — varchar(32)
- country — varchar(10)
- callphone — varchar(20)
- subject — varchar(120)
- msg — varchar(3000)
- reqtime — bpchar(14)
- senttime — bpchar(14)
- recvtime — bpchar(14)
- result — bpchar(1)
- errcode — int4
- kind — bpchar(1)
- fkcontent — int4
- batchflag — int4
- retry — int4
- resend — varchar(1)
- templatecode — varchar(40)
- retext — varchar(2000)
- sentmedia — varchar(1)
- mediatype — bpchar(1)
- attachment — varchar(4000)
- supplement — varchar(4000)
- carousel — varchar(4000)
- header — varchar(25)
- kakaoerrcode — bpchar(10)
- template_title — varchar(500)
- ad_flag — bpchar(1)
- etc1 — bpchar(10)
- etc2 — bpchar(10)
- etc3 — bpchar(10)
- etc4 — bpchar(10)
- etc5 — bpchar(10)
public.tb_msg_request_isac (tb_msg_request_isac)
- msg_id — numeric(100) — Primary key — NOT NULL
- msg_type — varchar(10) — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- emp_no — varchar(30) — NOT NULL
- site_id — varchar(30)
- service_cd — bpchar(5)
- subject — varchar(64)
- message — text
- request_date — varchar(16)
- send_date — varchar(16)
- callback — varchar(20)
- dest_name — varchar(30)
- dest_tel_no — varchar(30)
- content_type — varchar(10)
- content_file1 — varchar(100)
- content_file2 — varchar(100)
- content_file3 — varchar(100)
- result — numeric(10)
- deliver_date — varchar(20)