10M+ Japanese Data Records – Complete Multi-Segment Business Databases

St_ven · 23-08-26, 08:12 AM

Hello everyone!

This time, we infiltrated the Japanese Max Group corporation and obtained data from 16 production databases. The data contained various information such as bank account numbers and mobile phone numbers, and the number of leaked records exceeded ten million.

company introduction：

The Max Group mainly operates social networking and dating-related businesses in Japan, including pcmax.jp, sp-max.jp, maxg.jp, vi-vo.link, and others.

He has the following businesses

Database introduction：

The database is divided into Oracle and MySQL databases. The following is a brief list.

WHAT'S INSIDE (Column-Level Detail for Key Tables):

If you find it too long, you can skip this introductory part. You can download the data analysis reports of each library by clicking on "Download of sample data", or contact me to obtain real-time data query services.

DB-01 CARD (Oracle) - Prepaid card / point-card issuance, stock, auth and settlement (SuperMAXSeries/maxg.jp, PC*MAX/pcmax.jp, vi-vo.link).

T_ISSUE_AUTH_HIS (DB-01) - Issue auth history/authorization trail: card, auth code, program, service, time. (11893958 rows)
AUTH_CD (VARCHAR2)
ISSUE_DATE (DATE)

T_ISSUE_CARD_DTL (DB-01) - Card import/issue detail: card number, card key, amount, points, program, error status. (8528877 rows)
ISSUE_HIS_SEQ (NUMBER)
ISSUE_DTL_NO (NUMBER)
CARD_SERIAL_NO (VARCHAR2)
CARD_ID (VARCHAR2)
CARD_PASSWORD (VARCHAR2)
BAL_POINT (NUMBER)
SALES_AMT (NUMBER)
ISSUER_SEQ (NUMBER)
CARD_ATTR (VARCHAR2)

T_STOCK_CARD (DB-01) - Card stock table: unissued/in-stock cards with number, key, amount, points, group, issue status. (7557235 rows)
CARD_ID (VARCHAR2)

T_CARD (DB-01) - Core card master: number, key, program, service, amount, points, issue/expiry, issuer, channel, status, auth code. (6108034 rows)
CARD_SERIAL_NO (VARCHAR2)
CARD_ID (VARCHAR2)
CARD_PASSWORD (VARCHAR2)
CARD_STATUS (NUMBER)
CARD_ATTR (VARCHAR2)
CARD_REGIST_TYPE (NUMBER)
SALES_AMT (NUMBER)
BAL_AMT (NUMBER)
SALES_POINT (NUMBER)
BAL_POINT (NUMBER)
ISSUE_DATE (DATE)
EXPIRE_DAY (VARCHAR2)
ISSUE_HIS_SEQ (NUMBER)
ISSUER_SEQ (NUMBER)
DELIVER_SEQ (NUMBER)
REMARKS (VARCHAR2)
SETTLE_COUNT (NUMBER)
SETTLE_REPORTING_FLAG (NUMBER)
SETTLE_REPORTING_START_DATE (DATE)
SETTLE_REPORTING_END_DATE (DATE)
AUTH_CD (VARCHAR2)
ISSUE_DAY (VARCHAR2)
LUCKY_POINT (NUMBER)
LUCKY_TYPE (VARCHAR2)
LUCKY_GUIDANCE (VARCHAR2)

T_SETTLE_LOG (DB-01) - Settlement trail: program, service, settled amount/points, user contacts, card, API URL, request text, result. (1106281 rows)
SETTLE_SEQ (NUMBER)
BEFORE_SETTLE_AMT (NUMBER)
SETTLE_AMT (NUMBER)
AFTER_SETTLE_AMT (NUMBER)
BEFORE_SETTLE_POINT (NUMBER)
AFTER_SETTLE_POINT (NUMBER)
SETTLE_RESULT (VARCHAR2)
SETTLE_START_DATE (DATE)
SETTLE_END_DATE (DATE)
SETTLE_RESULT_REPORT_FLAG (NUMBER)
USER_ID (VARCHAR2)
TEL (VARCHAR2)
EMAIL_ADDR (VARCHAR2)
CARD_ID (VARCHAR2)
CARD_PASSWORD (VARCHAR2)
CARD_SERIAL_NO (VARCHAR2)
SETTLE_CURRENT_STATUS (NUMBER)
ISSUER_SEQ (NUMBER)
DELIVER_SEQ (NUMBER)
SERVICE_EMAIL_ADDR (VARCHAR2)
AUTH_CD (VARCHAR2)
SETTLE_START_DAY (VARCHAR2)
CARD_ATTR (VARCHAR2)
CAMPAIGN_POINT (NUMBER)
SETTLE_POINT (NUMBER)

ID75 (DB-01) - Temp/filter table containing only CARD_ID (extracted card ID list). (170280 rows)
CARD_ID (VARCHAR2)

T_TEXT (DB-01) - Text detail table storing multi-line text per card ID (notes, import text, log fragments). (129179 rows)
CARD_ID (VARCHAR2)

T_CARD_HISTORY (DB-01) - Card change history: status, balance/points, machine name, before/after values. (59015 rows)
CARD_SERIAL_NO (VARCHAR2)
CARD_PASSWORD (VARCHAR2)
CARD_ID (VARCHAR2)
CARD_STATUS (NUMBER)
CARD_ATTR (VARCHAR2)
BAL_AMT (NUMBER)
BAL_POINT (NUMBER)

T_ISSUE_CARD_HIS (DB-01) - Card import/issue batch history: upload/issue dates, channel, row count, error flags. (3877 rows)
ISSUE_HIS_SEQ (NUMBER)
DELIVER_SEQ (NUMBER)

SYS_EXPORT_SCHEMA_03 (DB-01) - Oracle Data Pump export job metadata, not business data; records export objects, progress, status, files, version, platform. (1468 rows)
OBJECT_NAME (VARCHAR2)
OBJECT_LONG_NAME (VARCHAR2)
PARTITION_NAME (VARCHAR2)
SUBPARTITION_NAME (VARCHAR2)
PROCESSING_STATUS (CHAR)
BASE_OBJECT_NAME (VARCHAR2)
NAME (VARCHAR2)
USER_DIRECTORY (VARCHAR2)
USER_FILE_NAME (VARCHAR2)
FILE_NAME (VARCHAR2)
PROCESS_NAME (VARCHAR2)
USER_NAME (VARCHAR2)
STATUS_QUEUE (VARCHAR2)

DB-02 MAXG (Mysql) - MAXG girls membership, CTI, messaging, points and payment platform.

CtiLog (DB-02) - CTI/phone auth request log: CTI ID, account ID, auth code, corner, billing duration. (2,983,843 rows)
cti_id (user/device ID, 2,983,843 non-null, ~159 distinct)
idcode (user/device ID, 2,983,843 non-null, ~17,350 distinct)
certifycd (prepaid card/payment card or auth code, 2,983,843 non-null, ~9 distinct)
id (PK)

MessageMan (DB-02) - Male/customer-side message records: account ID, VCS ID, content pointer, payment status. (2,485,591 rows)
idcode (user/device ID, 992,762 non-null, ~19,032 distinct)
vcsid (user/device ID, 2,485,591 non-null, ~34,290 distinct)
cti_id (user/device ID, 2,475,561 non-null, ~148 distinct)
msg_id (PK)

