test
Tables (34)
TB_ADMIN_SETTING
- SUBS_ID — varchar(12) — Primary key — NOT NULL
- ADMIN_IMAGE_URL — varchar(256)
- COMPANY_IMAGE_URL — varchar(256)
- ASSIGN_TYPE — varchar(1)
- NON_RESPONSE_TIMEOUT — int(4)
- VALID_PREASSIGN — int(4)
- TIMEZONE_OFFSET — varchar(5)
- LUNCH_TIME_START — varchar(4)
- LUNCH_TIME_END — varchar(4)
- CLOSE_TIMEOUT — varchar(2)
- WEB_THEME_TYPE — varchar(1)
- FUCTION_LIST — varchar(16)
- RECORD_TYPE — varchar(1)
- RECORD_STORAGE_TYPE — varchar(1)
- GALLERY_ID — int(11)
- IS_AUTO_ASSIGN — varchar(1)
- TITLE_HEAD — varchar(10)
- BLUR_TYPE — varchar(1)
- IS_VOICE_CALL — varchar(5)
- IS_VIDEO_CALL — varchar(5)
- IS_SCREEN_SHARING — varchar(5)
- IS_CO_BROWSING — varchar(5)
- IS_CONTACT_SIGNATURE — varchar(5)
- SMS_PREFIX — varchar(256)
TB_AUTO_MESSAGE
- AMSG_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- MSG_TYPE — varchar(2)
- MESSAGE — varchar(1024)
- ACTIVE — varchar(1)
TB_BANWORD
- BANW_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- WORD — varchar(128) — NOT NULL
- CREATED_DATE — datetime
TB_CALL_PARTICIPANT_HISTORY
- CPHT_ID — int(11) — Primary key — NOT NULL
- CALL_ID — varchar(15) — NOT NULL
- PARTICIPANT_ID — int(11)
- ID — varchar(128)
- HOST — varchar(128)
- TOKEN — varchar(128)
- WS_ID — varchar(128)
- PARTICIPANT_ROLE — varchar(16)
- PARTICIPANT_TYPE — varchar(16)
- SIGNAL_TYPE — varchar(16)
- PARTICIPANT_LOCATION — varchar(16)
- AUDIO_ACTIVE — tinyint(1)
- VIDEO_ACTIVE — tinyint(1)
- FRAME_RATE — int(11)
- DATE — datetime
- JOIN_DATE — datetime
- LEAVE_DATE — datetime
TB_CLIENT_TERMINAL_INFO
- ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- TERM_IP — varchar(44)
- SITE_NAME — varchar(16)
- SITE_CODE — int(11)
- TERM_NAME — varchar(16)
- TERM_CODE — varchar(50)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_CONTENT_CAPTURE
- CAPTURE_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- ROOM_ID — varchar(32) — NOT NULL
- FILE_NAME — varchar(256)
- SIZE — int(11)
- FORMAT — varchar(128)
- CREATE_DATE — datetime
TB_CONTENT_CHAT
- CHAT_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- ROOM_ID — varchar(128) — NOT NULL
- CHAT — longtext
- CHAT_DETAIL — longtext
- CREATE_DATE — datetime
TB_CONTENT_MEMO
- MEMO_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- ROOM_ID — varchar(128) — NOT NULL
- CLIENT_ID — varchar(128)
- AGENT_ID — varchar(128)
- MEMO_TITLE — varchar(128)
- MEMO — varchar(1028)
- CREATE_DATE — datetime
- MODIFY_DATE — datetime
TB_CONTENT_RECORD
- RECORD_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- ROOM_ID — varchar(128) — NOT NULL
- ORG_AGT_ID — varchar(128)
- FILE_NAME — varchar(256)
- REC_TURN — int(2) — NOT NULL
- SEQ_NO — int(2) — NOT NULL
- INTVAL — int(8) — NOT NULL
- USER_TYPE — varchar(12)
- SIZE — int(11)
- PLAY_TIME — int(11)
- FORMAT — varchar(256)
- CREATE_DATE — datetime
TB_CONTENT_SIZE
- SIZE_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12)
- USER_ID — int(11)
- SIZE — int(16)
- SIZE_H — varchar(16)
TB_FERMI_NOTICE
- NOTI_ID — int(11) — Primary key — NOT NULL — 공지사항 아이디
- USER_ID — int(11)
- TITLE — varchar(128)
- SEQ_NO — int(4) — 배열 순서
- CONTENTS — varchar(2048)
- HIDING — varchar(1) — 화면 표시 여부
- START_DATE — datetime — 게시 시작일(포함)
- END_DATE — datetime — 게시 종료일(포함)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_GALLERY_FOLDERS
- FOLD_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- USER_ID — int(11)
- PARNT_ID — int(11)
- DEPTH — int(2)
- NAME — varchar(128)
- PATH — varchar(1024)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_GALLERY_IMAGES
- IMAG_ID — int(11) — Primary key — NOT NULL
- USER_ID — int(11)
- FOLD_ID — int(11) — NOT NULL
- DISP_IDX — int(4) — NOT NULL
- NAME — varchar(128)
- PATH — varchar(1024)
- THUMBNAIL_PATH — varchar(1024)
- SIZE — int(16)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_IP_CAMERA_INFO
- ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- IP — varchar(45)
- PORT — int(11)
- ACCESS_ID — varchar(128)
- ACCESS_PW — varchar(256)
- NAME — varchar(128)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_KEYWORD
- KEYW_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- USER_ID — int(11) — NOT NULL
- KEYWORD — varchar(128) — NOT NULL
- MESSAGE — varchar(2048)
- CREATED_DATE — datetime
TB_LICENSES
- LICS_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- PRDT_ID — int(11) — NOT NULL
- STATUS — int(4) — NOT NULL
- REGI_DATE — datetime — NOT NULL
- END_DATE — datetime — NOT NULL
- BOTH_COUNT — int(4) — NOT NULL
- CHAT_COUNT — int(4) — NOT NULL
- BOTH_UNUSE_COUNT — int(4) — NOT NULL
- CHAT_UNUSE_COUNT — int(4) — NOT NULL
- PAYMENT_TYPE — varchar(2) — NOT NULL
- PAYMENT_PLAN — varchar(2)
- PAYMENT_START_DATE — datetime
- COUP_ID — varchar(29)
- PAYMENT_STATUS — varchar(8)
- IS_PAID_CUSTOMER — int(4)
- IS_VOUCHER — int(4)
TB_PAYMENT_HISTORY
- PAYH_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — int(11) — NOT NULL
- LICS_ID — int(11)
- KINDOF — varchar(2)
- PAYED_DATE — datetime — NOT NULL
- START_DATE — datetime — NOT NULL
- END_DATE — datetime — NOT NULL
- ACCOUNT_COUNT — int(11) — NOT NULL
- PAY_AMOUNT — int(15) — NOT NULL
- PAY_STATUS — varchar(64)
- PAY_PLAN — varchar(8)
TB_PHONE_BOOKS
- PBOK_ID — int(11) — Primary key — NOT NULL
- USER_ID — int(11) — NOT NULL
- PHONE_NUMBER — varchar(32) — NOT NULL
- EMAIL — varchar(128)
- COMPANY — varchar(64)
- NAME — varchar(128)
- MEMO — varchar(128)
TB_PRODUCTS
- PRDT_ID — int(11) — Primary key — NOT NULL
- KINDOF — varchar(2)
- PRICE — int(10)
- SMS_COUNT — int(6)
- STORAGE_SIZE — int(10)
- VIDEO_SHARE — varchar(2)
- SCREEN_SHARE — varchar(2)
- CHAT — varchar(2)
- LOCAL_STORAGE — varchar(2)
- CLOUD_STORAGE — varchar(2)
- MULTI_PARTY — varchar(2)
- STATISTIC — varchar(2)
TB_ROOM_HISTORY
- ROOM_ID — varchar(32) — Primary key — NOT NULL
- SUBS_ID — varchar(12)
- COMPANY — varchar(128)
- ORG_AGT_ID — varchar(128)
- CALLER — varchar(128)
- LOGIN_ID — varchar(32)
- CRNAME — varchar(128)
- CALLEE — varchar(128)
- SITE_CODE — varchar(12)
- SITE_NAME — varchar(256)
- TERMINAL_ID — int(2)
- ITEM_CODE — varchar(16)
- ITEM_NAME — varchar(32)
- SMS — varchar(1)
- SMS_NUM — varchar(64)
- ROOM_INDEX — varchar(16)
- ROOM_TYPE — varchar(16)
- ROOM_POLICY — varchar(16)
- REQ_URL — varchar(256)
- CONTENT_PATH — varchar(256)
- CREATE_DATE — datetime
- CONNECTED_DATE — datetime
- END_DATE — datetime
- ROOM_STATUS — varchar(16)
- IS_MISSED — varchar(1)
- RATE — int(2) — NOT NULL
- CLOSE_CODE — int(3)
- CLOSE_REASON — varchar(128)
- SIP_CALL_DIR — int(11)
- SIP_CALL_ID — varchar(256)
- SIP_UID — varchar(256)
- MEMO_TITLE — varchar(256)
- CLIENT_NAME — varchar(256)
- CLIENT_PHONE — varchar(16)
- CLIENT_EMAIL — varchar(32)
- CLIENT_REMARK — varchar(128)
- CONTENT_CHAT — varchar(1)
- CONTENT_CAPTURE — varchar(1)
- CONTENT_RECORD — varchar(1)
- CONTENT_MEMO — varchar(1)
- CONTENT_VIDEO_CALL — varchar(1)
- CONTENT_FILE_SHARE — varchar(1)
- CONTENT_SCREEN_SHARE — varchar(1)
- INVALID — varchar(1)
TB_ROOM_IMAGES
- RIMG_ID — int(11) — Primary key — NOT NULL
- ROOM_ID — varchar(32) — NOT NULL
- NAME — varchar(128)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_SMS_COUNT
- SMSC_ID — int(11) — Primary key — NOT NULL
- LICS_ID — int(11) — NOT NULL
- YYMM — varchar(8) — NOT NULL
- COUNT — int(11) — NOT NULL
TB_SMS_COUNT_USER
- SMSCU_ID — int(11) — Primary key — NOT NULL
- LICS_ID — int(11) — NOT NULL
- USER_ID — int(11) — NOT NULL
- COUNT — int(11) — NOT NULL
- TOTAL_CALL_COUNT — int(11) — NOT NULL
- LAST_COUNT — int(11) — NOT NULL
- LAST_TOTAL_CALL_COUNT — int(11) — NOT NULL
TB_SMS_HISTORY
- SMS_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12)
- USER_ID — int(11)
- ROOM_ID — varchar(32)
- SEND_TYPE — int(1)
- MSG — varchar(2048)
- USE_DATE — datetime
TB_SUBSCRIPTIONS
- SUBS_ID — varchar(12) — Primary key — NOT NULL
- SUBS_LOGIN_ID — varchar(32)
- COMPANY — varchar(128) — NOT NULL
- PHONE_NUMBER — varchar(16) — NOT NULL
- SMS_NUMBER — varchar(16) — NOT NULL
- CUSTOM_SMS_INFO — varchar(256)
- CREATE_DATE — datetime
- MODIFY_DATE — datetime
TB_USER
- USER_ID — int(11) — Primary key — NOT NULL
- LOGIN_ID — varchar(32) — NOT NULL
- PASSWORD — varchar(256) — NOT NULL
- EMAIL — varchar(128)
- USER_TYPE — varchar(16) — NOT NULL
- SALT — varchar(128) — NOT NULL
- NAME — varchar(128) — NOT NULL
- FAMILY_NAME — varchar(32)
- PHONE_NUMBER — varchar(32) — NOT NULL
- BUSINESS — varchar(64) — NOT NULL
- USER_IMAGE_URL — varchar(256)
- SUBS_ID — varchar(12)
- LICS_ID — int(11)
- IS_VERIFIED — varchar(1)
- WRONG_COUNT — int(4)
- WEB_PASSWORD — varchar(256)
- WEB_SALT — varchar(128)
- CUSTOM_CI — varchar(2)
- LAST_LOGIN_DATE — datetime
- LAST_LOGOUT_DATE — datetime
- CREATE_DATE — datetime — NOT NULL
- MODIFY_DATE — datetime
TB_USER_NOTICE
- NOTI_ID — int(11) — Primary key — NOT NULL — 공지사항 아이디
- SUBS_ID — varchar(12) — Primary key — NOT NULL
- USER_ID — int(11) — NOT NULL
- TITLE — varchar(128) — NOT NULL
- SEQ_NO — int(4) — 배열순서
- CONTENTS — varchar(2048)
- HIDING — varchar(1) — 화면 표시 여부 Y표시/N숨기기
- START_DATE — datetime — 게시 시작일(포함) null 인 경우, forever
- END_DATE — datetime — 게시 종료일(포함)
- CREATED_DATE — datetime
- MODIFIED_DATE — datetime
TB_USER_SETTING
- USER_ID — int(11) — Primary key — NOT NULL
- CAMERA_MODE — varchar(2)
- STAFF_STATUS — varchar(2)
- IS_EXCLUDE — varchar(1)
- STORAGE_PATH — varchar(256)
- START_MODE — varchar(16)
TB_USER_TYPE
- ID — int(11) — Primary key — NOT NULL
- USER_ID — int(11) — NOT NULL
- IS_ALL_TYPE — int(1)
- TYPE_CODE — varchar(16)
- CREATED_DATE — datetime
TB_WORK_SCHEDULE
- WKSD_ID — int(11) — Primary key — NOT NULL
- SUBS_ID — varchar(12) — NOT NULL
- SCHEDULE_TYPE — varchar(1)
- WHAT_DAY — varchar(1)
- DAY_INDEX — int(11)
- IS_WORK — varchar(1)
- IS_ALLDAY — varchar(1)
- STIME — varchar(4)
- ETIME — varchar(4)
- DATE — varchar(8)
- SCHEDULE_CONTENTS — varchar(1024)
msg_dstaddr_list
- dkey — varchar(50) — Primary key — NOT NULL
- dstaddr — varchar(20) — Primary key — NOT NULL
- stat — char(1) — NOT NULL
- insert_time — datetime
- scnt — int(11) — NOT NULL
- srepcnt — int(11) — NOT NULL
msg_queue
- mseq — int(11) — Primary key — NOT NULL
- msg_type — char(1) — NOT NULL
- send_type — char(1) — NOT NULL
- dkey — varchar(50) — NOT NULL
- dcnt — int(11) — NOT NULL
- dstaddr — varchar(20) — NOT NULL
- callback — varchar(20)
- stat — char(1) — NOT NULL
- subject — varchar(120)
- text_type — char(1) — NOT NULL
- text — varchar(4000) — NOT NULL
- text2 — varchar(4000)
- expiretime — int(11)
- filecnt — int(11) — NOT NULL
- fileloc1 — varchar(512)
- filesize1 — int(11)
- fileloc2 — varchar(512)
- filesize2 — int(11)
- fileloc3 — varchar(512)
- filesize3 — int(11)
- fileloc4 — varchar(512)
- filesize4 — int(11)
- fileloc5 — varchar(512)
- filesize5 — int(11)
- filecnt_checkup — int(11) — NOT NULL
- insert_time — datetime
- request_time — datetime — NOT NULL
- send_time — datetime
- report_time — datetime
- tcprecv_time — datetime
- save_time — datetime
- telecom — varchar(10)
- result — char(4)
- repcnt — int(11) — NOT NULL
- server_id — int(11)
- opt_id — varchar(20)
- opt_cmp — varchar(40)
- opt_post — varchar(40)
- opt_name — varchar(40)
- ext_col0 — int(11)
- ext_col1 — varchar(64)
- ext_col2 — varchar(32)
- ext_col3 — varchar(32)
- pseq — varchar(10)
- sender_key — varchar(40)
- k_template_code — varchar(30)
- k_expiretime — int(11)
- k_next_type — int(11)
- k_at_send_type — char(1)
- k_ad_flag — char(1) — NOT NULL
- k_attach — varchar(2000)
- k_attach2 — varchar(2000)
msg_queue_block
- dstaddr — varchar(20) — Primary key — NOT NULL
- msg_type — char(1) — Primary key — NOT NULL
- reg_time — date
- memo — varchar(30)
msg_result
- mseq — int(11) — NOT NULL
- msg_type — char(1) — NOT NULL
- send_type — char(1) — NOT NULL
- dkey — varchar(50) — NOT NULL
- dcnt — int(11) — NOT NULL
- dstaddr — varchar(20) — NOT NULL
- callback — varchar(20)
- stat — char(1) — NOT NULL
- subject — varchar(120)
- text_type — char(1) — NOT NULL
- text — varchar(2000)
- text2 — varchar(2000)
- expiretime — int(11)
- filecnt — int(11) — NOT NULL
- fileloc1 — varchar(512)
- filesize1 — int(11)
- fileloc2 — varchar(512)
- filesize2 — int(11)
- fileloc3 — varchar(512)
- filesize3 — int(11)
- fileloc4 — varchar(512)
- filesize4 — int(11)
- fileloc5 — varchar(512)
- filesize5 — int(11)
- filecnt_checkup — int(11) — NOT NULL
- insert_time — datetime
- request_time — datetime — NOT NULL
- send_time — datetime
- report_time — datetime
- tcprecv_time — datetime
- save_time — datetime
- telecom — varchar(10)
- result — char(4)
- repcnt — int(11) — NOT NULL
- server_id — int(11)
- opt_id — varchar(20)
- opt_cmp — varchar(40)
- opt_post — varchar(40)
- opt_name — varchar(40)
- ext_col0 — int(11)
- ext_col1 — varchar(64)
- ext_col2 — varchar(32)
- ext_col3 — varchar(32)
- pseq — varchar(10)
- sender_key — varchar(40)
- k_template_code — varchar(30)
- k_expiretime — int(11)
- k_next_type — int(11)
- k_at_send_type — char(1)
- k_ad_flag — char(1)
- k_attach — varchar(2000)
- k_attach2 — varchar(2000)