Make `chains.chain_id` field the primary key

[efstajas]

Currently the record has a sequential id and chain_id which is the canonical one - remove id and use chain_id as primary key

[efstajas]

• complex bc we need to migrate references to the chains table to point at the new primary keys