我正在创建表格之间的关系,这是自动增加两列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