market 2.0 - collection

Tables (6)

collection (collection 관련 정적 정보 저장)

  • collection id (Key) — Primary key — NOT NULL
  • collection name (Field) — varchar
  • logo image url (Field2) — varchar
  • background image url (Field11) — varchar
  • description (Field12) — varchar
  • is neith (Field3) — boolean
  • can reveal (Field13) — boolean
  • is displaying (Field8) — boolean
  • display index (Field10) — integer
  • total nfts (Field4) — integer
  • covenant date (Field5) — timestamp
  • covenant value (Field6) — integer
  • release date (Field9) — timestamp
  • collection address (Field7) — varchar

collection - flexible info (collection 관련 동적 정보 저장)

  • collection flexible id (Key) — Primary key — NOT NULL
  • collection id (Key2) — Foreign key → collection.collection id — NOT NULL
  • status (Field) — enum - UPCOMING/OFFERING 등
  • total bids (Field2) — integer
  • listed nfts (Field3) — integer
  • floor price (Field4) — integer
  • total volume (Field5) — integer
  • owners (Field6) — integer

collection - transaction info (collection 관련 거래 정보 저장)

  • collection transaction info id (Key) — Primary key — NOT NULL
  • collection id (Key2) — Foreign key → collection.collection id — NOT NULL
  • timestamp (Field) — timestamp
  • tx hash (Field2) — varchar
  • tx from (Field3) — varchar
  • tx to (Field4) — varchar
  • amount (Field5) — numeric

collection button (Untitled)

  • collection button id (Key) — Primary key — NOT NULL
  • collection id (Key2) — Foreign key → collection.collection id — NOT NULL
  • link (Field3) — varchar

collection contact (Untitled2)

  • collection contact id (Key) — Primary key — NOT NULL
  • collection id (Key2) — Foreign key → collection.collection id — NOT NULL
  • type (Field) — enum - DISCORD, PAPYRUS 등
  • link (Field2) — varchar

collection translation (Untitled3)

  • collection button translation id (Key) — Primary key — NOT NULL
  • language (Field)
  • text (Field2)
  • type (Field3)
  • target id (Field4)