DTU-Wallet_Admin
Tables (37)
admin_user
- IDX — int(11) — Primary key — NOT NULL
- USER_ID — varchar(32) — NOT NULL
- PASSWORD — varchar(64) — NOT NULL
- NAME — varchar(32)
- SUPER_ADMIN — tinyint(4)
- CREATE_DATE — datetime
- IP_ADDRESS — varchar(45) — NOT NULL
- MOBILE — varchar(16)
- EMAIL — varchar(45)
- OTP_KEY — varchar(256)
- OTP_URL — varchar(512)
- OTP_VERIFIED — tinyint(4)
- SECURITY — char(10)
admin_user_auth
- ADMIN_USER_IDX — int(11) — Primary key — NOT NULL
- MENU_IDX — int(11) — Primary key — NOT NULL
- AUTH — tinyint(4)
air_drop_log
- IDX — int(11) — Primary key — NOT NULL
- ADMIN_ID — varchar(32) — NOT NULL
- TYPE — varchar(20) — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- ADDRESS — varchar(160) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- MEMO — varchar(256)
- CREATE_DATE — datetime — NOT NULL
- TX_ID — varchar(128)
- STATUS — varchar(12)
- REQ_IDX — int(11)
- FEE — bigint(20)
audit_admin
- IDX — int(11) — Primary key — NOT NULL
- ADMIN — varchar(32) — NOT NULL
- ACTION — varchar(32) — NOT NULL
- REQUEST — varchar(256) — NOT NULL
- RESULT — varchar(32) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
audit_user
- IDX — int(11) — Primary key — NOT NULL
- USER_IDX — int(11) — NOT NULL
- ACTION — varchar(32) — NOT NULL
- REQUEST — varchar(256) — NOT NULL
- RESULT — varchar(128) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- MESSAGE — varchar(45)
audit_virtual_account
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- ORG_IDX — int(11) — NOT NULL
- ADDRESS — varchar(64) — NOT NULL
- CREATE_DATE — datetime
balance
- ADDRESS — varchar(160) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- BALANCE — bigint(20) — NOT NULL
- BLOCK — bigint(20) — NOT NULL
- FIRST_FLAG — tinyint(4) — NOT NULL
banner
- IDX — int(11) — Primary key — NOT NULL
- POSITION — int(11) — NOT NULL
- URL — varchar(256) — NOT NULL
- IMAGE — char(36) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4) — NOT NULL
- START_DATE — datetime — NOT NULL
- EXPIRE_DATE — datetime — NOT NULL
blockchain
- IDX — int(11) — Primary key — NOT NULL
- RANK — int(11)
- CATEGORY — varchar(8) — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- SYMBOL — varchar(8) — NOT NULL
- NAME — int(11) — NOT NULL
- IMAGE — text — NOT NULL
- PRICE — int(11) — NOT NULL
- CONTRACT — varchar(64)
- ABI — text
- ESTIMATION_GAS — int(11)
- DECIMAL — int(11)
- DELETED — tinyint(4)
coin
- SERIAL_NUM — char(20) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- ADDRESS — varchar(160) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- OCTET_IDX — int(11)
coin_node_info
- COIN_TYPE — int(11) — Primary key — NOT NULL
- API_ID — varchar(45)
- API_KEY — varchar(45)
- NODE_URL — varchar(45)
- CHAIN_ID — varchar(45)
- BLOCK_HEIGHT — bigint(20)
faq
- IDX — int(11) — Primary key — NOT NULL
- TITLE_IDX — int(11) — NOT NULL
- CONTENT_IDX — int(11) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4)
- READ — int(11)
fee_wallet
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- ADDRESS — varchar(160) — NOT NULL
- SEED — varchar(160)
- MEMO — varchar(128)
- ACTIVE — tinyint(4)
- DELETED — tinyint(4)
- CREATE_DATE — datetime
- BLOCK — bigint(20)
- UPDATE_DATE — varchar(45)
file
- ID — char(36) — Primary key — NOT NULL
- PATH — varchar(128) — NOT NULL
- FILE_NAME — varchar(64) — NOT NULL
- FILE_NAME_ORG — varchar(64) — NOT NULL
- FILE_TYPE — varchar(16) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4) — NOT NULL
foundation
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- PRICE — double
- BALANCE — bigint(20) — NOT NULL
- DESCRIPTION — varchar(1024)
- WEBSITE_LINK — varchar(160)
- WHITEPAPER_LINK — varchar(160)
- COMMUNITY_LINK — varchar(160)
- COUNTRY — varchar(32)
- CREATE_DATE — datetime
- USE_PRICE — tinyint(4) — NOT NULL
- MARKET_CAP — bigint(20)
- DELETED — tinyint(4) — NOT NULL
- FOUNDATION_BALANCE — bigint(20) — NOT NULL
- STABLE_FLAG — tinyint(4) — NOT NULL
image
- IDX — int(11) — Primary key — NOT NULL
- TYPE — varchar(16) — NOT NULL
- REF_IDX — int(11) — NOT NULL
- PHOTO — char(36) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4) — NOT NULL
- SUB_PHOTO — char(36)
menu
- IDX — int(11) — Primary key — NOT NULL
- NAME — varchar(32) — NOT NULL
- NAME_KR — varchar(32) — NOT NULL
- PATH — varchar(128)
- PARENT_IDX — int(11)
message
- IDX — int(11) — Primary key — NOT NULL
- LANGUAGE — varchar(8) — Primary key — NOT NULL
- CONTENT — text
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4) — NOT NULL
notice
- IDX — int(11) — Primary key — NOT NULL
- CATEGORY — char(8) — NOT NULL
- TITLE_IDX — int(11) — NOT NULL
- CONTENT_IDX — int(11) — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- DELETED — tinyint(4) — NOT NULL
- MAIN — tinyint(4) — NOT NULL
- READ — int(11)
organization
- IDX — int(11) — Primary key — NOT NULL
- PARENT_IDX — int(11)
- USER_IDX — int(11) — NOT NULL
- NAME — varchar(32) — NOT NULL
- BUSINESS_NUM — varchar(32)
- LOCATION_ADDRESS — varchar(256)
- LOCATION_ADDRESS_DETAIL — varchar(256)
- LOCATION_POINT — varchar(32)
- MEMO — varchar(256)
- FRANCHISE — tinyint(4)
- AUTO_ADJUSTMENT — tinyint(4)
- FEE_RATIO — double
- SHARE_RATIO_1 — double
- SHARE_RATIO_2 — double
- INTERFACE_URI — varchar(128)
- REDIRECT_URI — varchar(128)
- EXTERNAL_KEY — varchar(64)
- THUMBNAIL — char(36)
- IMAGE — char(36)
- CREATE_DATE — datetime
- DELETED — tinyint(4)
- ATTRACT_FRAN_PAID — tinyint(4)
- ATTRACT_FRAN_PAID_DATE — datetime
- CLASSIFICATION — int(11)
- ETC — varchar(256)
- OPEN_TIME — varchar(256)
payment_cancel_request
- IDX — int(11) — Primary key — NOT NULL
- REQ_IDX — int(11)
- TX_ID — varchar(128)
- STATUS — varchar(45)
- CREATE_DATE — datetime
- DELETED — tinyint(4)
payment_log
- IDX — int(11) — Primary key — NOT NULL
- ORGANIZATION_IDX — int(11)
- USER_IDX — int(11)
- COIN_TYPE — int(11) — NOT NULL
- AMOUNT — bigint(20)
- PAY_COIN_TYPE — int(11)
- PAY_AMOUNT — bigint(20)
- UNIT_PRICE — double
- PRICE — double
- PAYBACK_COIN_TYPE — int(11)
- PAYBACK_METHOD — varchar(8)
- PAYBACK_RATIO — double
- PAYBACK_AMOUNT — bigint(20)
- CANCELED — tinyint(4)
- CANCEL_DATE — datetime
- CREATE_DATE — datetime
- PAY_TYPE — varchar(12)
- VRITUAL_ACCOUNT_IDX — int(11)
- STATUS — varchar(12)
- ORDER_ID — varchar(45)
- MEMO — varchar(256)
- TX_ID — varchar(128)
- FEE — bigint(20)
payment_setting
- ORGANIZATION_IDX — int(4) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- PAY_COIN_TYPE — int(11)
- PAYBACK_COIN_TYPE — int(11)
- PAYBACK_METHOD — varchar(8)
- PAYBACK_RATIO — double
- UPDATE_DATE — datetime
- CREATE_DATE — datetime
- DELETED — tinyint(4)
real_fee
- COIN_TYPE — int(11) — Primary key — NOT NULL
- FEE — bigint(20)
serial
- SERIAL — char(20) — Primary key — NOT NULL
- PRIVATE_KEY_HASH — char(64)
- PHONE — varchar(16)
- PHONE_VERIFIED — tinyint(4)
- EMAIL — varchar(64)
- EMAIL_VERIFIED — tinyint(4)
- VERIFY_TOKEN — varchar(64)
- TYPE — varchar(8)
- PUSH_TOKEN — varchar(256)
- SECURITY — char(10)
- MEMO — varchar(256)
- CREATE_DATE — datetime
- DELETED — tinyint(4)
service_status
- IDX — int(11) — Primary key — NOT NULL
- TYPE — varchar(45) — NOT NULL
- SERVICE — varchar(45) — NOT NULL
- STATUS — varchar(45) — NOT NULL
- MEMO — varchar(200)
stat_payment
- STAT_DATE — varchar(8) — Primary key — NOT NULL
- ORGANIZATION_IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- COUNT — int(11) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- PRICE — double — NOT NULL
- UNIT_PRICE — double — NOT NULL
- STATUS — varchar(8) — NOT NULL
stat_payment_month
- STAT_DATE — varchar(8) — Primary key — NOT NULL
- ORGANIZATION_IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- COUNT — int(11) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- PRICE — double — NOT NULL
- UNIT_PRICE — double — NOT NULL
- STATUS — varchar(8) — NOT NULL
stat_payment_week
- STAT_DATE — varchar(8) — Primary key — NOT NULL
- ORGANIZATION_IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- COUNT — int(11) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- PRICE — double — NOT NULL
- UNIT_PRICE — double — NOT NULL
- STATUS — varchar(8) — NOT NULL
stat_transfer_day
- STAT_DATE — varchar(8) — Primary key — NOT NULL
- COIN_TYPE — int(11) — Primary key — NOT NULL
- COUNT — int(11) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- EXTERNAL_IN_COUNT — int(11) — NOT NULL
- EXTERNAL_OUT_COUNT — int(11) — NOT NULL
- EXTERNAL_OUT_AMOUNT — bigint(20) — NOT NULL
- EXTERNAL_IN_AMOUNT — bigint(20) — NOT NULL
- PAYMENT_COUNT — int(11) — NOT NULL
- PAYMENT_AMOUNT — bigint(20) — NOT NULL
transfer_log
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- TYPE — varchar(12) — NOT NULL
- FROM — varchar(160) — NOT NULL
- TO — varchar(160) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- FEE — bigint(20)
- STATUS — varchar(45)
- TXID — varchar(160)
- MEMO — varchar(512)
- CREATE_DATE — datetime
- DESTINATION_TAG — bigint(20)
transfer_log_ref
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11)
- ADDRESS — varchar(160)
- REF_IDX — int(11)
transfer_request
- IDX — int(11) — Primary key — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- FROM — varchar(160) — NOT NULL
- TO — varchar(160) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- FEE — bigint(20)
- DELETED — tinyint(4)
- TRX_ID — varchar(128)
- STATUS — varchar(8) — NOT NULL
- LOG_IDX — int(11)
- CREATE_DATE — datetime
- ERROR_MSG — varchar(512)
- DESTINATION_TAG — bigint(20)
url_link
- IDX — int(11) — Primary key — NOT NULL
- RANK — int(11)
- NAME_IDX — int(11)
- URL — varchar(512)
- IMAGE — text
- DELETED — tinyint(4)
- CREATE_DATE — datetime
- CATEGORY_IDX — int(11)
- CONTENT_IDX — int(11)
user
- IDX — int(11) — Primary key — NOT NULL
- NAME — varchar(32)
- ID — varchar(64) — NOT NULL
- SECURITY_PASSWORD — varchar(64)
- EMAIL — varchar(64)
- EMAIL_VERIFIED — tinyint(4) — NOT NULL
- PHONE — varchar(32)
- PHONE_VERIFIED — tinyint(4) — NOT NULL
- PASSWORD — varchar(64)
- SERIAL — char(20)
- DEVICE_ID — varchar(256)
- MEMO — varchar(516)
- RECOMMENDER — varchar(64)
- DELETED — tinyint(4)
- CREATE_DATE — datetime
- TOKEN — varchar(256)
- TOKEN_DATE — datetime
- MNEMONIC — varchar(256)
- OTP_KEY — varchar(256)
- OTP_URL — varchar(512)
- SECURITY_LEVEL — int(11)
- FIRST_LOGIN_FLAG — tinyint(4)
- OTP_VERIFIED — tinyint(4)
- ACCOUNT_HOLDER — varchar(45)
- BANK_CODE — varchar(45)
- BANK_ACCOUNT — varchar(45)
- RECOMMEND_CODE — varchar(12)
- HIDE_BALANCE_FLAG — tinyint(4)
- DELETE_DATE — datetime
- LOGIN_TYPE — int(11)
- PUSH_TOKEN — varchar(256)
- PUSH_FLAG — tinyint(4)
- LOGIN_COUNT — int(11)
- SEND_COUNT — int(11)
virtual_account
- IDX — int(11) — Primary key — NOT NULL
- ORGANIZATION_IDX — int(11)
- ORDER_ID — varchar(64) — NOT NULL
- PRODUCT_NAME — varchar(64) — NOT NULL
- PRICE — int(11) — NOT NULL
- COST_PRICE — int(11) — NOT NULL
- RECEIVED — int(11) — NOT NULL
- STATUS — varchar(16) — NOT NULL
- ADDRESS — varchar(160)
- CREATE_DATE — datetime
- MALL_INTERFACE — tinyint(4)
- MALL_INTERFACE_RESULT — varchar(64)
- MALL_INTERFACE_TOKEN — varchar(64)
virtual_account_decent
- IDX — int(11) — Primary key — NOT NULL
- ORG_IDX — int(11) — NOT NULL
- ORDER_ID — varchar(128) — NOT NULL
- USER_ADDRESS — varchar(128)
- ADDRESS — varchar(128) — NOT NULL
- COIN_TYPE — int(11) — NOT NULL
- SEED — varchar(128) — NOT NULL
- AMOUNT — bigint(20) — NOT NULL
- PRICE — double — NOT NULL
- COIN_PRICE — double — NOT NULL
- TX_ID — varchar(128)
- STATUS — varchar(12)
- CREATE_DATE — datetime
- MERGED — tinyint(4)
- WALLET_TYPE — varchar(12)
- CONFIRM — tinyint(4)
- BALANCE — bigint(20)
- LOG_IDX — int(11)
- MEMO — varchar(256)