ALTER TABLE srp_booking ADD COLUMN SEA_ROUTE_ID bigint(20) COMMENT '海运产品航线 ID'; ALTER TABLE srp_credit_management ADD COLUMN EIN_CODE varchar(32) DEFAULT 'USCC' COMMENT '企业识别号名称'; ALTER TABLE srp_credit_management ADD COLUMN CREDIT_CODE varchar(32) DEFAULT 'USCC' COMMENT '企业识别号'; ALTER TABLE srp_credit_management ADD COLUMN PERCENTILE_SCORE varchar(32) DEFAULT null COMMENT '国内企业评分'; ALTER TABLE srp_credit_management ADD COLUMN CUST_TYPE varchar(32) DEFAULT null COMMENT '客户类型'; ALTER TABLE srp_credit_management ADD COLUMN MEMBERSHIP_NETWORK varchar(128) DEFAULT null COMMENT '会员网络';
EIN_CODE
CREDIT_CODE
PERCENTILE_SCORE
CUST_TYPE
MEMBERSHIP_NETWORK
ALTER TABLE srp_booking ADD COLUMN SEA_ROUTE_ID bigint(20) COMMENT '海运产品航线 ID'; ALTER TABLE srp_credit_management ADD COLUMN
EIN_CODE
varchar(32) DEFAULT 'USCC' COMMENT '企业识别号名称'; ALTER TABLE srp_credit_management ADD COLUMNCREDIT_CODE
varchar(32) DEFAULT 'USCC' COMMENT '企业识别号'; ALTER TABLE srp_credit_management ADD COLUMNPERCENTILE_SCORE
varchar(32) DEFAULT null COMMENT '国内企业评分'; ALTER TABLE srp_credit_management ADD COLUMNCUST_TYPE
varchar(32) DEFAULT null COMMENT '客户类型'; ALTER TABLE srp_credit_management ADD COLUMNMEMBERSHIP_NETWORK
varchar(128) DEFAULT null COMMENT '会员网络';