CPS数据关系设计

ResourceDB.xml

<?xml version="1.0" encoding="UTF-8"?> <resources> <resource name="1328976399538.txt" type="text"> <param name="remark">文本测试</param> <param name="createtime">2012-02-12 00:06:39</param> <param name="createby">a</param> </resource> <resource name="1328976423080.avi" type="video"> <param name="remark">视频测试</param> <param name="createtime">2012-02-12 00:07:03</param> <param name="createby">a</param> </resource> <resource name="1328976440082.gif" type="image"> <param name="remark">图片测试</param> <param name="createtime">2012-02-12 00:07:20</param> <param name="createby">a</param> </resource> <resource name="1328976467467.mp3" type="audio"> <param name="remark">音频测试</param> <param name="createtime">2012-02-12 00:07:47</param> <param name="createby">a</param> </resource> <resource name="1329055127473.png" type="image"> <param name="remark">篮球广告背景</param> <param name="createtime">2012-02-12 21:58:47</param> <param name="createby">a</param> </resource> </resources>
TemplateDB.xml

<?xml version="1.0" encoding="UTF-8"?> <templates> <template id="template_1328976662650" name="模板测试 - 1"> <param name="remark">这是个模板测试</param> <param name="createtime">2012-11-12 00:11:02</param> <param name="createby">a</param> <param name="models"> <model id="1328976662650" name="video1" type="video" dimension="0,0,89,65" gradation="1" /> <model id="1328976662650" name="image2" type="image" dimension="97,0,182,49" gradation="2" /> </param> </template> <template id="template_1328976884861" name="模板测试 - 2"> <param name="remark">测试</param> <param name="createtime">2012-14-12 00:14:44</param> <param name="createby">a</param> <param name="models"> <model id="1328976884861_video1" name="video1" type="video" dimension="0,0,128,83" gradation="1" /> <model id="1328976884861_image2" name="image2" type="image" dimension="465,0,600,92" gradation="2" /> <model id="1328976884861_audio3" name="audio3" type="audio" dimension="469,332,600,400" gradation="3" /> </param> </template> <template id="template_1329022305005" name="探讨探讨探讨"> <param name="remark">他的身法斯蒂芬</param> <param name="createtime">2012-51-12 12:51:45</param> <param name="createby">a</param> <param name="models"> <model id="1329022305005_video1" name="video1" type="video" dimension="96,86,206,182" gradation="1" /> <model id="1329022305005_image2" name="image2" type="image" dimension="358,127,427,177" gradation="2" /> <model id="1329022305005_audio3" name="audio3" type="audio" dimension="48,243,180,326" gradation="3" /> <model id="1329022305005_text4" name="text4" type="text" dimension="285,258,449,330" gradation="4" /> </param> </template> <template id="template_1329022363960" name="阿斯顿发大水"> <param name="remark">阿斯顿干撒顶个</param> <param name="createtime">2012-52-12 12:52:43</param> <param name="createby">a</param> <param name="models"> <model id="1329022363959_video1" name="video1" type="video" dimension="99,82,188,166" gradation="1" /> <model id="1329022363959_image2" name="image2" type="image" dimension="329,69,436,174" gradation="2" /> <model id="1329022363959_audio3" name="audio3" type="audio" dimension="65,208,184,279" gradation="3" /> <model id="1329022363959_text4" name="text4" type="text" dimension="279,234,401,286" gradation="4" /> </param> </template> <template id="template_1329032027882" name="test"> <param name="remark">test</param> <param name="createtime">2012-33-12 15:33:47</param> <param name="createby">a</param> <param name="models"> <model id="1329032027882_video1" name="video1" type="video" dimension="0,0,127,106" gradation="1" /> <model id="1329032027882_image2" name="image2" type="image" dimension="126,0,600,106" gradation="2" /> <model id="1329032027882_text3" name="text3" type="text" dimension="0,103,600,400" gradation="3" /> </param> </template> </templates>