LogPoint (DB-02) - Points spend/change trail: member, both accounts, points, time, IP, corner. (2,483,522 rows)
member_id (user/device ID, 2,482,110 non-null, ~25,436 distinct)
char_id (user/device ID, 2,469,528 non-null, ~25,231 distinct)
idcode (user/device ID, 2,482,110 non-null, ~25,353 distinct)
char_no (user/device ID, 2,469,528 non-null, ~25,148 distinct)
sex (gender, 2,482,110 non-null, ~2 distinct)
your_idcode (user/device ID)
your_sex (gender, 2,483,522 non-null, ~2 distinct)
your_member_id (user/device ID, 2,483,522 non-null, ~12,001 distinct)
remote_addr (IP/network address, 2,483,099 non-null, ~20,740 distinct)
login_id (user/device ID)
log_id (PK)

Message (DB-02) - Message/CTI notification records: account ID, VCS ID, content pointer, send/receive time. (749,427 rows)
cti_id (user/device ID, 749,427 non-null, ~165 distinct)
idcode (user/device ID, 629,055 non-null, ~2,303 distinct)
vcsid (user/device ID, 749,427 non-null, ~4,132 distinct)
sex (gender, 749,427 non-null, ~2 distinct)
msg_id (PK)

Access (DB-02) - Access log: time, source, IP, User-Agent. (348,990 rows)
remote_addr (IP/network address, 348,990 non-null, ~115,126 distinct)
user_agent (device/network ID, 324,978 non-null, ~22,431 distinct)
id (PK)

PointGet (DB-02) - Points, credits or consumption business table. (298,212 rows)
member_id (user/device ID, 298,212 non-null, ~10,258 distinct)
id (PK)

CtiHist (DB-02) - CTI usage history: member, category, area, operation time. (232,012 rows)
member_id (user/device ID, 232,012 non-null, ~10,364 distinct)
id (PK)

Chara (DB-02) - Character/profile table: member link, nickname, birth info, GPS/location, profile text. (207,614 rows)
char_no (user/device ID, 207,614 non-null, ~207,614 distinct)
member_id (user/device ID, 207,614 non-null, ~207,614 distinct)
nickname (name/nickname)
addr_gps (address/location)
gps_name (address/location)
latitude (address/location)
longitude (address/location)
prf_sex (gender, 207,614 non-null, ~1 distinct)
old_idcode (user/device ID)
id (PK)

Member (DB-02) - Member master: account, password, phone, email, points, registration/usage, prepaid card, auth status. (207,614 rows)
memb_id (user/device ID, 207,614 non-null, ~207,614 distinct)
idcode (user/device ID, 207,614 non-null, ~207,614 distinct)
passwd (password/credential, 207,614 non-null, ~8,314 distinct)
sex (gender, 207,614 non-null, ~2 distinct)
name (name/nickname)
tel (phone/mobile, 165,992 non-null, ~165,799 distinct)
preca_idcode (card/prepaid/auth code)
preca_passwd (card/prepaid/auth code)
user_agent_reg (device/network ID)
user_agent_now (device/network ID)
subscriber_no (phone/mobile)
tel_crdt (phone/mobile)
ms_member_id (user/device ID, 207,614 non-null, ~51,388 distinct)
certifycd (prepaid card/payment card or auth code, 207,614 non-null, ~10 distinct)
vcsid (user/device ID, 184,471 non-null, ~184,471 distinct)
tel_callid (phone/mobile, 138,619 non-null, ~129,356 distinct)
memb_id (PK)

VcsReq (DB-02) - VCS/CTI request records: account, phone, points, menu, category, CTI address. (188,618 rows)
idcode (user/device ID, 188,618 non-null, ~9,986 distinct)
tel (phone/mobile, 188,618 non-null, ~9,752 distinct)
cti_addr (IP/network address, 186,755 non-null, ~34 distinct)
id (PK)

DB-03 ECLUB (Oracle) - E-CLUB multi-region voice calls, phone auth, users, points, settlement, ops statistics.

T_TIME_CH_POINT (DB-03) - Points statistics by time and channel. (11,642,664 rows)
SEX_CD (gender code, 11,642,664 non-null, ~2 distinct)

T_RESERVE_ID (DB-03) - Reserved/booking ID resource pool. (5,943,319 rows)
USER_ID (user/account ID, 5,943,319 non-null, ~5,581,625 distinct)

T_TIME_CH_CALL (DB-03) - Call statistics by time and channel. (5,584,489 rows)
SEX_CD (gender code, 5,584,489 non-null, ~4 distinct)

T_SERVICE_CALL (DB-03) - Service call/reminder/voice/email records. (2,640,956 rows)
PASSWORD (password/credential, 2,640,956 non-null, ~9,724 distinct)
USER_SEQ (user/account ID, 2,640,956 non-null, ~140,951 distinct)
USER_ID (user/account ID, 2,640,956 non-null, ~87,223 distinct)

T_REPORT_POINT_DAY (DB-03) - Daily aggregated points report. (2,577,274 rows)
SEX_CD (gender code, 2,577,274 non-null, ~3 distinct)

T_USER_TEL (DB-03) - User phone master, linkable to user via USER_SEQ. (2,023,993 rows)
TEL (phone/mobile/inbound-outbound number, 2,023,993 non-null, ~319,540 distinct)
USER_SEQ (user/account ID, 2,023,993 non-null, ~1,509,366 distinct)

T_USER (DB-03) - User master: user ID, password, gender, status, registration type, remarks. (1,853,473 rows)
PASSWORD (password/credential, 1,852,109 non-null, ~10,339 distinct)
USER_SEQ (user/account ID, 1,853,473 non-null, ~1,846,032 distinct)
USER_ID (user/account ID, 1,853,473 non-null, ~1,063,934 distinct)
SEX_CD (gender code, 1,853,473 non-null, ~3 distinct)

T_BLACK_TEL (DB-03) - Blacklisted phone numbers. (1,753,568 rows)
TEL (phone/mobile/inbound-outbound number, 1,753,568 non-null, ~163,342 distinct)

T_USER_MAN (DB-03) - User management/balance/card/points/blacklist/prepaid info. (1,701,090 rows)
PREPAID_SERIAL (card number/credit/prepaid, 652,850 non-null, ~652,850 distinct)
CREDIT_CARD_NO (card number/credit/prepaid, 3,840 non-null, ~3,101 distinct)
USER_SEQ (user/account ID, 1,701,090 non-null, ~1,700,496 distinct)

T_COMM_LOG (DB-03) - Comm/billing log: call, number, duration, status, user sequence. (1,693,158 rows)
TEL (phone/mobile/inbound-outbound number, 1,611,597 non-null, ~20,501 distinct)
USER_SEQ (user/account ID, 1,693,158 non-null, ~31,982 distinct)
CRN (SID/request/call ID, 1,693,158 non-null, ~1,693,158 distinct)
SEX_CD (gender code, 1,231,062 non-null, ~3 distinct)

DB-04 EYE (Oracle) - Misesu EYE multi-region voice calls, phone auth, users, points, settlement, ops statistics.

T_RESERVE_ID (DB-04) - Reserved/booking ID pool for number, account or resource allocation. (48,160,301 rows)
USER_ID (user/account ID, 48,160,301 non-null, ~5,755,449 distinct)

