JP6466370B2 - Table information processing apparatus, table information processing method, and program - Google Patents

Description

  The present invention relates to a table information processing apparatus or the like that processes table information.

  Some conventional table information processing apparatuses edit or present table information (for example, see Non-Patent Document 1).

Microsoft, “Excel”, [online], [Search June 9, 2016], Internet [URL: https://products.office.com/ja-jp/excel]

  However, in the conventional table information processing apparatus, the table records cannot be easily edited or presented.

  The table information processing apparatus according to the first aspect of the present invention provides a table storage unit for storing a table having one or more records, a table output unit for outputting a table, and a table output by the table output unit. A selection receiving unit for receiving selection of one record, and a screen in which one or more attribute values of the selected one record are read from the table storage unit and each of the one or more attribute values is assigned to a corresponding field. A screen composition part, a screen output part for outputting a screen composed of the screen composition part, an edit instruction reception part for accepting an edit instruction for the screen output by the screen output part, and one record according to the edit instruction Is a table information processing apparatus including a record update unit that edits and updates a record.

  With this configuration, the table record can be easily edited.

  In the table information processing apparatus according to the second aspect of the present invention, the table output unit adds an edit button for calling a screen to each of one or more records and configures a table to be output. It is a table information processing apparatus comprising table composition means and table output means for outputting a table constituted by the table composition means.

  With this configuration, the screen corresponding to the desired record can be called with the button, so that the table record can be edited more easily.

  In the table information processing apparatus according to the third aspect of the present invention, the record has one or two or more attribute values that are attribute values, with respect to the first or second aspect of the invention. Corresponding information further includes a required information storage unit for storing required information indicating whether or not the attribute value is required, and the screen configuration unit indicates that the attribute value is required to be present. Is a table information processing apparatus constituting a screen in which the background color of the field corresponding to is different from the background color of other fields.

  With this configuration, the fields for which attribute values must be input can be seen at a glance, so that the table records can be edited more easily.

  The table information processing apparatus according to the fourth aspect of the invention corresponds to the third aspect of the invention, an input receiving unit for receiving input of attribute values for fields, and essential information indicating that the presence of attribute values is essential. The table information processing apparatus further includes a screen changing unit that changes the background color of the field to a color corresponding to the input of the attribute value when the input of the attribute value for the field to be received is accepted.

  With this configuration, when an attribute value is entered in a mandatory input field, the background color is changed, so it can be seen at a glance whether the attribute value has been entered in the mandatory field. Can be edited more easily.

  In the table information processing apparatus according to the fifth aspect of the invention, a table storage unit storing a table having one or two or more records having two or more attribute values and one or more records constituting the table are included. Corresponding to the attribute value of the first attribute of each of the one or more records constituting the table, the correspondence information storage unit storing two or more correspondence information for associating the attribute value of the first attribute with the attribute value of the field The attribute value of the field to be acquired using the correspondence information, the attribute value of the second attribute included in each of the one or more records is acquired, the field having the attribute value of the acquired field, A screen configuration unit configured with one or more records constituting a table, and a screen output unit configured to output a screen configured by the screen configuration unit, the screen having one or more fields having attribute values as values in the field; Table information provided It is a management apparatus.

  With this configuration, two or more attribute values are presented in one field for each of one or more records, so that the table records can be efficiently presented.

  The table information processing apparatus according to the sixth aspect of the present invention is a table information processing apparatus in which the field attribute value is the background color of the field.

  With this configuration, among two or more attribute values, one attribute value is indicated by a character string in the field, while the other attribute value is indicated by a field background color. Therefore, two or more attribute values indicated by one field Can be understood at a glance, and the table records can be presented more efficiently.

  ADVANTAGE OF THE INVENTION According to this invention, the table | surface information processing apparatus etc. which can edit or browse a table record easily are implement | achieved.

Block diagram of table information processing apparatus 1 in the embodiment Flow chart for explaining the overall operation of the table information processing apparatus 1 The flowchart explaining the table output process of the table information processing apparatus 1 The flowchart explaining the edit screen structure process of the table information processing apparatus 1 The flowchart explaining the background color change process of the table information processing apparatus 1 The flowchart explaining the screen change process of the table information processing apparatus 1 The flowchart explaining another operation | movement of the table information processing apparatus 1 Data structure diagram of the table Figure showing output example of the same table The figure which shows the example output of the same edit screen Figure showing the edit screen after the change Data structure diagram of the correspondence information The figure which shows the output example of the presentation screen External view of the computer system 900 Internal configuration diagram of the computer system 900

  Hereinafter, an embodiment of a table information processing apparatus or the like that can easily edit or view a table record will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again. Moreover, the table illustrated below is a table for managing information necessary for the registration procedure of the automobile, but the contents of the table are not limited. The table is a table of a database such as a relational database or an object-oriented database, a table of spreadsheet software, or the like. Needless to say, the structure of the table does not matter.

  FIG. 1 is a block diagram of a table information processing apparatus 1 in the present embodiment. The table information processing apparatus 1 includes a storage unit 11, a reception unit 12, a processing unit 13, and an output unit 14. The storage unit 11 includes a table storage unit 111, a correspondence information storage unit 112, an essential information storage unit 113, and a screen information storage unit 114. The receiving unit 12 includes a selection receiving unit 121, an editing instruction receiving unit 122, and an input receiving unit 123. The processing unit 13 includes a screen configuration unit 131, a record update unit 132, and a screen change unit 133. The output unit 14 includes a table output unit 141 and a screen output unit 142. The table output unit 141 includes a table configuration unit 1411 and a table output unit 1412.

  The storage unit 11 can store various types of information. The various information includes, for example, a table, correspondence information described later, essential information described later, screen information described later, and the like.

  The storage unit 11 may store a set of attribute names, field identifiers, and flags. The attribute name is the name of the attribute. The attribute name is, for example, “new user”, “consignment date”, etc., but any name may be used. A field identifier is an identifier for identifying a field. The field identifier is, for example, “1”, “2”,... The flag will be described later.

  The storage unit 11 may store a set of a specific attribute name and one or more attribute names related to the specific attribute name. The specific attribute name is, for example, “garage delivery date”, but may be anything. One or more attribute names related to the specific attribute name are, for example, “new user”, “scheduled receipt date”, and “garage remarks”, but may be anything.

  A table is stored in the table storage unit 111. The stored table is composed of one or more records, and each of the one or more records has an ID for identifying the record and one or more attribute values corresponding to the one or more attributes. However, the data structure of the stored table does not matter. For example, the ID is a number such as “7535”, “7534”,... One or more attribute values corresponding to one or more attributes are attribute value “(existing) DEF” corresponding to attribute “new user”, 2006-05-11 corresponding to attribute “consignment date”, attribute “consignment” Attribute value “transfer” corresponding to “content”, “Morioka 580 ○○○○” corresponding to attribute “registration number”, “2016-05-15” corresponding to attribute “garage delivery date”, attribute “to be received” “2016-05-18” corresponding to “day”, “garage only” corresponding to the attribute “garage remarks”, and so on.

  The correspondence information storage unit 112 stores one or more correspondence information. The correspondence information is information for associating the attribute value of the first attribute and the attribute value of the field that one or more records constituting the table have. A field is an area of a screen corresponding to one record, and is an area into which an attribute value of the record is input. A field attribute value is a value of a field attribute. The field attributes include, for example, the background color that is the background color of the field, the background pattern that is the background pattern of the field, the thickness of the border of the field, and the like. The attribute value of the attribute “background color” is, for example, red or blue, but may be any color. The attribute value of the attribute “background pattern” is, for example, a geometric pattern, a lattice, or a diagonal line, but any pattern may be used. The attribute value of the attribute “frame line thickness” is, for example, a thin frame, a thick frame, or the like, but may have any thickness. The correspondence information includes, for example, the attribute name of the first attribute, the attribute value of the first attribute, the attribute name of the field paired with the first attribute, the attribute value of the field, and the first The attribute name of the second attribute and the attribute value of the second attribute to be paired with the attribute of, but the data structure is not limited.

  The essential information storage 113 stores essential information in association with one or more attributes or in association with one or more fields. The essential information is information indicating whether or not the attribute value is essential. The essential information may be information indicating that the presence of the attribute value is essential. The essential information storage unit 113 stores, for example, attribute information indicating that the presence of an attribute value is essential in association with the attribute “new user” or the field identifier “1”, or the attribute “consignment date”. Alternatively, attribute information indicating that the presence of an attribute value is not essential may be stored in association with the field identifier “2”.

  The screen information storage unit 114 stores screen information. Screen information is information that forms a screen template. The screen information is information for configuring the screen. The screen information may include, for example, image information of two or more parts constituting the screen, arrangement information indicating arrangement of two or more parts in the screen, and the like. The component is, for example, the above-described field or edit button, but may be anything. However, the data structure of screen information does not matter.

  The receiving unit 12 receives various types of information. Acceptance refers to accepting information input from an input device such as a keyboard, mouse, or touch panel, receiving information transmitted via a wired or wireless communication line, and reading from a recording medium such as an optical disk, magnetic disk, or semiconductor memory. It is a concept that includes accepting information that has been issued. The various information includes, for example, a record identifier for identifying the selected record, an editing instruction, an attribute value input by the user, and the like.

  The selection receiving unit 121 receives a selection of one record for a table output by a table output unit 141 described later. The selection may be, for example, selection of the record itself or selection by an edit button (link) corresponding to the record. The edit button and link will be described later. The selection receiving unit 121 receives selection of one record via an input device such as a mouse or a keyboard.

  The editing instruction receiving unit 122 receives an editing instruction for the screen output by the screen output unit 142. The editing instruction is an instruction relating to screen editing. The editing instruction is, for example, an instruction for inputting an attribute value into a field, deleting an attribute value from the field, or the like. However, the editing instruction may be, for example, an instruction for inputting a check into a check box included in a field or an instruction for canceling the input, and the content of the instruction does not matter.

  The input receiving unit 123 receives input of attribute values for the field.

  The processing unit 13 executes various processes. The various processes include, for example, a screen configuration, a record update, a screen change, a determination as to whether various selections and instructions have been accepted, and accumulation of various information in the storage unit 11 and the like. is there.

  The screen configuration unit 131 can configure various screens having one or more fields as described later using the screen information stored in the screen information storage unit 114. For example, the screen composition unit 131 reads the selected record from the table storage unit 111 in response to the selection reception unit 121 receiving selection of one record for the table output by the table output unit 141, A screen is formed in which one or more attribute values of the one record are expressed in corresponding fields. The screen in which the attribute value is expressed in the corresponding field is, for example, a screen in which the attribute value is displayed in the corresponding field. The screen in which the attribute value is represented in the corresponding field is, for example, a screen having a field having the attribute value of the field corresponding to the attribute value.

  In addition, the screen configuration unit 131 uses the essential information stored in the essential information storage unit 113 and uses one or more attribute values (eg, background color, background pattern, line) corresponding to one or more attribute values. May be changed. For example, the screen configuration unit 131 differs the background color of the field corresponding to the attribute corresponding to the essential information indicating that the presence of the attribute value is essential from the background color of the other field (normal color: light purple, for example). You may comprise the screen used as a color (special color: red, blue, etc.). Further, for example, when there is an attribute value corresponding to the field corresponding to the essential information indicating that the presence of the attribute value is essential, the screen configuration unit 131 sets the background color of the field to the first special color (for example, (Red), and if it does not exist, a screen in which the background color of the field is the second special color (for example, blue) may be configured. Note that the attribute value (for example, background color) of the field corresponding to the attribute corresponding to the essential information indicating that the presence of the attribute value is essential is the attribute value of the field corresponding to the attribute not corresponding to the essential information (for example, It is preferable that the attribute value is conspicuous compared to the background color.

  In addition, the screen composition unit 131 indicates a field in which one attribute value is indicated by a character string in a field among two or more attribute values included in one record, while another attribute value is indicated by a field attribute value. As described above, the screen can be configured. Specifically, the screen configuration unit 131 stores, for example, the attribute information of the field corresponding to the attribute value of the first attribute included in one or more records constituting the table in the correspondence information storage unit 112. Is used to acquire the attribute value of the second attribute, has the attribute value of the acquired field, and has one or more fields having the attribute value of the second attribute as the value in the field You may comprise a screen from the 1 or more record which comprises a table | surface. That is, such a field is a field in which the attribute value of the second attribute is a value in the field, and the attribute value of the first attribute can be grasped from the attribute value of the field. Such a field is referred to as a multi-attribute value expression field. Then, using one or more pieces of correspondence information having an identifier (for example, attribute name) of the first attribute, an identifier (for example, attribute name) of the second attribute, and an attribute value of the first attribute, The configuration unit 131 configures a field that can express these two attribute values.

  For example, when the selection receiving unit 121 receives a selection of a specific attribute name for the table output by the table output unit 141, the screen configuration unit 131 attributes the first attribute corresponding to the specific attribute name. The value is read from the table storage unit 111, the attribute value of the second attribute that is paired with the first attribute is read from the table storage unit 111, and the attribute value of the field corresponding to the read attribute value of the first attribute is A field that is acquired using the correspondence information stored in the correspondence information storage unit 112 and has the attribute value of the acquired field, and that has the read attribute value of the second attribute as a value in the field, is 1 As described above, the screen may be configured.

  For example, the screen configuration unit 131 may configure an editing screen that is a screen for editing the selected record in response to reception of selection of one record for the table. The editing screen may be a screen having one or more fields as described above. Further, it is preferable that the one or more fields include a multiple attribute value expression field. Moreover, the trigger for the screen structure part 131 to comprise a presentation screen is not ask | required.

  The record update unit 132 edits and updates one record in response to the editing instruction. Editing refers to, for example, adding an attribute value to a record corresponding to the field according to the input of the attribute value to the field, or from a record corresponding to the field according to deletion of the attribute value from the field. This is a process of deleting the attribute value. However, editing may include, for example, a process of adding or deleting information corresponding to the check box or a process of creating a new record in response to the input to the check box or the cancellation of the input. The mode of editing does not matter. The update is a process of replacing the record information stored in the table storage unit 111 with the edited information.

  The screen changing unit 133 changes the screen output by the screen output unit 142 to a screen in which the attribute value is displayed in the field in response to the input receiving unit 123 receiving an input of the attribute value for the field. To do. In addition, the screen change unit 133 is a field corresponding to essential information indicating that the presence of an attribute value is essential, and when an input of an attribute value for a field for which an attribute value does not yet exist is received, The background color (first special color) of the field may be changed to a color (second special color) corresponding to the input of the attribute value.

  The output unit 14 outputs various information. Output refers to display on a display, projection using a projector, printing on a printer, sound output, transmission to an external device, storage on a recording medium, processing results to other processing devices or other programs, etc. It is a concept that includes delivery. The various types of information include the above-described tables and screens.

  The table output unit 141 outputs a table. The table configuration unit 1411 constituting the table output unit 141 adds an edit button for calling a screen to one or more records included in the table stored in the table storage unit 111, and also includes specific attributes included in the table. A table to be output may be configured by adding a link to the presentation screen to the name. The table constituting unit 1411 may add a print button for printing the record to one or more records. That is, the table construction unit 1411 may add one or more processing buttons (for example, an edit button, a print button, a delete button for deletion) for performing processing on the record to one or more records. Good. The table output unit 1412 outputs the table configured by the table configuration unit 1411 via an output device such as a display.

  The screen output unit 142 outputs the screen configured by the screen configuration unit 131 via an output device such as a display.

  The storage unit 11, the table storage unit 111, the correspondence information storage unit 112, the essential information storage unit 113, and the screen information storage unit 114 are preferably non-volatile recording media such as a hard disk and a flash memory, but are volatile such as a RAM. It is also possible to realize this recording medium.

  The process of storing information such as a table in the storage unit 11 or the like is not limited. For example, information may be stored in the storage unit 11 or the like via a removable recording medium such as a CD-ROM or a memory card, and information transmitted via a network, a communication line, or the like is stored in the storage unit 11. The information input via the input device may be stored in the storage unit 11 or the like. The input device may be anything such as a keyboard, mouse, touch panel, or menu screen.

  The receiving unit 12, the selection receiving unit 121, the editing instruction receiving unit 122, and the input receiving unit 123 can be realized by a device driver of an input device such as a keyboard, control software for a menu screen, or the like.

  The processing unit 13, the screen configuration unit 131, the record update unit 132, and the screen change unit 133 can usually be realized by an MPU, a memory, or the like. The processing procedure of the processing unit 13 or the like is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, the processing procedure may be realized by hardware (a dedicated circuit).

The output unit 14, the table output unit 141, the table configuration unit 1411, the table output unit 1412, and the screen output unit 142 may or may not include an output device such as a display or a speaker. The output unit 14 or the like can be realized by driver software of the output device, or by driver software of the output device and the output device.
Next, operation | movement of the table | surface information processing apparatus 1 is demonstrated using the flowchart of FIGS.

  FIG. 2 is a flowchart for explaining the overall operation of the table information processing apparatus 1.

  (Step S201) The table output unit 141 executes a table output process that is a process of outputting a table. The table output process will be described with reference to the flowchart of FIG.

  (Step S202) The processing unit 13 determines whether or not the selection receiving unit 121 has received selection of one record for the table. When it is determined that the selection receiving unit 121 has received selection of one record for the table, the process proceeds to step S203, and when it is determined that the selection is not received, the process returns to step S201.

  (Step S <b> 203) The screen composition unit 131 executes an edit screen composition process that is a process for constructing an edit screen corresponding to the selected record. The edit screen configuration process will be described with reference to the flowchart of FIG.

  (Step S204) The screen output unit 142 outputs the edit screen configured by the screen configuration unit 131 via an output device such as a display.

  (Step S205) The processing unit 13 determines whether or not the editing instruction receiving unit 122 has received an editing instruction for the editing screen. When it is determined that the editing instruction receiving unit 122 has received an editing instruction for the editing screen, the process proceeds to step S206, and when it is determined that it has not been received, the process proceeds to step S208.

  (Step S206) The record update unit 132 edits and updates the one record in response to the editing instruction. For example, when an attribute value is input to the field, the attribute value is added to the record corresponding to the field, or the attribute value is deleted from the field. Including the process of deleting the attribute value from. The record update includes a process of replacing the record information stored in the table storage unit 111 with the edited information.

  (Step S <b> 207) The screen change unit 133 executes a screen change process that is a process for updating the screen output by the screen output unit 142 in accordance with the update of the record stored in the table storage unit 111. The screen change process will be described with reference to the flowchart of FIG.

  (Step S208) The processing unit 13 determines whether or not the receiving unit 12 has received an instruction to return to the table. If it is determined that the reception unit 12 has received an instruction to return to the table, the process returns to step S201. If it is determined that the reception unit 12 has not received an instruction to return to the table, the process returns to step S205.

  Note that the processing of FIG. 2 starts, for example, in response to power-on of the table information processing apparatus 1, but the start trigger does not matter. In the flowchart of FIG. 2, the process is ended by power-off or a process end interrupt.

  FIG. 3 is a flowchart for explaining a partial operation (table output process) of the table information processing apparatus 1.

  (Step S301) The table construction unit 1411 reads a table from the table storage unit 111.

  (Step S302) The table construction unit 1411 adds, for example, an edit button for calling a screen to each of one or more records included in the read table, and composes an output table. The table construction unit 1411 may further add a link to the presentation screen to a specific attribute name included in the table. The table construction unit 1411 may add an operation button such as a print button other than the edit button to one or more records.

  (Step S303) The table output unit 1412 outputs the table configured by the table configuration unit 1411. Thereafter, the process returns to the upper process.

  FIG. 4 is a flowchart for explaining edit screen configuration processing of the table information processing apparatus 1.

  The default (initial value) of a flag corresponding to each of one or more fields is off. The flag that is turned off indicates that an attribute value is assigned to the field (the attribute value corresponding to the field exists). The flag that is turned on indicates that no attribute value is assigned to the field (there is no attribute value corresponding to the field). However, the correspondence between on / off of the flag and the presence / absence of the attribute value may be reversed.

  (Step S <b> 401) The screen configuration unit 131 acquires screen information for configuring an editing screen (hereinafter simply referred to as “screen”) from the screen information storage unit 114.

  (Step S <b> 402) The screen configuration unit 131 configures a screen having one or more fields corresponding to one or more attribute values that the one record may have, with the background color being a normal color (for example, light purple) field. To do.

  (Step S403) The screen configuration unit 131 sets 1 to the variable i.

  (Step S404) The screen composition unit 131 selects the i-th field among one or more fields of the screen.

  (Step S405) The screen configuration unit 131 refers to the table of the table storage unit 111 to determine whether or not the one record has an attribute value corresponding to the i-th field. If it is determined that the one record has an attribute value corresponding to the i-th field (hereinafter, the attribute value may be described as “exists”), the process proceeds to step S406, and it is determined that the record does not exist. In this case, the process proceeds to step S408.

  (Step S <b> 406) The screen configuration unit 131 reads the attribute value from the table storage unit 111.

  (Step S407) The screen composition unit 131 assigns the attribute value to the i-th field. Thereafter, the process proceeds to step S409.

  (Step S408) The screen configuration unit 131 turns on the flag corresponding to the i-th field.

  (Step S409) The screen configuration unit 131 executes a background color changing process that is a process of changing the background color of the i-th field. The background color change process will be described with reference to the flowchart of FIG.

  (Step S410) The screen configuration unit 131 determines whether or not the attribute value assigned to the field is the attribute value of the second attribute included in the correspondence information. If it is determined that the attribute value is the attribute value of the second attribute included in the correspondence information, the process proceeds to step S411, and it is determined that the attribute value is not the attribute value of the second attribute included in the correspondence information. If YES, go to step S415.

  (Step S411) The screen configuration unit 131 acquires the attribute value of the first attribute corresponding to the second attribute using the correspondence information.

  (Step S412) The screen configuration unit 131 acquires the attribute value of the attribute of the field corresponding to the first attribute using the correspondence information.

  (Step S413) The screen configuration unit 131 configures one field using the acquired two attribute values. This field is the above-described multi-attribute value expression field.

  (Step S414) The screen configuration unit 131 increments the variable i.

  (Step S415) The screen composition unit 131 determines whether or not the i-th field exists. If the i-th field exists, the process returns to step S404, and if it does not exist, the process returns to the upper process.

  FIG. 5 is a flowchart for explaining the background color changing process of the table information processing apparatus 1.

  (Step S <b> 501) The screen configuration unit 131 acquires essential information corresponding to the i-th field (or i-th attribute) from the essential information storage unit 113. There may be a case where there is no essential information corresponding to the i-th field. In this case, the essential information has the same meaning as the information indicating “not essential”.

  (Step S502) The screen configuration unit 131 determines whether or not the essential information indicates essential. If the essential information indicates essential, the process proceeds to step S503. If the essential information does not indicate essential, the process returns to the higher-level process.

  (Step S503) It is determined whether or not the flag corresponding to the i-th field is ON. If the flag corresponding to the i-th field is on, the process proceeds to step S504, and if it is off, the process proceeds to step S505.

  (Step S504) The screen composition unit 131 changes the background color of the i-th field from the normal color to the first special color (for example, red). Thereafter, the process returns to the upper process.

  (Step S505) The screen composition unit 131 changes the background color of the i-th field from the normal color to the second special color (for example, blue). Thereafter, the process returns to the upper process.

  FIG. 6 is a flowchart for explaining the screen change process of the table information processing apparatus 1.

  (Step S601) The screen changing unit 133 determines whether or not the editing instruction is an input of an attribute value for the field. If the edit instruction is an input of an attribute value for the field, the process proceeds to step S602. If the edit instruction is not an input of an attribute value for the field, the process proceeds to step S608.

  (Step S602) The screen changing unit 133 determines whether or not the flag corresponding to the field is on. If the flag corresponding to the field is on, the process proceeds to step S603, and if it is off, the process proceeds to step S607.

  (Step S603) The screen changing unit 133 substitutes the input attribute value into the field.

  (Step S604) The screen changing unit 133 turns off the flag corresponding to the field.

  (Step S605) The screen changing unit 133 determines whether or not the essential information corresponding to the field indicates essential. If the essential information corresponding to the field indicates essential, the process proceeds to step S606. If the essential information does not indicate essential, the process returns to the upper process.

  (Step S606) The screen changing unit 133 changes the first special color that is the current background color of the field to the second special color that is a color corresponding to the input of the attribute value. Thereafter, the process returns to the upper process.

  (Step S607) The screen changing unit 133 updates the attribute value of the field. That is, the screen changing unit 133 replaces the attribute value existing in the field with the input attribute value. Thereafter, the process returns to the upper process.

  (Step S608) The screen changing unit 133 determines whether or not the editing instruction is deletion of an attribute value from the field. If it is determined that the editing instruction is to delete the attribute value from the field, the process proceeds to step S609. If it is determined that the attribute value is not to be deleted from the field, the process returns to the upper process.

  (Step S609) The screen changing unit 133 deletes the attribute value from the field.

  (Step S610) The screen changing unit 133 turns on the flag corresponding to the field.

  (Step S611) The screen changing unit 133 determines whether or not the essential information corresponding to the field indicates essential. If the essential information corresponding to the field indicates essential, the process proceeds to step S612. If the essential information does not indicate essential, the process returns to the higher-level process.

  (Step S612) The screen changing unit 133 changes the second special color which is the current background color of the field to the first special color which is a color corresponding to the attribute value not being input. Thereafter, the process returns to the upper process.

  FIG. 7 is a flowchart illustrating a process of presenting a table record of the table information processing apparatus 1. The process here is a process for outputting a screen having a plurality of attribute value expression fields.

  (Step S701) The screen composition unit 131 sets 1 to the variable j.

  (Step S702) The screen composition unit 131 is an attribute value of the jth record among one or more records constituting the table, and uses the attribute value of the first attribute corresponding to the specific attribute name as the correspondence information The correspondence information stored in the storage unit 112 is used to read from the table storage unit 111.

  (Step S703) The screen configuration unit 131 uses the correspondence information stored in the correspondence information storage unit 112, is the attribute value of the jth record, and is the second attribute that is paired with the first attribute. The attribute value of the attribute is read from the table storage unit 111.

  (Step S704) The screen configuration unit 131 acquires the attribute value of the field corresponding to the read attribute value of the first attribute using the correspondence information stored in the correspondence information storage unit 112.

  (Step S705) The screen composition unit 131 determines whether or not another attribute name related to the specific attribute name is stored in the storage unit 11. If it is determined that another attribute name related to the specific attribute name is stored in the storage unit 11, the process proceeds to step S705. If it is determined that the attribute name is not stored, the process proceeds to step S707.

  (Step S706) The screen configuration unit 131 reads out from the table storage unit 111 other attribute values that are attribute values of the j-th record and that correspond to the other attribute names.

  (Step S707) The screen configuration unit 131 increments the variable j.

  (Step S708) The screen composition unit 131 determines whether or not there is a jth record. If it is determined that there is a jth record, the process returns to step 702. If it is determined that there is no jth record, the process proceeds to step S709. move on.

  (Step S709) The screen configuration unit 131 acquires screen information for configuring a presentation screen from the screen information storage unit 114.

  (Step S710) The screen configuration unit 131 is a field having one or more fields that have the acquired attribute value and the attribute value of the second attribute that has been read out as a value in the field. If there is an attribute value, a screen having a field having the other attribute value as a value in the field is configured using the screen information.

  (Step S711) The screen output unit 142 outputs the screen configured by the screen configuration unit 131 via an output device such as a display.

  (Step S <b> 712) The processing unit 14 determines whether or not to end the processing based on, for example, the presence or absence of a power-off or processing end interrupt. If it is determined not to end the process, the process returns to step S711. If it is determined to end the process, the process ends.

  The process of FIG. 7 starts when the receiving unit 12 receives a selection of a specific attribute name for the table, for example, but the start trigger does not matter.

  Hereinafter, a specific operation of the table information processing apparatus 1 in the present embodiment will be described.

(Specific example 1)
For example, a table as shown in FIG. 8 is stored in the table storage 111. As described above, the stored table includes one or more records, and each of the one or more records includes an ID for identifying the record and one or more attribute values corresponding to the one or more attributes. Have. In the table of FIG. 8, one or more attributes are, for example, “new user”, “consignment date”, “consignment content”, “registration number”, “garage delivery date”, “scheduled receipt date”, “garage remarks”. ", ... etc. Note that “new user” or the like is the name of the attribute (attribute name) and may be described as the attribute “new user” or the like. An attribute name such as “new user” may also be stored in one record constituting the table.

  For example, the first record identified by the ID “7535” includes an attribute value “(ABC) ABC” of the attribute “new user”, an attribute value “2016-05-12” of the attribute “trust date”, The attribute value “transition” of the attribute “consignment content”, the attribute value “−” of the attribute “registration number”, the attribute value “2016-05-16” of the attribute “garage delivery date”, and the attribute “estimated receipt date” And an attribute value “garage only” of an attribute “garage remarks”. The second record identified by the ID “7534” includes the attribute value “Taro Yamada” of the attribute “new user”, the attribute value “2016-05-12” of the attribute “consignment date”, and the attribute “ The attribute value “transfer” of the “consignment content”, the attribute value “Fukuoka 501 to ○○○○” of the attribute “registration number”, the attribute value “2016-05-16” of the attribute “garage delivery date”, and the attribute “ It has an attribute value “2016-05-17” of “scheduled receipt date” and an attribute value “-” of attribute “garage remarks”. The third record identified by the ID “7533” includes an attribute value “(existing) DEF” of the attribute “new user”, an attribute value “2016-05-11” of the attribute “consignment date”, An attribute value “transfer” of the attribute “consignment content”, an attribute value “Morioka 580” of the attribute “registration number”, an attribute value “2016-05-15” of the attribute “garage delivery date”, It has an attribute value “2016-05-18” of the attribute “estimated receipt date” and an attribute value “garage only” of the attribute “garage remarks”. The attribute value “−” indicates that the attribute does not exist.

  The essential information storage unit 113 stores a set of pairs of field identifiers and essential information. The set of pairs of field identifiers and essential information includes, for example, a pair of “1” and “required”, a pair of “2” and “not required”, a pair of “3” and “not required”, “4” and “required” pairs, “5” and “not required” pairs, “6” and “not required” pairs, “7” and “not required” pairs, etc. is there.

  The storage unit 11 stores a set of attribute names, field identifiers, and flags. The set of attribute name, field identifier, and flag sets includes, for example, a set of “new user”, “1”, and “off”, a set of “consignment date”, “2”, and “off”, “Commission contents”, “3” and “Off”, “Registration number”, “4” and “On”, “Garage delivery date”, “5” and “Off”, A set of “scheduled receipt date”, “6” and “on”, a set of “garage remarks”, “7” and “off”, and so on.

  When the table information processing apparatus 1 is activated, the table construction unit 1411 reads the table (see FIG. 8) from the table storage unit 11, and adds operation buttons such as an edit button and a print button to the read table. Configure the output table. The table construction unit 1411 may further add a link to the presentation screen to a specific attribute name (for example, “garage delivery date”) of the table. The table output unit 1412 outputs the table configured by the table configuration unit 1411 via an output device such as a display. Thereby, for example, a table as shown in FIG. 9 is displayed on the display.

  The displayed table has two or more rows and two or more columns. In this table, “print” is displayed in the first column of the first row, “edit” is displayed in the second column, “ID” is displayed in the third column, and “print” is displayed in the fourth column. The new user is displayed, “Contract Date” is displayed in the fifth column, “Contract Details” is displayed in the sixth column, “Registration Number” is displayed in the seventh column, and The eighth column displays “garage delivery date”, the ninth column displays “scheduled receipt date”, and the tenth column displays “garage remarks”.

  In this table, a “print” button is displayed in the first column of the second row, an “edit” button is displayed in the second column, an ID “7535” is displayed in the third column, and The new user “(ABC) ABC” is displayed in the fourth column, the consignment date “2016-05-12” is displayed in the fifth column, the content of the consignment “Transition” is displayed in the sixth column, The seventh column displays the registration number “-”, the eighth column displays the garage delivery date “2016-05-16”, and the ninth column displays the scheduled receipt date “-”. In the tenth column, garage remarks “garage only” are displayed.

  In this table, a “print” button is displayed in the first column of the third row, an “edit” button is displayed in the second column, an ID “7534” is displayed in the third column, and The new user “Taro Yamada” is displayed in the fourth column, the consignment date “2016-05-12” is displayed in the fifth column, the consignment content “transfer” is displayed in the sixth column, and the seventh column. The registration number “Fukuoka 501 xxx” is displayed in the column, the garage delivery date “2016-05-16” is displayed in the eighth column, and the scheduled receipt date “2016- 16” is displayed in the ninth column. 05-17 "is displayed, and the garage remark"-"is displayed in the tenth column.

  In this table, a “print” button is displayed in the first column of the fourth row, an “edit” button is displayed in the second column, an ID “7533” is displayed in the third column, and The new user “(Yes) EEF” is displayed in the fourth column, the consignment date “2016-05-11” is displayed in the fifth column, and the consignment content “transfer” is displayed in the sixth column. The 7th column displays the registration number “Morioka 580 xxx”, the 8th column displays the garage delivery date “2016-05-15”, and the 9th column displays the scheduled receipt date “ "2016-05-18" is displayed, and the garage remark "garage only" is displayed in the 10th column.

  For this table, the selection receiving unit 121 selects one record (for example, one “edit” button among one or more “edit” buttons displayed in the second column of the table shown in FIG. 9). The screen composition unit 131 composes an editing screen for editing the selected record.

  For example, if the user presses the first (second row) “edit” button on the table shown in FIG. 9, an edit screen for editing the first record corresponding to this button is displayed. The configuration is as follows. The screen configuration unit 131 acquires screen information for configuring the editing screen from the screen information storage unit 114, and the background color is a field having a normal color (in this example, light purple), and the first record has One or more fields corresponding to one or more attribute values to be obtained (in this example, seven attribute values that can be displayed in the fourth to tenth columns of the table shown in FIG. 9) Field). Next, the screen configuration unit 131 sets 1 to the variable i and selects the i-th field among the seven fields of the screen. Then, the screen configuration unit 131 executes the following process for the i-th field.

  The screen configuration unit 131 refers to the table in the table storage unit 111 and determines whether or not an attribute value corresponding to the i-th field exists. When it is determined that an attribute value corresponding to the i-th field exists, the screen configuration unit 131 reads the attribute value from the table storage unit 111 and substitutes the attribute value in the i-th field. On the other hand, when it is determined that the attribute value corresponding to the i-th field does not exist, the screen configuration unit 131 turns on the flag corresponding to the i-th field.

  Next, the screen composition unit 131 changes the background color of the i-th field by the following procedure. The screen configuration unit 131 acquires the essential information corresponding to the i-th field from the essential information storage unit 113, and determines whether or not the essential information indicates essential. When it is determined that the essential information indicates essential, the screen configuration unit 131 determines whether or not the flag corresponding to the i-th field is on, and when it is determined that the flag is on, If the background color of the i-th field is changed from the normal color to the first special color (for example, red) and the flag is determined to be off, the background color of the i-th field is changed from the normal color to the second special color. Change to a color (eg blue). On the other hand, when it is determined that the essential information corresponding to the i-th field does not indicate essential, the screen configuration unit 131 does not change the background color of the field.

  Therefore, when the i-th field corresponds to the essential information indicating that the attribute value is not required to be input, regardless of whether the attribute value has been input or not input (that is, whether the flag is OFF or ON). The background color remains the normal color (light purple). If the i-th field corresponds to essential information indicating that an attribute value must be input, if the attribute value is not input (that is, the flag is ON), the background color is the first color from the normal color. If the attribute value is already input (that is, the flag is off) while the color is changed to one special color (red), the background color is changed from the normal color to the second special color (blue).

  When the screen composition unit 131 repeats the above processing while incrementing the variable i, an edit screen having one or more fields corresponding to one or more attribute values that the selected record may have is constructed. The

  The screen output unit 142 outputs the editing screen configured by the screen configuration unit 131 via an output device such as a display. Thereby, for example, an editing screen as shown in FIG. 10 is displayed on the display.

  FIG. 10 is a diagram illustrating an output example of the editing screen. The edit screen has one or more fields corresponding to one or more attribute values that one record may have. The editing screen of this example is a screen corresponding to the first record constituting the table of FIG. This edit screen includes a field corresponding to “new user” (first field), a field corresponding to “contract date” (second field), and a field corresponding to “consignment content” (third field). Field), a field corresponding to "registration number" (fourth field), a field corresponding to "garage delivery date" (fifth field), and a field corresponding to "scheduled receipt date" (sixth field) Field) and a field (seventh field) corresponding to “garage remarks”.

  “(ABC) ABC” is displayed in the first field of this editing screen, “2016-05-12” is displayed in the second field, and “Transition” is displayed in the third field. Nothing is displayed in the fourth field, “2016-05-16” is displayed in the fifth field, nothing is displayed in the sixth field, and “garage” is displayed in the seventh field. “Only” is displayed. The background color of the first field is the second special color because the essential information indicates essential and an attribute value exists. The background color of the third field is the first special color because the essential information indicates essential and there is no attribute value. The background color of the other fields is a normal color because the essential information does not indicate essential.

  The user can input necessary editing instructions on the editing screen. When the editing instruction receiving unit 122 receives an editing instruction for the editing screen, the record update unit 132 edits and updates the one record constituting the table stored in the table storage unit 111 in accordance with the editing instruction. To do. The screen changing unit 133 changes the editing screen output by the screen output unit 142 according to the update of the one record, for example, according to the following procedure.

  The screen changing unit 133 determines whether or not the editing instruction is an input of an attribute value for the field. When it is determined that the editing instruction is an input of an attribute value for the field, a flag corresponding to the field is set. It is further determined whether or not it is on. When it is determined that the flag corresponding to the field is on, the screen changing unit 133 substitutes the input attribute value for the field, and turns off the flag corresponding to the field. Subsequently, the screen changing unit 133 determines whether or not the essential information corresponding to the field indicates essential, and if it is determined that the essential information corresponding to the field indicates essential, the screen changing unit 133 The background color of the field is changed to the second special color corresponding to the input of the attribute value. When it is determined that the essential information corresponding to the field does not indicate essential, the screen changing unit 133 does not change the background color of the field.

  When it is determined that the flag corresponding to the field is off, the screen changing unit 133 replaces the attribute value existing in the field with the input attribute value.

  When it is determined that the editing instruction is not an input of an attribute value for the field, the screen change unit 133 further determines whether or not the editing instruction is to delete the attribute value from the field. When it is determined that the editing instruction is to delete the attribute value from the field, the screen changing unit 133 deletes the attribute value from the field and turns on the flag corresponding to the field. Subsequently, the screen changing unit 133 determines whether or not the essential information corresponding to the field indicates essential, and if it is determined that the essential information corresponding to the field indicates essential, the background color of the field is changed. , Change to the first special color corresponding to the attribute value not being input. When it is determined that the essential information corresponding to the field does not indicate essential, the screen changing unit 133 does not change the background color of the field.

  Therefore, for example, if “Osaka 301 HiOO” is entered in the field corresponding to the registration number (fourth field) on the editing screen of FIG. 10, the essential information corresponding to this field is mandatory. In addition, since the flag corresponding to this field is ON, the editing screen is changed to an editing screen as shown in FIG. In the editing screen of FIG. 11, “Osaka 301 Hi-OO” is assigned to the field corresponding to the registration number, and the background color of the field is mandatory and already entered from the first special color indicating mandatory and not entered. Is changed to the second special color.

  When the user finishes editing, the user gives an instruction to return to the table (such as pressing a “return” button (not shown)). When the receiving unit 12 receives an instruction to return to the table, the table output unit 141 outputs the changed table via an output device such as a display. Thus, the changed table (not shown) is displayed on the display. In this table, “Osaka 301 HOOXX” is displayed in the second row and the sixth column.

  In the editing screen of this example, the above-described multiple attribute value expression field can be used. In this case, the correspondence information storage unit 112 stores correspondence information as shown in FIG. 12, for example. Details of the correspondence information in FIG. 12 will be described in a specific example 2. For example, when configuring the editing screen corresponding to the third record in the table of FIG. 8, the screen configuration unit 131 sets the attribute value “2016” as the first attribute from the third record. -05-18 "and the attribute value" second color "(for example, green) of the field corresponding to the acquired attribute value" 2016-05-18 "of the first attribute is stored in the correspondence information storage unit 112 The attribute value “garage only” of the second attribute “garage remarks” is obtained from the third record, and has the attribute value “second color” of the acquired field. A multi-attribute value expression field that is a field and has the attribute value “only garage” of the second attribute “garage remarks” in the field may be configured. Thereby, for example, in the editing screen shown in FIG. 10 or FIG. 11, two attribute values “2016-05-15” and “garage only” expressed using the sixth and seventh fields are displayed. Since the information field is expressed by using one multi-attribute value expression field, the same amount of information can be expressed by a small number of fields, and the table records can be efficiently presented.

