galactic-ERD

Tables (15)

approval

  • id — bigint — Primary key — NOT NULL
  • blocknumber — bigint
  • tx_hash — varchar
  • event — varchar
  • owner — varchar
  • operator — varchar
  • approved — varchar
  • ca — varchar
  • token_id — varchar
  • blocktime — TIMESTAMP

asset

  • id — bigint — Primary key — NOT NULL
  • uuid_asset — varchar
  • creator_address — varchar
  • owner_address — varchar
  • contract_address — varchar
  • token_id — varchar
  • token_num — bigint
  • blockchain — varchar
  • network_id — varchar
  • name — varchar
  • asset_blockchain — INT
  • type — bigint
  • asset_type — varchar
  • supply — bigint
  • quantity — bigint
  • init_count — bigint
  • uri_metadata — varchar
  • royalty_fee — INT
  • royalty_payout_address — varchar
  • is_freeze — INT
  • is_mint — INT
  • type_put_market — INT
  • category — varchar
  • service_fee — DOUBLE
  • is_royalty_register — TEXT
  • is_fees_register — TEXT

asset_metadata

  • id — bigint — Primary key — NOT NULL
  • asset_id — bigint — Foreign key → asset.id — NOT NULL
  • image_url — TEXT
  • name — TEXT
  • external_link — TEXT
  • description — TEXT
  • image_preview_url — TEXT
  • image_thumbnail_url — TEXT
  • image_original_url — TEXT
  • animation_url — TEXT
  • animation_original_url — TEXT
  • uri_metadta — TEXT
  • is_freeze — INT

buy_request

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • market_id — bigint — Foreign key → market.id — NOT NULL
  • id (id2) — bigint — Foreign key → market.asset_id — NOT NULL
  • uuid_buy — varchar
  • token_id — varchar
  • contract_address — varchar
  • tx_id — varchar
  • buy_count — bigint
  • request_status — INT
  • order_recipt — TEXT
  • order_signature — varchar

event_history

  • id — bigint — Primary key — NOT NULL
  • contract_address — varchar
  • token_id — varchar
  • event — varchar
  • price — DOUBLE
  • from_address — varchar
  • to_address — varchar
  • order_recipt — TEXT
  • order_signature — varchar
  • market_id — bigint

exchange

  • id — bigint — Primary key — NOT NULL
  • blocknumber — bigint
  • tx_hash — varchar
  • event — varchar
  • buyer — varchar
  • seller — varchar
  • token_id — varchar
  • value — varchar
  • token_type — varchar
  • royalty — varchar
  • royalty_recipient — varchar
  • fee — varchar
  • actual_amount — varchar
  • price — varchar
  • blocktime — TIMESTAMP
  • is_check — INT

fail_exchange

  • id — bigint — Primary key — NOT NULL
  • blocknumber — bigint
  • tx_hash — varchar
  • status — varchar
  • signer — varchar
  • contract_address — varchar
  • cancel_payment — varchar
  • blocktime — TIMESTAMP

fail_mint

  • id — bigint — Primary key — NOT NULL
  • blocknumber — bigint
  • tx_hash — varchar
  • status — varchar
  • signer — varchar
  • contract_address — varchar
  • blocktime — TIMESTAMP

market

  • id — bigint — Primary key — NOT NULL
  • asset_id — bigint — Foreign key → asset.id — NOT NULL
  • uuid_market — varchar
  • contract_address — varchar
  • token_id — varchar
  • is_display — INT
  • price — DOUBLE
  • token_type — varchar
  • asset_type — varchar
  • market_type — INT
  • price_reserve — DOUBLE
  • minimum_bid — DOUBLE
  • type_trade — INT
  • category — varchar
  • supply — bigint
  • quantity — bigint
  • is_end — INT
  • start_at — TIMESTAMP
  • expiration_date — TIMESTAMP
  • order_recipt — TEXT
  • order_signature — varchar
  • seller_address — varchar
  • tx_id — varchar

mint

  • id — bigint — Primary key — NOT NULL
  • tx_hash — varchar
  • blocknumber — bigint
  • event — varchar
  • from_address — varchar
  • to_address — varchar
  • token_id — varchar
  • token_amount — varchar
  • token_type — varchar
  • token_supply — varchar
  • blocktime — TIMESTAMP

personal_access_tokens

  • id — bigint — Primary key — NOT NULL
  • tokenable_type — varchar
  • tokenable_id — bigint
  • name — varchar
  • token — varchar
  • nonce — varchar
  • abilities — TEXT
  • last_used_at — TIMESTAMP

premium_market_lists

  • id — bigint — Primary key — NOT NULL
  • sell_list_id — bigint — Foreign key → premium_sell_lists.id — NOT NULL
  • market_id — bigint — Foreign key → market.id — NOT NULL
  • uuid_premium — varchar
  • is_premium_display — INT

premium_sell_lists

  • id — bigint — Primary key — NOT NULL
  • collection_name — varchar
  • comment — TEXT
  • is_display — INT
  • is_sell — INT
  • external_link — TEXT
  • animation_url — TEXT
  • company_banner_image_url — TEXT
  • company_name — varchar
  • company_profile_image — TEXT
  • company_email — varchar
  • company_bio — TEXT
  • is_enable — INT

user_profile

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • user_name — varchar
  • user_bio — TEXT
  • user_email — varchar
  • image_banner — varchar
  • image_profile — varchar

users

  • id — bigint — Primary key — NOT NULL
  • wallet_address — varchar
  • blockchain — varchar
  • uuid_user — varchar
  • is_certified — INT
  • is_company — INT