《数据库文档产品中心》由会员分享,可在线阅读,更多相关《数据库文档产品中心(8页珍藏版)》请在金锄头文库上搜索。
1、产品中心数据库设计文档(熊水林)1.数据库表一览英文名称简要说明旧名称T_PRODUCTS产品表T_PRODUCTST_PROD_TYPE产品类型表T_PRODUCT_TYPET_PROD_TRAIT产品特性表T_DICT_ITEM_PD_TPT_PROD_X_PROD产品关系表T_PRODUCT_LIMITT_INSURER代理商表T_INSURER1.1表规格说明CMS_CHANNEL(频道表)字段名字段类型字段说明主键/索引NotnullCHANNEL_IDVARCHAR2(36)IDPKYCHANNEL_NAMEVARCHAR2(100)名称NCHANNEL_URLVARCHAR2(5
2、12)首页地址NDISABLEDNUMBER(1)失效标识NORDERNUMNUMBER(2)显示顺序NCMS_THEME(栏目表)字段名字段类型字段说明主键/索引NotnullTHEME_IDVARCHAR2(36)IDPKYTHEME_NAMEVARCHAR2(100)名称NPARENT_IDVARCHAR2(36)上级IDNCHANNEL_IDVARCHAR2(36)所属频道NSCREEN_IDVARCHAR2(64)栏目地址NPARAMETERSVARCHAR2(256)参数串NDISABLEDNUMBER(1)失效标识NORDERNUMNUMBER(2)显示顺序NCMS_TEMPLA
3、TE(模板表)字段名字段类型字段说明主键/索引NotnullTEMPLATE_IDVARCHAR2(36)IDPKYGRID_IDVARCHAR2(36)网格IDPKYTEMPLATE_FILEVARCHAR2(128)模板文件位置NDIRECTVARCHAR2(16)资源引用方式NDISABLEDNUMBER(1)失效标识NCMS_RESOURCE(资源表)字段名字段类型字段说明主键/索引NotnullRESOURCE_IDVARCHAR2(36)IDPKYRESOURCE_NAMEVARCHAR2(100)名称YRESOURCE_URLVARCHAR2(512)资源有效地址NTHEME_I
4、DVARCHAR2(36)栏目IDNDISABLEDNUMBER(1)失效标识NCMS_SCREEN_TEMPL(屏幕-模板表)字段名字段类型字段说明主键/索引NotnullSCREEN_IDVARCHAR2(64)屏幕IDNTEMPLATE_IDVARCHAR2(36)模板IDNCMS_SCREEN_RES(模板资源表)字段名字段类型字段说明主键/索引NotnullSCREEN_RES_IDVARCHAR2(36)IDPKYSCREEN_IDVARCHAR2(64)屏幕IDYGRID_IDVARCHAR2(36)网格IDYRESOURCE_IDVARCHAR2(36)资源IDYROLE_ID
5、VARCHAR2(36)角色IDNLAYOUT_AIIRVARCHAR2(512)r布局属性NDIRECTVARCHAR2(16)资源引用方式NCMS_BIGCONTENT(大字段内容表)字段名字段类型字段说明主键/索引NotnullBLOB_IDVARCHAR2(36)IDPKYMIMETYPEVARCHAR2(32)数据流类型,如:“text/html”CONTENTBLOBREMARKVARCHAR2(256)备注CONTENT_IDVARCHAR2(36)内容ID,如公告ID、新闻ID等THEME_IDVARCHAR2(36)栏目ID1.2表脚本-频道表CREATETABLECMS_C
6、HANNEL(CHANNEL_IDVARCHAR(36),CHANNEL_NAMEVARCHAR2(100)CHANNEL_URLVARCHAR2(512),DISABLEDNUMBER(1),ORDERNUMNUMBER(2),constraitPK_CMS_CHANNELprimarykey(channel_id);-栏目表CREATETABLECMS_THEME(THEME_IDTHEMENAMEPARENTIDCHANNEL_IDSCREENIDORDERNUMDISABLEDVARCHAR2(36),VARCHAR2(100),VARCHAR2(36),VARCHAR2(36),VA
7、RCHAR2(64),NUMBER(4,0),NUMBER(4,0),VARCHAR2(256),PARAMETERSconstraintPK_CMS_THEMEprimarykey(theme_id);-模板表CREATETABLECMS_TEMPLATE(TEMPLATEIDVARCHAR2(36),VARCHAR2(36),GRIDIDDIRECTVARCHAR2(16),TEMPLATEFILEVARCHAR2(128),NUMBER(4,0),DISABLEDconstraintPK_CMS_TEMPLATEprimarykey(template_id,grid_id);-资源表CR
8、EATETABLECMS_RESOURCE(RESOURCEIDRESOURCE_NAMERESOURCEURLDISABLEDTHEMEIDVARCHAR2(36),VARCHAR2(100),VARCHAR2(512),NUMBER(4,0),VARCHAR2(36),constraintPK_CMS_RESOURCEprimarykey(resource_id);-屏幕模板表CREATETABLECMS_SCREEN_TEMPL(SCREEN_IDVARCHAR2(64),TEMPLATE_IDVARCHAR2(36),constraintPK_CMS_SCREEN_TEMPLprima
9、rykey(screen_id);-屏幕资源表SCREEN_RES_IDSCREEN_IDGRID_IDDIRECTCREATETABLECMS_SCREEN_RES(VARCHAR2(36),VARCHAR2(64),VARCHAR2(36),RESOURCE_IDROLE_IDLAYOUTATTRVARCHAR2(16),VARCHAR2(512),VARCHAR2(36),VARCHAR2(512),constraintPK_TEMPL_RESprimarykey(screen_id,grid_id,resource_id,role_id);-大字段的内容表BLOB_IDMIMETYPE
10、CONTENTCREATETABLECMS_BIGCONTENT(VARCHAR2(36)notnull,VARCHAR2(32),BLOB,REMARKTHEME_IDCONTENTIDVARCHAR2(256),VARCHAR2(36),VARCHAR2(36),constraintPK_CMS_BLOB_IDprimarykey(blob_id);1.3表注释-频道表COMMENDONTABLECMS_CHANNELS道表;commendoncolumnCHANNEL_IDISID;commendoncolumnCHANNEL_NAMEIS频道名称commendoncolumnCHANN
11、EL_URLIS频道首页地址commendoncolumnDISABLEDIS失效标识;commendoncolumnORDERNUMIS显示顺序;-栏目表COMMENDONTABLEMS_THEMEIS栏目表;commendoncolumnTHEME_IDISID;commendoncolumnTHEME_NAMEIS名称;commendoncolumnPARENT_IDIS上级ID;commendoncolumnCHANNEL_IDIS所属频道;commendoncolumnSCREEN_IDIS屏幕地址;commendoncolumnPARAMETERSIS参数串;commendonco
12、lumnDISABLEDIS失效标识;commendoncolumnORDERNUMIS显示顺序;-模板表COMMENDONTABLECMEMPLATEIS模板表;commendoncolumnTEMPLATE_IDISID;commendoncolumnGRID_IDIS网格ID;commendoncolumnDIRECTIS资源引用方式;commendoncolumnTEMPLATE_FILEIS模板文件路径commendoncolumnDISABLEDIS失效标识;-资源表COMMENDONTABLECMSRESOURCE渤表commendoncolumnJRESOURCE_IDISID
13、;commendoncolumnRESOURCE_NAMEIS名称commendoncolumncommendoncolumncommendoncolumnRESOURCE_URLIS资源路径THEME_IDIS栏目ID;DISABLEDIS失效标识;-屏幕模板表COMMENDONTABLECMS_SCREEN_TEMPWS模板表commendoncolumnSCREEN_IDIS屏幕ID;commendoncolumnTEMPLATE_IDIS模板ID-屏幕资源表COMMENDONTABLECMS_SCREEN_RESH资源表commendoncolumnSCREEN_RES_IDISID,;commendoncolumnSCREEN_IDIS屏幕ID;commendoncolumnGRID_IDIS网格ID;commendoncolumnDIRECTIS资源引用方式commendoncolumnRESOURCE_IDIS资源ID;角色ID;commendoncolumnROLE_IDIScommendoncolumnLAYOUT_ATTRIS布局属性-大字段表COMMENDONTABLEMS_BIGCONTENTIS大字段表commendoncolumnBLOB_IDISID;commendoncolumnMIMETYPEIS数据流类型;commend