Tokyo_MongZ

Tables (23)

environment_variable

  • Index — int — Primary key — NOT NULL
  • desc — varchar(100)
  • variableType — int
  • value — varchar(100)
  • comment — varchar(255)
  • environment — varchar(10)

tbl_access_list

  • account_address — varchar(255) — Primary key — NOT NULL
  • access_type — char(1) — Primary key — NOT NULL
  • register_datetime — datetime — NOT NULL
  • register_date — date
  • mint_count — varchar(45) — NOT NULL

tbl_account

  • account — varchar(255) — Primary key — NOT NULL
  • chainId — varchar(255) — Primary key — NOT NULL
  • connector — varchar(100)
  • library — varchar(255)
  • active — varchar(10)
  • error — varchar(500)
  • activate — varchar(100)
  • deactivate — varchar(100)
  • is_whitelist — char(1)
  • is_migration_holder — char(1)
  • register_datetime — datetime — NOT NULL
  • register_date — date — NOT NULL
  • update_datetime — datetime — NOT NULL
  • update_date — date — NOT NULL
  • admin_user — varchar(50)
  • minted_count — int — NOT NULL
  • reveal_count — int — NOT NULL
  • register_utc_datetime — datetime
  • login_root — varchar(10)

tbl_account_wallet_history

  • account_address — varchar(255) — Primary key — NOT NULL
  • wallet_tx_hash — varchar(255) — Primary key — NOT NULL
  • transaction_id — varchar(255) — Primary key — NOT NULL
  • tx_block_number — bigint — Primary key — NOT NULL
  • source_wallet_address — varchar(255)
  • tx_value — decimal(40,18) — NOT NULL
  • tx_time — bigint — NOT NULL
  • register_datetime — datetime — NOT NULL
  • register_date — date
  • register_utc_datetime — datetime

tbl_admin_account

  • admin_id — varchar(50) — Primary key — NOT NULL
  • admin_password — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • register_datetime — datetime — NOT NULL
  • register_date — date — NOT NULL

tbl_airdrop

  • seq — int — Primary key — NOT NULL
  • token_id — int — NOT NULL — 토큰아이디
  • to_address — varchar(255) — 홀더 지갑 주소
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime

tbl_migration_history

  • seq — int — Primary key — NOT NULL
  • from_address — varchar(255)
  • to_address — varchar(255)
  • token_id — int
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime
  • hash — varchar(255)

tbl_migration_try_history

  • seq — int — Primary key — NOT NULL
  • plt_address — varchar(255)
  • metamask_address — varchar(255)
  • token_id — int
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime
  • try_type — varchar(30)

tbl_mint_history

  • seq — int — Primary key — NOT NULL
  • transaction_hash — varchar(255)
  • transaction_index — int
  • block_hash — varchar(255)
  • block_number — int
  • from_address — varchar(255)
  • to_address — varchar(255)
  • gas_used — int
  • cumulative_gas_used — int
  • contract_address — varchar(255)
  • status — varchar(10)
  • logs_bloom — varchar(4000)
  • log_type — varchar(10)
  • nft_count — int
  • register_datetime — datetime — NOT NULL
  • confirm_datetime — datetime
  • register_utc_datetime — datetime

tbl_mint_info

  • seq — int — Primary key — NOT NULL
  • mint_start_datetime — datetime — NOT NULL
  • whitelist_mint_start_datetime — datetime — NOT NULL
  • whitelist_mint_end_datetime — datetime — NOT NULL
  • public_mint_start_datetime — datetime — NOT NULL
  • public_mint_end_datetime — datetime — NOT NULL
  • mint_end_datetime — datetime — NOT NULL
  • register_datetime — datetime — NOT NULL
  • total_mint_count — int — NOT NULL
  • sales_nft_count — int
  • reveal_allow — char(1) — NOT NULL
  • nft_display_allow — varchar(45) — NOT NULL

tbl_reveal_history

  • seq — int — Primary key — NOT NULL
  • from_address — varchar(255)
  • to_address — varchar(255)
  • token_id — varchar(255)
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime
  • hash — varchar(255) — NFT 전송 해시
  • transaction_hash — varchar(255) — 결제 해시

