苹果CMS文档

mac_vod是苹果CMSV10点播模块的核心数据表,后台资源添加、编辑、采集入库,前台列表、详情页、播放页的数据读取都依赖本表,播放器配置、观看权限、评分点击统计、剧情分集内容全部存放于此,开发模板、采集插件、播放接口时都需要参考本表结构。

序号列名数据类型长度小数位数主键自增允许空默认值列说明
1vod_idint

√√


2type_idsmallint
0


0
3type_id_1smallint
0


0
4group_idsmallint
0


0
5vod_namevarchar255





6vod_subvarchar255





7vod_envarchar255





8vod_statustinyint
0


0
9vod_letterchar1





10vod_colorvarchar6





11vod_tagvarchar100





12vod_classvarchar255





13vod_picvarchar1024





14vod_pic_thumbvarchar1024





15vod_pic_slidevarchar1024





16vod_pic_screenshottext65535


√

17vod_actorvarchar255





18vod_directorvarchar255





19vod_writervarchar100





20vod_behindvarchar100





21vod_blurbvarchar255





22vod_remarksvarchar100





23vod_pubdatevarchar100





24vod_totalmediumint
0


0
25vod_serialvarchar20



0
26vod_tvvarchar30





27vod_weekdayvarchar30





28vod_areavarchar20





29vod_langvarchar10





30vod_yearvarchar10





31vod_versionvarchar30





32vod_statevarchar30





33vod_authorvarchar60





34vod_jumpurlvarchar150





35vod_tplvarchar30





36vod_tpl_playvarchar30





37vod_tpl_downvarchar30





38vod_isendtinyint
0


0
39vod_locktinyint
0


0
40vod_leveltinyint
0


0
41vod_copyrighttinyint
0


0
42vod_pointssmallint
0


0
43vod_points_playsmallint
0


0
44vod_points_downsmallint
0


0
45vod_hitsmediumint
0


0
46vod_hits_daymediumint
0


0
47vod_hits_weekmediumint
0


0
48vod_hits_monthmediumint
0


0
49vod_durationvarchar10





50vod_upmediumint
0


0
51vod_downmediumint
0


0
52vod_scoredecimal31


0.0
53vod_score_allmediumint
0


0
54vod_score_nummediumint
0


0
55vod_timeint




0
56vod_time_addint




0
57vod_time_hitsint




0
58vod_time_makeint




0
59vod_tryseesmallint
0


0
60vod_douban_idint




0
61vod_douban_scoredecimal31


0.0
62vod_reurlvarchar255





63vod_rel_vodvarchar255





64vod_rel_artvarchar255





65vod_pwdvarchar10





66vod_pwd_urlvarchar255





67vod_pwd_playvarchar10





68vod_pwd_play_urlvarchar255





69vod_pwd_downvarchar10





70vod_pwd_down_urlvarchar255





71vod_contentmediumtext16777215





72vod_play_fromvarchar255





73vod_play_servervarchar255





74vod_play_notevarchar255





75vod_play_urlmediumtext16777215





76vod_down_fromvarchar255





77vod_down_servervarchar255





78vod_down_notevarchar255





79vod_down_urlmediumtext16777215





80vod_plottinyint
0


0
81vod_plot_namemediumtext16777215





82vod_plot_detailmediumtext16777215