HOME   Cart(0)   Quotation   About-Us Policy PDFs Standard-List
www.ChineseStandard.net Database: 189760 (18 Oct 2025)

HJ 723-2014 English PDF

US$1359.00 · In stock
Delivery: <= 8 days. True-PDF full-copy in English will be manually translated and delivered via email.
HJ 723-2014: Specification for environmental information data dictionary
Status: Valid
Standard IDContents [version]USDSTEP2[PDF] delivered inStandard Title (Description)StatusPDF
HJ 723-2014English1359 Add to Cart 8 days [Need to translate] Specification for environmental information data dictionary Valid HJ 723-2014

Standard similar to HJ 723-2014

HJ 511   HJ 945.3   HJ 943   

Basic data

Standard ID HJ 723-2014 (HJ723-2014)
Description (Translated English) Specification for environmental information data dictionary
Sector / Industry Environmental Protection Industry Standard
Word Count Estimation 52,592
Date of Issue 12/25/2014
Date of Implementation 3/1/2015
Quoted Standard HJ/T 419
Regulation (derived from) Ministry of Environmental Protection Notice 2014 No. 87
Issuing agency(ies) Ministry of Ecology and Environment
Summary This standard specifies the content of environmental information and attribute data dictionary consisting of requirements and provides dictionary-style and environmental information common data dictionary-like form. This standard applies to all levels of

HJ 723-2014: Specification for environmental information data dictionary

---This is a DRAFT version for illustration, not a final translation. Full copy of true-PDF in English version (including equations, symbols, images, flow-chart, tables, and figures etc.) will be manually/carefully translated upon your order.
Specification for environmental information data dictionary National Environmental Protection Standard of the People 's Republic of China Environmental Information Data Dictionary Specification 2014-12-25 release 2015-03-01 Implementation Ministry of Environmental Protection released Directory Preface ..i

1 Scope of application

2 normative reference documents

3 terms and definitions

4 environmental information data dictionary content composition 1 5 Environmental Information Data Dictionary Content Attribute 2 6 environmental information data dictionary preparation requirements 6 Appendix A (Normative Appendix) "Environmental Information Data Dictionary" Table 8 Appendix B (informative) "Environmental Quality Object Basic Information Database Data Dictionary" Appendix C (informative) "Industrial key pollution source object basic information database data dictionary" table example.

Foreword

For the implementation of the "People's Republic of China Environmental Protection Law" to promote environmental information work, standardize the environmental information database Data dictionary design and environmental information database construction, the development of this standard. This standard specifies the environmental information data dictionary content composition, attributes and preparation requirements and so on. This standard is the first release. Appendix A to this standard is a normative appendix, Appendix B, Appendix C is an informative appendix. This standard is organized by the Ministry of Environmental Protection Science and Technology Standards Division. The main drafting of this standard. Environmental Information Department of the Ministry of Environmental Protection, Beijing Environmental Information Center. The Environmental Protection Department of this standard approved on December 25,.2014. This standard is implemented on March 1,.2015. This standard is explained by the Ministry of Environmental Protection.

1 Scope of application

This standard specifies the content and attribute requirements of the environmental information data dictionary and provides common dictionary styles and environmental letters Data table. This standard applies to all levels of environmental protection department environmental information database data dictionary design, and can be used as environmental letter Information database system design acceptance of the reference.

2 normative reference documents

The contents of this standard refer to the following documents or their terms. Those who do not specify the date of the reference file, the effective version of the appropriate For this standard.

3 terms and definitions

The following terms and definitions apply to this standard. 3.1 Environmental information data dictionary environmental information data dictionary The information system of the environment information database is a collection of information that records the composition and format of the database. surroundings The information data dictionary belongs to the category of environmental information metadata, which consists of entity and data element.

4 environmental information data dictionary content composition