T_TIME_CH_POINT (DB-04) - Points statistics by time and channel. (11,072,454 rows)
SEX_CD (gender code, 11,072,454 non-null, ~2 distinct)

T_USER_TEL (DB-04) - User phone master, linkable to user via USER_SEQ. (9,262,685 rows)
TEL (phone/mobile/inbound-outbound number, 9,262,685 non-null, ~722,046 distinct)
USER_SEQ (user/account ID, 9,262,685 non-null, ~8,105,081 distinct)

T_TIME_CH_CALL (DB-04) - Call statistics by time and channel. (5,594,195 rows)
SEX_CD (gender code, 5,594,195 non-null, ~4 distinct)

T_BLACK_TEL (DB-04) - Blacklisted phone numbers. (5,319,382 rows)
TEL (phone/mobile/inbound-outbound number, 5,319,382 non-null, ~164,658 distinct)

T_MAINTE_LOG (DB-04) - Maintenance/backend operation log: time, IP, function, result. (4,922,340 rows)
IP_ADDR (IP/network address, 4,922,302 non-null, ~131 distinct)

T_FREE_USER_ID (DB-04) - Free/allocatable user ID pool. (3,713,750 rows)
USER_ID (user/account ID, 3,713,750 non-null, ~122,360 distinct)

T_REPORT_POINT_DAY (DB-04) - Daily aggregated points report. (3,302,394 rows)
SEX_CD (gender code, 3,302,394 non-null, ~3 distinct)

T_USER (DB-04) - User master: user ID, password, gender, status, registration type, remarks. (2,526,341 rows)
PASSWORD (password/credential, 2,523,645 non-null, ~10,339 distinct)
USER_SEQ (user/account ID, 2,526,341 non-null, ~2,526,341 distinct)
USER_ID (user/account ID, 2,526,341 non-null, ~1,010,815 distinct)
SEX_CD (gender code, 2,526,341 non-null, ~3 distinct)

T_DAY_POINT (DB-04) - Daily points statistics. (2,522,874 rows)
SEX_CD (gender code, 2,522,874 non-null, ~2 distinct)

DB-05 LOC14 (Oracle) - LOC_CD=14 voice phone auth, points, settlement, multi-tenant operations.

T_RESERVE_ID (DB-05) - Reserved user ID pool: pending/available accounts per tenant. (17,715,987 rows)
USER_ID (user/account ID)

T_BLACK_TEL (DB-05) - Blacklisted phone table: restricted/marked phones and tenant. (3,891,154 rows)
TEL (phone/mobile/inbound-outbound number)

T_USER_TEL (DB-05) - User-phone mapping: one user to one or more phone numbers. (3,212,153 rows)
USER_SEQ (user/account ID)
TEL (phone/mobile/inbound-outbound number)

T_USER (DB-05) - User master: account, password, gender, status, registration and last-used time. (2,877,551 rows)
USER_SEQ (user/account ID)
USER_ID (user/account ID)
PASSWORD (password or credential field, 2,875,516 non-null, ~10,004 distinct)
SEX_CD (gender code)

T_USER_MAN (DB-05) - Male/customer-side user extensions: points, settlement, card, prepaid, blacklist status. (2,469,355 rows)
USER_SEQ (user/account ID)
CREDIT_CARD_NO (prepaid serial/card number field, 1,486 non-null, ~1,259 distinct)
PREPAID_SERIAL (prepaid serial/card number field, 1,031,800 non-null, ~1,031,800 distinct)

T_MAINTE_LOG (DB-05) - Maintenance/backend operation log: time, IP, operator, content. (2,261,321 rows)
IP_ADDR (IP/network address)

T_FREE_USER_ID (DB-05) - Free/trial user ID pool: available accounts by tenant and registration type. (2,185,625 rows)
USER_ID (user/account ID)

T_SERVICE_CALL (DB-05) - Service phone auth/call records: user, password, registration status, cumulative spend. (1,891,971 rows)
USER_SEQ (user/account ID)
USER_ID (user/account ID)
PASSWORD (password or credential field, 1,891,971 non-null, ~9,424 distinct)

T_MAN_CERTIFY_TEL (DB-05) - Male/customer-side certified phone table: phone, user ID, auth type, registration time. (1,830,138 rows)
TEL (phone/mobile/inbound-outbound number)
USER_ID (user/account ID)

T_CREDIT_LOG (DB-05) - Card/settlement trail: user, amount, payment phone, card number, credit settlement password, payment IP. (1,017,458 rows)
USER_SEQ (user/account ID)
USER_ID (user/account ID)
SETTLE_USED_TEL (phone/mobile/inbound-outbound number)
CREDIT_USER_PASSWORD (password or credential field, 14,225 non-null, ~3,606 distinct)
CREDIT_CARD_NO (prepaid serial/card number field, 393,035 non-null, ~47,821 distinct)
CREDIT_BATCH_SEQ (SID/request/call ID)
CREDIT_IP_NO (IP/network address)

DB-06 MAXDB (Oracle) - Phone/CTI, user-web binding, call logs, points/credit & prepaid settlement (ORG_USER + VCS_USER).

T_TIME_CH_POINT (DB-06) - Points statistics by time slice. (12997511 rows)
LOC_CD
PGM_CD
CALL_TYPE
REPORT_DAY
REPORT_TIME
B_CH
SEX_CD
CHARGE_TYPE
TOTAL_USED_COUNT
TOTAL_USED_POINT

T_RESERVE_ID (DB-06) - Reserved resource/account pool. (11983447 rows)
LOC_CD
PGM_CD
USER_ID

T_MEASUREMENT_EFFECT (DB-06) - Business config or runtime table; fields: LOC_CD, PGM_CD, REPORT_DAY, USER_REGIST_TYPE, MEDIA_MEASURE_SEQ, REGIST_COUNT, TOTAL_USED_POINT, TOTAL_USED_COUNT, TOTAL_RECEIPT_AMT, TOTAL_RECEIPT_COUNT, UPDATE_DATE (7423128 rows)
LOC_CD
PGM_CD
REPORT_DAY
USER_REGIST_TYPE
MEDIA_MEASURE_SEQ
REGIST_COUNT
TOTAL_USED_POINT
TOTAL_USED_COUNT
TOTAL_RECEIPT_AMT
TOTAL_RECEIPT_COUNT
UPDATE_DATE

T_TIME_CH_CALL (DB-06) - Call statistics by time slice. (6957020 rows)
CALL_PREPAID_COUNT (card/prepaid business clue, 6957020 non-null, ~4 distinct)
LOC_CD
PGM_CD
CALL_TYPE
REPORT_DAY
REPORT_TIME
B_CH
SEX_CD
CALL_COUNT
REGIST_COUNT
CALL_BEFORE_COUNT
CALL_AFTER_COUNT
CALL_CREDIT_COUNT
CALL_BITCASH

T_BLACK_TEL (DB-06) - Blacklisted phone table: restricted/marked phones and tenant. (5688503 rows)
LOC_CD
PGM_CD
TEL
OTHER_LOCATION_BLACK_FLAG
CREATE_DATE
REVISION_NO

