mysql建表时错误1075_错误1075表格定义不正确;只能有一个自动列，它必须被定义为一个键...

我正在创建表格之间的关系，这是自动增加两列id_quotation和seq_quotation所必需的。列id_quotation，我引用到另一个表(tb_core_process_id_quotation)，我已经增加了它。错误1075表格定义不正确;只能有一个自动列，它必须被定义为一个键

下表(tb_core_process_customer_data)将被其他表用于捕获公共和主要客户数据。为了使这个数据库中的整个表格共有三个验证密钥：cpf_cnpj，id_quotation和seq_quotation。

tb_core_process_customer_data查询：

CREATE TABLE tb_core_process_customer_data(

cpf_cnpj VARCHAR(255) NOT NULL,

id_quotation INT NOT NULL,

seq_quotation INT NOT NULL AUTO_INCREMENT,

name VARCHAR(255),

dt_birth DATE,

cd_insurance_type INT,

PRIMARY KEY (cpf_cnpj, seq_quotation, id_quotation),

FOREIGN KEY (cd_insurance_type) REFERENCES tb_nm_insurance_type(cd_insurance_type),

FOREIGN KEY (id_quotation) REFERENCES tb_core_process_id_quotation(id_quotation)

);

tb_core_process_id_quotation查询：

CREATE TABLE tb_core_process_id_quotation(

id_quotation INT NOT NULL AUTO_INCREMENT,

PRIMARY KEY (id_quotation)

);

所以，我有困难的关系，这三个键，并让此验证。当我尝试创建tb_core_process_customer_data后续消息显示我送行：

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

2017-01-16

Aipi