I have a data field "Shipment ID" which is a
VARCHAR(18) from a number of different vendors. This is going into a table
shipment with a surrogate PK
I'm trying to figure out the best way to name this column. Our conventions say:
- Only PKs or FKs can end in
- PKs are
tablename_id. So a table
hello_worldwould have a PK of
- table and columns are
- nothing about name collisions (if I get a good answer here, I'll make sure it's added to the style guide.)
I know it doesn't follow this awesome answer, but that's what we've got
I can't use the "Shipment ID" field as a PK because it's not guaranteed to be unique or even exist. Plus it is a string and I am not a fan of string PKs.
I don't really like
vendor_shipment_id. What do you guys use in cases like this?