T_MAINTE_LOG (DB-06) - Backend operation log: time, IP, operator, content. (4903100 rows)
IP_ADDR (IP/network address, 4043132 non-null, ~144 distinct)
SEQ_NO
UPDATE_DATE
MACHINE_NM
UPDATE_DTL

T_USER_TEL (DB-06) - User-phone mapping: user bound to one or more numbers. (4367073 rows)
USER_SEQ
TEL
LAST_USED_DATE

T_USER (DB-06) - User master: account, password, gender, status, registration and last-used time. (4191162 rows)
PASSWORD (password/credential, 4187784 non-null, ~10008 distinct)
USER_SEQ
LOC_CD
PGM_CD
USER_ID
SEX_CD
USER_REGIST_TYPE
USER_STATUS
REMARKS1
REMARKS2
REMARKS3
REMARKS4
USE_FLAG
NOW_TALK_FLAG
NEW_USER_FLAG
ILLEGAL_MSG_DEL_

T_USER_MAN (DB-06) - Male/customer-side user extensions: points, settlement, card, prepaid, restriction status. (3497922 rows)
FREE_PREPAID_1ST_BLK_OK_FLAG (card/prepaid business clue, 3497922 non-null, ~1 distinct)
PREPAID_BLK_USE_NA_FLAG (card/prepaid business clue, 3497922 non-null, ~2 distinct)
PREPAID_SALES_AMT (card/prepaid business clue, 3497922 non-null, ~660 distinct)
PREPAID_RANK (card/prepaid business clue, 1809596 non-null, ~9 distinct)
PREPAID_EXPIRE_DAY (card/prepaid business clue, 1671134 non-null, ~7080 distinct)
PREPAID_SERIAL (card, card-key, payment & auth judgement, 1640609 non-null, ~1640609 distinct)
CREDIT_CARD_NO (card, card-key, payment & auth judgement, 9151 non-null, ~7670 distinct)
USER_SEQ
BAL_POINT
LIMIT_POINT
RECEIPT_LIMIT_DAY
FIRST_POINT_USED_DATE
BILL_AMT
TOTAL_RECEIPT_AMT
TOTAL_RECEIPT_COUNT
CREDIT_EXPIRE_DAY
CREDIT_SETTLE_STATU

T_FREE_USER_ID (DB-06) - Free/trial business data. (3417803 rows)
LOC_CD
PGM_CD
USER_REGIST_TYPE
USER_ID
UPDATE_DATE

DB-07 MAXHOKKAIDO (Oracle) - Phone auth / voice / user resource pool / points settlement / ops statistics.

T_MAINTE_LOG (DB-07) - Maintenance/operation log; largest table. (4,222,450 rows)
IP_ADDR (IP/network address, 4,222,110 non-null, ~144 distinct)

T_REPORT_CALL_TIME (DB-07) - Time-aggregated call statistics report. (535,968 rows)
SEX_CD (gender code, 535,968 non-null, ~3 distinct)

T_FREE_USER_ID (DB-07) - Free/allocatable user ID pool. (449,450 rows)
USER_ID (user/account ID, 449,450 non-null, ~120,138 distinct)

T_BLACK_TEL (DB-07) - Blacklisted phone numbers. (152,637 rows)
TEL (phone/mobile/inbound-outbound number, 152,637 non-null, ~147,436 distinct)

T_COMM_LOG (DB-07) - Communication/billing log. (139,157 rows)
TEL (phone/mobile/inbound-outbound number, 70,408 non-null, ~4,364 distinct)
USER_SEQ (user/account ID, 139,157 non-null, ~2,010 distinct)
CRN (SID/request/call ID, 139,157 non-null, ~139,157 distinct)
SEX_CD (gender code, 35,581 non-null, ~2 distinct)

T_USER_TEL (DB-07) - User phone number master. (113,517 rows)
TEL (phone/mobile/inbound-outbound number, 113,517 non-null, ~41,229 distinct)
USER_SEQ (user/account ID, 113,517 non-null, ~60,762 distinct)

T_TIME_CH_CALL (DB-07) - Call statistics by time distribution. (103,563 rows)
SEX_CD (gender code, 103,563 non-null, ~4 distinct)

T_TIME_CH_POINT (DB-07) - Points statistics by time distribution. (91,666 rows)
SEX_CD (gender code, 91,666 non-null, ~2 distinct)

T_USER (DB-07) - User master: password, gender, status, certification flag. (70,920 rows)
USER_SEQ (user/account ID, 70,920 non-null, ~70,920 distinct)
USER_ID (user/account ID, 70,920 non-null, ~62,009 distinct)
PASSWORD (password/credential, 70,820 non-null, ~8,852 distinct)
SEX_CD (gender code, 70,920 non-null, ~2 distinct)

T_FREE_BOX (DB-07) - Free BOX/resource pool. (55,257 rows)
SEX_CD (gender code, 55,257 non-null, ~2 distinct)

DB-08 SS_USER (Oracle) - Phone/CTI, user registration & web binding, call logs, points/credit settlement, ops logs.

T_REGIST_USER (DB-08) - Business config or runtime table; fields: PGM_CD, TEL, MEDIA_MEASURE_SEQ, UPDATE_DATE, PGM_TYPE (4676458 rows)
TEL (phone/mobile/inbound-outbound number, 4676458 non-null, ~760269 distinct)
MEDIA_MEASURE_SEQ (request/call/trail ID, 4676458 non-null, ~27142 distinct)
PGM_CD
UPDATE_DATE
PGM_TYPE

T_TEXT (DB-08) - Business config or runtime table; fields: SEQ_NO, TEXT_LINE_NO, TEXT_DTL (1909035 rows)
SEQ_NO
TEXT_LINE_NO
TEXT_DTL

T_RECEIPT (DB-08) - Receipt/top-up trail: user, amount, point delta, receipt type, profile link. (1218309 rows)
REMARKS (business content/log text, 57971 non-null, ~38843 distinct)
PAYMENT_NM_FULL (name/personnel name, 1218309 non-null, ~169359 distinct)
PERSONAL_ID (user/account ID, 1218309 non-null, ~55 distinct)
USER_ID (user/account ID, 1217846 non-null, ~71658 distinct)
RECEIPT_SEQ (request/call/trail ID, 1218309 non-null, ~1218309 distinct)
RECEIPT_AMT
FROM_BANK_NM
FROM_BRANCH_NM
ACCOUNT_CD
RECEIPT_CD
LOC_CD
PGM_CD
STATUS
SEND_FLAG
RECEIPT_DATE
SEN

T_MAINTE_HIS (DB-08) - Business config or runtime table; fields: HIS_SEQ, USER_ACTION, PERSONAL_ID, USER_ID, RECEIPT_SEQ, ACTION_DATE, PGM_CD, IP_ADDR, CPU_NAME, OTHER_COM (511459 rows)
CPU_NAME (IP/network address, 511459 non-null, ~57 distinct)
IP_ADDR (IP/network address, 511459 non-null, ~49 distinct)
OTHER_COM (business content/log text, 276052 non-null, ~47187 distinct)
PERSONAL_ID (user/account ID, 492422 non-null, ~60 distinct)
USER_ID (user/account ID, 320894 non-null, ~38363 distinct)
HIS_SEQ (request/call/trail ID, 511459 non-null, ~511459 distinct)
RECEIPT_SEQ (request/call/trail ID, 320843 non-null, ~263572 distinct)
USER_ACTION
ACTION_DATE
PGM_CD