(Specific example 2)
A specific attribute name is stored in the storage unit 11. The specific attribute name stored is, for example, “garage delivery date”.

  In the table storage unit 111, for example, a table as shown in FIG. 8 is stored. The correspondence information storage unit 112 stores correspondence information as shown in FIG. 12, for example. This correspondence information includes the attribute name of the first attribute corresponding to the specific attribute, the attribute value of the first attribute, the attribute name of the field paired with the first attribute, and the attribute value of the field And a set of attribute names of the second attribute paired with the first attribute. The set of stored sets is, for example, a first attribute “estimated receipt date” corresponding to a specific attribute “garage delivery date”, and an attribute value “2016-05-17” of the first attribute. The attribute name “background color” of the field paired with the first attribute, the attribute value “first color (for example, light blue: represented by a shadow pattern in the figure)” of the field, and the first attribute The second attribute “garage remarks” and the first attribute “estimated receipt date” corresponding to the specific attribute “garage delivery date” and the attribute value “2016-05-18” of the first attribute ”, The attribute name“ background color ”of the field paired with the first attribute, the attribute value“ second color (for example, green: represented by a net pattern in the figure) ”of the field, and the first attribute A pair with the second attribute “garage remarks” paired with, and so on. In the correspondence information storage unit 112, the attribute value of the field that is paired with the attribute value of the first attribute other than the attribute values “2016-05-17” and “2016-05-18” of the first attribute is stored. The value “no color” may be further stored. “No color” may be an appropriate color other than the first color and the second color (for example, light green, white, etc.).

  The storage unit 11 may store other attribute names related to a specific attribute name. The stored other attribute name is, for example, “new user”.

  For example, a table as shown in FIG. 9 is displayed on the display. When the user selects a specific attribute name “garage delivery date” for the displayed table, the reception unit 12 receives the selection of the specific attribute name, and the screen configuration unit 131 displays the specific attribute name. A presentation screen that presents two or more attribute values related to the attribute name is configured, for example, by the following procedure.

  The screen configuration unit 131 sets 1 to the variable j and is the attribute value of the jth record, and the attribute value of the first attribute corresponding to the specific attribute name is stored in the correspondence information storage unit 112. Is read from the table storage unit 111 using the corresponding information. Next, the screen composition unit 131 uses the correspondence information stored in the correspondence information storage unit 112, is the attribute value of the jth record, and is a second attribute that is paired with the first attribute. Are read from the table storage unit 111. Then, the screen configuration unit 131 acquires the attribute value of the field corresponding to the read attribute value of the first attribute using the correspondence information stored in the correspondence information storage unit 112. Further, if another attribute name related to the specific attribute name is stored in the storage unit 11, the screen configuration unit 131 is an attribute value of the j-th record, and corresponds to the specific attribute name. Other attribute values are also read from the table storage unit 111. Thereafter, the screen configuration unit 131 repeats the same processing as above while incrementing the variable j.

  When the variable j exceeds the number of records, the screen configuration unit 131 acquires screen information for configuring the presentation screen from the screen information storage unit 114. The screen composition unit 131 is a field having the acquired attribute value, and composes a screen having one or more fields having the read attribute value of the second attribute as a value in the field using the screen information. To do. If there is another attribute value that has been read, the screen composition unit 131 constructs a screen that includes a field having the other attribute value as a value in the field in addition to the one or more fields. The screen output unit 142 outputs the screen configured by the screen configuration unit 131 via an output device such as a display.

  Therefore, for example, when the user selects “garage delivery date” which is a specific attribute name, the screen composition unit 131 displays one or more records constituting the table as attribute values corresponding to this “garage delivery date”. From the attribute value “-, 2006-05-17, 2006-05-18,...” Of the first attribute “estimated receipt date” is read out, and the second attribute that is paired with the first attribute “estimated receipt date”. The attribute value “garage only, −, garage only,...” Of the attribute “garage remarks” is read, and the read attribute values “−, 2006-05-17, 2006-05-18,. The attribute value “no color, first color, second color,...” Of the field to be acquired is acquired using the correspondence information. In addition, the screen composition unit 131 sets, as other attribute values related to “garage delivery date”, attribute values “attributed to“ new user ”,“ ABC Inc. ”, Taro Yamada, (existing) from one or more records. DEF and... And the attribute value “2016-05-16, 2006-05-16, 2006-05-15,...” Of the attribute “garage delivery date” are also read out.

  The screen composition unit 131 is a field having a background color corresponding to the attribute value “no color, first color, second color,...” Acquired as described above, and the attribute of the read second attribute. A presentation screen having at least one field (the field is the above-described multi-attribute value expression field) having values “garage only, −, garage only,. One or more fields with other attribute “new user” attribute values “ABC, Taro Yamada, DEF,...” In the field, and other attributes “garage delivery date” attribute A presentation screen having one or more fields having values “2016-05-16, 2016-05-16, 2016-05-15,. The screen output unit 142 outputs the presentation screen thus configured via an output device such as a display. As a result, a presentation screen as shown in FIG. 13, for example, is output on the display.

  FIG. 13 is a diagram illustrating an output example of the presentation screen. The presentation screen is a field having a background color corresponding to the attribute value of the first attribute, and has one or more multiple attribute value expression fields having the attribute value of the second attribute as a value in the field. The presentation screen also includes one or more fields having attribute values of other attributes as values in the field when attribute values of other attributes exist.

  The presentation screen of this example uses the attribute value “2016-05-16, 2016-05-15,...” Of the specific attribute “garage delivery date” having the selected specific attribute name as the value in the field 2 The above fields (hereinafter referred to as field “2016-05-16”, field “2016-05-15”,...) And other attributes related to the specific attribute “garage delivery date” “new user” ”Attribute values“ ABC, Taro Yamada, DEF,... ”” In the field, two or more fields (hereinafter “Field“ ABC ”, field“ Taro Yamada ”, field“ Corresponds to the first attribute “attribute values“ −, 2006-05-17, 2006-05-18,... ”Related to the specific attribute“ garage delivery date ”. Background color "No color, 1st color, 1st Is a field having a color,..., And a second attribute “garage remarks” corresponding to the first attribute has an attribute value “garage only, −, garage only,. And an attribute value expression field (hereinafter referred to as a non-colored field “garage only”, a first color field “−”, a second color field “garage only”,...).

  In this presentation screen, the field “2016-05-16” is paired with the field “ABC” and the colorless field “garage only”, and the field “Taro Yamada” and the first color field “ A pair with “-” is displayed. In addition, a pair of a field “(existing) DEF” and a second color field “only garage” is displayed in a pair with the field “2016-05-15”. According to this presentation screen, a plurality of attribute values that can present two attribute values in one field, such as a non-colored field “garage only”, a first color field “-”, and a second color field “garage only”. By using the attribute value expression field, the table record can be efficiently presented.

  As described above, according to the present embodiment, the table information processing apparatus 1 stores a table having one or more records, outputs this table, and records one record for the output table. A selection screen is received, one or more attribute values of one selected record are read, a screen in which each one or more attribute values are assigned to the corresponding fields, and the configured screen is output and output. An editing instruction for the screen is received, and one record is edited and updated in accordance with the editing instruction, so that the table record can be easily edited. This effect becomes remarkable when there is a restriction such as a narrow screen.

  Further, in the table information processing apparatus 1, an edit button for calling a screen is added to one or more records, the output table is configured, and the configured table is output, so that the button corresponds to the desired record You can edit the table records more easily.

  Further, in the table information processing apparatus 1, the record has one or more attribute values that are attribute values, and whether or not the attribute value is indispensable in association with each of the one or more attributes. By constructing a screen in which the background color of the field corresponding to the mandatory information indicating that the presence of the attribute value is mandatory is different from the background color of the other fields, At a glance, you can see which fields require attribute values, so you can edit the table records more easily.

  Further, in the table information processing apparatus 1, when an input of an attribute value for a field is received and an input of an attribute value for a field corresponding to essential information indicating that the presence of the attribute value is essential is received, By changing the background color to the color corresponding to the input of the attribute value, if the attribute value is input to the required input field, the attribute value for the required field is changed by changing the background color. You can see at a glance whether or not you have entered the, so you can more easily edit the table records.

  The table information processing apparatus 1 also includes a table having one or more records having two or more attribute values, an attribute value of the first attribute and a field attribute value of each of the one or more records constituting the table. 2 or more correspondence information that associates with each other, and obtains the attribute value of the field corresponding to the attribute value of the first attribute of each of the one or more records constituting the table using the correspondence information, The attribute value of the second attribute included in each of the one or more records is acquired, the field having the attribute value of the acquired field, and the field having the attribute value of the second attribute as the value in the field, A screen having one or more records constituting a table, and by outputting the composed screen, two or more attribute values are presented in one field for each one or more records. Effect To be presented.

  Further, in the table information processing apparatus 1, the attribute value of the field is the background color of the field, so that one of the two or more attribute values is indicated by a character string in the field, while the other attribute value Since the value is indicated by the background color of the field, two or more attribute values indicated by one field can be known at a glance, and the table record can be presented more efficiently.

  Furthermore, the processing in the present embodiment may be realized by software. Then, this software may be distributed by software download or the like. Further, this software may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification. Note that the software that implements the information processing apparatus according to the present embodiment is the following program. In other words, in the program according to the present embodiment, the computer-accessible recording medium stores the table storage unit 111 in which a table having one or more records is stored, and the computer outputs the table. For the table output unit 141, the table output by the table output unit 141, a selection receiving unit 121 that receives selection of one record, and one or more attribute values that the selected one record has A screen composition unit 131 that configures a screen that is read from the table storage unit 111 and that substitutes the one or more attribute values into corresponding fields, and a screen output unit 142 that outputs a screen configured by the screen configuration unit 131; The editing instruction receiving unit 122 that receives an editing instruction for the screen output by the screen output unit 142, and the one record in response to the editing instruction. It collects a program for functioning as a record update section 132 for updating.

  In the program according to the present embodiment, a computer-accessible recording medium includes a table storage unit 111 in which a table having one or more records having two or more attribute values is stored, and 1 constituting the table. A correspondence information storage unit 112 that stores two or more correspondence information that associates the attribute value of the first attribute of each record with the attribute value of the field, and configures the computer as the table The attribute value of the field corresponding to the attribute value of the first attribute possessed by each of the one or more records is obtained using the correspondence information, and the attribute value of the second attribute possessed by the one or more records is obtained. A screen having at least one field having the attribute value of the acquired field and having the attribute value of the second attribute as a value in the field. A screen configuration unit 131 be composed of one or more records that constitute the screen configuration unit 131 is also a program for functioning as a screen output unit 142 that outputs the screen configured.

  FIG. 14 is a diagram illustrating an example of an external appearance of a computer system 900 that implements the table information processing apparatus 1 by executing a program according to the present embodiment. The present embodiment can be realized by computer hardware and a computer program executed on the computer hardware. 14, the computer system 900 includes a computer 901 including a CD-ROM drive 905, a keyboard 902, a mouse 903, and a display 904. Note that the entire system including the keyboard 902, the mouse 903, and the display 904 may be called a computer.

  FIG. 15 is a diagram illustrating an example of the internal configuration of the computer system 900. In FIG. 15, in addition to the CD-ROM drive 905, a computer 901 is connected to an MPU 911, a ROM 912 for storing a program such as a bootup program, and the MPU 911, and temporarily stores an instruction of an application program. A RAM 913 that provides temporary storage space, a hard disk 914 that stores application programs, system programs, and data, a bus 915 that interconnects the MPU 911, ROM 912, and the like, and a network card that provides connection to a network such as the Internet 916.

  A program that causes the computer system 900 to execute the function of the table information processing apparatus 1 may be stored in the CD-ROM 921, inserted into the CD-ROM drive 905, and transferred to the hard disk 914. Alternatively, the program may be transmitted to the computer 901 via a network such as the Internet and stored in the hard disk 914. The program is loaded into the RAM 913 when executed. The program may be loaded directly from the CD-ROM 921 or the network. Further, the program may be read into the computer system 900 via another removable recording medium (for example, a DVD or a memory card) instead of the CD-ROM 921.

  The program may not necessarily include an operating system (OS) that executes the function of the table information processing apparatus 1 or a third-party program in 901 indicating the details of the computer. The program may include only a part of an instruction that calls an appropriate function or module in a controlled manner and obtains a desired result. How the computer system 900 operates is well known and will not be described in detail.

  In the above program, in a transmission step for transmitting information, a reception step for receiving information, etc., processing performed by hardware, for example, processing performed by a network card or the like in the transmission step (only performed by hardware) Processing) is not included.

  Further, the computer that executes the program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the table information processing apparatus and the like according to the present invention have an effect that a table record can be easily edited or viewed, and are useful as a table information processing apparatus and the like.

