Unnatural Keys – Nature doesn’t come with identifiers

Re:Unnatural Keys – Nature doesn’t come with identifiers by OJFord on Sunday May 28, 2023 @11:38AM (#36104988)

Which single element are they then?

Surely such a system would have a products table with something like nominal element fk, purity, mass columns anyway. (And stock table with fk to products.)

Then nothing wrong with 'natural' key on the elements, but sure, products are the thing you've (personally) made up, so of course there's no 'someone else's' key to use.

[ Parent | on HN ]

Re:Unnatural Keys – Nature doesn’t come with identifiers by TRiG_Ireland on Sunday May 28, 2023 @04:10PM (#36107308)

Diamonds and coal are both pure carbon (mostly carbon-12). So is graphite, and buckminsterfullerene, and a number of other things. Crystal structure matters a lot.

[ Parent | on HN ]

Re:Unnatural Keys – Nature doesn’t come with identifiers by OJFord on Sunday May 28, 2023 @04:48PM (#36107649)

They're not pure carbon was my point. I wasn't saying crystal structure not important, I missed that but it'd be in my 'product derived from element x' table.

[ Parent | on HN ]