T_MAINTE_LOG (DB-08) - Backend operation log: time, IP, operator, content. (325337 rows)
IP_ADDR (IP/network address, 325337 non-null, ~86 distinct)
MACHINE_NM (IP/network address, 325337 non-null, ~73 distinct)
UPDATE_DTL (business content/log text, 325337 non-null, ~42562 distinct)
SEQ_NO
UPDATE_DATE

T_HTTP_LOG (DB-08) - Operations or business log. (123168 rows)
TEXT (business content/log text, 123168 non-null, ~96981 distinct)
SEND_DATE

T_YB_LIMIT_USER (DB-08) - Business config or runtime table; fields: PGM_CD, PGM_TYPE, TEL, UPDATE_DATE (96380 rows)
TEL (phone/mobile/inbound-outbound number, 96380 non-null, ~9750 distinct)
PGM_CD
PGM_TYPE
UPDATE_DATE

T_FREE_MEASURE_CD (DB-08) - Free/trial business data. (78068 rows)
MEASURE_CD
CREATE_DATE

T_CHECK_FOR_REGIST (DB-08) - Business config or runtime table; fields: USER_ID, EXEC_DATE, GG_FLAG, REGIST_COUNT, BLACK_COUNT, RECEIPT_COUNT, RECEIPT_AMT, RETURN_COUNT (63034 rows)
USER_ID (user/account ID, 63034 non-null, ~63034 distinct)
EXEC_DATE
GG_FLAG
REGIST_COUNT
BLACK_COUNT
RECEIPT_COUNT
RECEIPT_AMT
RETURN_COUNT

T_GG_CHECK (DB-08) - Business config or runtime table; fields: USER_ID, EXEC_DATE, GG_FLAG, REGIST_COUNT, BLACK_COUNT, RECEIPT_COUNT, RETURN_COUNT, EXEC_YB, STATUS, SEQ (57565 rows)
USER_ID (user/account ID, 57565 non-null, ~13576 distinct)
EXEC_DATE
GG_FLAG
REGIST_COUNT
BLACK_COUNT
RECEIPT_COUNT
RETURN_COUNT
EXEC_YB
STATUS
SEQ

DB-09 TELAUTH (Oracle) - Phone auth / voice / user ID pool / call statistics / points & settlement config / backend logs.

T_MAINTE_LOG (DB-09) - Maintenance/operation log; largest table, records system maintenance or backend operations. (1,855,493 rows)
IP_ADDR (IP/network address, 1,851,326 non-null)

T_TIME_OPERATION (DB-09) - User usage/ops statistics aggregated by program and cycle: start/end, WSHOT, PROFILE, adjustment minutes. (1,107,187 rows)
USER_ID (user/account ID, 1,107,187 non-null)

T_FREE_USER_ID (DB-09) - Free/allocatable user ID pool: LOC, program, registration type, user ID. (770,000 rows)
USER_ID (user/account ID, 770,000 non-null)

T_REPORT_CALL_TIME (DB-09) - Time-aggregated call report: call count, registrations, prepaid/credit/WSHOT/PROFILE/MSG stats. (439,272 rows)
SEX_CD (gender code, 439,272 non-null)

T_REPORT_POINT_TIME (DB-09) - Time-aggregated points consumption report: consumption type, count, points. (376,202 rows)
SEX_CD (gender code, 376,202 non-null)

T_TIME_CH_CALL (DB-09) - Statistics report (312,000 rows)
SEX_CD (gender code, 312,000 non-null)

T_DIAL_IN_CID (DB-09) - Dial-in numbers/CID data in the phone access or number identification chain. (305,166 rows)
DIAL_IN_NO (phone/mobile/inbound-outbound number, 305,166 non-null)
CID_ACCEPT_SEQ (SID/request/call association ID, 305,166 non-null)

T_FREE_BOX (DB-09) - Free BOX/mailbox or voicemail box resource pool. (140,000 rows)
SEX_CD (gender code, 140,000 non-null)

T_NA_REGIST_AREA (DB-09) - Registration area / number area data. (103,176 rows)
TEL (phone/mobile/inbound-outbound number, 103,176 non-null)

T_COMM_LOG (DB-09) - Communication/billing log: call start/end, phone number, seconds, user sequence, start/end points. (53,332 rows)
TEL (phone/mobile/inbound-outbound number, 48,015 non-null)
USER_SEQ (user/account ID, 53,332 non-null)
CRN (SID/request/call association ID, 53,332 non-null)

DB-10 ZERO (Oracle) - Phone/CTI, user-web binding, call logs, points/credit & prepaid settlement (VCS_USER).

T_RESERVE_ID (DB-10) - Reserved resource/account pool. (17715987 rows)
LOC_CD
PGM_CD
USER_ID

T_TIME_CH_POINT (DB-10) - Points statistics by time slice. (9261778 rows)
SEX_CD (gender code, 9261778 non-null, ~2 distinct)
LOC_CD
PGM_CD
CALL_TYPE
REPORT_DAY
REPORT_TIME
B_CH
CHARGE_TYPE
TOTAL_USED_COUNT
TOTAL_USED_POINT

T_TIME_CH_CALL (DB-10) - Call statistics by time slice. (4924598 rows)
CALL_PREPAID_COUNT (card/prepaid business clue, 4924598 non-null, ~5 distinct)
SEX_CD (gender code, 4924598 non-null, ~4 distinct)
LOC_CD
PGM_CD
CALL_TYPE
REPORT_DAY
REPORT_TIME
B_CH
CALL_COUNT
REGIST_COUNT
CALL_BEFORE_COUNT
CALL_AFTER_COUNT
CALL_CREDIT_COUNT
CALL_BITCASH

T_MEASUREMENT_EFFECT (DB-10) - Business config or runtime table; fields: LOC_CD, PGM_CD, REPORT_DAY, USER_REGIST_TYPE, MEDIA_MEASURE_SEQ, REGIST_COUNT, TOTAL_USED_POINT, TOTAL_USED_COUNT, TOTAL_RECEIPT_AMT, TOTAL_RECEIPT_COUNT, UPDATE_DATE (4363540 rows)
LOC_CD
PGM_CD
REPORT_DAY
USER_REGIST_TYPE
MEDIA_MEASURE_SEQ
REGIST_COUNT
TOTAL_USED_POINT
TOTAL_USED_COUNT
TOTAL_RECEIPT_AMT
TOTAL_RECEIPT_COUNT
UPDATE_DATE

T_BLACK_TEL (DB-10) - Blacklisted phone table: restricted/marked phones and tenant. (3915781 rows)
LOC_CD
PGM_CD
TEL
OTHER_LOCATION_BLACK_FLAG
CREATE_DATE
REVISION_NO

T_REPORT_POINT_DAY (DB-10) - Points statistics report. (3665046 rows)
SEX_CD (gender code, 3665046 non-null, ~3 distinct)
SEQ_NO
LOC_CD
PGM_CD
CHARGE_TYPE
CREATE_DATE
CHARGE_TYPE_NM
TOTAL_USED_COUNT_TODAY
TOTAL_USED_COUNT_MONTH
TOTAL_USED_COUNT_AVE
TOTAL_USED_POINT_TODAY
TOTAL_USED_P

