·¢²¼Ê±¼ä : ÐÇÆÚÎå ÎÄÕÂ5λ - Êý¾Ý¿âÉè¼Æ˵Ã÷Êé - 061214£¨½Ìѧ²Î¿¼°æ£©¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ5cb411a1b0717fd5360cdc4f
µÚ3Õ °²È«±£ÃÜÉè¼Æ
×Ö¶ÎÃû CATEGORY_ID
? CMS_CONTENT_PROPERTY ¹¦ÄÜÃèÊö:ÄÚÈݸ½¼ÓÊôÐÔÀ©Õ¹±í ×Ö¶ÎÃû CONTENT_ID
? CMS_CAT_CONTENT ¹¦ÄÜÃèÊö:ÄÚÈݸ½¼ÓÊôÐÔÀ©Õ¹±í ×Ö¶ÎÃû CONTENT_ID
ÀàÐÍ£¨³¤¶È£© NUMBER NUMBER ÊÇ·ñΪ¿Õ ÓÃ;ÃèÊö ÄÚÈÝID À¸Ä¿ID ¸½¼ÓÊôÐÔÖµ ÊÇ·ñΪ¿Õ ÓÃ;ÃèÊö ÄÚÈÝID ¸½¼ÓÊôÐÔÃû³Æ 2.2 ͼƬÁ´½Ó
ʵÏÖͼƬÁ´½ÓµÄ²é¿´ä¯ÀÀ¡¢¹ÜÀí¹¦ÄÜ¡£
½¨É赥λ£º¹ãÖÝÊй«°²¾Ö½»Í¨¾¯²ìÖ§¶Ó ³Ð½¨µ¥Î»£º¹ãÖÝÊз½ÐÀ¿Æ¼¼ÓÐÏÞ¹«Ë¾
7
¹ãÖÝÊÐÖÇÄܽ»Í¨¹ÜÀíÖ¸»Óϵͳ×ÓÏîÄ¿-½»Í¨¹ÜÀíÐÅÏ¢ÍøÕ¾¿ª·¢ÏîÄ¿-Êý¾Ý¿âÉè¼Æ˵Ã÷Êé
2.2.1 Êý¾Ý±íÉè¼Æ
2.2.1.1. ÃèÊö
²ÉÓÃcmsÄÚÈÝ·¢²¼ÏµÍ³ÊµÏÖͼƬÁ´½ÓµÄ¹¦ÄÜ¡£Ö÷ÒªÉæ¼°µÄcmsÊý¾Ý±íΪCMS_CATEGORY¡¢CMS_CONTENT¡¢CMS_CATEGORY_PROPERTY¡¢CMS_CONTENT_PROPERTY¡¢CMS_CAT_CONTENT¡£CMS_CATEGORYΪÀ¸Ä¿±í£¬CMS_CONTENTΪÄÚÈÝ±í£¬CMS_CATEGORY_PROPERTYΪÀ¸Ä¿¸½¼ÓÊôÐÔÀ©Õ¹±í£¬CMS_CONTENT_PROPERTYΪÄÚÈݸ½¼ÓÊôÐÔÀ©Õ¹±í£¬CMS_CAT_CONTENTΪÀ¸Ä¿ºÍÄÚÈݹØϵ±í¡£
CMS_CATEGORY±í±£´æͼƬÁ´½ÓÀ¸Ä¿ÐÅÏ¢£¬CMS_CONTENT±í±£´æͼƬÁ´½ÓÐÅÏ¢£¬CMS_CONTENT_PROPERTY±í±£´æͼƬ±£´æ·¾¶¸½¼ÓÊôÐÔ¡£
2.2.1.2. ¹Øϵͼ
ÈçÏÂͼËùʾ£º
½¨É赥λ£º¹ãÖÝÊй«°²¾Ö½»Í¨¾¯²ìÖ§¶Ó ³Ð½¨µ¥Î»£º¹ãÖÝÊз½ÐÀ¿Æ¼¼ÓÐÏÞ¹«Ë¾
8
µÚ3Õ °²È«±£ÃÜÉè¼Æ
CMS_CONTENT_PROPERTYCONTENT_IDNUMBER
? CMS_CATEGORY ¹¦ÄÜÃèÊö:cmsÀ¸Ä¿±í ×Ö¶ÎÃû CATEGORY_ID
ÀàÐÍ£¨³¤¶È£© NUMBER ÊÇ·ñΪ¿Õ ÓÃ;ÃèÊö À¸Ä¿ID VARCHAR2(200) À¸Ä¿Ãû³Æ VARCHAR2(255) ¡Ì À¸Ä¿ÃèÊö À¸Ä¿±àÂë ÉóºË±êÖ¾ ½¨É赥λ£º¹ãÖÝÊй«°²¾Ö½»Í¨¾¯²ìÖ§¶Ó ³Ð½¨µ¥Î»£º¹ãÖÝÊз½ÐÀ¿Æ¼¼ÓÐÏÞ¹«Ë¾
¹ãÖÝÊÐÖÇÄܽ»Í¨¹ÜÀíÖ¸»Óϵͳ×ÓÏîÄ¿-½»Í¨¹ÜÀíÐÅÏ¢ÍøÕ¾¿ª·¢ÏîÄ¿-Êý¾Ý¿âÉè¼Æ˵Ã÷Êé
CATEGORY_TEMPLETE CONTENT_DEFAULT_TEMPLETE CONTENT_TYPE ENABLE DELETE_FLAG CREATE_DATE MODIFY_DATE CONTENT_ENTRY TYPE Ö÷¼ü
VARCHAR2(255) ¡Ì À¸Ä¿Ä£°æ VARCHAR2(255) ¡Ì ÄÚÈÝĬÈÏÄ£°æ CHAR ¹«/˽ÓÐÊý¾Ý CHAR CHAR ÊÇ·ñÓÐЧ ɾ³ý±ê¼Ç DATE ¡Ì ´´½¨ÈÕÆÚ DATE ¡Ì ÐÞ¸ÄÈÕÆÚ VARCHAR2(255) ¡Ì ¹ÜÀíÒ³ÃæÈë¿Ú CHAR Íâ¼ü±í¼°×ֶΠ¼¶Áª¹Øϵ À¸Ä¿ÀàÐÍ ÓÃ;ÃèÊö ? CMS_CONTENT ¹¦ÄÜÃèÊö:cmsÄÚÈݱí ×Ö¶ÎÃû CONTENT_ID
ÀàÐÍ£¨³¤¶È£© NUMBER ÊÇ·ñΪ¿Õ ÓÃ;ÃèÊö ÄÚÈÝID(ͼƬÁ´½ÓID) ¡Ì ¡Ì ÄÚÈݱêÌâ(ͼƬÁ´½Ó±êÌâ) ¹Ø¼ü×Ö À´Ô´ ½¨É赥λ£º¹ãÖÝÊй«°²¾Ö½»Í¨¾¯²ìÖ§¶Ó ³Ð½¨µ¥Î»£º¹ãÖÝÊз½ÐÀ¿Æ¼¼ÓÐÏÞ¹«Ë¾