CREATE TABLE “dwd_o_cust_person_day” (
“MONTH_ID” varchar(20) DEFAULT NULL COMMENT ‘月份’,
“DAY_ID” varchar(40) DEFAULT NULL COMMENT ‘日期’,
“AREA_NO” varchar(10) DEFAULT NULL COMMENT ‘地市’,
“CITY_NO” varchar(20) DEFAULT NULL COMMENT ‘区县’,
“TOWN_NO” varchar(30) DEFAULT NULL COMMENT ‘乡镇’,
“CUST_NO” varchar(40) DEFAULT NULL COMMENT ‘客户标识’,
“START_DATE” datetime DEFAULT NULL COMMENT ‘开始时间’,
“FEE” decimal(18,2) DEFAULT NULL COMMENT ‘费用’,
“PROV_ID” varchar(6) DEFAULT NULL COMMENT ‘省份’
) COMPRESS(1, 3) ENGINE=EXPRESS DISTRIBUTED BY(‘cust_no’) DEFAULT CHARSET=utf8 COMMENT=’个人客户资料表’
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/221286.html原文链接:https://javaforall.net
