gbase建表模板

建表模板

CREATE TABLE "off_net" (
  "TIME_DAY" datetime DEFAULT NULL,
  "CALLING_DN" varchar(50) DEFAULT NULL,
  "CALLED_DN" varchar(50) DEFAULT NULL,
  "CONN_TIME" float DEFAULT NULL,
  "CALL_ALL_NUM" bigint(20) DEFAULT NULL,
  "NO_CALLEDBACK" decimal(10,0) DEFAULT NULL,
  "USER_COUNT" decimal(10,0) DEFAULT NULL,
  "CALL_BACK" decimal(10,0) DEFAULT NULL,
  "AREA_NAME" varchar(200) DEFAULT NULL,
  "MKT_AREA_NAME" varchar(200) DEFAULT NULL,
  "CUST_AGE" bigint(20) DEFAULT NULL,
  "CUST_TYPE_NAME" varchar(16) DEFAULT NULL,
  "VIP_LEVEL_NAME" varchar(16) DEFAULT NULL,
  "INNET_datetime" datetime DEFAULT NULL,
  "EFF_datetime" datetime DEFAULT NULL,
  "EXP_datetime" datetime DEFAULT NULL,
  "PROD_OFFER_NAME" varchar(255) DEFAULT NULL,
  "CHARGE" decimal(10,0) DEFAULT NULL,
  "PROD_ADDR" varchar(255) DEFAULT NULL,
  "CALL_RESPON_NUM" bigint(20) DEFAULT NULL
) COMPRESS(5, 5)  ENGINE=EXPRESS REPLICATED  DEFAULT CHARSET=utf8 TABLESPACE='bigdata' 

COMPRESS(5, 5)  压缩比

REPLICATED  复制表

CHARSET=utf8 字符编码

TABLESPACE='bigdata' 指定表空间