How to put an attribute as foreign and primary key at the same time?

1

I use MySQL Workbench and I have to represent a DER in the physical model. I come across a specialization:

TABELA_PESSOA       
cpf*               
nome               
sexo            

TABELA_CLIENTE  
cpf_pessoa*             
email                   
senha                   

TABELA_FUNCIONARIO  
cpf_pessoa*  
salario  
cargo

How do I get cpf_pessoa to be a foreign key (in both tables) for TABELA_PESSOA and at the same time are primary keys in their respective tables?

    
asked by anonymous 21.10.2017 / 20:40

0 answers