[Pulp-dev] 'id' versus 'pulp_id' on Content

[Jeff Ortel]

On 06/08/2018 02:57 PM, Brian Bouterse wrote:
>
> @jortel: We're blocked on your -1 vote expressed for 3704. We have 
> practical plugin writer issues with the current state. Can you 
> elaborate on why we shouldn't go forward with 
> https://pulp.plan.io/issues/3704

The 'ID' column is reserved for the primary key and is inappropriate for 
natural keys.  This is well establish convention and best practice.  
Plugin writers specify natural keys.  Also, by introducing '_' prefix 
(or any prefix) means a table could have both 'ID' and '_ID' columns 
which is especially confusing since the 'ID' column would not be the 
primary key.

How does naming the natural key for an rpm as 'rpm_id' cause a 
significant problem for plugin writers?

@bmbouters: just curious, where does the rpm 'id' come from and how is 
it used differently than the NEVREA composite natural key.