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)