UNCR Studio DB

Tables (14)

bnn_index

  • BG_INDEX — float — NOT NULL
  • DATE — date — NOT NULL
  • HARVESTED_BNN — float — NOT NULL
  • ISSUED_BNN — float — NOT NULL

bnn_token

  • TOKEN_ID — varchar(100) — Foreign key → token.TOKEN_ID — NOT NULL
  • BNN_TOKEN — float — NOT NULL

bnn_token_log

  • TOKEN_ID — varchar(100) — Foreign key → token.TOKEN_ID — NOT NULL
  • BNN_TOKEN — float — NOT NULL
  • DATE — date — NOT NULL

channel

  • CHANNEL_ID — varchar(100) — NOT NULL
  • LAST_VIEWCOUNT — bigint(20)
  • NEW_VIEWCOUNT — bigint(20)
  • LAST_SUBSCRIBECOUNT — bigint(20)
  • NEW_SUBSCRIBECOUNT — bigint(20)

channel_log

  • CHANNEL_ID — varchar(100)
  • VIEW_COUNT — bigint(20)
  • SUBSCRIBE_COUNT — bigint(20)
  • DATE — timestamp

creator_growth_index

  • CREATOR_GROWTH_INDEX — float — NOT NULL
  • DATE — date — NOT NULL

general_creator_growth_index

  • GENERAL_CREATOR_GROWTH_INDEX — float — NOT NULL
  • DATE — date — NOT NULL

segmentation_creator_growth_rate_log

  • SEG_ID — int(11) — Foreign key → segmentation_id.SEG_ID — NOT NULL
  • GENERAL_CREATOR_GROWTH_RATE — float — NOT NULL
  • VIEW_COUNT_GROWTH_RATE — float — NOT NULL
  • SUB_COUNT_GROWTH_RATE — float — NOT NULL
  • DATE — date — NOT NULL
  • SEG_NUMBER — int(11)

segmentation_id

  • SEG_ID — int(11) — NOT NULL
  • SEG_NAME — varchar(50) — NOT NULL

support_activitiy_count

  • TOKEN_ID — varchar(100) — Foreign key → token.TOKEN_ID — NOT NULL
  • SUBSCRIBE_COUNT — bigint(20) — NOT NULL
  • SHARE_COUNT — bigint(20) — NOT NULL
  • LIKE_COUNT — bigint(20) — NOT NULL
  • COMMENT_COUNT — bigint(20) — NOT NULL
  • TWIT_COUNT — bigint(20) — NOT NULL
  • FACEBOOK_COUNT — bigint(20) — NOT NULL

support_activity_index

  • TOKEN_ID — varchar(100) — Foreign key → token.TOKEN_ID — NOT NULL
  • SUPPORT_ACTIVITY_INDEX — float — NOT NULL

support_activity_index_log

  • TOKEN_ID — varchar(100) — NOT NULL
  • CREATOR_SUPPORT_ACTIVITY_INDEX — float — NOT NULL — 스케쥴러 시 연산
  • DATE — int(11) — NOT NULL

token

  • TOKEN_ID — varchar(100) — Primary key — NOT NULL
  • CHANNEL_ID — varchar(100)
  • UPDATE_TIME — timestamp
  • IMAGE_URI — varchar(100)

user_wallet

  • WALLET_ADDRESS — varchar(100) — Primary key — NOT NULL
  • REFERAL_CODE — varchar(100)