| 1234567891011121314151617181920212223 |
- CREATE TABLE ap_credit_detail (
- ACD_ID VARCHAR(20) NOT NULL COMMENT '信用详情ID',
- ACD_ACI_ID VARCHAR(20) COMMENT '关联信用ID',
- ACD_ENTERPRISE VARCHAR(2) COMMENT '企业性质分',
- ACD_DURATION VARCHAR(2) COMMENT '合作年限分',
- ACD_REGISTERED_CAPITAL VARCHAR(2) COMMENT '注册资金分',
- ACD_EXPECTED_VOLUME VARCHAR(2) COMMENT '下年度预计交易量分',
- ACD_COOPERATION VARCHAR(2) COMMENT '合作顺畅度分',
- ACD_REPUTATIOM VARCHAR(2) COMMENT '行业内信誉度分',
- ACD_CREDIT_RATE VARCHAR(2) COMMENT '纳税信用等级分',
- ACD_CONTRACT_RATE VARCHAR(2) COMMENT '合同兑现率分',
- ACD_INCOME VARCHAR(2) COMMENT '年度营业收入分',
- ACD_NET VARCHAR(2) COMMENT '净资产分',
- ACD_PROFIT VARCHAR(2) COMMENT '利润率分',
- ACD_LIABILITIES_RATIO VARCHAR(2) COMMENT '资产负债率分',
- ACD_INVOICE VARCHAR(2) COMMENT '增值税发票核定票版信息分',
- ACD_BANK_CREDIT VARCHAR(2) COMMENT '银行信用等级分',
- ACD_VOLUME_PART VARCHAR(2) COMMENT '交易量分',
- ACD__VOLUME_LIST VARCHAR(2) COMMENT '交易量排名分',
- ACD_VOLUME_SCALE VARCHAR(2) COMMENT '交易量比例分',
- ACD_ALL_PART VARCHAR(5) COMMENT '总分',
- PRIMARY KEY (ACD_ID)
- ) ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='公司信用详情表';
|
