Collects DB

Table: collects

name	type	notes
id	String
created_at	DateTime
modified_at	DateTime?
metadata_uri	String?	Decentralised storage uri of Collect Publication's NFT item metadata
metadata_s3_uri	String	Centralised sotrage uri of Collect Publication's NFT item metadata
profile_id	String	profile_id of the 'Collector'
publication_type	PublicationType
post_id	String?	Foreign key: post_id of Post collected
comment_id	String?	Foreign key: comment_id of Comment collected
mirror_id	String?	Foreign key: mirror_id of Mirror collected
publication_collection_nft_address	String?	collect_nft_address from Post/Comment/Mirror table
contract_item_id	String? (66)
nft_token_id	String?	Integer count of NFT Item in Collected Publication's NFT Collection
nft_chain_id	Int?
block_timestamp	DateTime	Time of minting of Collect's NFT item mint
created_block_hash	String (66)	Transaction hash for Collect's NFT item minting

Unique constrains:

• profile_id + post_id must be unique in this table

• profile_id + comment_id must be unique in this table

• profile_id + mirror_id must be unique in this table

Enums

enum PublicationType {
  POST
  COMMENT
  MIRROR
}