3tree

Tables (8)

Untitled (users)

  • index — NOT NULL, UNIQUE, AUTO_INCREMENT — Primary key — NOT NULL
  • profileName (profile_name) — default: user_id(TRIGGER)
  • profile_img
  • Field (profile_bio)
  • Field (user_id) — UNIQUE
  • Field (social_id) — UNIQUE
  • Field (role)
  • Field (social_platform)
  • Field (created_at) — NOT NULL, DEFAULT current_timestamp
  • Field (language) — default "ENG" (KOR)

Untitled (link)

  • Key (index) — NOT NULL AUTO_INCREMENT — Primary key — NOT NULL
  • index (user_index) — Foreign key → Untitled.index — NOT NULL
  • Field (link_title) — NOT NULL
  • Field (link_url) — NOT NULL

Untitled (wallet)

  • Key (wallet_address) — NOT NULL, UNIQUE — Primary key — NOT NULL
  • Field (wallet_type)
  • Field (index) — NOT NULL, UNIQUE AUTO_INCREMENT

Untitled (user_wallet)

  • Key (index) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • index (user_index) — Foreign key → Untitled.index — NOT NULL
  • Key (wallet_address) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (wallet_type) — default: wallet과 동기화

Untitled (token_send_transaction)

  • Key (index) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • index (sender_user_index) — Foreign key → Untitled.index — NOT NULL
  • Field (sender_user_id)
  • Field (sender_wallet_address) — NOT NULL
  • Field (sender_token_wallet_type) — NOT NULL
  • Field (reciever_social_platform) — NOT NULL
  • Field (receiver_social_id) — NOT NULL
  • Field (receiver_wallet_address)
  • Field (receiver_token_wallet_type)
  • Field (token_udenom)
  • Field (token_amount)
  • Field (link_key) — UNIQUE
  • Field (is_expired) — DEFAULT false
  • Field (is_valid) — DEFAULT true
  • Field (transaction_gas_fee)
  • Field (transaction_hash)
  • Field (token_contract_address)
  • Field (network_id)
  • Field (transaction_escrow_id)
  • Field (created_at) — NOT NULL, DEFAULT current_timestamp
  • Field (expired_at) — trigger

Untitled (profile_decorate)

  • Key (index) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • Field (background_type) — DEFAULT "COLOR" (IMAGE)
  • Field (background_color) — DEFAULT "#ffffff"
  • Field (background_img)
  • Field (button_color) — DEFAULT "#ffffff"
  • Field (button_font_color) — DEFAULT "#000000"
  • Field (font_color) — DEFAULT "#000000"
  • index (user_id) — UNIQUE — Foreign key → Untitled.index — NOT NULL

Untitled (token_refund)

  • Key (index) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • Key (transaction_index) — not null — Foreign key → Untitled.Key — NOT NULL
  • Field (sender_user_id)
  • Field (sender_wallet_address) — not null
  • Field (sender_token_wallet_type) — not_null
  • Field (token_udenom) — not null
  • Field (token_amount) — not null
  • Field (network_id)
  • Field (exprired_at)
  • Field (refund_status) — default: unstarted, unstarted/success/fail/pending
  • Field (refund_at)
  • Field (update_at) — NOT NULL, DEFAULT CURRENT_TIMESTAMP, on update current_timestamp
  • Field (refund_transaction_hash)
  • Field (transaction_fee)
  • Field (gas_price)
  • Field (gas_limit)
  • Field (gas_used_by_txn)

Untitled (refund_bot)

  • Field (processing) — defalut false