中小商贸-数据库设计说明书

【重庆市中小商贸流通企业公共】数据库设计说明书文档2013-10-信本文件涉及之信息，属易商数码科技所有易商数码科技允许，文件中的都不能以向第散发。 文档修订记录版本修订日期修订人修订状审核日期审核人批准人2013-A2013- 服务项目需求表机构端服务意向表 表II表详细介 II.1表表字段属MODMODMOD50410211(， 2233445566778899代码droptableEXPERTScascade/*Table: createtableEXPERTS not HIGHEST_LEVEL_OF_EDUCATIONNUMBER(16), default0notnull, default0not SPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_NUMBER_6NUMBER(16),SPECIAL_COLUMN_NUMBER_7NUMBER(16),SPECIAL_COLUMN_NUMBER_8NUMBER(16),SPECIAL_COLUMN_NUMBER_9NUMBER(16),SPECIAL_COLUMN_NUMBER_10NUMBER(16),SPECIAL_COLUMN_VARCHAR_15VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_16VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_17VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_18VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_19VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_20VARCHAR2(200),commentontableEXPERTSiscommentoncolumnEXPERTS.IDiscommentoncolumnEXPERTS.MOD_IDiscommentoncolumnEXPERTS.EXPERT_NAMEiscommentoncolumnEXPERTS.EXPERT_PHOTOiscommentoncolumnEXPERTS.EXPERT_INDUSTRYiscommentoncolumnEXPERTS.AREAS_OF_EXPERTISEiscommentoncolumnEXPERTS.EXPERT_YEARiscommentoncolumnEXPERTS.VOCATIONAL_QUALIFICATIONSiscommentoncolumnEXPERTS.EXPERT_TITLESiscommentoncolumnEXPERTS.HIGHEST_LEVEL_OF_EDUCATIONiscommentoncolumnEXPERTS.WORK_UNITiscommentoncolumnEXPERTS.LINK_ADDRiscommentoncolumnEXPERTS.LINK_MANiscommentoncolumnEXPERTS.LINK_iscommentoncolumn commentoncolumnEXPERTS.ORDER_VALUEiscommentoncolumnEXPERTS.ADD_UIDis'添加用户ID';commentoncolumnEXPERTS.ADD_DATETIMEiscommentoncolumnEXPERTS.IS_DELis'是否删除，0否1是';commentoncolumnEXPERTS.DEL_DATEiscommentoncolumnEXPERTS.DEL_UIDis'删除用户ID';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_1is'保留字段1(类别，0：，1：)';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_2is'保留字段2';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_3is'保留字段3';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_4is'保留字段4';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_5is'保留字段5';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_6is'保留字段6';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_7is'保留字段7';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_8is'保留字段8';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_9is'保留字段9';commentoncolumnEXPERTS.SPECIAL_COLUMN_NUMBER_10is'保留字段10';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_11is'保留字段11';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_13is'保留字段13';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_14is'保留字段14';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_15is'保留字段15';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_16is'保留字段16';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_17is'保留字段17';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_18is'保留字段18';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_19is'保留字段19';commentoncolumnEXPERTS.SPECIAL_COLUMN_VARCHAR_20is'保留字段20';字段属码企业，商圈商圈__地图X地图X地图Y地图Y资（万元间表人,012登4（人（人（人（人（人（人4入（元E元（元额（元500字以内500字以1500以内（描述在1500字以期税记证号证记证类型登登记类记证期银行名01是，如果是-1则0204ID0102户ID1234567891011地址信息121314151617181920代码/*Table: VARCHAR2(200), VARCHAR2(200), NUMBER(18,4), NATIONAL_EXPIRY_DATEDATE, LICENSE_EXPIRY_DATEDATE, default0notnull, default0notnull, default0not SPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_NUMBER_6NUMBER(16),SPECIAL_COLUMN_NUMBER_7NUMBER(16),SPECIAL_COLUMN_NUMBER_8NUMBER(16),SPECIAL_COLUMN_NUMBER_9NUMBER(16),SPECIAL_COLUMN_NUMBER_10NUMBER(16),commentontableENTP_INFOiscommentoncolumnENTP_INFO.IDiscommentoncolumnENTP_INFO.ENTP_NAMEiscommentoncolumnENTP_INFO.LICENSE_CODEiscommentoncolumnENTP_INFO. ANIZATION_CODEiscommentoncolumnENTP_INFO.CUSTOM_CODEiscommentoncolumnENTP_INFO.ENTP_NUMBERis'企业，自动生成，按P_INDEX+序列方式生成';commentoncolumnENTP_INFO.P_INDEXiscommentoncolumnENTP_INFO.BUSINESS_TRADE_IDis'商圈ID';commentoncolumnENTP_INFO.AREA_COUNTRYiscommentoncolumnENTP_INFO.AREA_VILLAGEiscommentoncolumnENTP_INFO.MAP_Xis'地图X坐标';commentoncolumnENTP_INFO.MAP_Yis'地图Y坐标';commentoncolumnENTP_INFO.POST_CODEiscommentoncolumn iscommentoncolumnENTP_INFO.CAPITALiscommentoncolumnENTP_INFO.ADD_DATETIMEiscommentoncolumnENTP_INFO.LOGOUT_DATEiscommentoncolumnENTP_INFO.CORPORATION_NAMEiscommentoncolumnENTP_INFO.CORPORATION_SEXis'企业法定代表人,0男1女';commentoncolumnENTP_INFO.CORPORATION_BIRiscommentoncolumnENTP_INFO.CORPORATION_EDUiscommentoncolumnENTP_INFO.LINK_MANiscommentoncolumnENTP_INFO. commentoncolumnENTP_INFO.MOBILEiscommentoncolumnENTP_INFO.FAXiscommentoncolumnENTP_INFO.ENTP_REG_TYPEiscommentoncolumnENTP_INFO.EMPLOYEEiscommentoncolumnENTP_INFO.EMPLOYEE_COLLEGEiscommentoncolumnENTP_INFO.EMPLOYEE_DEVELOPiscommentoncolumnENTP_INFO.ENTP_CRAF_CODEiscommentoncolumn EiscommentoncolumnENTP_INFO.PROFITiscommentoncolumnENTP_INFO.SALESiscommentoncolumnENTP_INFO.TAXESiscommentoncolumnENTP_INFO.TOTAL_ASSETSiscommentoncolumnENTP_INFO.DEVELOP_FUNDSiscommentoncolumnENTP_INFO.PARTITION_TYPEiscommentoncolumnENTP_INFO.BUSINESS_SCOPEis'经营范围（描述在500字以内）';commentoncolumnENTP_INFO.ENTP_DESCis'企业简介（描述在1500字以内）';commentoncolumnENTP_INFO.CORPORATIONis commentoncolumnENTP_INFO.NATIONAL_CODEiscommentoncolumnENTP_INFO.NATIONAL_DATEiscommentoncolumnENTP_INFO.NATIONAL_EXPIRY_DATEiscommentoncolumnENTP_INFO.NATIONAL_IMGiscommentoncolumnENTP_INFO.LOCAL_CODEiscommentoncolumnENTP_INFO.LOCAL_DATEiscommentoncolumnENTP_INFO.LOCAL_EXPIRY_DATEiscommentoncolumnENTP_INFO.LOCAL_IMGiscommentoncolumnENTP_INFO.LICENSE_CODE2iscommentoncolumnENTP_INFO.LICENSE_TYPEiscommentoncolumnENTP_INFO.LICENSE_DATEiscommentoncolumnENTP_INFO.LICENSE_EXPIRY_DATEiscommentoncolumnENTP_INFO.LICENSE_IMGiscommentoncolumnENTP_INFO. ANIZATION_DATEiscommentoncolumnENTP_INFO. ANIZATION_IMGiscommentoncolumnENTP_INFO.BANK_NAMEiscommentoncolumnENTP_INFO.BANK_ACCOUNTiscommentoncolumnENTP_INFO.BANK_USER_NAMEiscommentoncolumnENTP_INFO.ORDER_VALUEiscommentoncolumnENTP_INFO.ADD_UIDis'添加用户ID';commentoncolumnENTP_INFO.COLUMN_41iscommentoncolumnENTP_INFO.IS_DELis'是否删除，0否1是';commentoncolumnENTP_INFO.DEL_DATEiscommentoncolumnENTP_INFO.DEL_UIDis'删除用户ID';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_1is'保留字段1';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_2is'保留字段2';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_3is'保留字段3';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_4is'保留字段4';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_5is'保留字段5';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_6is'保留字段6';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_7is'保留字段7';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_8is'保留字段8';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_9is'保留字段9';commentoncolumnENTP_INFO.SPECIAL_COLUMN_NUMBER_10is'保留字段10';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_11is'保留字段11（保存企业地址信息）';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_12is'保留字段12';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_13is'保留字段13';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_14is'保留字段14';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_15is'保留字段15';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_16is'保留字段16';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_17is'保留字段17';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_18is'保留字段18';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_19is'保留字段19';commentoncolumnENTP_INFO.SPECIAL_COLUMN_VARCHAR_20is'保留字段20';字段属企业企业2型0请，10不通过的码企业，成__地图X地图X地图Y地图Y金（（万元登间表人,0124（人（人（人（人（人（人4E元元产（额（元500字以内500字以1500以内（描述在1500字以税号税记证号证记证类型登登记类登期证记证银行间户ID<BR04过ID1245689101112131517181920代码/*Table: createtableENTP_INFO_APPLYnotnot VARCHAR2(200), NUMBER(18,4), NATIONAL_EXPIRY_DATEDATE, LICENSE_EXPIRY_DATEDATE, default0notnull, SPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_NUMBER_6NUMBER(16),SPECIAL_COLUMN_NUMBER_7NUMBER(16),SPECIAL_COLUMN_NUMBER_8NUMBER(16),SPECIAL_COLUMN_NUMBER_9NUMBER(16),SPECIAL_COLUMN_NUMBER_10NUMBER(16),commentontableENTP_INFO_APPLYiscommentoncolumnENTP_INFO_APPLY.IDiscommentoncolumnENTP_INFO_APPLY.ENTP_IDis'企业ID';commentoncolumnENTP_INFO_APPLY.ENTP_NAMEiscommentoncolumnENTP_INFO_APPLY.APPLY_NAMEiscommentoncolumnENTP_INFO_APPLY.LICENSE_CODEiscommentoncolumnENTP_INFO_APPLY. commentoncolumnENTP_INFO_APPLY.CUSTOM_CODEiscommentoncolumnENTP_INFO_APPLY.ENTP_NUMBERis'企业，自动生成，按P_INDEX+序列方式生成';commentoncolumnENTP_INFO_APPLY.P_INDEXiscommentoncolumnENTP_INFO_APPLY.BUSINESS_TRADE_IDiscommentoncolumnENTP_INFO_APPLY.AREA_COUNTRYiscommentoncolumnENTP_INFO_APPLY.AREA_VILLAGEiscommentoncolumnENTP_INFO_APPLY.MAP_Xis'地图X坐标';commentoncolumnENTP_INFO_APPLY.MAP_Yis'地图Y坐标';commentoncolumnENTP_INFO_APPLY.POST_CODEiscommentoncolumnENTP_INFO_APPLY. is'E－commentoncolumnENTP_INFO_APPLY.CAPITALiscommentoncolumnENTP_INFO_APPLY.ADD_DATETIMEiscommentoncolumnENTP_INFO_APPLY.LOGOUT_DATEiscommentoncolumnENTP_INFO_APPLY.CORPORATION_NAMEiscommentoncolumnENTP_INFO_APPLY.CORPORATION_SEXis'企业法定代表人,0男1女';commentoncolumnENTP_INFO_APPLY.CORPORATION_BIRiscommentoncolumnENTP_INFO_APPLY.CORPORATION_EDUiscommentoncolumnENTP_INFO_APPLY.LINK_MANiscommentoncolumnENTP_INFO_APPLY. commentoncolumnENTP_INFO_APPLY.MOBILEiscommentoncolumnENTP_INFO_APPLY.FAXiscommentoncolumnENTP_INFO_APPLY.ENTP_REG_TYPEiscommentoncolumnENTP_INFO_APPLY.EMPLOYEEiscommentoncolumnENTP_INFO_APPLY.EMPLOYEE_COLLEGEiscommentoncolumnENTP_INFO_APPLY.EMPLOYEE_DEVELOPiscommentoncolumnENTP_INFO_APPLY.ENTP_CRAF_CODEiscommentoncolumnENT commentoncolumnENTP_INFO_APPLY.PROFITiscommentoncolumnENTP_INFO_APPLY.SALESiscommentoncolumnENTP_INFO_APPLY.TAXESiscommentoncolumnENTP_INFO_APPLY.TOTAL_ASSETSiscommentoncolumnENTP_INFO_APPLY.DEVELOP_FUNDSiscommentoncolumnENTP_INFO_APPLY.PARTITION_TYPEiscommentoncolumnENTP_INFO_APPLY.BUSINESS_SCOPEis'经营范围（描述在500字以内）';commentoncolumnENTP_INFO_APPLY.ENTP_DESCis'企业简介（描述在1500字以内）';commentoncolumnENTP_INFO_APPLY.CORPORATIONis commentoncolumnENTP_INFO_APPLY.NATIONAL_CODEiscommentoncolumnENTP_INFO_APPLY.NATIONAL_DATEiscommentoncolumnENTP_INFO_APPLY.NATIONAL_EXPIRY_DATEiscommentoncolumnENTP_INFO_APPLY.NATIONAL_IMGiscommentoncolumnENTP_INFO_APPLY.LOCAL_CODEiscommentoncolumnENTP_INFO_APPLY.LOCAL_DATEiscommentoncolumnENTP_INFO_APPLY.LOCAL_EXPIRY_DATEiscommentoncolumnENTP_INFO_APPLY.LOCAL_IMGiscommentoncolumnENTP_INFO_APPLY.LICENSE_CODE2iscommentoncolumnENTP_INFO_APPLY.LICENSE_TYPEiscommentoncolumnENTP_INFO_APPLY.LICENSE_DATEiscommentoncolumnENTP_INFO_APPLY.LICENSE_EXPIRY_DATEiscommentoncolumnENTP_INFO_APPLY.LICENSE_IMGiscommentoncolumnENTP_INFO_APPLY. commentoncolumnENTP_INFO_APPLY. ANIZATION_IMGiscommentoncolumnENTP_INFO_APPLY.BANK_NAMEiscommentoncolumnENTP_INFO_APPLY.BANK_ACCOUNTiscommentoncolumnENTP_INFO_APPLY.BANK_USER_NAMEiscommentoncolumnENTP_INFO_APPLY.APPLY_DATETIMEiscommentoncolumnENTP_INFO_APPLY.APPLY_UIDiscommentoncolumnENTP_INFO_APPLY.AUDIT_STATEis'审核状态<BRcommentoncolumnENTP_INFO_APPLY.AUDIT_UIDis'审核用户ID';commentoncolumnENTP_INFO_APPLY.AUDIT_DESCiscommentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_1is'保留字段1';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_3is'保留字段3';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_4is'保留字段4';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_5is'保留字段5';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_6is'保留字段6';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_7is'保留字段7';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_8is'保留字段8';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_9is'保留字段9';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_NUMBER_10is'保留字段10';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_11is'保留字段11(保存企业详细地址信息)';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_12is'保留字段12';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_13is'保留字段13';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_14is'保留字段14';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_15is'保留字段15';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_16is'保留字段16';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_17is'保留字段17';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_18is'保留字段18';commentoncolumnENTP_INFO_APPLY.SPECIAL_COLUMN_VARCHAR_19is'保留字段19';字段属地图X坐地图X地图Y坐地图YmodMODMOD(平方米商圈类型主营业态（简称商圈办增加用户是否删除，0021删除用户04代码/*Table: createtableBUSINESS_TRADE BT_ default0not default0notnull,constraintPK_BUSINESS_TRADEprimarykey(ID)commentontableBUSINESS_TRADEiscommentoncolumnBUSINESS_TRADE.IDiscommentoncolumnBUSINESS_TRADE.BT_NAMEiscommentoncolumnBUSINESS_TRADE.BT_MAIN_IMAGEiscommentoncolumnBUSINESS_TRADE.BT_DESCiscommentoncolumnBUSINESS_TRADE.MAP_Xis'地图X坐标';commentoncolumnBUSINESS_TRADE.MAP_Yis'地图Y坐标';commentoncolumnBUSINESS_TRADE.MOD_IDiscommentoncolumnBUSINESS_TRADE.BT_AREAiscommentoncolumnBUSINESS_TRADE.BT_TYPEiscommentoncolumnBUSINESS_TRADE.MAIN_FORMATSiscommentoncolumnBUSINESS_TRADE.CHARACTERISTICiscommentoncolumnBUSINESS_TRADE.KNOWN_ENTERPRISESiscommentoncolumnBUSINESS_TRADE.BT_OFFICEiscommentoncolumnBUSINESS_TRADE.BT_ADDRiscommentoncolumnBUSINESS_TRADE.BT_iscommentoncolumnBUSINESS_TRADE.ADD_UIDis'增加用户ID';commentoncolumnBUSINESS_TRADE.ADD_DATETIMEiscommentoncolumnBUSINESS_TRADE.IS_DELis'是否删除，0否1是';commentoncolumnBUSINESS_TRADE.DEL_DATEiscommentoncolumnBUSINESS_TRADE.DEL_UIDis'删除用户ID';commentoncolumnBUSINESS_TRADE.ORDER_VALUEisII.5重置字段属用户用户1操作时代码/*Table: createtablePASSWORD_RESETnotdefault1notnotdefaultSYSDATEnotcommentontablePASSWORD_RESETiscommentoncolumnPASSWORD_RESET.IDiscommentoncolumnPASSWORD_RESET.USER_IDis'用户ID';commentoncolumnPASSWORD_RESET.UUIDiscommentoncolumnPASSWORD_RESE '申请重置操作时II.6字段属值【9090码<br/>0：，式1：02接URL11100201040102123456789代码/*Table: createtableADVERTISEMENT not default0notdefault1notdefault0notdefaultdefault0notdefault0notSPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_VARCHAR_6VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_7VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_8VARCHAR2(200),SPECIAL_COLUMN_VARCHAR_9VARCHAR2(200),commentontableADVERTISEMENTiscommentoncolumnADVERTISEMENT.IDiscommentoncolumnADVERTISEMENT.AD_NAMEiscommentoncolumnADVERTISEMENT.AD_CODEiscommentoncolumnADVERTISEMENT.AD_DESCiscommentoncolumnADVERTISEMENT.MEDIA_TYPEis 类型<br/> ，只能上传jpg、pngcommentoncolumnADVERTISEMENT.AD_SAVE_PATHiscommentoncolumnADVERTISEMENT.START_DATEiscommentoncolumnADVERTISEMENT.END_DATEiscommentoncolumnADVERTISEMENT.IS_USE_DIRECT_URIis'是否使用直接URL，0否1是';commentoncolumnADVERTISEMENT.GOTO_URLiscommentoncolumnADVERTISEMENT.CLICK_COUNTiscommentoncolumnADVERTISEMENT.IS_ENABLEis'是否启用，0否1是';commentoncolumnADVERTISEMENT.ORDER_VALUEiscommentoncolumnADVERTISEMENT.ADD_UIDis'添加用户ID';commentoncolumnADVERTISEMENT.ADD_DATETIMEiscommentoncolumnADVERTISEMENT.IS_DELis'是否删除，0否1是';commentoncolumnADVERTISEMENT.DEL_DATEiscommentoncolumnADVERTISEMENT.DEL_UIDis'删除用户ID';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_NUMBER_1is'保留字段1';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_NUMBER_2is'保留字段2';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_NUMBER_3is'保留字段3';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_NUMBER_4is'保留字段4';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_NUMBER_5is'保留字段5';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_VARCHAR_6is'保留字段6';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_VARCHAR_7is'保留字段7';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_VARCHAR_8is'保留字段8';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_VARCHAR_9is'保留字段9';commentoncolumnADVERTISEMENT.SPECIAL_COLUMN_VARCHAR_10is'保留字段10';字段属2式（短标题（短1（子标题（子接URI直接1明源1)<BR04ID04除0102ID否，1是0212357代码/*Table: createtableATTRACT_FUNDS not LINK_ IS_USE_INVALID_DATENUMBER(1), default0notnull, default0notnull, default0not SPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4VARCHAR2(200),SPECIAL_COLUMN_NUMBER_6VARCHAR2(200),SPECIAL_COLUMN_NUMBER_5VARCHAR2(200),SPECIAL_COLUMN_NUMBER_7VARCHAR2(200),'招商引资表，内容用NEWS_CONTENT，ID用与同commentoncolumnATTRACT_FUNDS.IDiscommentoncolumnATTRACT_FUNDS.UUIDiscommentoncolumnATTRACT_FUNDS.MOD_IDis'模块代码，1是招商项目2是供需对接';commentoncolumnATTRACT_FUNDS.LINK_MANiscommentoncolumnATTRACT_FUNDS.LINK_iscommentoncolumnATTRACT_FUNDS.TITLE_COLORiscommentoncolumnATTRACT_FUNDS.TITLE_IS_STRONGiscommentoncolumnATTRACT_FUNDS.TITLE_SHORTiscommentoncolumnATTRACT_FUNDS.TITLE_SUBiscommentoncolumnATTRACT_FUNDS.IS_USE_DIRECT_URIiscommentoncolumnATTRACT_FUNDS.DIRECT_URIis'直接URI';commentoncolumnATTRACT_FUNDS.KEYWORDiscommentoncolumnATTRACT_FUNDS.IMAGE_PATHiscommentoncolumnATTRACT_FUNDS.IMAGE_DESCiscommentoncolumnATTRACT_FUNDS.SUMMARYiscommentoncolumnATTRACT_FUNDS.AUTHORiscommentoncolumnATTRACT_FUNDS.INFO_SOURCEiscommentoncolumnATTRACT_FUNDS.IS_USE_INVALID_DATEiscommentoncolumnATTRACT_FUNDS.INVALID_DATEiscommentoncolumnATTRACT_FUNDS.PUB_TIMEiscommentoncolumnATTRACT_FUNDS.PUB_USERiscommentoncolumnATTRACT_FUNDS.VIEW_COUNTiscommentoncolumnATTRACT_FUNDS.P_INDEXiscommentoncolumnATTRACT_FUNDS.AUDIT_STATEis'审核状态<BRcommentoncolumnATTRACT_FUNDS.AUDIT_UIDis'审核用户ID';commentoncolumnATTRACT_FUNDS.AUDIT_DESCiscommentoncolumnATTRACT_FUNDS.ORDER_VALUEiscommentoncolumnATTRACT_FUNDS.ADD_UIDis'添加用户ID';commentoncolumnATTRACT_FUNDS.ADD_DATETIMEiscommentoncolumnATTRACT_FUNDS.IS_DELis'是否删除，0否1是';commentoncolumnATTRACT_FUNDS.DEL_DATEiscommentoncolumnATTRACT_FUNDS.DEL_UIDis'删除用户ID';commentoncolumnATTR '是否（门户显示）：0否，1是';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_1is'预留字段1';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_2is'预留字段2';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_3is'预留字段3';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_4is'预留字段4';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_6is'预留字段6';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_5is'预留字段5';commentoncolumnATTRACT_FUNDS.SPECIAL_COLUMN_NUMBER_7is'预留字段7';字段属招商引资(人报名规模(人报名报名审核状态<BR4审核用户添加用户是否删除，0是02删除用户代码/*Table: createtableATTRACT_APPLYnotdefault10notdefault0notcommentontableATTRACT_APPLYis'招商报名表，ID用与同SEQ';commentoncolumnATTRACT_APPLY.IDiscommentoncolumnATTRACT_APPLY.AF_IDis'招商引资ID';commentoncolumnATTRACT_APPLY.APPLY_TITLEiscommentoncolumnATTRACT_APPLY.APPLY_NAMEis'报名人commentoncolumnATTRACT_APPLY.APPLY_MSGiscommentoncolumnATTRA commentoncolumnATTRACT_APPLY.APPLY_ADDRiscommentoncolumnATTRACT_APPLY.APPLY_SCALEiscommentoncolumnATTRACT_APPLY.APPLY_IPis'报名IP';commentoncolumnATTRACT_APPLY.P_INDEXiscommentoncolumnATTRACT_APPLY.AUDIT_STATEis'审核状态<BRcommentoncolumnATTRACT_APPLY.AUDIT_UIDis'审核用户ID';commentoncolumnATTRACT_APPLY.AUDIT_DESCiscommentoncolumnATTRACT_APPLY.ADD_UIDis'添加用户ID';commentoncolumnATTRACT_APPLY.ADD_DATETIMEiscommentoncolumnATTRACT_APPLY.IS_DELis'是否删除，0否1是';commentoncolumnATTRACT_APPLY.DEL_DATEiscommentoncolumnATTRACT_APPLY.DEL_UIDis'删除用户ID';字段属服务类型（元0用户ID（保留字段增加服务的服务机构ID，机构只能管理自己添加004是否删除，0是02删除用户增加用户代码/*Table: createtableSERVICE_DETAIL

not default'0'notnull, default0notnull, default0notnull, default0not commentontableSERVICE_DETAILiscommentoncolumnSERVICE_DETAIL.IDiscommentoncolumnSERVICE_DETAIL.BST_IDis'服务类型ID';commentoncolumnSERVICE_DETAIL.SERVICE_NAMEiscommentoncolumnSERVICE_DETAIL.SERVICE_MONEYiscommentoncolumnSERVICE_DETAIL.SERVICE_DESCiscommentoncolumnSERVICE_DETAIL.SERVICE_UIDiscommentoncolumnSERVICE_DETAIL.AGENCIES_IDiscommentoncolumnSERVICE_DETAIL.ORDER_VALUEiscommentoncolumnSERVICE_DETAIL.IS_DELis'是否删除，0否1是';commentoncolumnSERVICE_DETAIL.DEL_DATEiscommentoncolumnSERVICE_DETAIL.DEL_UIDis'删除用户ID';commentoncolumnSERVICE_DETAIL.ADD_UIDis'增加用户ID';commentoncolumnSERVICE_DETAIL.ADD_DATETIMEis表字段属元(万元机关系(人(人(人(人真4机构地图X地图X坐地图Y地图Y坐商圈6容人号类型期银行名人名系时间是-1则不0204除，0是02户ID1223445566778899101112131416181920代码/*Table: createtableSERVICE_AGENCIES_RECORD MANA_ LINK_MAN_ INTER_TITLE_EMPLOYEENUMBER(14), NATIONAL_EXPIRY_DATEDATE, LICENSE_EXPIRY_DATEDATE, default0notdefault0notdefault0notSPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_4NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_NUMBER_6NUMBER(16),SPECIAL_COLUMN_NUMBER_7NUMBER(16),SPECIAL_COLUMN_NUMBER_8NUMBER(16),SPECIAL_COLUMN_NUMBER_9NUMBER(16),SPECIAL_COLUMN_NUMBER_10NUMBER(16),commentontableSERVICE_AGENCIES_RECORDiscommentoncolumnSERVICE_AGENCIES_RECORD.IDiscommentoncolumnSERVICE_AGENCIES_RECORD.UNIT_NAMEiscommentoncolumnSERVICE_AGENCIES_RECORD.FOUNDED_YEARiscommentoncolumnSERVICE_AGENCIES_RECORD.UNIT_NATUREiscommentoncolumnSERVICE_AGENCIES_RECORD.CAPITALiscommentoncolumnSERVICE_AGENCIES_RECORD.REG_AUTHORITYiscommentoncolumnSERVICE_AGENCIES_RECORD.MANA_iscommentoncolumnSERVICE_AGENCIES_RECORD.LINK_MANiscommentoncolumnSERVICE_AGENCIES_RECORD.LINK_MAN_iscommentoncolumnSERVICE_AGENCIES_RECORD.EMPLOYEEiscommentoncolumnSERVICE_AGENCIES_RECORD.PROFE_EMPLOYEEiscommentoncolumnSERVICE_AGENCIES_RECORD.INTER_TITLE_EMPLOYEEiscommentoncolumnSERVICE_AGENCIES_RECORD. commentoncolumnSERVICE_AGENCIES_RECORD. commentoncolumnSERVICE_AGENCIES_RECORD.UNIT_URLiscommentoncolumnSERVICE_AGENCIES_RECORD.P_INDEXiscommentoncolumnSERVICE_AGENCIES_RECORD.ENTP_CRAF_CODEiscommentoncolumnSERVICE_AGENCIES_RECORD.UNIT_IMAGEiscommentoncolumnSERVICE_AGENCIES_RECORD.MAP_Xis'地图X坐标';commentoncolumnSERVICE_AGENCIES_RECORD.MAP_Yis'地图Y坐标';commentoncolumnSERVICE_AGENCIES_RECORD.BUSINESS_TRADE_IDis'商圈ID';commentoncolumnSERVICE_AGENCIES_RECORD.UNIT_GRADEiscommentoncolumnSERVICE_AGENCIES_RECORD.UNIT_DESCiscommentoncolumnSERVICE_AGENCIES_RECORD.PERFORMANCEiscommentoncolumnSERVICE_AGENCIES_RECORD.SERVICE_QUALIFICATIONiscommentoncolumnSERVICE_AGENCIES_RECORD.CORPORATIONis commentoncolumnSERVICE_AGENCIES_RECORD.NATIONAL_CODEiscommentoncolumnSERVICE_AGENCIES_RECORD.NATIONAL_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.NATIONAL_EXPIRY_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.NATIONAL_IMGiscommentoncolumnSERVICE_AGENCIES_RECORD.LOCAL_CODEiscommentoncolumnSERVICE_AGENCIES_RECORD.LOCAL_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.LOCAL_EXPIRY_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.LOCAL_IMGiscommentoncolumnSERVICE_AGENCIES_RECORD.LICENSE_CODEiscommentoncolumnSERVICE_AGENCIES_RECORD.LICENSE_TYPEiscommentoncolumnSERVICE_AGENCIES_RECORD.LICENSE_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.LICENSE_EXPIRY_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.LICENSE_IMGiscommentoncolumnSERVICE_AGENCIES_RECORD. ANIZATION_DATEiscommentoncolumn commentoncolumnSERVICE_AGENCIES_RECORD.BANK_NAMEiscommentoncolumnSERVICE_AGENCIES_RECORD.BANK_ACCOUNTiscommentoncolumnSERVICE_AGENCIES_RECORD.BANK_USER_NAMEiscommentoncolumnSERVICE_AGENCIES_RECORD.REG_MANAiscommentoncolumnSERVICE_AGENCIES_RECORD.REG_is'人';commentoncolumnSERVICE_AGENCIES_RECORD.ADD_DATETIMEiscommentoncolumnSERVICE_AGENCIES_RECORD.IS_RECORDis'是否备案，0否1是，如果是-1则不允许再备案申请了';commentoncolumnSERVICE_AGENCIES_RECORD.ORDER_VALUEiscommentoncolumnSERVICE_AGENCIES_RECORD.IS_DELis'是否删除，0否1是';commentoncolumnSERVICE_AGENCIES_RECORD.DEL_DATEiscommentoncolumnSERVICE_AGENCIES_RECORD.DEL_UIDis'删除用户ID';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_1is'保留字段1';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_2is'保留字段2';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_3is'保留字段3';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_4is'保留字段4';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_5is'保留字段5';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_6is'保留字段6';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_8is'保留字段8';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_9is'保留字段9';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_NUMBER_10is'保留字段10';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_11is'保留字段11（保存服务机构地址信息）';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_12is'保留字段12';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_13is'保留字段13';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_14is'保留字段14';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_15is'保留字段15';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_16is'保留字段16';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_17is'保留字段17';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_18is'保留字段18';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_19is'保留字段19';commentoncolumnSERVICE_AGENCIES_RECORD.SPECIAL_COLUMN_VARCHAR_20is'保留字段20';表字段属服务机构服务类型服务父ID，顶级为0代码/*Table: createtableSERVICE_TYPE_LINKnotnotnotcommentontableSERVICE_TYPE_LINKiscommentoncolumnSERVICE_TYPE_LINK.IDiscommentoncolumnSERVICE_TYPE_LINK.SAR_IDis'服务机构ID';commentoncolumnSERVICE_TYPE_LINK.ST_IDis'服务类型ID';commentoncolumnSERVICE_TYPE_LINK.ST_PIDis'服务父类型ID，顶级为0';表名字段属备案备案服务机构服务类型服务父类型ID，顶级为0代码/*Table: createtableSERVICE_TYPE_LINK_APPLY not commentontableSERVICE_TYPE_LINK_APPLYiscommentoncolumnSERVICE_TYPE_LINK_APPLY.IDiscommentoncolumnSERVICE_TYPE_LINK_APPLY.APPLY_IDis'备案ID';commentoncolumnSERVICE_TYPE_LINK_APPLY.SAR_IDis'服务机构ID';commentoncolumnSERVICE_TYPE_LINK_APPLY.ST_IDis'服务类型ID';commentoncolumnSERVICE_TYPE_LINK_APPLY.ST_PIDis'服务父类型ID，顶级为0';表字段属机构2元(万元机关系(人术(人(人(人真件4机构地图X地图X坐地图Y地图Y坐商圈容期税期类型证银行人名人系时间用户ID<BR04ID见11223344556678891011121314151617181920代码/*Table: createtableSERVICE_AGENCIES_RECORD_APPLY MANA_ LINK_MAN_ INTER_TITLE_EMPLOYEENUMBER(14), NATIONAL_EXPIRY_DATEDATE, LICENSE_EXPIRY_DATEDATE, REG_ default0notnull, SPECIAL_COLUMN_NUMBER_1NUMBER(16),SPECIAL_COLUMN_NUMBER_2NUMBER(16),SPECIAL_COLUMN_NUMBER_3NUMBER(16),SPECIAL_COLUMN_NUMBER_5NUMBER(16),SPECIAL_COLUMN_NUMBER_6NUMBER(16),SPECIAL_COLUMN_NUMBER_7NUMBER(16),SPECIAL_COLUMN_NUMBER_8NUMBER(16),SPECIAL_COLUMN_NUMBER_9NUMBER(16),SPECIAL_COLUMN_NUMBER_10NUMBER(16),commentontableSERVICE_AGENCIES_RECORD_APPLYiscommentoncolumnSERVICE_AGENCIES_RECORD_APPLY.IDiscommentoncolumnSERVICE_AGENCIES_RECORD_APPLY.AGENCIES_IDis'机构ID';commentoncolumnSERVICE_AGENCIES_RECORD_APPLY.UNIT_NAMEiscommentoncolumnSERVICE_AGENCIES_RECORD_APPLY.APPLY_NAMEiscommentoncolumnSERVICE_AGENCIES_RECORD_APPLY.FOUNDED_YEARiscommentonco