DESCRIPTION OF SYMBOLS 1 Table information processing apparatus 11 Storage part 12 Reception part 13 Processing part 14 Output part 111 Table storage part 112 Corresponding information storage part 113 Essential information storage part 114 Screen information storage part 121 Selection reception part 122 Edit instruction reception part 123 Input reception part 131 Screen configuration unit 132 Record update unit 133 Screen change unit 141 Table output unit 142 Screen output unit 1411 Table configuration unit 1412 Table output unit

Claims (4)

A table storage for storing a table having one or more records;
A table output unit for outputting the table;
A selection receiving unit that receives a selection of one record for the table output by the table output unit;
One or more attribute values of the selected record are read from the table storage unit, and a screen configuration unit that configures a screen in which the one or more attribute values are assigned to corresponding fields;
A screen output unit for outputting a screen configured by the screen configuration unit;
An edit instruction receiving unit for receiving an edit instruction for the screen output by the screen output unit;
In response to the editing instruction, the one record is edited and a record update unit for updating is provided,
The record has two or more attribute values that are attribute values;
A mandatory information storage unit that stores essential information indicating whether or not the existence of an attribute value is essential in association with each of the two or more attributes;
The screen composition unit
The first special color that is different from the background color of the other fields if the background color of one or more fields corresponding to the essential information indicating that the presence of the attribute value is essential, if the attribute value corresponding to the field exists And when there is no attribute value corresponding to the field, configure a screen with a second special color different from the background color of the other field and the first special color,
An input receiving unit that receives input of attribute values for the field;
The field corresponding to the essential information indicating that the presence of the attribute value is mandatory, and when the input of the attribute value for the field for which the attribute value does not yet exist is accepted, the background color of the field is A table information processing apparatus further comprising: a screen changing unit that changes the second special color to the first special color that is a color corresponding to the input of an attribute value. The table output unit is:
An edit button for calling the screen to each of the one or more records, and a table configuration means for configuring an output table;
The table information processing apparatus according to claim 1, further comprising a table output unit configured to output a table configured by the table configuration unit. The recording medium is
Storing a table storage unit in which a table having one or more records is stored;
A table information processing method performed by a table output unit, a selection reception unit, a screen configuration unit, a screen output unit, an edit instruction reception unit, a record update unit, an input reception unit, and a screen change unit,
A table output step in which the table output unit outputs the table;
A selection receiving step in which the selection receiving unit receives a selection of one record for the table output by the table output unit;
A screen configuration that configures a screen in which the screen configuration unit reads one or more attribute values of the selected record from the table storage unit and assigns the one or more attribute values to corresponding fields. Steps,
The screen output unit outputs a screen configured by the screen configuration unit; and
An editing instruction receiving step for receiving an editing instruction for the screen output by the screen output unit;
The record update unit comprises a record update step for editing and updating the one record in response to the editing instruction,
The record has two or more attribute values that are attribute values;
The recording medium is
In association with each of the two or more attributes, a mandatory information storage unit that stores essential information indicating whether or not the presence of an attribute value is essential is further stored.
The screen composition unit
The first special color that is different from the background color of the other fields if the background color of one or more fields corresponding to the essential information indicating that the presence of the attribute value is essential, if the attribute value corresponding to the field exists And when there is no attribute value corresponding to the field , configure a screen with a second special color different from the background color of the other field and the first special color ,
An input receiving step in which the input receiving unit receives an input of an attribute value for a field;
When the screen change unit receives an input of an attribute value for a field corresponding to essential information indicating that the presence of an attribute value is mandatory, and the attribute value does not yet exist , A table information processing method further comprising: changing a background color from the second special color to the first special color which is a color corresponding to the input of an attribute value. Computer-accessible recording media
Storing a table storage unit in which a table having one or more records is stored;
The computer,
A table output unit for outputting the table;
A selection receiving unit that receives a selection of one record for the table output by the table output unit;
One or more attribute values of the selected record are read from the table storage unit, and a screen configuration unit that configures a screen in which the one or more attribute values are assigned to corresponding fields;
A screen output unit for outputting a screen configured by the screen configuration unit;
An edit instruction receiving unit for receiving an edit instruction for the screen output by the screen output unit;
In response to the edit instruction, edit the one record, function as a record update unit to update,
The record has two or more attribute values that are attribute values;
The recording medium is
In association with each of the two or more attributes, a mandatory information storage unit that stores essential information indicating whether or not the presence of an attribute value is essential is further stored.
The screen composition unit
The first special color that is different from the background color of the other fields if the background color of one or more fields corresponding to the essential information indicating that the presence of the attribute value is essential, if the attribute value corresponding to the field exists And when there is no attribute value corresponding to the field , configure a screen with a second special color different from the background color of the other field and the first special color ,
The computer,
An input receiving unit that receives input of attribute values for the field;
Is a field presence attribute values corresponding to the required information indicating that it is essential, if the input attribute value is accepted for fields not yet attribute value is present, the background color of the field, the first A program for further functioning as a screen change unit for changing from two special colors to the first special color , which is a color corresponding to the input of an attribute value.

Images