mydata
Tables (19)
BDAY_CUST
- CUST_SEQ — BIGINT — Primary key — NOT NULL
- CUST_NM — VARCHAR(88) — NOT NULL
- CUST_ID — VARCHAR(20) — NOT NULL
- MOBILE_NO — VARCHAR(24) — NOT NULL
- EMAIL — VARCHAR(256) — NOT NULL
- BIRTH_DD — DATE — NOT NULL
- GNDR — CHAR(1) — NOT NULL
- FOREIGNER — CHAR(1) — NOT NULL
- CI — VARCHAR(88) — NOT NULL
- INVST_INCLNT_TP_CD — VARCHAR(10)
- INVST_INCLNT_TP_PNT — TINYINT
- INVST_INCLNT_RPLY_DT — DATETIME(0)
- FINCL_WEAK_CLAS_TP_CD — VARCHAR(10)
- MKT_AGR_YN — CHAR(1)
- MKT_AGR_DT — DATETIME(0)
- MKT_AGR_CHNL_LIST — VARCHAR(20)
- PRDCT_USE_AGR_YN — CHAR(1)
- PRDCT_USE_DT — DATETIME(0)
- EVT_PUSH_YN — CHAR(1)
- NIGHT_PUSH_YN — CHAR(1)
- PIN_NO — VARCHAR(60)
- PIN_NO_CRT_DT — DATETIME(0)
- PIN_NO_ERR_CNT — TINYINT
- NEW_ALM_CHK_DT — DATETIME(0)
- DEL_YN — CHAR(1) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
MD_INSU_INSURANCES
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- PROD_NAME — VARCHAR(300) — NOT NULL
- IS_CONSENT — BOOLEAN — NOT NULL
- INSU_TYPE — VARCHAR(2) — NOT NULL
- INSU_STATUS — VARCHAR(2) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_I`(`ORG_CODE`)
MD_INSU_INSURANCES_BASIC
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- IS_RENEWABLE — BOOLEAN — NOT NULL
- ISSUE_DATE — DATE — NOT NULL
- EXP_DATE — DATE — NOT NULL
- FACE_AMT — VARCHAR(21) — NOT NULL
- CURRENCY_CODE — VARCHAR(3)
- IS_VARIABLE — BOOLEAN — NOT NULL
- IS_UNIVERSAL — BOOLEAN — NOT NULL
- PENSION_RCV_START_DATE — DATE
- PENSION_RCV_CYCLE — VARCHAR(2)
- IS_LOANABLE — BOOLEAN — NOT NULL
- INSURED_CNT — INTEGER — NOT NULL
- INSURED_LIST — VARCHAR(1000) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_BASIC_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_BASIC_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_BASIC_I`(`INSU_NUM`)
MD_INSU_INSURANCES_CAR
- CAR_NUMBER — VARCHAR(17) — Primary key — NOT NULL
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- CAR_INSU_TYPE — VARCHAR(2) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- CONTRACT_AGE — VARCHAR(60) — NOT NULL
- CONTRACT_DRIVER — VARCHAR(60) — NOT NULL
- IS_OWN_DMG_COVERAGE — BOOLEAN — NOT NULL
- SELF_PAY_RATE — VARCHAR(2) — NOT NULL
- SELF_PAY_AMT — VARCHAR(15) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_CAR_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_CAR_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_CAR_I`(`INSU_NUM`)
MD_INSU_INSURANCES_CAR_TRANSACTIONS
- TRANS_DTIME — DATETIME(0) — Primary key — NOT NULL
- CAR_NUMBER — VARCHAR(17) — Primary key — NOT NULL
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- TRANS_NO — VARCHAR(64)
- FACE_AMT — VARCHAR(15) — NOT NULL
- PAID_IN_CNT — INTEGER — NOT NULL
- PAID_AMT — VARCHAR(21) — NOT NULL
- PAY_METHOD — VARCHAR(2) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_CAR_TRANSACTIONS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_CAR_TRANSACTIONS_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_CAR_TRANSACTIONS_I`(`INSU_NUM`)
MD_INSU_INSURANCES_CONSTRACTS
- CONSTRACT_NAME — VARCHAR(300) — Primary key — NOT NULL
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- CONTRACT_STATUS — VARCHAR(2) — NOT NULL
- CONTRACT_EXP_DATE — DATE — NOT NULL
- CONTRACT_FACE_AMT — VARCHAR(21) — NOT NULL
- CURRENCY_CODE — VARCHAR(3)
- IS_REQUIRED — BOOLEAN — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_CONSTRACTS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_CONSTRACTS_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_CONSTRACTS_I`(`INSU_NUM`)
MD_INSU_INSURANCES_COVERAGES
- COVERAGE_NUM — VARCHAR(20) — Primary key — NOT NULL
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- SUBJECT — VARCHAR(1) — NOT NULL
- RELATION — VARCHAR(2) — NOT NULL
- STATUS — VARCHAR(2) — NOT NULL
- COVERAGE_CODE — VARCHAR(5) — NOT NULL
- TYPE — VARCHAR(1)
- COVERAGE_NAME — VARCHAR(300) — NOT NULL
- COVERAGE_AMT — VARCHAR(10) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_COVERAGES_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_COVERAGES_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_COVERAGES_I`(`INSU_NUM`)
MD_INSU_INSURANCES_PAYMENT
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- PAY_DUE — VARCHAR(2) — NOT NULL
- PAY_CYCLE — VARCHAR(2) — NOT NULL
- PAY_CNT — INTEGER — NOT NULL
- PAY_ORG_CODE — VARCHAR(8)
- PAY_DATE — DATE
- PAY_END_DATE — DATE — NOT NULL
- PAY_AMT — VARCHAR(21) — NOT NULL
- CURRENCY_CODE — VARCHAR(3)
- IS_AUTO_PAY — BOOLEAN — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_PAYMENT_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_PAYMENT_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_INSURANCES_TO_MD_INSU_INSURANCES_PAYMENT_I`(`INSU_NUM`)
MD_INSU_INSURANCES_TRANSACTIONS
- INSU_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- RSP_CODE — VARCHAR(5) — NOT NULL
- RSP_MSG — VARCHAR(450) — NOT NULL
- TRANS_DTIME — DATE — NOT NULL
- TRANS_NO — VARCHAR(64)
- TRANS_TYPE — VARCHAR(2) — NOT NULL
- TRANS_AMT — VARCHAR(15) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_INSURANCES_TRANSACTIONS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_INSURANCES_TRANSACTIONS_I`(`ORG_CODE`)
- INDEX — `FK_MD_INVEST_INSURANCES_TO_MD_INVEST_INSURANCES_TRANSACTIONS_I`(`INSU_NUM`)
MD_INSU_IRPS
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- PROD_NAME — VARCHAR(300) — NOT NULL
- IS_CONSENT — BOOLEAN — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_IRPS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_IRPS_I`(`ORG_CODE`)
MD_INSU_IRPS_BASIC
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- RSP_CODE — VARCHAR(5) — NOT NULL
- RSP_MSG — VARCHAR(450) — NOT NULL
- ACCUM_AMT — VARCHAR(21) — NOT NULL
- EVAL_AMT — VARCHAR(21) — NOT NULL
- EMPLOYER_AMT — VARCHAR(21) — NOT NULL
- EMPLOYEE_AMT — VARCHAR(21) — NOT NULL
- ISSUE_DATE — DATE — NOT NULL
- FIRST_DEPOSIT_DATE — DATE
- REG_DATE — DATE
- RVC_START_DATE — DATE
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_IRPS_BASIC_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_IRPS_I_BASIC_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_IRPS_TO_MD_INSU_IRPS_BASIC_I`(`ACCOUNT_NUM`)
MD_INSU_IRPS_DETAIL
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- RSP_CODE — VARCHAR(5) — NOT NULL
- RSP_MSG — VARCHAR(450) — NOT NULL
- IRP_NAME — VARCHAR(300) — NOT NULL
- IRP_TYPE — VARCHAR(2) — NOT NULL
- EVAL_AMT — VARCHAR(21) — NOT NULL
- INV_PRINCIPAL — VARCHAR(21) — NOT NULL
- FUND_NUM — VARCHAR(21)
- OPEN_DATE — DATE
- EXP_DATE — DATE
- INT_RATE — VARCHAR(5)
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_IRPS_DETAIL_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_IRPS_DETAIL_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_IRPS_TO_MD_INSU_IRPS_DETAIL_I`(`ACCOUNT_NUM`)
MD_INSU_IRPS_TRANSACTIONS
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- RSP_CODE — VARCHAR(5) — NOT NULL
- RSP_MSG — VARCHAR(450) — NOT NULL
- TRANS_DTIME — DATE — NOT NULL
- TRANS_NO — VARCHAR(64)
- TRANS_TYPE — VARCHAR(2) — NOT NULL
- TRANS_AMT — VARCHAR(15) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_IRPS_TRANSACTIONS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_IRPS_TRANSACTIONS_I`(`ORG_CODE`)
- INDEX — `FK_MD_INVEST_IRPS_TO_MD_INVEST_IRPS_TRANSACTIONS_I`(`ACCOUNT_NUM`)
MD_INSU_LOANS
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- PROD_NAME — VARCHAR(300) — NOT NULL
- IS_CONSENT — BOOLEAN — NOT NULL
- ACCOUNT_TYPE — VARCHAR(4) — NOT NULL
- ACCOUNT_STATUS — VARCHAR(2) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_LOANS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_LOANS_I`(`ORG_CODE`)
MD_INSU_LOANS_BASIC
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- LOAN_START_DATE — DATE — NOT NULL
- LOAN_EXP_DATE — DATE — NOT NULL
- REPAY_METHOD — VARCHAR(2) — NOT NULL
- INSU_NUM — VARCHAR(20)
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_LOANS_BASIC_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_LOANS_BASIC_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_LOANS_TO_MD_INSU_LOANS_BASIC_I`(`ACCOUNT_NUM`)
MD_INSU_LOANS_DETAIL
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- BALANCE_AMT — VARCHAR(21) — NOT NULL
- LOAN_PRINCIPAL — VARCHAR(21) — NOT NULL
- NEXT_REPAY_DATE — DATE — NOT NULL
- CURRENCY_CODE — VARCHAR(3)
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_LOANS_DETAIL_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_LOANS_DETAIL_I`(`ORG_CODE`)
- INDEX — `FK_MD_INSU_LOANS_TO_MD_INSU_LOANS_DETAIL_I`(`ACCOUNT_NUM`)
MD_INSU_LOANS_TRANSACTIONS
- TRANS_DTIME — DATETIME(0) — Primary key — NOT NULL
- ACCOUNT_NUM — VARCHAR(20) — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- TRANS_NO — VARCHAR(20)
- LOAN_PAID_AMT — VARCHAR(21) — NOT NULL
- INT_PAID_AMT — VARCHAR(21) — NOT NULL
- INT_LIST — VARCHAR(2000)
- CURRENCY_CODE — VARCHAR(3)
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_INSU_LOANS_TRANSACTIONS_I`(`CUST_SEQ`)
- INDEX — `FK_MD_ORGS_TO_MD_INSU_LOANS_TRANSACTIONS_I`(`ORG_CODE`)
- INDEX — `FK_MD_INVEST_LOANS_TO_MD_INVEST_LOANS_TRANSACTIONS_I`(`ACCOUNT_NUM`)
MD_ORGS
- ORG_CODE — VARCHAR(10) — Primary key — NOT NULL
- ORG_NAME — VARCHAR(60)
- OP_TYPE — VARCHAR(1) — NOT NULL
- ORG_TYPE — VARCHAR(2) — NOT NULL
- IS_RCV_ORG — BOOLEAN
- ORG_REGNO — VARCHAR(12)
- CORP_REGNO — VARCHAR(13)
- SERIAL_NO — VARCHAR(20)
- ADDRESS — VARCHAR(150)
- DOMAIN — VARCHAR(70)
- DOMAIN_IP_CNT — INTEGER
- DOMAIN_IP_LIST — VARCHAR(1000)
- RELAY_ORG_CODE — VARCHAR(10)
- INDUSTRY — VARCHAR(10)
- AUTH_TYPE — VARCHAR(2)
- CERT_ISSUER_DN — VARCHAR(15)
- CERT_OID — VARCHAR(300)
- IP_CNT — INTEGER
- IP_LIST — VARCHAR(1000)
- NP_TIME_CNT — INTEGER
- NP_TIME_LIST — VARCHAR(1000)
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
MD_USER_AUTH_TOKEN
- TOKEN_SEQ — INTEGER — Primary key — NOT NULL
- CUST_SEQ — INTEGER — Primary key — NOT NULL
- CUST_SEQ (CUST_SEQ2) — BIGINT — Foreign key → BDAY_CUST.CUST_SEQ — NOT NULL
- TX_ID — VARCHAR(74)
- ORG_CODE — VARCHAR(10) — NOT NULL
- TYPE — VARCHAR(10) — NOT NULL
- GRANT_TYPE — VARCHAR(20) — NOT NULL
- TOKEN_TYPE — VARCHAR(6) — NOT NULL
- ACCESS_TOKEN — VARCHAR(1500) — NOT NULL
- EXPIRES_IN — INTEGER — NOT NULL
- REFRESH_TOKEN — VARCHAR(1500) — NOT NULL
- RE_TKN_EXP_IN — INTEGER — NOT NULL
- SCOPE — VARCHAR(500) — NOT NULL
- CRT_ID — VARCHAR(20) — NOT NULL
- CRT_DT — DATETIME(0) — NOT NULL
- MDF_ID — VARCHAR(20) — NOT NULL
- MDF_DT — DATETIME(0) — NOT NULL
- INDEX — `FK_BDAY_CUST_TO_MD_USER_INTG_AUTH_TOKEN_I`(`CUST_SEQ`)