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