以上两个关联的表分别为:
r_resourceinfo叫资源表,
c_stateprovinceinfo叫省区表
省区表为主表,资源表为子表,而且省区表为自关联表(就是把全国省,市,区,县的信息全部存储在这张表中)
具体表间关系及表定义如下:
create table R_RESOURCEINFO (
RESOURCEID CHAR(16) not null,
CONTENTID CHAR(16),
KNOWLEDGEID CHAR(16),
LEVELID CHAR(16),
PROVINCEID CHAR(16),
CHAPTER_ID CHAR(16),
SUBJECTID CHAR(16),
GRADEID CHAR(16),
VERSION_ID CHAR(16),
TITLE VARCHAR2(256),
RESOURCE_YEAR NUMBER(10),
SUMMARY VARCHAR2(1024),
DETAIL VARCHAR2(3000),
DURATION NUMBER(10),
RESOURCE_CODE VARCHAR2(128),
RESOURCE_TYPE CHAR(16),
RESOURCE_MODE CHAR(16),
RESOURCE_STATUS