4.1 Environmental information Data dictionary content Environment information data dictionary content reference HJ/T 419, by the data dictionary management information, data table information, view information, Stored procedure information, user function information, user-defined data type information, data item (field) information, and so on. 4.2 Environmental Information Data Dictionary Management Information Entity By the data dictionary name, version, data dictionary author, data dictionary write date, data dictionary status, data Dictionary audit unit, data dictionary reviewer, audit date and other data elements. 4.3 Environmental Information Data Table Entity By the data table name, Chinese name, description, regulatory agencies, contacts, contact telephone, contact Email, contact address And the zeros, update units, update date, record number, capacity (MB), trigger description, index description and other data elements. 4.4 View information entity It consists of data elements such as view name, Chinese name, description, script, update unit, update person, update date and so on. 4.5 Stored procedure information entity By the stored procedure name, Chinese name, description, script, input parameter description, output parameter description, update unit, Update person, update date and other data elements. 4.6 User function information entity By the function name, Chinese name, description, script, input parameter description, output parameter description, update unit, update Person, update date and other data elements. 4.7 User-defined data type information entity It consists of user-defined data type name, Chinese name, system data type, description, length and other data elements. 4.8 data item (field) information entity By the field name, Chinese name, data type, length, precision, unit of measurement, the value range, whether it can be empty, Whether the primary key, whether the foreign key, foreign key table name, default, notes and other data elements. 4.9 Other information entities Including data dictionary information for other data entities that are not listed above.

5 Environmental Information Data Dictionary Content Attributes

5.1 Data dictionary content attributes Environment Information Data Dictionary The content attribute consists of name, domain name, whether it is required, maximum number of occurrences, data type, Range of values. 5.1.1 Name A token assigned to an entity or data element. The entity name is unique in the environmental information data dictionary, the data element name In the entity is unique, and in the environmental information data dictionary can not be unique. 5.1.2 domain name The abbreviation of the name is usually expressed in English or Chinese phonetic alphabet. 5.1.3 is required Indicating whether the data element should always be selected, or sometimes selected (ie, have values). The descriptor can have the following values. yes (must Optional) or NULL (optional). 5.1.4 Maximum number of occurrences Specifies the maximum number of instances the data element can have. Only once with "1" said. Repeat the "N" table Show. The number of fixed occurrences of 1 can be expressed by the corresponding numbers, such as "2", "3", "4". Does not appear with "0" or "NULL" means. 5.1.5 Data type Describe the data types of data dictionary entities and data elements, such as integers, real types, strings, and so on. Basic data type see Table 1. Table 1 List of basic data types Data type description An entity represents a compound element that can consist of an element or entity. Text/character (string) Free text, indicating that there is no restriction on the contents of the data item (field). A type of value expressed by a number Date The type of value that is expressed in the form of YYYYMMDD Date datetime The type of value expressed in the form of YYYYMMDDhhmmss Boolean (boolean) two and only two values that indicate the condition, such as True or False. (1 or 0) Binary (binary) through the binary format to store objects, such as pictures, audio, video and so on 5.1.6 Range of values Describe the allowable range of data elements. If the range is "free text", there is no restriction on the contents of the data element. 5.2 Data dictionary management information Environmental information data dictionary management information attributes and fill requirements, see Table 2. Table 2 Environmental Information Data Dictionary Management Information Attribute Description and Filling Requirements Serial number maximum appear frequency data Types of Domain name Whether it is Required fields Remarks 1 data dictionary name 1 text free text DictName yes The full name of the database 'Data Dictionary' 2 version 1 text free text DictVersion is 3 Data Dictionary Writer 1 Text Free Text DictAuthor Yes 4 Data Dictionary Write Date 1 Date Type DictDate Yes year month day (YYYYMMDD) The data dictionary is last modified date

1 date type DictUpdate yes

