title: auto_increment foreign key (postgresql )
body: <p><a href="https://i.stack.imgur.com/r48FI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r48FI.png" alt="Simple ER diagram"></a></p>
  
  <p>company(companytype) is a FOREIGN KEY in this case.</p>
  
  <p>c_type(ID) is a Primary key then it will be automaticlly incremented.
  My question is : when the c_type(ID) will be incremented , will company(companytype) be automaticlly incremented too ?</p>
  
  <p>When entering data, users are asked to select the company type, if it exists it will be used in the company table else a new one will have to be created.</p>
  
  <p>Thanks in advance</p>