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