摘要 |
PROBLEM TO BE SOLVED: To provide a database system for sewerage maintenance management for making it easy to add and delete a maintenance item even after the operation of the system.SOLUTION: The database system includes at least: an attribute name management table in which the destinations of attributes as the management items of sewerage maintenance management and attribute IDs applied to the destinations of the attributes are associated with each other and arrayed in a vertical direction; an attribute value management table in which attribute values as the data of each attribute and value IDs preliminarily applied to the attribute values are associated with the attribute IDs and arrayed in a vertical direction; and a set data management table in which set IDs applied for each set (tuple) of data and the attribute IDs and the attribute values of each attitude are arrayed in a vertical direction as each column. On the display screen of a computer, when a set ID is selected by an operator, the set data management table, the attribute name management table and the attribute value management table are searched by using the set ID as a key, and a sewerage maintenance management table in which the attribute names and the attribute values are arrayed in a vertical direction as each column is displayed. |