流量增长部数据分类
2019-05-23 19:33:38 6 举报AI智能生成
登录查看完整内容
![[可编辑]数据来源分类图表](https://po-img.processon.com/chart_image/thumb/60a5bc63e0b34d0717456310.png)
基础架构
作者其他创作
大纲/内容
同镇流量增长部数据分类<br>
统计相关
行为日志
外部表：dw_tz_speed_user_behavior
seqno
faceid
imei
uid
feedtab
deviceid
behaviortype
city
county
town
flag
datasource
itemid
predictno
recallno
index
ip
lat
lon
cid
os
channel
behaviortime
version
usercity
usercounty
usertown
abtestno
behaviordate
行为统计
表：
子主题
外部表：t_tongzhen_hour_track_v2
gitd
cookieid
infoid
masterid
townid
province
xian
zhen
cate1
cate2
distributorid
accesstime
hour
track_source
stat_date
hour_min
用户相关
用户画像
外部表：dw_tz_speed_user_profile
age
sex
active_city
active_county
active_town
category
last_time
first_time
total_showpv
total_clickpv
st_news
st_county_job
st_county_ershoufang
mt_news
mt_county_job
mt_county_ershoufang
lt_news
lt_county_job
lt_county_ershoufang
rt_news
rt_county_job
rt_county_ershoufang
industry
hobby
nick_name
date
帖子相关
同镇帖子详情
内部表：dw_t_tz_infodetail
id
userid
cateid
localid
state
source
phone
title
content
userip
pic
thirduid
createtime
updatetime
postdate
examinedate
enddate
param
parammap
pv
proline
lsort
forbidtime
propertityparams
propertityparamsmap
同镇部落帖子表
内部表：dw_so_ugc_question
contenttype
topic
topicid
topictype
gender
producertype
thirdid
username
question
question_type
questiondetail
status
type
agree
answernum
inserttime
headanswer
dt
帖子数据
外部表：dw_t_speed_content_profile_rawdata
key
cityid
countyid
itemtype
addtime
pubtime
topic1
topic2
topic3
topic4
publishtype
producttype
params
dataversion
静态数据
同镇城市字典数据
内部表：dw_t_v_local
code
localname
pid
fullpath
depth
dirname
pinyin
同镇站长信息
内部表：dw_t_tz_station_user3
user_id
wechat
opentime
closetime
local_id
station_name
subject_name
area
group_id
franchiseetype
companyname
registernum
bindname
payuser
bspname
email
idcard
nickname
realname
qq
birthday
address
face
aboutme
materiel
decorate
风控相关
外部表：dw_tz_flowidentify
gtid
master
strategy
score
logtime
ipcity
pagename
black_ip
数据库：hdp_ubu_tech_wei_defaultdb
0 条评论
回复 删除
下一页