T_USER_TEL (DB-10) - User-phone mapping: user bound to one or more numbers. (3240598 rows)
USER_SEQ
TEL
LAST_USED_DATE

T_USER (DB-10) - User master: account, password, gender, status, registration and last-used time. (2901444 rows)
PASSWORD (password/credential, 2899409 non-null, ~10004 distinct)
SEX_CD (gender code, 2901444 non-null, ~2 distinct)
USER_SEQ
LOC_CD
PGM_CD
USER_ID
USER_REGIST_TYPE
USER_STATUS
REMARKS1
REMARKS2
REMARKS3
REMARKS4
USE_FLAG
NOW_TALK_FLAG
NEW_USER_FLAG
ILLEGAL_MSG_DEL_

T_USER_MAN (DB-10) - Male/customer-side user extensions: points, settlement, card, prepaid, restriction status. (2490880 rows)
FREE_PREPAID_1ST_BLK_OK_FLAG (card/prepaid business clue, 2490880 non-null, ~1 distinct)
PREPAID_BLK_USE_NA_FLAG (card/prepaid business clue, 2490880 non-null, ~2 distinct)
PREPAID_SALES_AMT (card/prepaid business clue, 2490880 non-null, ~324 distinct)
PREPAID_RANK (card/prepaid business clue, 1131575 non-null, ~7 distinct)
PREPAID_EXPIRE_DAY (card/prepaid business clue, 1052782 non-null, ~6311 distinct)
PREPAID_SERIAL (card, card-key, payment & auth judgement, 1031800 non-null, ~1031800 distinct)
CREDIT_CARD_NO (card, card-key, payment & auth judgement, 4764 non-null, ~3875 distinct)
USER_SEQ
BAL_POINT
LIMIT_POINT
RECEIPT_LIMIT_DAY
FIRST_POINT_USED_DATE
BILL_AMT
TOTAL_RECEIPT_AMT
TOTAL_RECEIPT_COUNT
CREDIT_EXPIRE_DAY
CREDIT_SETTLE_STATU

T_MAINTE_LOG (DB-10) - Backend operation log: time, IP, operator, content. (2294986 rows)
IP_ADDR (IP/network address, 2294687 non-null, ~164 distinct)
SEQ_NO
UPDATE_DATE
MACHINE_NM
UPDATE_DTL

DB-11 POSTMAN (Mysql) - Email delivery / SMTP scheduling, domain grouping, throttling, blacklists, delivery logs.

mail_log (DB-11) - Mail delivery log: message ID, sender/recipient, SMTP local IP, status, delay, task. (133,816 rows)
message_id (business/task ID, 133,816 non-null, ~133,816 distinct)
saved_filepath (file path, 133,816 non-null, ~133,816 distinct)
smtp_server_local_ip (IP/network address, 133,816 non-null, ~2 distinct)
mail_from (email, 133,777 non-null, ~2 distinct)
rcpt_to (email, 133,777 non-null, ~2 distinct)
task_id (business/task ID, 133,777 non-null, ~2 distinct)
message_id (PK)

job_result_info (DB-11) - Email task results: task, total, success/failure counts, status, details, start/end time. (89,293 rows)
job_id (business/task ID, 89,293 non-null, ~89,293 distinct)
task_id (business/task ID, 89,293 non-null, ~2 distinct)
detail (email content/rule content, 89,293 non-null, ~1 distinct)
job_id (PK)

send_rule_domain_group_rel (DB-11) - Send rules / domain group association. (36 rows)
task_id (business/task ID, 36 non-null, ~8 distinct)
rule_id (business/task ID, 36 non-null, ~21 distinct)
task_id,group_index (PK)

send_rule_info (DB-11) - Send throttling/retry rules: intervals, success/failure thresholds, IP switching, test mailbox. (21 rows)
name (account/config name, 21 non-null, ~2 distinct)
testmail_to (email, 20 non-null, ~1 distinct)
id (PK)

domain_group_info (DB-11) - Domain group detail: domain, group index, time. (20 rows)
domain (domain/host, 20 non-null, ~5 distinct)
list_id,group_index (PK)

domain_group_list_info (DB-11) - Domain group list: name, enabled flag, time. (5 rows)
name (account/config name, 5 non-null, ~2 distinct)
id (PK)

smtp_serv_group_task_info_rel (DB-11) - SMTP server group / task association and ordering. (5 rows)
task_id (business/task ID, 5 non-null, ~5 distinct)
group_id (business/task ID, 5 non-null, ~5 distinct)
task_id,group_id (PK)

smtp_serv_group_info (DB-11) - SMTP server group config. (4 rows)
name (account/config name, 4 non-null, ~4 distinct)
id (PK)

smtp_serv_info (DB-11) - SMTP server config: name, host, group, internal/external IP, enabled flag. (4 rows)
name (account/config name, 4 non-null, ~4 distinct)
hostname (domain/host, 4 non-null, ~1 distinct)
group_id (business/task ID, 4 non-null, ~4 distinct)
local_ip (IP/network address, 4 non-null, ~4 distinct)
global_ip (IP/network address)
local_ip,is_active (PK)

task_info (DB-11) - Mail delivery task config: directory, polling, egress IPs, domain groups, rules, concurrency, priority. (4 rows)
name (account/config name, 4 non-null, ~4 distinct)
dir_path (file path, 4 non-null, ~4 distinct)
global_ip_list (IP/network address, 4 non-null, ~4 distinct)
default_netmask (IP/network address, 4 non-null, ~1 distinct)
from_domain_auto_selection (domain/host, 4 non-null, ~1 distinct)
id (PK)

DB-12 SPMAX (Mysql) - Member registration & traffic, points, credit-card & convenience-store payment, SMS/email, site callback.

SmsHist (DB-12) - SMS delivery history: target phone, content, carrier, status, result, network address. (3,459,676 rows)
to_address (phone/mobile, 3,459,676 non-null, ~86,813 distinct)
message (message/email content, 3,459,676 non-null, ~39,830 distinct)
ipcode (IP/network address)
cti_id (business/user ID, 3,459,642 non-null, ~129 distinct)
smsid (business/user ID, 3,457,815 non-null, ~3,457,815 distinct)
result_message (message/email content, 300,614 non-null, ~2 distinct)
id (PK)

SmsCsvShow (DB-12) - SMS batch tasks / member ID display-delivery association. (3,225,655 rows)
idcode (business/user ID, 3,225,655 non-null, ~80,663 distinct)

SmsCsvLog (DB-12) - SMS batch send detail: member ID, content, task, send status, error code. (3,224,382 rows)
idcode (business/user ID, 3,224,382 non-null, ~80,666 distinct)
msg (message/email content, 3,224,382 non-null, ~39,493 distinct)
smsid (business/user ID, 3,222,492 non-null, ~3,222,487 distinct)
id (PK)

LoginB (DB-12) - Member post-login points and validity status. (1,831,013 rows)
idcode (business/user ID, 1,831,013 non-null, ~41,536 distinct)
id (PK)

MemberAff (DB-12) - Member phone, ad/affiliate source, site and member ID mapping. (1,739,529 rows)
tel (phone/mobile, 1,739,529 non-null, ~264,573 distinct)
idcode (business/user ID, 1,739,529 non-null, ~1,739,529 distinct)
id (PK)

