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