保險行業(yè)的bi分析模型ppt26頁(編輯修改稿)
2025-03-09 14:57 本頁面
【文章內容簡介】 OR_ID pk,fk INTEGERPRODUCT_ID pk,fk INTEGERDEMO_ID pk,fk INTEGERENTY_ID pk,fk INTEGERV_E_ENTY_ID fk INTEGERCOR_EVT_TXN_SEQ_NB pk NUMBERPRD_ID fk INTEGERAMOUNT NUMBERD_CORE_EVT_TYPEVT_TYP_ID pk INTEGEREVT_TYP_SHRT_NAM VARCHAR(15)EVT_TYP_LONG_NAM VARCHAR(35)EVT_TYP_SUBTYP_NAM VARCHAR(15)D_CORE_RPT_STRCCOR_RPT_STRC_ID pk INTEGERHOLDING_COMPANY VARCHAR(35)ORG_TYPE VARCHAR(20)ORG_NAME VARCHAR(35)REGION VARCHAR(20)SALES_TEAM_TYPE VARCHAR(15)SALES_TEAM VARCHAR(15)SALES_PERSON_NAME charSALES_PERSON_GRADE CHARSALES_PERSON_TYPE CHARCHNL_CATEGORY1 char(18)CHNL_TYPE CHARCHNL_SUBCAT CHARCHNL_NAME charCHNL_CEASED_TRD_DT DATECHNL_ENTY_ID INTEGERCHNL_CITY VARCHAR(20)CHNL_POSTCODE VARCHAR(20)BEGIN_DATE_PRD_ID INTEGEREND_DATE_PRD_ID INTEGERD_GEOGRAPHYGEO_ID pk INTEGERALL_ENTRIES CHARPOSTAL_CODE CHAR VARYING(15)CITY charPOSTAL_CD_PFX char(3)HZRD_WTHR_AREA CHARHZD_WTHR_TYPE CHARDMA_CODE CHARSMSA_CODE CHARST_PROV_AREA CHARTV_REGION CHARNTL_RADIO_AREA CHARLCL_RADIO_AREA CHARREGION CHARCOUNTRY char(3)CONTINENTY_ABBR char(3)GEO_SUB_CNTNT_ABBR char(3)SMRY_EFF_DT INTEGERSMRY_END_DT INTEGERPRISN_ADRS_IND CHARD_MSR_UNITMEASURE_UNIT_ID pk INTEGERSHRT_DESC char(6)LONG_DESC char(20)D_DEMOGRAPHICSDEMO_ID pk INTEGERALL_ENTRIES CHARINCOME_BAND VARCHAR(50)AGE_BAND VARCHAR(50)GNDR CHARMRTL_STAT CHARHIGH_VALUE_INDICAT CHARACMDTN_CTGRY CHARNBR_IN_HH_BAND VARCHAR(50)CHLD_AT_HOME_BAND VARCHAR(50)SIZE_CLS CHARLEGAL_ORG_TYPE CHARNBR_EMP_BAND VARCHAR(50)SECTOR_CLS CHARMAIL_PRMSN_IND CHARTELMKT_PRMSN_IND CHARD_FNCL_SCORFNCL_SCORES_ID pk INTEGERINTERNAL_FNCL_SCOR VARCHAR(50)EXPERIAN_SCOR_BAND VARCHAR(50)SCOR_N_BAND VARCHAR(50)PRFT_IND_BAND VARCHAR(50)DEBT_INCOME_RATIO NUMBERD_LANGUAGELANGUAGE_ID pk INTEGERISO_LANG_CODE CHARISO_LANG_NAME charLANG_GROUP VARCHAR(20)D_PN_BHVR_SCORPN_BHVR_SCOR_ID pk INTEGERSCORE1_BAND VARCHAR(20)SCORE_N_BAND VARCHAR(20)D_PRODUCTPRODUCT_ID pk,fk INTEGERENTY_ID fk INTEGERPRODUCT_LINE CHARPRODUCT_GROUP CHARPRODUCT_CODE CHARPRODUCT_NAME CHARPD_VARIANT_CODE CHARPRODUCT_VARIANT VARCHAR(35)GRP_INDV_IND CHARPD_START_PRD_ID INTEGERPD_END_PRD_ID
教學課件相關推薦
鄂ICP備17016276號-1