year month day (YYYYMMDD) 6 Data dictionary state 1 text "Complete", "ministry" Points to complete " "undone" DictStatus is 7 Data Dictionary Auditing Unit 1 Text Free Text DictCheckUnit Yes 8 Data Dictionary Auditor 1 Text Free Text DictChecker Yes 9 Review Date 1 Date DictCheckDate Yes year month day (YYYYMMDD) 5.3 Data sheet information Environmental information data sheet attribute description and fill requirements, see Table 3. Table 3 Environmental Information Data Sheet Attribute Description and Filling Requirements Serial number Maximum out The number of times Data Type Value Domain Name Whether it is Required fields Remarks 1 Data Table Name 1 Text Free Text TableName Yes The storage name in the database 2 Chinese name 1 text free text TableCname yes 3 Description 1 Text Free Text TableContentInfo Yes Serial number Maximum out The number of times Data Type Value Domain Name Whether it is Required fields Remarks 4 Regulatory Body 1 Text Free Text TableStrct Responsible for the contents of the data sheet Regulatory Authority 5 Contacts 1 Text Free Text Linkman Yes Record the connection of the data sheet 6 Contact Phone 1 Text Free Text LinkmanTel 7 Contact Email 1 Text Free Text LinkmanMail Contact address and Zip code

1 text free text LinkAddress

9 update unit 1 text free text UpdateUnit is 10 Update Date 1 Date UpdateTime Yes year month day (YYYYMMDD) 11 record number 1 record type RecordNum Need to indicate 'expected' or 'real Inter - 12 capacity (MB) 1 value type Need to indicate 'expected' or 'real Inter - 13 Trigger Description 1 Text Free Text TriggerInfo The concentration of multiple triggers description 14 Index Description 1 Text Free Text IndexInfo A collection of multiple indexes 5.4 View information View information attribute description and fill requirements, see Table 4. Table 4 View information attribute description and fill request Serial number The largest appearance frequency data Types of Domain name Whether it is necessary Fill in Remarks 1 view name 1 text free text ViewName yes Storage in the database name 2 Chinese name 1 text free text ViewCname is the Chinese name 3 Description 1 Text Free Text ViewContentInfo Yes 4 Script 1 Text Free Text ViewCode Yes Create the view's SQL Statement 5 Update Unit 1 Text Free Text UpdateUnit is the unit that updates the view 6 Updater 1 Text Free Text Creator is the person who updates the view 7 Update Date 1 Date UpdateTime Yes year month day (YYYYMMDD) 5.5 Stored procedure information Stored procedure information attribute description and fill request, see Table 5. Table 5 Stored procedure attribute description and fill request Serial number Maximum out The number of times data Types of Domain name Whether it is Required fields Remarks Serial number Maximum out The number of times data Types of Domain name Whether it is Required fields Remarks Stored procedure name

1 text free text Pname is

The storage name in the database 2 Chinese name 1 text free text Pcname is the Chinese name 3 Description 1 Text Free Text PcontentInfo Yes 4 script 1 text free text Pcode is Create a stored procedure SQL statement Enter the parameter description

1 text free text InputParaInfo

Output parameter description

1 text free text OutputParaInfo

7 Update Unit 1 Text Free Text UpdateUnit Yes Update the stored procedure 8 Updater 1 Text Free Text Creator Yes Update the stored procedure 9 Update Date 1 Date UpdateTime Yes year month day (YYYYMMDD) 5.6 User function information User function attribute description and fill request, see Table 6. Table 6 User function attribute description and fill request Serial number Maximum out The number of times data Types of Domain name Whether it is Required fields Remarks 1 user function name 1 text free text FunctionName is Storage in the database name 2 Chinese name 1 text free text FunctionCname is the Chinese name 3 Description 1 Text Free Text FunctionInfo Yes 4 Script 1 Text Free Text FunctionCode Yes Create a function of SQL Statement 5 Input Parameter Description 1 Text Free Text InputParaInfo 6 Output Parameter Description 1 Text Free Text OutputParaInfo Yes 7 Update Unit 1 Text Free Text UpdateUnit Yes Update the user function unit 8 Updater 1 Text Free Text Creator Yes Update the user function personnel 9 Update Date 1 Date UpdateTime Yes year month day (YYYYMMDD) 5.7 User-defined data type information User-defined data type information attribute description and fill requirements, see Table 7. Table 7 User-defined data type information Attribute description and fill request Serial number Maximum out The number of times data Types of Domain name Whether it is necessary Fill in Remarks User-defined data Type name

