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)