Data dictionary, a basic function of the management background

As an important part of the management background, the existence and design of data dictionaries are very important. In this article, the author has sorted out and summarized the corresponding functional requirements of the data dictionary, and students who want to know about it may wish to take a look.

1. Introduction

The data dictionary is the basic function and important part of the management background, through which the content of the drop-down menu (single or multiple selection) of the current system can be uniformly standardized, which is convenient for the enumeration of parameters required by the management system.

1. Purpose

Software requirements are the basis of software development and the basis of software engineering activities. The purpose of writing this PRD is to clearly and accurately describe the requirements of the kite competition applet, and provide a reliable basis for formulating the project development plan and the later stage of outline design, prototype design, testing and other stages.

2. Scope

This document is intended for product managers, project managers, UI designers, development engineers, and test engineers.

2. Product Overview

There are many application scenarios of data dictionaries, especially for fields with changes in enumeration content, which can quickly and easily manage the display content of fields through data dictionaries.

3. Description of functional requirements

Data Dictionary

1) Inquiry

Page Design:

Requirement Description:

Data dictionary menu, which is used to manage field information and enumerated values of data dictionary;

Data dictionary menu, support fuzzy query of dictionary Chinese name;

Data dictionary menu, the display content includes: serial number, dictionary Chinese name, dictionary English name, remarks, status, last modified time and last modified person;

Data dictionary menu, supporting: query, reset, modify records, delete records, export templates, import, export, add, enumerate values, modify, start and stop, and delete operations;

Instructions:

• Query: Enter the Chinese name of the dictionary, click the [Query] button, and query the data dictionary information according to the input content;
• Reset: Click the [Reset] button to query the conditions, and all data dictionary information will be displayed by default;
• Modification Record: Click the [Modification Record] button to jump to the Modification Record page, which displays the content of the data dictionary modification record on the current page.
• Delete Records: Click the [Delete Records] button to jump to the Delete Records page, which displays the data dictionary on the current page to delete the record contents.
• Export Template: Click the [Import Template] button to download the import template file;
• Import: Click the [Import] button, select the import file of the current device, and add data dictionary content in batches according to the import file;
• Export: Click the [Export] button to export the export file according to the query result, and the content of the exported file is consistent with the query result.
• New: Click the [New] button, and a pop-up window will display the new page;
• Enumerated Values: Click the [Enumerated Values] button to jump to the Enumerated Values page and maintain the enumerated value information of the data dictionary;
• Modify: Click the [Modify] button, and a pop-up window will display the modification page to modify the data dictionary information;
• Start & Stop: Field Status: Enabled, the action bar displays the Deactivate button, the operation is completed, and the modified field status is Deactivated; Field Status: Deactivated, the action bar displays the Enable button, the operation is completed, and the modified field status is Enabled; The data dictionary in the deactivated state cannot be used normally; It is recommended to distinguish between the blue and red buttons to prevent users from misoperation.
• To delete, click the [Delete] button to delete the content of the data dictionary, and the deletion needs to be confirmed twice before the operation can be successful.

2) Modify the record

Page Design:

Requirement Description:

1. In the data field menu, click the [Modify Record] button to jump to the Modify Record page;
2. On the Modify Record page, the menu to which it belongs is the Data Dictionary by default, and the displayed content is the Modify Record content of the Data Dictionary page.
3. Modify the record page, support the page to which it belongs, the field name, the modifier and the modification time, the page to which it belongs, the page name, the field name, the fuzzy query, the modified person, the fuzzy query, the modification time, the time period, accurate to the second.
4. On the Modify Record page, the displayed content includes: the page to which it belongs, the field name, the before and after the modification, the review status, the modification time, and the modification by.

3) Delete the record

Page Design:

Requirement Description:

1. In the data field menu, click the [Delete Record] button to jump to the Delete Record page;
2. On the Delete Record page, the menu to which it belongs is Data Dictionary by default, and the displayed content is the deleted record content of the Data Dictionary page.
3. If you delete a record page, you can query the page to which you belong, the name of the field, the person who modified it, and the time you want to query it, and the page to which it belongs can be queried by fuzzy page, and the page to which you belong can be queried fuzzy, and the page to which you belong can be queried fuzzy, and the field name can be queried by the modified page, and the page to which you belong can be queried.
4. On the Delete Record page, the displayed content includes: the page to which it belongs, the field name, the review status, the deletion time, and the deletion user.
5. Click the Restore button to recover the deleted data.

4) New

Page Design:

Requirement Description:

1. In the data dictionary menu, click the [New] button, and a pop-up window will display the new page;
2. Add a new page, the new data dictionary needs to fill in the dictionary Chinese name and dictionary English name, the remarks information is not required; the dictionary Chinese name and dictionary English name cannot be repeated;
3. The data dictionary is added and the content of the data dictionary is refreshed.

5) Enumeration values

Page Design:

Query results

New

Requirement Description:

In the data dictionary menu, click the [Enumeration Value] button to jump to the enumeration value page;

The enumeration value page, which is used to maintain the field content of the data dictionary;

The enumeration value page supports fuzzy query of dictionary tags;

The enumerated values page displays the following contents: dictionary encoding, dictionary tags, dictionary keys, dictionary order, status, last modified time, and most recently modified person;

Data dictionary menu, supporting: query, reset, modify records, delete records, export templates, import, export, add, modify, start and stop, and delete operations;

Instructions:

• Query: Enter the dictionary tag, click the [Query] button, and query the enumerated value information according to the input content.
• Reset: Click the [Reset] button to query the conditions, and all enumerated value information will be displayed by default;
• Modification History: Click the [Modification Record] button to jump to the Modification Records page, which displays the enumeration value of the current page.
• Delete Record: Click the [Delete Record] button to jump to the Delete Record page, which displays the enumerated value record content of the current page.
• Export Template: Click the [Import Template] button to download the import template file;
• Import: Click the [Import] button, select the import file of the current device, and add the enumeration value content in batches according to the import file;
• Export: Click the [Export] button to export the export file according to the query result, and the content of the exported file is consistent with the query result.
• New: Click the [Add] button to display the new page, and the pop-up window will display the new page, and the new page for enumerated values needs to be filled in: dictionary tags, dictionary keys, dictionary order, and comments; dictionary tags and dictionary keys cannot be repeated; dictionary order is an integer; remarks are not required;
• Modify: Click the [Modify] button, and a pop-up window will display the modification page to modify the enumeration value information;
• Start & Stop: Field Status: Enabled, the action bar displays the Deactivate button, the operation is completed, and the modified field status is Deactivated; Field Status: Deactivated, the action bar displays the Enable button, the operation is completed, and the modified field status is Enabled; The enumerated values in the deactivated state cannot be used normally; It is recommended to distinguish between the blue and red buttons to prevent users from misoperation.
• To delete, click the [Delete] button to delete the enumerated value, and the deletion needs to be confirmed twice before the operation can be successful.

Columnist

No regrets, everyone is a product manager columnist. Nine years of product experience, across multiple industries and fields, focusing on finance and marketing, good at product demand analysis, there is an extraordinary heart under the ordinary appearance.

This article was originally published on Everyone is a Product Manager. Reproduction without permission is prohibited

Image from Unsplash, based on the CC0 license

The views in this article only represent the author's own, everyone is a product manager, and the platform only provides information storage space services.