1 text free text UDTypeName is

Storage in the database name 2 Chinese name 1 text free text UDCname is the Chinese name 3 System Data Type 1 Text Free Text SysType Yes 4 Description 1 Text Free Text UDContentInfo Yes 5 Length 1 Value Length is the number of bytes 5.8 Data item (field) information Data item (field) information attribute description and fill in the requirements, see Table 8. Table 8 Data item (field) Information attribute description and fill request Serial number Maximum out The number of times data Types of Domain name Whether it is necessary Fill in Remarks 1 field name 1 text free text FieldName is Storage in the database name 2 Chinese name 1 text free text FieldCname is the Chinese name 3 Data Type 1 Text Free Text FieldDataType Yes 4 Length 1 Value FieldLength bytes 5 Accuracy 1 Value FieldPrecision Numeric field fraction Number of bits 6 Unit of measure 1 Text Free text FieldUnit 7 Range of values 1 Text Free text ValueCon 8 can be empty 1 boolean type 1,0 or Null (empty) IsNull is 1 that can be empty 9 is the primary key 1 boolean type 1,0 or Null (empty) IsPrimaryKey If the primary key, then fill in 1, if the primary key is 0 Or empty 10 is a foreign key 1 boolean type 1,0 or Null (empty) IsForeignKey If foreign key, fill in 1, if not foreign key can be Is empty 11 foreign key table name 1 text free text FKTable Foreign key associated data Table name 12 Default value 1 Text Free text DefaultValue 13 Remarks 1 Text Free text Memo 5.9 Other entity information If other entity information, should also be in accordance with the data dictionary content attributes for a comprehensive description of the preparation of specific fill requirements.

6 environmental information data dictionary preparation requirements

Environmental information database system development and design units should write a database data dictionary, data dictionary table see Appendix A. ring The information dictionary of the environment information database can be used as the environmental protection department at all levels to accept the environmental information database system development and design unit The completion of the database system design reference. This standard takes the basic information data dictionary of environmental quality object and the basic information data dictionary of industrial key pollution source object as an example For the design of the environmental information data dictionary, see Appendix B, Appendix C.

Appendix A

(Normative appendix) "Environmental Information Data Dictionary" A.1 Data dictionary management information The data dictionary management information contains the following. A) data dictionary name; B) version; C) data dictionary writer; D) Data dictionary writing date; E) the state of the data dictionary; F) data dictionary audit unit; G) Data dictionary reviewers; H) the date of the audit. A.2 data sheet data Table Name Chinese name contact Email Contact Address and post Update date capacity (MB) trigger Strokes index description Note. When the contact of each data sheet for the same person, the contact information only fill in the first line can be. A.3 view No. View Name Chinese Name Description Script Update Unit Update Person Update Date A.4 stored procedure Serial number stored procedure name Chinese name description script input parameter description Output parameters description Update unit Update person update day A.5 user function Serial number user function name Chinese name Description Script Input Parameter Description Output parameter description Update unit Update person update date A.6 User-defined data types No. User Defined Data Type Name Chinese Name System Data Type Description Length A.7 data item (field) < Data table name> Field name Chinese name data Types of Metering unit Value range Whether it can be Thought it was empty whether Mainly whether For the outside Foreign key Table Name

Appendix B