MemberStatus (DB-12) - Member current points, status, expiry, password, SMS/DM toggles, user type. (1,283,042 rows)
idcode (business/user ID, 1,283,042 non-null, ~179,373 distinct)
pass (password/credential, 233 non-null, ~7 distinct)
id (PK)

NotTel (DB-12) - Disallowed/excluded phone number list. (281,336 rows)
tel (phone/mobile, 281,336 non-null, ~281,336 distinct)

Logcom (DB-12) - Combined member log: points, status, payment type, callback ID. (134,137 rows)
idcode (business/user ID, 134,119 non-null, ~13,642 distinct)
url_poadd (URL/callback address)
id (PK)

MailLog (DB-12) - Email send log: sender/recipient, subject, body, HTML body, result. (101,430 rows)
idcode (business/user ID, 101,430 non-null, ~8,290 distinct)
mail (email, 101,430 non-null, ~8,649 distinct)
mail_from (email, 101,430 non-null, ~1 distinct)
mail_sub (message/email content, 101,430 non-null, ~18 distinct)
mail_mess (message/email content, 101,430 non-null, ~74,102 distinct)
mail_mess_html (message/email content)
id (PK)

Access (DB-12) - Site access/traffic log: business site, callback ID, ad ID, access time. (83,295 rows)
id (PK)

DB-13 SVC (Mysql) - Member social platform: profiles, bulletin board, diary, DMs, chat, points, payments, email.

Bbs (DB-13) - Community/bulletin content: member/character, title, body, area, GPS, IP, interaction stats. (1,496,294 (metadata approx) rows)
member_id (user/business ID)
char_id (user/business ID)
title (message/email/profile content)
mess (message/email/profile content)
addr_gps (address/location)
latitude (address/location)
longitude (address/location)
remote_addr (IP/network address)
freeip_ret (IP/network address)
bbs_id (PK)

Chara2 (DB-13) - Second set or historical user display profiles/characters. (918,713 (actual) rows)
member_id (user/business ID)
nickname (name/nickname/account)
memo (message/email/profile content)
addr_gps (address/location)
gps_name (address/location)
latitude (address/location)
longitude (address/location)
prf_mess01 (message/email/profile content)
id (PK)

Member (DB-13) - Member master: account/password, phone, email, registration/usage time, points or service status. (567,332 (actual) rows)
memb_id (user/business ID)
passwd (password/credential/push key)
mail (email)
mail_reg (email)
memo (message/email/profile content)
subscriber_no (user/business ID)
tel (phone/mobile)
nickname (name/nickname/account)
prf_mess01 (message/email/profile content)
idcode (user/business ID)
imode_id (user/business ID)
member_md5 (user/business ID)
remote_addr (IP/network address)
memo2 (message/email/profile content)
name (name/nickname/account)
mail2 (email)
preca_idcode (card/prepaid/auth code)
memb_id (PK)

Pps (DB-13) - In-site DM/point-to-point messages: both members/characters, title, body, location, IP. (109,098 (metadata approx) rows)
title (message/email/profile content)
mess (message/email/profile content)
addr_gps (address/location)
latitude (address/location)
longitude (address/location)
snd_addr (address/location)
remote_addr (IP/network address)
freeip_ret (IP/network address)
pps_id (PK)

DiaryComment (DB-13) - Diary comments: comment text, both characters/members, IP, time. (41,976 (metadata approx) rows)
char_id (user/business ID)
member_id (user/business ID)
comment (message/email/profile content)
remote_addr (IP/network address)
freeip_ret (IP/network address)
comment_id (PK)

Diary (DB-13) - Diary/feed content: title, body, author character, member, IP, display status. (10,906 (metadata approx) rows)
char_id (user/business ID)
title (message/email/profile content)
mess (message/email/profile content)
member_id (user/business ID)
remote_addr (IP/network address)
freeip_ret (IP/network address)
diary_id (PK)

PaymentConvDirect (DB-13) - Convenience-store/direct payment orders: name, address, phone, email, amount, callback fields. (865 (actual) rows)
taskid (user/business ID)
name1 (name/nickname/account)
name2 (name/nickname/account)
adr1 (address/location)
tel (phone/mobile)
mail (email)
rem_url (URL/host/callback address)
id (PK)

Manager (DB-13) - Admin accounts: login, password, name, source IP, session/auth info. (65 (actual) rows)
pass (password/credential/push key)
admin_name (name/nickname/account)
memo (message/email/profile content)
ipaddr (IP/network address)
ipaddr2 (IP/network address)
ipaddr3 (IP/network address)
ipaddr4 (IP/network address)
ipaddr5 (IP/network address)
remote_addr (IP/network address)
login_md5 (password/credential/push key)
admin_maint_tel (phone/mobile)
session_id (password/credential/push key)
admin_id (PK)

ChatTalk (DB-13) - Chat room messages: room, character, nickname, body, device/browser, status. (0 (metadata approx) rows)
mess (message/email/profile content)
nickname (name/nickname/account)
char_id (user/business ID)
char_id2 (user/business ID)
nickname2 (name/nickname/account)
member_id (user/business ID)
id (PK)

LogPoint (DB-13) - Points/service usage trail: member, business ID, time slot, IP, User-Agent. (0 (metadata approx) rows)
member_id (user/business ID)
char_id (user/business ID)
idcode (user/business ID)
your_char_id (user/business ID)
your_idcode (user/business ID)
remote_addr (IP/network address)
freeip_ret (IP/network address)
log_id (PK)

DB-14 SVC_OPWEB (Mysql) - Operations backend: CTI/VCS, voice & message inventory, tasks, points, push, runtime logs.

VcsReq (DB-14) - VCS/CTI request trail: user ID, phone, points, menu, CTI node, time. (75,213,687 (metadata approx) rows)
idcode (user/business ID)
tel (phone/mobile)
id (PK)

DummyReturnLog (DB-14) - Simulation/callback request log: target user, HTTP status, callback URL, message. (43,631,891 (metadata approx) rows)
target_user_id (user/business ID)
post_url (URL/host/callback address)
return_log_id (PK)

Message (DB-14) - Voice/message content master: CTI, message ID, body, play/nominate/reuse status. (18,692,198 (metadata approx) rows)
msg_id (user/business ID)
vcsid (user/business ID)
mess (message/email/profile content)
msg_id (PK)

MessageOld (DB-14) - Archived/historical message content. (11,316,208 (metadata approx) rows)
msg_id (user/business ID)
vcsid (user/business ID)
mess (message/email/profile content)
msg_id (PK)

MessagePv (DB-14) - PV/preview scene message content. (3,975,389 (metadata approx) rows)
msg_id (user/business ID)
vcsid (user/business ID)
mess (message/email/profile content)
msg_id (PK)

VcsMess (DB-14) - VCS message records: both user IDs, CTI, play/send status, business location. (178,695 (actual) rows)
msg_id (user/business ID)
idcode (user/business ID)
idcode2 (user/business ID)
msg_id (PK)

WebPush (DB-14) - Browser push subscriptions: member ID, endpoint, auth key, User-Agent. (3,105 (actual) rows)
idcode (user/business ID)
push_end_point (URL/host/callback address)
push_auth (password/credential/push key)
push_key (password/credential/push key)