tbl_search_history

  • page — int
  • pagesize — int
  • addr — varchar(255)
  • search_type — varchar(30)
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime

tbl_send_error

  • seq — int — Primary key — NOT NULL
  • error_message — text
  • register_datetime — datetime — NOT NULL
  • register_utc_datetime — datetime

tbl_start_eth_transaction_history

  • affected_rows — int
  • transaction_index — int
  • insert_id — int
  • info — int
  • server_status — int
  • warning_status — int
  • register_utc_datetime — datetime
  • register_datetime — datetime

tbl_tmhc_tokeninfo

  • etoken_id — int — NOT NULL — 전체 Index
  • cardpack_id — varchar(100)
  • PLT_token_id — int — PLT Index
  • is_receive — char(1) — N-전송되지 않음\nY-전송완료\nP-전송완료대기
  • wallet_address — varchar(255) — 전송 또는 전송대기 중인 지갑 주소
  • receive_datetime — datetime — NOT NULL
  • receive_utc_datetime — datetime — NOT NULL
  • webhook_complete — varchar(45) — webhook2를 통해서 confirm을 저장
  • transaction_hash — varchar(255) — 결제에 대한 트랜젝션 해시
  • send_transaction_hash — varchar(255) — 전송에 대한 transaction_hash

tmhc-e1tmhc-status

  • idx — int — Primary key — NOT NULL
  • token_address — varchar(50)
  • token_id — int
  • owner_of — varchar(50)
  • block_number — int
  • block_number_minted — int
  • token_hash — varchar(50)
  • amount — int
  • contract_type — varchar(50)
  • name — varchar(50)
  • symbol — varchar(50)
  • token_uri — varchar(128)
  • metadata — varchar(1024)
  • last_token_uri_sync — varchar(50)
  • last_metadata_sync — varchar(50)
  • minter_address — varchar(50)

tmhc-e1tmhc-txinfo

  • index — int — Primary key — NOT NULL
  • createdAt — varchar(50)
  • gasfee — decimal(30,20)
  • pToken_ID — int
  • eToken_ID — int
  • PLTWalletAddress — varchar(50)
  • PLTContract — varchar(100)
  • PLTHash — varchar(100)
  • ETHHash — varchar(100)

tmhc-history

  • index — int — Primary key — NOT NULL
  • createdAt — varchar(50)
  • tokenId — int
  • value — decimal(30,20)
  • fromAddress — varchar(50)
  • toAddress — varchar(50)
  • blockNum — int
  • hash — varchar(128)
  • contractAddr — varchar(100)
  • networkType — varchar(100)

tmhc-info

  • token_id — int — Primary key — NOT NULL
  • token_id_hex — varchar(50)
  • ipfs_url — varchar(128)
  • name — varchar(50)
  • url — varchar(128)
  • info — varchar(560)
  • card_pack_id — varchar(50)
  • PLT_token_id — varchar(100)
  • BACK — varchar(50)
  • BODY — varchar(50)
  • CLOTHES — varchar(50)
  • EARRING — varchar(50)
  • EYEWEAR — varchar(50)
  • FACE — varchar(50)
  • HEAD — varchar(50)
  • MOUTH — varchar(50)
  • NECK_ACCESSORIES — varchar(50)
  • BACKGROUND — varchar(50)
  • FromAddress — varchar(50)
  • SentAddress — varchar(50)

tmhc-payment-history

  • index — int — Primary key — NOT NULL
  • createdAt — varchar(50)
  • status — text
  • nftCount — int
  • value — decimal(30,20)
  • fromAddress — varchar(50)
  • toAddress — varchar(50)
  • blockNum — int
  • hash — varchar(128)

tmhc-token-history

  • index — int — Primary key — NOT NULL
  • createdAt — varchar(50)
  • eToken_ID — text
  • ETHWalletAddress — varchar(50)
  • ETHHash — varchar(100)

tmhc_backupJSON

  • index — int — Primary key — NOT NULL
  • createdAt — varchar(50)
  • log — json

tmhc_tmp

  • salesCount — int