(Informative) "Environmental Quality Object Basic Information Database Data Dictionary" B.1 Environmental Quality Object Basic Information Database Dictionary Management Information A) Data dictionary name. Environmental quality object Basic information Database data dictionary B) Version. 1.0 C) Data dictionary Written by. Li ×× D) Data Dictionary Date. August 31,.2010 E) Status of the data dictionary. Completed F) Data dictionary Audit unit. ××× Environmental monitoring center station G) Data dictionary Auditor. Zhang ×× H) Review date. April 15,.2011 B.2 Environmental Quality Data Sheet No. Data Sheet Name Chinese Description Regulatory Agency Contact Phone Contact Email Contact address and Zip code Update unit update date recording capacity (MB) trigger description index description 1 T_Env_Moni_Station Station basic information Record the station Basic Information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2012-XX- XX 3000 10 no no 2 T_Env_Moni_StationAir atmospheric measurement point recorded atmospheric measurement XX environmental monitoring Zhang XX 010-XXXXXX [email protected] Beijing XX XX environmental monitoring.2011-XX- 100 1 no No. Data Sheet Name Chinese Description Regulatory Agency Contact Phone Contact Email Contact address and Zip code Update unit update date recording capacity (MB) trigger description index description Information point unique letter Test Center Station XX Zip Measuring center station XX 3 T_Env_Moni_StationRiver River information Record the river Basic Information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 4 T_Env_Moni_StatRiverSection River section information Record river break Face information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 5 T_Env_Moni_StationLake lake information Record the lake library Basic Information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 6 T_Env_Moni_StatLakeSection Lake library vertical line information Record the lake library Line information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 7 T_Env_Moni_DrinkWaterSource Drinking water sources Foundation letter Record drinking water Source of the base information XX environmental monitoring Measuring center station Lee XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 8 T_Env_Moni_StatNoiseRegion Regional network Noise measurement points Record the area network Noise measurement points XX environmental monitoring Measuring center station Wang XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no No. Data Sheet Name Chinese Description Regulatory Agency Contact Phone Contact Email Contact address and Zip code Update unit update date recording capacity (MB) trigger description index description Of the information 100000 9 T_Env_Moni_StatNoiseArea Functional area noise Sound points Record the functional area Noise measurement point information XX environmental monitoring Measuring center station Wang XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 10 T_Env_Moni_StatNoiseRoad the traffic Noise measurement points Record road cross Noise measurement points The information XX environmental monitoring Measuring center station Wang XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 11 T_Env_Moni_Soil Soil sampling Point information Record soil picking Sample information XX environmental monitoring Measuring center station Zhao XX 010-XXXXXX XX [email protected] Beijing XX Zip code XX environmental monitoring Measuring center station 2011-XX- XX 100 1 no no 12 T_Cod_StandardDrink Drinking water Quality standards Record drinking water Water quality standards XX environmental monitoring Measuring center...

Tips & Frequently Asked Questions:

Question 1: How long will the true-PDF of HJ 723-2014_English be delivered?

Answer: Upon your order, we will start to translate HJ 723-2014_English as soon as possible, and keep you informed of the progress. The lead time is typically 5 ~ 8 working days. The lengthier the document the longer the lead time.

Question 2: Can I share the purchased PDF of HJ 723-2014_English with my colleagues?

Answer: Yes. The purchased PDF of HJ 723-2014_English will be deemed to be sold to your employer/organization who actually pays for it, including your colleagues and your employer's intranet.

Question 3: Does the price include tax/VAT?

Answer: Yes. Our tax invoice, downloaded/delivered in 9 seconds, includes all tax/VAT and complies with 100+ countries' tax regulations (tax exempted in 100+ countries) -- See Avoidance of Double Taxation Agreements (DTAs): List of DTAs signed between Singapore and 100+ countries

Question 4: Do you accept my currency other than USD?

Answer: Yes. If you need your currency to be printed on the invoice, please write an email to [email protected]. In 2 working-hours, we will create a special link for you to pay in any currencies. Otherwise, follow the normal steps: Add to Cart -- Checkout -- Select your currency to pay.