graphsense-transformation
graphsense-transformation copied to clipboard
Align address/cluster field names
I'd suggest to align address and cluster field names where they mean the same:
- relation tables:
value<>estimated_value - id fields:
address_id<>clusterresp.address_id_group<>cluster_group(better:cluster_idandcluster_id_group)
eth:
raw.block.block_group<>transformed.block_transactions.height_groupraw.block.number<>transformed.block_transactions.height<>raw.transaction.block_number
Just collecting things here. Need to discuss:
block_transactions.txs(a list) <>address_transactions.transaction_id(a foreign key)
cluster_tag_by_label column entity instead of cluster
Updated eth_raw https://github.com/graphsense/graphsense-ethereum-etl/commit/3e3065e12f5de927ab6cacd139b08e55d175c00e
utxo transformed schema:
CREATE TYPE tx_id_time (
block_id int,
tx_id bigint,
timestamp int
);
vs. eth transformed schema:
CREATE TYPE tx_id_time (
height int,
transaction_id int,
block_timestamp int
);
~~Please align if possible.~~ (see next comment)
I think we can remove tx_id_time at all since tx needs to be looked up anyways for the tx_hash. Instead just store tx_id for first/last_tx in address/cluster table.
address_transactions: timestamp and block_id could be removed also (like in the eth transformation).