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`)