denarium-database/README.md at master · prasos/denarium-database
Mục lục bài viết
Official Denarium database
This is the official Denarium Bitcoin
database. The database is a single file, coin.tsv which
contains current status of all Denarium Bitcoins ever produced in
tab-separated format.
If you want to see coin details and transactions in a visual format, we also have the Denarium Database Explorer.
Provided data was automatically produced at 2021-01-05 12:47:31 UTC.
Content is signed by bitcoin address
1PrasosHejKfuRW6XgB6iYwftZQcatrMNC.
Proof of origin and existence of the data is in transaction
6ba18fab62db087823849e1371e7b38488b18895b6ea0a120106d123bf0c0799.
Verification
To verify the origin, check that the transaction originates from our bitcoin
address. To verify existence, calculate SHA256 of coin.tsv and
compare it to last bytes of OP_RETURN output of given bitcoin transaction.
There is also verify.py which does all of this
automatically. See that file for instructions.
Format
Data is separated to columns using tab (\t
) character. Character set
is ASCII. It can be easily imported to common databases and
spreadsheet editors.
Column
Description
address
Bitcoin address of the coin
serial
Serial number (L series are pre-loaded coins)
pubkey
Reserved for future use
sku
Stock keeping unit (see below)
denomination
Bitcoin value of that coin after activation
batch
Production batch code (see below)
created_at
Timestamp of coin creation (importing is done in batches so this is not the exact moment of manufacture)
status
Coin status (see below)
pubkey_2fa
Reserved for future use
txid
Funding transaction ID. (Some of the txid’s have been subject to malleability attacks)
Coin status
Status
Description
new
Successfully manufactured, not shipped yet
failed
Destroyed on the production line
sample
Random samples for quality control
shipped
Shipped but not yet activated
reported_missing
Reported as missing by customer
reported_damaged
Reported as damaged by customer
reported_ok
Reported as OK by customer
missing
Confirmed as missing
complete
Successfully activated
SKU
The X in the SKU means that the coin is sold as empty and in most cases, the serial number begins with an E. For mock-up coins, prototypes and new models we use Bitcointalk for auctioning these pieces. These coins serial number usually starts with an A.
Serial number
SERIAL
Description
A
Auction coin (unique pieces sold as Bitcointalk)
E
Sold as empty or multisig
L
Sold as loaded with bitcoins
M
Used for special multisig coins
SKU JSON
The file coin_sku.json contains all the products with their corresponding SKU names. It is useful for creating charts and other tools to the top of the Denarium Database.
Production batch code
The format is in YYYY-MM-DD-N format and is composed of year, month,
day of the production set-up. The same set-up may have been used for
multiple days. In case of multiple set-ups per a day, N is
incremented.