产品中心数据库设计文档（熊水林）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(频道表)字段名字段类型字段说明主键/索引Not nullCHANNEL_IDVARCHAR2(36)IDPKYCHANNEL_NAMEVARCHAR2(100)名称NCHANNEL_URLVARCHAR2(512)首页地址NDISABLEDNUMBER(1)失效标识NORDERNUMNUMBER(2)显示顺序NCMS_THEME(栏目表)字段名字段类型字段说明主键/索引Not nullTHEME _IDVARCHAR2(36)IDPKYTHEME_NAMEVARCHAR2(100)名称NPARENT_IDVARCHAR2(36)上级IDNCHANNEL_IDVARCHAR2(36)所属频道NSCREEN_IDVARCHAR2(64)栏目地址NPARAMETERSVARCHAR2(256)参数串NDISABLEDNUMBER(1)失效标识NORDERNUMNUMBER(2)显示顺序NCMS_TEMPLATE（模板表）字段名字段类型字段说明主键/索引Not nullTEMPLATE_IDVARCHAR2(36)IDPKYGRID_IDVARCHAR2(36)网格IDPKYTEMPLATE_FILEVARCHAR2(128)模板文件位置NDIRECTVARCHAR2(16)资源引用方式NDISABLEDNUMBER(1)失效标识NCMS_RESOURCE（资源表）字段名字段类型字段说明主键/索引Not nullRESOURCE_IDVARCHAR2(36)IDPKYRESOURCE_NAMEVARCHAR2(100)名称YRESOURCE_URLVARCHAR2(512)资源有效地址NTHEME_IDVARCHAR2(36)栏目IDNDISABLEDNUMBER(1)失效标识NCMS_SCREEN_TEMPL(屏幕-模板表)字段名字段类型字段说明主键/索引Not nullSCREEN_IDVARCHAR2(64)屏幕IDNTEMPLATE_IDVARCHAR2(36)模板IDNCMS_SCREEN_RES (模板资源表)字段名字段类型字段说明主键/索引Not nullSCREEN_RES_IDVARCHAR2(36)IDPKYSCREEN_IDVARCHAR2(64)屏幕IDYGRID_IDVARCHAR2(36)网格IDYRESOURCE_IDVARCHAR2(36)资源IDYROLE_IDVARCHAR2(36)角色IDNLAYOUT_ATTRVARCHAR2(512)布局属性NDIRECTVARCHAR2(16)资源引用方式NCMS_BIGCONTENT(大字段内容表)字段名字段类型字段说明主键/索引Not nullBLOB_IDVARCHAR2(36)IDPKYMIMETYPEVARCHAR2(32)数据流类型,如：“text/html”CONTENTBLOBREMARKVARCHAR2(256)备注CONTENT_IDVARCHAR2(36)内容ID，如公告ID、新闻ID等THEME_IDVARCHAR2(36)栏目ID1.2表脚本-频道表CREATE TABLE CMS_CHANNEL ( CHANNEL_ID VARCHAR(36),CHANNEL_NAME VARCHAR2(100),CHANNEL_URL VARCHAR2(512),DISABLED NUMBER(1),ORDERNUM NUMBER(2),constrait PK_CMS_ CHANNEL primary key(channel_id);-栏目表CREATE TABLE CMS_THEME ( THEME_ID VARCHAR2(36), THEME_NAME VARCHAR2(100), PARENT_ID VARCHAR2(36), CHANNEL_ID VARCHAR2(36), SCREEN_ID VARCHAR2(64), ORDERNUM NUMBER(4,0), DISABLED NUMBER(4,0), PARAMETERS VARCHAR2(256), constraint PK_CMS_THEME primary key(theme_id);-模板表CREATE TABLE CMS_TEMPLATE( TEMPLATE_ID VARCHAR2(36), GRID_ID VARCHAR2(36), DIRECT VARCHAR2(16), TEMPLATE_FILE VARCHAR2(128), DISABLED NUMBER(4,0), constraint PK_CMS_TEMPLATE primary key(template_id,grid_id);-资源表CREATE TABLE CMS_RESOURCE( RESOURCE_ID VARCHAR2(36), RESOURCE_NAME VARCHAR2(100), RESOURCE_URL VARCHAR2(512), DISABLED NUMBER(4,0), THEME_ID VARCHAR2(36), constraint PK_CMS_RESOURCE primary key(resource_id);-屏幕模板表CREATE TABLE CMS_SCREEN_TEMPL( SCREEN_ID VARCHAR2(64), TEMPLATE_ID VARCHAR2(36), constraint PK_CMS_SCREEN_TEMPL primary key(screen_id);-屏幕资源表CREATE TABLE CMS_SCREEN_RES( SCREEN_RES_IDVARCHAR2(36), SCREEN_ID VARCHAR2(64), GRID_ID VARCHAR2(36), DIRECT VARCHAR2(16), RESOURCE_ID VARCHAR2(512), ROLE_ID VARCHAR2(36), LAYOUT_ATTR VARCHAR2(512), constraint PK_TEMPL_RES primary key(screen_id,grid_id,resource_id,role_id);-大字段的内容表CREATE TABLE CMS_BIGCONTENT( BLOB_ID VARCHAR2(36) not null, MIMETYPE VARCHAR2(32), CONTENT BLOB, REMARK VARCHAR2(256), THEME_ID VARCHAR2(36), CONTENT_ID VARCHAR2(36), constraint PK_CMS_BLOB_ID primary key(blob_id);1.3表注释-频道表COMMEND ON TABLE CMS_CHANNEL IS 频道表;commend on column CHANNEL_ID IS ID;commend on column CHANNEL_NAME IS频道名称;commend on column CHANNEL_URL IS 频道首页地址;commend on column DISABLED IS 失效标识;commend on column ORDERNUM IS 显示顺序;-栏目表COMMEND ON TABLE CMS_THEME IS栏目表;commend on column THEME_ID IS ID;commend on column THEME_NAME IS 名称;commend on column PARENT_ID IS上级ID;commend on column CHANNEL_ID IS 所属频道;commend on column SCREEN_ID IS 屏幕地址;commend on column PARAMETERS IS 参数串;commend on column DISABLED IS 失效标识;commend on column ORDERNUM IS 显示顺序;-模板表COMMEND ON TABLE CMSTEMPLATE IS模板表; commend on column TEMPLATE_ID IS ID;commend on column GRID_ID IS 网格ID;commend on column DIRECT IS 资源引用方式;