SmsHist (DB-14) - SMS send history: target phone, content, carrier, result, IP. (855 (actual) rows)
to_address (phone/mobile)
message (message/email/profile content)
ipcode (IP/network address)
smsid (user/business ID)
result_message (message/email/profile content)
id (PK)

WebPushCmd (DB-14) - Browser push task/template commands incl. SQL/params and message content. (621 (metadata approx) rows)
sql_cmd (backend command/SQL)
tmpl_mess (message/email/profile content)
id (PK)

Cti (DB-14) - CTI/telephone service node config: numbers, SIP/toll-free lines, host addresses, category. (159 (actual) rows)
cti_addr (URL/host/callback address)
cti_tel (phone/mobile)
cti_tel_sip (phone/mobile)
cti_tel_free (phone/mobile)
cti_addr2 (URL/host/callback address)

DB-15 VIVO_CTI (Mysql) - Asterisk SIP terminal config and CTI call/transfer/voicemail, session mapping & scheduling.

SetIdCgiList (DB-15) - CTI CGI session mapping: both parties, call ID, command, time limit, points, location, category, message links. (1,099,877 rows)
idcode (user/business ID, 1,099,877 non-null, ~969,432 distinct)
idcode2 (user/business ID, 1,099,877 non-null, ~12,160 distinct)
callid (call/session ID, 1,099,877 non-null, ~1,099,692 distinct)
cmd (recording file/business content, 1,099,877 non-null, ~7 distinct)
prog_id (user/business ID, 1,099,877 non-null, ~2 distinct)
buf (recording file/business content)
prog_id2 (user/business ID)
den_id (user/business ID, 1,099,877 non-null, ~1 distinct)
id (PK)

Talk (DB-15) - Call session records: both accounts, channel, phone code, start time, points, bridging, status. (248,420 rows)
prog_id (user/business ID, 110,269 non-null, ~1 distinct)
idcode (user/business ID, 248,420 non-null, ~54,238 distinct)
idcode2 (user/business ID, 248,420 non-null, ~43,799 distinct)
ch1 (call/session ID, 248,420 non-null, ~246,623 distinct)
ch2 (call/session ID, 248,420 non-null, ~109,733 distinct)
fch (call/session ID, 248,420 non-null, ~246,623 distinct)
fch1 (call/session ID)
fch2 (call/session ID)
telcode (phone number/CTI dial ID, 248,420 non-null, ~1 distinct)
uniqueid (call/session ID)
bridge (call/session ID, 248,420 non-null, ~1 distinct)
bridge_ch (call/session ID, 248,420 non-null, ~108,522 distinct)
char_id2 (user/business ID, 248,420 non-null, ~1 distinct)
transet_id (call/session ID, 248,420 non-null, ~1 distinct)
id (PK)

Tran (DB-15) - Transfer/call dispatch records: member, account, CTI context/extension, caller ID, phone code, session. (107,770 rows)
memb_id (user/business ID, 107,770 non-null, ~1 distinct)
prog_id (user/business ID, 107,770 non-null, ~1 distinct)
idcode (user/business ID, 107,770 non-null, ~6,231 distinct)
fch (call/session ID, 107,770 non-null, ~107,268 distinct)
char_id (user/business ID)
ast_context (system route/address, 107,770 non-null, ~1 distinct)
ast_exten (system route/address, 107,770 non-null, ~1 distinct)
callerid (phone number/CTI dial ID, 107,770 non-null, ~1 distinct)
variable (recording file/business content, 107,770 non-null, ~107,770 distinct)
telcode (phone number/CTI dial ID, 107,770 non-null, ~6,278 distinct)
uniqueid (call/session ID)
id (PK)

Dengon (DB-15) - Voicemail/recording metadata: both users, recording file, box, play count, call duration, phone code. (26,154 rows)
den_id (user/business ID, 26,154 non-null, ~26,154 distinct)
prog_id (user/business ID, 26,154 non-null, ~3 distinct)
memb_id (user/business ID, 26,154 non-null, ~19,676 distinct)
idcode (user/business ID, 26,154 non-null, ~19,675 distinct)
char_id (user/business ID, 26,154 non-null, ~2 distinct)
prog_id2 (user/business ID, 26,154 non-null, ~2 distinct)
idcode2 (user/business ID, 26,154 non-null, ~2 distinct)
char_id2 (user/business ID, 26,154 non-null, ~1 distinct)
filename (recording file/business content, 26,154 non-null, ~25,929 distinct)
memo (recording file/business content)
telcode (phone number/CTI dial ID)
den_id (PK)

sip_buddies (DB-15) - Asterisk SIP endpoint config: endpoint name, registration host, IP, SIP secret/MD5 key, TLS/DTLS settings, client info. (403 rows)
name (account/name, 403 non-null, ~403 distinct)
host (IP/host/network address, 403 non-null, ~1 distinct)
callerid (phone number/CTI dial ID, 403 non-null, ~403 distinct)
defaultip (IP/host/network address)
fromdomain (IP/host/network address)
md5secret (password/credential)
secret (password/credential, 403 non-null, ~1 distinct)
fullcontact (IP/host/network address, 403 non-null, ~1 distinct)
ipaddr (IP/host/network address, 403 non-null, ~1 distinct)
id (PK)

Channel (DB-15) - Current CTI channel state: parties, phones, points, status, duration, session fields. (120 rows)
ch (call/session ID, 120 non-null, ~120 distinct)
fch (call/session ID, 120 non-null, ~3 distinct)
prog_id (user/business ID)
idcode (user/business ID, 120 non-null, ~3 distinct)
idcode2 (user/business ID, 120 non-null, ~1 distinct)
status_str (recording file/business content, 120 non-null, ~3 distinct)
tel (phone number/CTI dial ID)
log_id (call/session ID, 120 non-null, ~1 distinct)
ch (PK)

SipPing (DB-15) - SIP extension probe records. (9 rows)
id (PK)

TalkHistory (DB-15) - Call session history/error records. (4 rows)
prog_id (user/business ID, 4 non-null, ~1 distinct)
idcode (user/business ID, 4 non-null, ~2 distinct)
idcode2 (user/business ID, 4 non-null, ~2 distinct)
ch1 (call/session ID)
ch2 (call/session ID)
error (recording file/business content, 4 non-null, ~2 distinct)
id (PK)

TranSet (DB-15) - Transfer rules and execution status. (0 rows)
memb_id (user/business ID)
prog_id (user/business ID)
idcode (user/business ID)
char_id (user/business ID)
prog_id2 (user/business ID)
telcode (phone number/CTI dial ID)
callerid (phone number/CTI dia l ID)
den_id (user/business ID)
id (PK)

Download of sample data And analysis report:

Data analysis report for download: https://gofile.io/d/278XHu0R
[Image: 7.png]

sample data for download: https://gofile.io/d/tu6EkGF0

If you need the sample data in xlsx format or if you want us to provide real-time query verification data, please feel free to contact us at any time.

contact us:

Telegram:@ichikawa_0

You can also contact me via private message on this website.

Looking forward to hearing from you

Ichikawa Team

St_ven · 24-08-26, 12:17 PM

I'm not sure how to set the price at the moment. Please feel free to come to me for an offer.