JP2014089674A - Database access right setting management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database access right setting management system such that when there are a plurality of administrators of a database to be constructed, rights to access the database that the plurality of administrators have are displayed to be easily grasped at a glance.SOLUTION: Arithmetic control means (arithmetic control circuit of common management server 13) displays a plurality of access operation objects (for example, individuals, groups, official titles, etc.) in one of longitudinal and lateral directions on an access right setting screen (access right setting screen in Fig. 49), displays access conditions (statuses of completion, application, and access order, for example, primary, secondary, ..., (n)th) in the other of the longitudinal and lateral directions on the access right setting screen, and also displays check boxes 130 for allowing access at positions corresponding to the plurality of access operation objects and access conditions.

Description

  The present invention relates to a database access right setting management system for setting and managing an access right of a database constructed in a server.

  Conventionally, various database development systems using a communication line such as the Web have been considered (for example, see Patent Documents 1 and 2).

  On the other hand, when building a database in a database development system, create the required multiple tables, set the attributes of each item in each table, and associate each table to normalize the associated table In general, an input form provided with an input unit based on a table is set.

  Such a database is generally approved (authenticated) by a plurality of administrators to obtain a final input screen even when it is newly created or changed in the middle. is there. In such cases, access rights for database approval must be set individually according to the management items of the database, depending on the departments, managers' responsibilities and qualifications held by the administrator, etc. Is normal (see, for example, Patent Document 3).

JP 2010-128873 A Japanese Patent Laid-Open No. 9-237274 JP 2007-157037 A

  Conventionally, however, access rights for such approval have been set individually, and it has been difficult for a database administrator to know how much access rights he has.

  Accordingly, an object of the present invention is to provide a database access right setting management system capable of displaying at a glance the access rights of a plurality of administrators to a database when there are a plurality of managers of the database to be constructed. To do.

  Therefore, the present invention provides a recording means for recording data management software for displaying an access right setting screen for a plurality of access operation objects, a display means for displaying the data management screen, and a data operation on the data management screen. A database access right setting management system comprising: an operating means to be executed; and an arithmetic control means for causing the display means to display an access right setting screen based on an operation of the operating means, wherein the arithmetic control means includes the access The plurality of access operation objects are displayed in one of the right direction and the horizontal direction of the right setting screen, the access condition is displayed in the other of the right and left directions of the access right setting screen, and the plurality of the access operation objects are displayed. And a check box that allows access to the corresponding location in the access condition. It characterized in that it was over to authenticate right setting management systems.

  According to this configuration, when there are multiple managers to the database to be built, it is possible to display the right of access to the database of multiple managers at a glance, making it easy to manage the access rights settings for building the database. Can be done.

It is explanatory drawing which shows an example of the database creation management system which concerns on this invention. FIG. 2 is a control circuit diagram of the fixed terminal shown in FIG. 1. It is a schematic block diagram explaining the user authentication server shown in FIG. FIG. 2 is a schematic configuration explanatory diagram of a common management server shown in FIG. 1. FIG. 2 is a schematic configuration explanatory diagram of a customer server shown in FIG. 1. FIG. 2 is a schematic configuration explanatory diagram of a system area server shown in FIG. 1. FIG. 2 is a control circuit diagram of the mobile terminal shown in FIG. 1. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing of the access right management screen in the database creation management system of FIG. It is explanatory drawing of the input screen creation of the mail account application form of the database access right setting management system which concerns on this invention. It is explanatory drawing of the workflow setting of the database access right setting management system which concerns on this invention. It is explanatory drawing of the approval screen of the mail account application form of the database access right setting management system which concerns on this invention. It is explanatory drawing of the access right setting screen of the database access right setting management system which concerns on this invention. FIG. 50 is an explanatory diagram of a group list screen displayed when a group addition button is clicked on the access right setting screen of FIG. 49. FIG. 49B is an explanatory diagram of a group list in which a list of job titles is displayed when the job title of FIG. 49A is selected and clicked. It is explanatory drawing which shows the example of a display of the data of an administrator's mail account application. It is explanatory drawing which shows the example of a display of the data of a general user's mail account application.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[Constitution]
(i). Schematic Components of Database Creation Management System As shown in FIG. 1, a database creation management system according to the present invention includes a database Web server system 1 and a fixed terminal on the client (user) side. (Communication terminals) A and B and mobile terminals (communication terminals) C such as mobiles on the client (user) side are provided. The database creation management system also includes connection communication devices 3 such as routers and gateways that connect the fixed terminals A and B to the Web server system 1 via the online line 2. In addition, the fixed terminal B and the mobile terminal C are connected to the Web server system 1 via the Internet 2 a and the connection communication device 3.

  As shown in FIG. 2, the fixed terminals A and B include a keyboard 4 used for inputting characters and the like, a mouse 5 used for screen operation, a keyboard (screen operation means) 4, a mouse (screen operation means) 5, and the like. An arithmetic control unit 6 that is an arithmetic control circuit (terminal control unit) to which an input signal or an operation signal is input by an input operation means, a memory (storage unit) 7 connected to the arithmetic control unit 6, and a memory 7 A display device (display means) 8 such as a liquid crystal display that displays a screen based on the stored control program is provided.

  As illustrated in FIG. 3, the mobile terminal C includes a calculation control unit 9 that is a calculation control circuit (terminal control unit), a memory (storage unit) 10 that is connected to the calculation control unit 9, and a memory 10. A display device (display means, screen operation means) 11 such as a touch panel type liquid crystal display that displays a screen based on a stored control program is provided.

Since the fixed terminal B is connected to the Web server system 1 via the internetwork 2a, it can be used as a mobile terminal as long as it is a notebook type.
(ii). Schematic Components of Web Server System 1 The Web server system 1 includes a user authentication server 12, a common management server 13, a customer area server 14, and a system area server 15.
(User authentication server 12)
The user authentication server 12 is used for user authentication, and performs authentication by customer ID / user ID / PW (password). The user authentication server 12 includes a management server control unit (management server control circuit) 12a and a storage unit (memory such as RAM and ROM) 12b shown in FIG. 2A, a program and data recording unit (hard disk, silicon disk or optical disk). Magnetic recording device) 12c and the like.
(Common management server 13)
The common management server 13 includes a management server control unit (arithmetic control circuit) 13a and a storage unit (memory such as RAM and ROM) 13b shown in FIG. 2B, a program and data recording unit (hard disk, silicon disk, or magneto-optical). Recording device) 13c and the like. The common management server 13 provides a common function for all customers, and mainly provides various database templates. Examples of the template include a control template, a form template, and a skin template.

In the recording unit 13c of the common management server 13, data management software having screen display programs such as an input data approval screen (FIG. 48) and an access right setting screen (FIG. 49) is recorded.
(Customer area server 14)
The customer area server (data server, data storage unit) 14 includes a data server control unit (arithmetic control circuit) 14a and a storage unit (memory such as RAM and RON) 14b, programs and data which are not shown in FIG. 2C. And a recording unit (hard disk, silicon disk, or magneto-optical recording apparatus) 14c. The customer area server 14 is a data storage unit that provides a WebDB (web database) function for each customer. The WebDB function includes a WebDB management function, a WebDB utilization function, and the like.
(System area server 15)
The system area server 15 includes a system control unit (arithmetic control circuit) 15a and a storage unit (memory such as RAM and RON) 15b, a program and data recording unit (hard disk, silicon disk, or magneto-optical recording) shown in FIG. 2D. Device) 15c and the like. The system area server 15 provides a customer addition / deletion function and outputs various source usage logs.
(Example of software used)
In addition, software such as CentOS, Apache, MySQL, Ruby, etc. is recorded in a recording unit (not shown) of programs and data such as the user authentication server 12, the common management server 13, the customer area server 14, and the system area server 15. Has been. CentOS is a free Linux (registered trademark) distribution software aiming at complete compatibility with RedHatEnterpriseLinux (hereinafter referred to as “RHEL”). Apache is Web server software. MySQL is free database software. Ruby is software used to write programs such as Web application system management and text processing.
(iii). Schematic Configuration and Access Procedure for Database Creation of Web Server System 1 The user authentication server 12 is accessed from the fixed terminal A via the connection communication device 3 to the Web server system 1, or the fixed terminal B When the Web server system 1 is accessed from the mobile terminal C via the Internet 2a and the connection communication device 3, the initial customer authentication screen 20 as shown in FIG. It is displayed on the display device 11 of the terminal C.

  The customer authentication screen 20 includes an ID input unit (ID input box) 21 for inputting a user ID, a PW input unit (PW input box) 22 for inputting a PW (password), a clear button 23, and a login button 24. Is displayed.

  On the customer authentication screen 20, the customer ID can be input to the ID input unit 21 using the keyboard 4 of the fixed terminals A and B, and the customer password can be input to the PW input unit 22. In the mobile terminal C, a customer ID or a customer password can be input by touching a character button or the like displayed on the display device 11.

  The clear button 23 and the login button 24 can be operated with the mouse 5 of the fixed terminals A and B. The mobile terminal C can be operated by touching the clear button 23 or the login button 24 displayed on the display device 11. The button selection operation using the mouse 5 and the selection operation by touching the touch panel display device 11 will be described below simply as a selection operation or a button selection operation.

  The user authentication server 12 selects the login button 24 on the customer authentication screen 20 shown in FIG. 4 while the customer ID is correctly input to the ID input unit 21 and the customer password is correctly input to the PW input unit 22. When operated, the control of the user authentication server 12 is switched to the control of the customer area server 14. When the control from the user authentication server 12 is switched, the customer area server 14 displays the selection screen 27 on which the WebDB use button 25 and the WebDB management button 26 shown in FIG. 5 are displayed.

  When the WebDB use button 25 is selected and operated, the calculation control circuit (control unit) (not shown) of the customer area server 14 searches a recording area (not shown) of the customer area server 14 and uses it other than the manager of the customer. A WebDB (web database) for inputting data is called from a recording area (not shown) of the customer area server 14 and switched to an input selection screen (not shown) of the WebDB.

  In addition, when a WebDB management button 26 is selected on the selection screen 27, an arithmetic control circuit (control unit) (not shown) of the customer area server 14 searches a recording area (not shown) of the customer area server 14 and manages the customer. The management screen (list screen) 28 of the WebDB (web database) as shown in FIG.

  On this management screen 28, a DB management menu bar 28a and a selection list 28b are displayed. In addition, items such as “WebDB”, “system management”, “WebDB use”, and “logout” are displayed on the DB management menu bar 28a. Items such as screen title, owner (administrator), version, update date / time, screen content, type, disclosure (public / private), change, and deletion are displayed in the selection list 28b.

  When “WebDB” in the DB management menu bar 28a of FIG. 6 is selected, “WebDB list”, “Create new form”, “Screen access control setting” as shown in FIG. , Items such as “form template list” are displayed. When the form template list in FIG. 7 is selected, a list of various templates in a database (not shown) is read from the common management server 13 and displayed. Examples of the various templates include templates recorded in the common management server 13 such as a control template, a form template, and a skin template.

  Then, a data input screen G1 of the database, for example, a data input screen of “company car master” whose screen title is shown in FIG. 8, or a screen title created using this “company car master” is shown. The present invention will be described by taking as an example a case where a data input screen G2 for “company car use management” as shown in FIG. 9 is created.

First, the database items on the data entry screen G1 of the “company car master” database shown in FIG. 8, the data entry screen G2 of “company car use management” as shown in FIG. 9, and the like will be described.
(Input items on the data entry screen G1 of “company-owned car master”)
In the data entry screen G1 of the “company car master” database shown in FIG. 8, the company car master is displayed as the database screen title, and “parking lot number, vehicle number, mission, equipment, use” Data entry items such as “start date, remarks, car name, address, display contents” are displayed.

  A text box (number input box) dB1 is displayed as a data input section to the right of the parking lot number, and a region selection combo box dB2, number input boxes dB21, dB22, and dB23 are data input sections to the right of the vehicle number. It is displayed as.

  On the right side of the mission, an AT selection radio button RB1 and an MT selection radio button RB2 which are mission types are displayed as a data input section, and on the right side of the equipment, an equipment check ETC check box ChB1, A navigation check box ChB2 is displayed as a data input section.

  Further, a date input box dB3 is displayed as a data input part on the right side of the use start date and a calendar icon CL is displayed for date selection, and a remark input box dB4 is displayed as a data input part on the right side of the remarks. A car name input box dB5 is displayed as a data input part on the right side of the car name, an address input box dB6 is displayed as a data input part on the right side of the address, and a content input box dB7 is entered on the right side of the display contents. It is displayed as a part.

  In addition, a “cancel” button is displayed at the lower left of the data input screen G1, and a “next” button for displaying the next input screen is displayed at the lower right of the data input screen G1.

In this data input screen G1, text box (number input box) dB1, area selection combo box dB2, number input boxes dB21, dB22, dB23, AT selection radio button RB1, MT selection radio button RB2, equipment check The ETC check box ChB1, the navigation check box ChB2, the date input box dB3, the remarks input box dB4, the car name input box dB5, the address input box dB6, the content input box dB7, and the like serve as data input sections.
(Items entered on the data entry screen G2 for “owned vehicle use management”)
In the data input screen G2 of “company car use management” in FIG. 9, “company car use management” is displayed as a screen title, and “management number, company car, representative user, use start date, Items such as “use end date, use purpose, vehicle status, remarks” are displayed. Since the data entry screen G2 for the “company car use management” is created in the same manner as the data entry screen G1 for the “company car master”, detailed description of the data entry screen G2 is omitted. Also on this data input screen G2, input boxes and buttons on the right side of items such as “management number, company-owned vehicle, representative user, use start date, use end date, use purpose, vehicle state, remarks”, etc. (reference number omitted) Becomes a data input part.

  In the first creation method, a template for a “company car master” data input screen as shown in FIG. 8 or a “company car use management” data input screen as shown in FIG. If it is easy on the one side, select "Form template list" from the pull-down menu of "WebDB" to display the form template list, and from this list "Company owned car master" or "Used company owned car management" Template. Then, a data input screen for “company car master” and “company car use management” is created using the selected template.

  In the second creation method, the user clicks “Create New Form” in FIG. When this “create new form” is clicked, a form information input screen 29 for creating a new form as shown in FIG. 10 is displayed.

  The form information input screen 29 includes a new selection button 30 that is a radio button, a template use button 31 that is a radio button, a template selection box 32, a template selection button 33, a screen corresponding to the form creation method item. A title input box 34, a screen content input box 35, a category input box 36, a cancel button 37, a create button 38, and the like are displayed.

  In the fixed terminals A and B, a new selection button 30, a template use button 31, and a template selection selection button 33 are displayed by operating a cursor (not shown) with the mouse 5 in the fixed terminals A and B, and touching the touch panel type display device 11 in the mobile terminal C. , The cancel button 37, the creation button 38, and the like can be operated.

  Then, a template use button 31 that is a radio button is selected and a selection button 33 for selecting a template is clicked or touched to display a template list that is a template of an already created database. A database template can be selected from this list and displayed in the template selection box 32.

  When the screen title input box 34, the screen content input box 35, the category input box 36, and the like are selected by touching the cursor (not shown) with the mouse 5 or the touch panel display device 11, the keyboards in the fixed terminals A and B are selected. 4 enables character input or the like to be performed in the screen title input box 34, the screen content input box 35, the category input box 36, and the like. This input can also be performed by touching a character button or the like displayed on the display device 11 on the mobile terminal C.

For example, as shown in FIG. 11, the title “company-owned car master” can be input in the screen title input box 34, and the content of “company-owned car master” is displayed in the screen content input box 35. The user can input the contents of the screen “This is the master of the company” and can input that the “company-owned car master” is in the category “master” in the category input box 36.
(iv) Detailed configuration for database creation by the Web server system 1 Since the input operations by the fixed terminals A and B and the mobile terminal C can be executed in the same manner, a new database form is created by the operation by the fixed terminal A. Will be described, and description of operations by the fixed terminal B and the mobile terminal C will be omitted. In this description, a case where a database used for management of vehicles owned by a company, that is, a “company-owned vehicle master” is created will be described as an example of database creation.

  As described above, the user clicks “Create a new form” in FIG. By clicking “Create new form”, a form information input screen 29 for creating a new form as shown in FIG. 10 is displayed.

  When a new selection button 30 is selected on the form information input screen 29, a black circle 30a indicating that the selection operation has been performed is displayed in the new selection button 30. In this state, as described above, for example, the title “company-owned car master” is input to the screen title input box 34, and the content of “company-owned car master” is set to “company-owned car master” in the screen content input box 35. The screen content “I am a master” is input, and the category input box 36 is input that “company-owned car master” is a category “master”. After this input, the creation button 38 is selected and operated.

  By this operation, the calculation control circuit (control unit) (not shown) of the customer area server 14 controls the common management server 13, and the database creation shown in FIG. 12 is performed by the calculation control circuit (control unit) (not shown) of the common management server 13. A screen (management software created image) 39 is displayed.

The database creation screen 39 in FIG. 12 includes a screen creation area (input form display area) 40 for displaying a data input section created by a computation control circuit (calculation control means) (not shown) of the customer area server 14, and a screen creation area. (Input form display area) 40 has a screen creation operation display area 41 for creating and displaying a data input section.
A. Screen creation operation display area 41
As shown in FIGS. 12 and 13, the screen creation operation display area 41 includes a control icon bar 42 used for creating a data input part of the screen creation area (input form display area) 40, and item creation of the data input part. It has an input condition setting display area 43 used for other setting operations such as arrangement and input conditions.
a. Control icon bar 42
The arrangement of control icons on the control icon bar 42 may be as shown in FIGS. As another example of the arrangement of the control icons, as shown in FIG. 46, frequently used items are arranged at visible positions, and those with low use frequency are called by the extended function icon 100. Can be set.
<Description of the icons of the arrangement shown in FIGS. 12 and 13>
This control icon bar 42 is indicated by a trash can control (trash can icon) 42a, a radio button creation control (radio button creation icon) 44 indicated by "middle inside black", and a "square" line. A check button creation control (check button creation icon) 45 and a combo box creation control (combo box creation icon) 46 indicated by “vertical lines and downward triangles in a rectangular frame elongated to the left and right” are arranged. .

  The control icon bar 42 includes a single line text box creation control (text box creation icon) 47 indicated by “Aiueo”, and a numeric input box creation control (numerical input box creation icon) indicated by “12345”. ) 48, several lines of text box creation control (text box creation icon) 49 shown in “2-line AIUEO”, date input box creation control (date input box creation icon) shown in “calendar icon” 50 is arranged.

  Further, the control icon bar 42 includes a URL input box creation control (URL input box creation icon) 51 indicated by “URL”, and a master linkage box creation indicated by “an icon using a right-angled arrow”. Control (master link box creation icon) 52, automatic number box creation control (auto number box creation icon) 53 indicated by "auto", screen information setting button 54 for screen information confirmation, "gear is displayed The control batch setting button 55 indicated by “Icon” is arranged.

For convenience of illustration, in FIG. 14 and subsequent figures, radio button creation control 44, check button creation control 45, combo box creation control 46, one-line text box creation control 47, numeric input box creation control 48, number A line text box creation control 49, a date input box creation control 50, a URL input box creation control 51, a master linkage box creation control 52, an automatic number box creation control 53, etc. are used as they are or explained. For convenience, it is simply used as controls 44-53. Further, the control (icons) 44 to 53 of the control icon bar 42 and the symbols of the buttons will be described with reference to the drawings as necessary.
・ Trash control 42a
The trash can control 42a moves the buttons and input boxes created in the screen creation area 40 to the trash can control 42a by dragging and dropping with a mouse. Used to delete.
-Radio button creation control 44
The radio button creation control 44 is used to create a radio button in the screen creation area 40 by dragging and dropping with a mouse.
-Check button creation control 45
The check button creation control 45 is used to create a check button in the screen creation area 40 by dragging and dropping with a mouse.
・ Combo box creation control 46
The combo box creation control 46 is used to create a combo box in the screen creation area 40 by dragging and dropping with a mouse.
-Text box creation control 47
The text box creation control 47 is used to create a text input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 48 for creating numeric input boxes
This numerical input box creation control 48 is used to create a numerical input box in the screen creation area 40 by dragging and dropping with a mouse.
-Text box creation control 49
This text box creation control 49 is used to create a long text input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 50 for creating date box
The date input box creation control 50 is used to create a date input box in the screen creation area 40 by dragging and dropping with a mouse.
-URL input box creation control 51
The URL input box creation control 51 is used to create a URL input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 52 for creating master linkage box
The master linkage box creation control 52 is used to create a linkage operation box in the screen creation area 40 by dragging and dropping with a mouse.
・ Automatic number box creation control 53
The automatic number box creation control 53 is used to create an automatic number input box in the screen creation area 40 by dragging and dropping with a mouse.
Screen information setting button 54 for confirming screen information
The screen information setting button 54 for confirming the screen information is used for displaying the created database input screen and confirming the database input screen.
・ Control batch setting button 55
The control batch setting button 55 is used to control the contents of the created database item (for example, presence / absence, uniqueness, display order in list, presence / absence of search target, display alignment, presence / absence of label, X coordinate and Y coordinate This is used to confirm or reset the position.
<Description of Icon Arrangement Example Shown in FIG. 46>
(Control icon bar 42)
In the example in which the database creation screen (management software creation image) 39 of FIG. 12 is displayed, the URL input box creation control 51, the master linkage box creation control 52, the automatic number box creation control 53, and the like are control icon bars. 42 shows an example that is always displayed.

  However, since the URL input box creation control 51, the master linkage box creation control 52, the automatic number box creation control 53, and the like are not frequently used, it is necessary to always display them on the control icon bar 42. There is no. These can be incorporated into extended functions.

  Therefore, in FIG. 46, the extended function icon 100 is provided in the control icon bar 42 in the database creation screen (management software creation image) 39. This extended function icon 100 is used by being incorporated in the control icon bar 42 of FIG.

  The extension function icon 100 calls the above-described URL input box creation control 51, master linkage box creation control 52, and automatic number box creation control 53. In the database creation screen 39 of FIG. 46, an input screen for a mail account application form is created.

In addition to the extended function icon 100, the control icon bar 42 in FIG. 46 includes a workflow control 102 that is a workflow icon and a control (access right setting icon) 102a that is an icon for setting access rights. However, explanation is omitted.
(Input screen configuration for email account applicants in screen creation area 40)
Before clicking the workflow control 102, the mail account applicant input screen is designed using the screen creation area 40 of FIG.

In this screen creation area 40, an image (image) to be displayed on the approval path on the workflow screen is arranged. In FIG. 46, for example, status, application..., Department manager, system manager, and image display setting box 103 are set as images.
For example, “applicant”, “primary approver”, “secondary approver”, “tertiary approver”, and the like are provided as items to be selected and input in the image display setting box 103. A plurality of image display setting boxes 103 are arranged to the right of “status”, and “applicant”, “primary approver”, “secondary approver”, “ When “tertiary approver” is selected and entered in order, “status”, “applicant”, “primary approver”, “secondary approver”, “third approver” in the mail account application form of FIG. The route can be displayed.

  In the screen creation area 40, an item “application / approval date” is arranged below “status”. Further, the screen creation area 40 includes “application category”, “mail category”, “affiliation category”, “desired processing date”, “name / group”, “name / group” “Yomigana”, “name / group”. "Romaji" and "Name / Organization" "Mail address" items. This “mail address” is provided with items such as “first request”, “second request”, and “third request”. The screen creation area 40 is provided with items of “memo” and “system person in charge”. Items such as “password”, “contact field”, and the like are provided as items of “system person input”.

  An application setting box 104 for setting an application category is provided to the right of the “application category” item. As this application category, for example, there are new,... The application setting box 104 and the application category list can be set in advance using the combo box creation control 46. The application category list can be displayed in a pull-down format by clicking the list button 104a at the right end of the application setting box 104. The application setting box 104 can be set by selecting the setting contents from this list. In the figure, “new” is set.

  An application target setting box 105 for setting an application target is provided to the right of the item “Mail Classification”. Examples of the application target include individuals, organizations (groups), positions, and so on. The application target setting box 105 and the application target list can be set in advance using the combo box creation control 46. The application target list can be displayed in a pull-down format by clicking the list button 105 a at the right end of the application target setting box 105. The application target setting box 105 can be set by selecting the setting contents from this list. In the figure, “individual” is set.

  To the right of the “affiliation category” item, an affiliation setting box 106 for setting the affiliation category is provided. As this affiliation category, for example, other departments such as the first sales department, the second sales department, the general affairs, the accounting department, the design department, and the planning department in a company or organization can be cited as an example. The affiliation setting box 106 and the affiliation classification list can be set in advance using the combo box creation control 46. The list of affiliation classifications can be displayed in a pull-down format by clicking the list button 106a at the right end of the affiliation setting box 106. Then, by selecting the setting contents from this list, the affiliation can be set in the affiliation setting box 106. In the figure, it is not set.

  A date input box 108 for inputting a desired processing date is provided to the right of the item “desired processing date”. A target input box 109 is provided to the right of the “name / group” item. In order to input the “Name / Organization” Yomigana or Romaji, the “Name / Organization” item has items such as “Yomigana”, “Romaji”, and “Mail Address” below. A character input box 109a is provided on the right side of “Yomigana”, a character input box 109b is provided on the right side of “Romaji”, an address input box 109c for “first choice” on the right side of “Mail address”, “ A second input address input box 109d and a third input address input box 109e are provided.

  Further, an input box 110 for inputting a password is provided to the right of the “password” item, and an input box 111 for inputting contact details to the system staff is provided to the right of the “contact field” item.

  The items, input boxes, and the like described above are merely examples, and items, input boxes, and the like other than the items described above can be set on the input screen of the mail account applicant.

  Such a screen of the mail account applicant is created using the control icon bar 42 of the screen creation area 40 and the screen creation operation display area 41 and the input condition setting display area 43.

46 shows an example of creating an image that is partly different from the content displayed on the mail account applicant screen of FIG. 48, the screen of the mac account application of FIG. 48 is the screen creation area 40 of FIG. The control icon bar 42 in the screen creation operation display area 41 and the input condition setting display area 43 are used.
(Workflow setting by workflow control 102)
The mail account applicant input screen shown in FIG. 48 is generated using the mail account applicant input screen as shown in FIG. When the workflow control 102 is clicked, a workflow setting screen 120 as shown in FIG. 47 can be called.

  On this workflow setting screen 120, access right for approving input data, access right for data input / output such as input / change / modification / deletion of data in the database, etc. can be set.

This workflow setting screen 120 includes “workflow execution”, “number of approvals”, “end of flow”, “selection of approver”, “notification of approval request mail”, “notification of return mail”, “edit mail contents”, etc. Are displayed, and an access right setting list 121 is displayed.
(Contents of display items)
In addition, the workflow setting screen 120 is provided with a check box 122 for “workflow execution”, an approval number input box 123 for “number of approvals”, an approval setting box 124 for “end of flow”, and the like. ing. The approval number input box 123 is provided with a button 123a for displaying a list of numerical value selections. By clicking this button 123a, a pull-down numerical value selection list “0, 1, 2,... N” is displayed, and the number of approvals can be selected and set from this list “0, 1, 2,. The approval setting box 124 is provided with a button 124a for displaying a list for selecting the number of workflow approvers, the route, and the approver. By clicking this button 124a, a pull-down selection box (not shown) is displayed. From this selection box (not shown), the number of workflow approvers, the route, the approver, and the like can be selected and set in the approval setting box 124.

  In the selection box 124a, for example, when the value input in the approval number input box 123 is “3”, only “applicant” is “applicant → primary approver → secondary approver → 3”. Other routes such as “next approver” are automatically generated and displayed so that they can be selected. If “applicant → primary approver → secondary approver → tertiary approver” is selected from the selection box 124a, “status” is displayed on the approval screen of the mail account application form shown in FIG. “Applicant → Primary Approver → Secondary Approver → Third Approver” is displayed.

  Further, the workflow setting screen 120 displays a selection box 125 for “selection of approver”, a check box 126 for approval request mail notification, a check box 127 for notification of return mail, and a check box 128 for editing mail contents. It is like that.

In the selection box 125 for “selection of approver”, a pull-down selection box (not shown) is displayed. In this selection box (not shown), a list of “select all by applicant”, “none”, specific items such as “system staff”, or “primary” to “n-order” is set. . This setting can be performed using the combo box creation control 46.
(List of access right settings 121)
When the workflow control 102 is clicked on the mail account applicant input screen as shown in FIG. 46, the access right setting list 121 corresponds to the items of the mail account applicant input screen created in the screen creation area 40 of FIG. The “control name” of the item to be created is automatically generated and displayed.

  Here, the input screen of the mail account applicant in FIG. 46 includes “application date”, “department manager approval date”, “system manager approval date”, “application category”, “email address (first choice)” ”,“ Mail address (second choice) ”,“ mail address (third choice) ”,“ name / organization name ”,“ desired processing date ”, and the like will be described.

  The access right setting list 121 in FIG. 47 includes “application date”, “department administrator approval date”, “system manager approval date”, and “application category” created on the mail account applicant input screen in FIG. "Email address (first choice)", "Email address (second choice)", "Email address (third choice)", "Name / Organization name", "Processing date", etc. automatically Generated and displayed.

  At this time, the items of “after completion” A1 and “application” A2 as the applicant are displayed in the access right setting list 121. In addition, in the access right setting list 121, access rights for “primary” to “n-order” A3 to An that are primary to n-order approver are set on the right side of the item “applicant”. Items are provided.

  In the example described above, the number corresponding to the number of approvals set in the approval number input box 123 is “3”. Therefore, “3” is displayed corresponding to the items B0, B1 to Bi to Bn displayed in the list in the “control name” A0. Access rights for “After completion” A1, “Application” A2, “Primary” A3 to “Tertiary” A5 can be set. Examples of the access right include “none”, “change”, “inquiry”, etc. in which nothing is set.

  In addition, by clicking the cells corresponding to the items B0 to Bn listed in the “control name” A0, “after completion” A1, “application” A2, “primary” A3 to “nth” An The list of “none”, “change”, and “inquiry”, which are the contents set in the cell at this location, can be displayed in a combo box or the like. Then, by selecting from the list of “none”, “change”, and “query”, any of “none”, “change”, and “query” can be set in the cell.

  For example, if the cells corresponding to “application date” B0 and “after completion” A1, “application” A2, “primary” A3 to “tertiary” A5 are C1 to C5, cell C1 has “none”. The setting “−” is set, the “change” setting is displayed in the cell C2, and the “inquiry” setting is set in the cells C2 to C5. Similar settings can be made for other items.

  After such setting is completed, the detailed setting is completed by clicking the “apply” button 129. Such a setting is set for each applicant.

  The detailed access right condition setting can be performed on the workflow setting screen shown in FIG. 47 by clicking the workflow control 102. The access right setting in such workflow setting is performed by a workflow setting person (an administrator who creates a database input screen).

  Then, after clicking the “Apply” button 129 after setting the number of approvals, that is, the number of primary, secondary,... The settings are registered.

  Also, after setting and registering the number of approvals, that is, the number of approvers of primary, secondary,..., A screen as shown in FIG. 49 for setting the access right for approval may be displayed. it can.

  The access right setting screen shown in FIG. 49 can be displayed by clicking an icon for account setting control shown in FIG. When this screen is displayed, only “all groups” are initially displayed. On this screen, an “add group” button 140 of an item for adding a group is clicked to set the access authority shown in FIG.

  When the “add group” button 140 is clicked on the screen of FIG. 49, the group list screen shown in FIG. 49A is displayed. On this group list screen, a search condition setting unit 141 is displayed.

  The search condition setting unit 141 includes a group check unit 142 and a user check unit 143 on the right side of the group / user item. The search condition setting unit 141 is provided with items of group type and group name located below the group / user item, and a group setting box 144 is displayed on the right side of the group type. A name input box 145 is displayed on the right side of the name item.

  Then, by clicking the button 144 a of the group setting box 144, a group list 146 is displayed below the search condition setting unit 141. In this embodiment, only “title” is displayed, but a group other than “title” can be set.

  When “Position” is selected from the list 146, “Position” is set in the group setting box 144 of the group type as shown in FIG. 49B, and the search button 147 is clicked, a list 148 related to “Position” is displayed. Is displayed. In this list 148, for example, positions such as team leaders, managers, vice heads, presidents, and so on are displayed. Also, in this list 148, check boxes 149 are displayed corresponding to the respective positions. When the check box 149 is checked and the selection button 150 is clicked, the post corresponding to the checked check box 149 is displayed in the workflow authority portion of FIG.

  In FIG. 49, “all groups”, “user: 11000566: Seiji Komatsu”, “affiliation: Kochi branch> corporate sales department”, and “title: section manager” selected in this way are accessed in the workflow authority column. It is listed as.

  Further, in FIG. 49, cell portions corresponding to the access targets G1 to Gn of the group G to which the authority of the workflow is given and “after completion” A1, “application” A2, “primary” A3 to “nth” An Each has a check box 130 displayed. This “after completion” A1, “application” A2, “primary” A3 to “n-order” An, etc. become access conditions (approval conditions, ie, authentication conditions).

  Then, only by checking the check box 130 of the cell portion corresponding to the applicant and “after completion” A1, “application” A2, “primary” A2 to “n-order” An, the access right for approval (Approval rights) can be set.

  The check box 130 is provided only in correspondence with the number of approvals shown in FIG. 47 in addition to “after setting is completed” A1 and “application” A2, so when the number of approvals is “3”, “setting complete” It is provided only in portions corresponding to “primary”, “secondary”, and “tertiary” outside “after” A1 and “application” A2. This setting is automatically performed by applying the setting shown in FIG.

  Therefore, it is possible to easily set the access right setting (approval right setting, that is, authentication condition setting) of a plurality of applicants simply by checking the check box 130. This setting can be easily released by simply unchecking the check box 130.

  In the example of FIG. 49, all the check boxes 130 of “After completion” and “Application” are checked, so anyone can apply for access right setting (approval right setting). The primary applicant is set as “Title: Manager”. Only the person whose title is the section manager can be designated as the primary approver. In addition, the affiliation that can be designated as the secondary approver is set to “only those who are in the corporate sales of the sales department of Kochi branch”. Further, the third-order approver is set to “only a user with a user ID of 110005626”. Such a setting can be easily changed by performing a check / uncheck operation by clicking the check box 130 on the access right setting screen of FIG.

  In FIG. 49, “All groups”, “User: 11000566: Seiji Komatsu”, “Affiliation: Kochi branch> Corporate sales department, Junsei Yamanaka”, “Title: Section chief” are subject to approval in the column of workflow authority ( Authentication operation target, that is, access target). Assuming that the manager is Haruyuki Kimura, the “Applicant” on the email account applicant approval screen shown in FIG. 48 is “Hiryuki Kimura”, “Primary Approver” is “Hiroyuki Kimura”, “Secondary “Approver” becomes “Yamanaka Junsei” and “Third Approver” becomes “Komatsu Seiji”.

  When the database creation screen (management software creation image) 39 of FIG. 46 is used, after the WebDB management button 26 of FIG. 5 is clicked, a new form creation or form template list of FIG. 46 database creation screens (management software created images) 39 are set so that they can be displayed. When the mail account application control 102a is clicked when the mail account applicant approval screen shown in FIG. 46 is created, the mail account application screen shown in FIG. 50 is displayed. When the worker in FIG. 46 is an administrator who has all the authority, as shown in FIG. 50, all mail account application data is displayed.

  Further, in the case of a general user, when the WebDB management button 26 is clicked, as shown in FIG. 51, it is set so that only the data of the mail account application related to the user is displayed. Can do. In FIG. 51, since “Kimura Haruyuki” is a list of mail account applicants who have logged in, only data related to “Kimura Haruyuki” is listed.

In the mail account application data lists of FIGS. 50 and 51, a search mark 151 is displayed in the “inquiry” item, and an approval screen display icon that permits a change (approval) on the approval screen in the “change” item. 152 is displayed. The search mark 151 of the item “inquiry” is displayed for all data. Further, the approval screen display icon 152 is displayed and set only for data corresponding to the access target and the access condition set in FIG. That is, the data is displayed in the data that matches the access target and the access condition checked by the check box 130.
(Approval screen for email account application form in Fig. 48)
When the approval screen display icon 152 is clicked on the mail account application screens shown in FIGS. 50 and 51, the mail account application approval screen shown in FIG. 48 is displayed.

  The approval screen content created in FIG. 46 is displayed on the approval screen in FIG. In this approval screen, a return button 131, a temporary save button 132, and an approval button 133 are displayed, and an input box 134 for “content of approval / return mail to be sent” is displayed.

  Under the “Status” item, the workflow approval status such as “Waiting for primary approval”, “Waiting for secondary approval”, “Waiting for tertiary approval”, “Completed”, etc. is displayed. In addition, an item “application / approval date” is displayed under the approval status. On the right side of the “application / approval date”, an approval date is displayed when the approval button 133 is clicked. In FIG. 48, “July 26, 2012” is displayed as the approval date.

The software for the workflow approval screen program created in this way can be used in other databases by adding it to a database other than the database shown in this embodiment.
b. Input condition setting display area 43
(b-1). Basic Display In FIGS. 12 and 13, nothing is displayed in the input condition setting display area 43.

  The controls 44 to 53 of the control icon bar 42 are moved to the screen creation area (input form display area) 40 by the touch creation operation of the touch panel of the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C. When a drag and drop operation is performed to create boxes and buttons corresponding to the controls 44 to 53 in the screen creation area 40, the input condition setting display area 43 includes an item name input box (input condition setting unit) 56 and a label. Check box (input condition setting unit) 57 is displayed as an operation unit, and in addition to the item name input box 56, condition setting for inputting necessary conditions in the text box dB1 created in the screen creation area 40 Part (operation part) is displayed. The label check box 57 is used to set whether the item name input in the item name input box 56 is the item name of the box or button created in the screen creation area 40 by the controls 44-53. Used for. When the label check box 57 is checked, the item names input in the item name input box 56 are displayed on the left side of the boxes and buttons created in the screen creation area 40 by the controls 44-53. 53, item names of boxes and buttons created in the screen creation area 40 are displayed.

  For example, the text box creation control 47 of the control icon bar 42 is displayed on the screen creation area (input form display area) 40 by a touch movement operation of the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C. When a drag and drop operation is performed in the creation area 40, a text box dB1 is created in the screen creation area 40 as shown in FIG. When the text box dB1 is created in the screen creation area 40, the item name input box 56 for inputting the item name of the text box dB1 and the item name input in the item name input box 56 are used as the label of the text box dB1. A label check box 57 for setting whether or not is displayed as an operation unit.

  Then, an item name is input to the item name input box 56 by operating the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C, and the label check box 57 is checked and operated. When a tick mark is entered at 57, the item name input in the item name input box 56 is displayed as the item name in the text box dB1 on the left side of the text box dB1 in the screen creation area 40.

  In addition to the item name input box 56 and the label check box 57, the input condition setting display area 43 includes a condition setting section for inputting necessary conditions in the text box dB1 created in the screen creation area 40. (Operation section) is also displayed.

  That is, in the input condition setting display area 43 in FIG. 14, a mandatory check box (input condition setting unit) 58 for setting whether or not to input characters and data to the data input unit and a data input unit are input. Unique check box (input condition setting unit) 59 for setting whether or not to allow duplicate registration of characters and data to be registered, and whether to use characters and data input to the data input unit for search An operation unit such as a search target check box (input condition setting unit) 60 to be displayed is displayed.

  Further, in the input condition setting display area 43, a display order input section (display order number input box, input condition setting section) 61 for setting the display order in the list, and a left alignment icon (input condition setting section for setting display alignment) ) 62, an operation unit such as a center alignment icon (input condition setting unit) 63, a right alignment icon (input condition setting unit) 64, and the like are displayed.

  The input condition setting display area 43 includes a help content input unit 65 for explaining contents to be input to the data input unit, an initial value input unit 66, a prefix input unit 67, and a suffix input unit 68. The number of input characters 69 of the data input unit, the X coordinate input unit 70 and the Y coordinate input unit 71 of the data input unit, and the item of the label created in the screen creation area 40 by being input to the item name input unit 60 The operation units such as the label X coordinate input unit 72 and the label Y coordinate input unit 73 of the name are displayed.

In FIG. 14, reference numerals attached to the input portion of the input condition setting display area 43 and the like will be described as necessary in other drawings.
(b-2). Display of selected content operation by another display / radio button creation control 44 in the input condition setting display area 43 In the screen creation area 40 using the radio button creation control 44 in the control icon bar 42 When a radio button is pasted as shown in FIG. 19, a selection content input unit 74 for selecting the content to be selected by the radio button is displayed in the input condition setting display area 43 as an operation unit.
Display of selected content operation by check button creation control 45 When a check box is pasted in the screen creation area 40 using the check button creation control 45 of the control icon bar 42 as shown in FIG. A selection content input unit 75 for selecting the content to be selected is displayed in the input condition setting display area 43 as an operation unit.
Display of operation of selected contents by combo box creation control 46 When combo box is pasted as data input part in screen creation area 40 using combo box creation control 46 in control icon bar 42 as shown in FIG. In this case, the content to be selected by the combo box is displayed as an operation unit in the selection content input unit 76 and the input condition setting display area 43.
Display of setting operation by the numerical value input box creation control 48 Further, the numerical value input box is pasted as a data input section in the screen creation area 40 by using the numerical value input box creation control 48 of the control icon bar 42 as shown in FIG. In the case of the input condition setting display area 43, the number-of-digits input setting unit 77 for setting the number of digits of the numerical value to be input to the numerical value input box and the check box 78 for setting whether or not the numerical value separator is displayed as a comma are displayed. Is displayed as an operation unit.
Display of setting operation by the date input box creation control 50 The date input box is pasted in the screen creation area 40 as a data input section as shown in FIG. 22 using the date input box creation control 50 of the control icon bar 42. In this case, the setting unit 79 for initial values of dates to be input to the date input box and the selection unit 80 for selecting and setting the date display style are displayed on the input condition setting display area 43 as operation units.
[Action]
Next, an example of database creation by the database creation management system having such a configuration and input and approval of the created database will be described.
(1). Creation of Database A user accesses the database Web server system 1 from the fixed terminals A and B, the mobile terminal C, etc. via the online line 2, the Internet 2 a and the connection communication device 3. This access is executed via the keyboard 4 of the fixed terminals A and B, the mouse 5 or the touch panel of the display device 11 of the mobile terminal C.

  With this access, the user authentication server 12 of the database Web server system 1 moves the customer authentication screen 20 of FIG. 4 to the fixed terminals A and B via the connection communication device 3 and the online line 2 or the Internet 2a. The data is transmitted to the terminal C and displayed on the display device 8 of the fixed terminals A and B and the display device 11 of the mobile terminal C. Hereinafter, when it is simply abbreviated as “display”, the user authentication server 12, the common management server 13, the customer area server 14, the system area server 15, etc. of the Web server system 1 are connected to the fixed terminals A and B, the mobile terminal C, etc. The display simply means display.

  In the customer authentication screen 20 of FIG. 4, a user (customer) ID input unit 21 and a PW (password) input unit 22 are displayed. In this state, the user inputs the customer ID into the ID input unit 21 and the customer password into the PW input unit 22 using the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. .

  In a state where the customer ID and the customer password are correctly input to the ID input unit 21 and the PW input unit 22 in the ID input unit 21, the user presses the login button 24 with the mouse 5 of the fixed terminals A and B, A selection operation is performed on the touch panel of the display device 11 of the mobile terminal C.

  By this operation, the control of the user authentication server 12 is switched to the control of the customer area server 14. When the control from the user authentication server 12 is switched, the customer area server 14 displays the selection screen 27 on which the WebDB use button 25 and the WebDB management button 26 shown in FIG. 5 are displayed on the display devices 8 of the fixed terminals A and B. Or displayed on the display device 11 of the mobile terminal C.

  Then, an arithmetic control circuit (control unit) (not shown) of the customer area server 14 selects and operates the WebDB management button 26 on the selection screen 27 by using the mouse 5 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. A WebDB (web database) management screen (list screen) 28 as shown in FIG. 6 for searching a recording area (not shown) of the customer area server 14 and selecting a database managed by the customer administrator is displayed on the fixed terminal A. , B and the display device 11 of the mobile terminal C are displayed.

  On this management screen 28, a DB management menu bar 28a and a selection list 28b are displayed. In addition, items such as “WebDB”, “system management”, “WebDB use”, and “logout” are displayed on the DB management menu bar 28a. Items such as screen title, owner (administrator), version, update date / time, screen content, type, disclosure (public / private), change, and deletion are displayed in the selection list 28b.

When the user selects and operates “WebDB” in the DB management menu bar 28a in FIG. 6 using the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C, the pull-down menu of “WebDB” displays Items such as “WebDB list”, “Create new form”, “Both-screen access control setting”, “Form template list” and the like as shown in FIG. 7 are displayed.

  Then, when creating a data input screen of a database, for example, a data input screen of “company-owned car master” as shown in FIG. 8, the mouse 5 of the fixed terminals A and B and the display device 11 of the mobile terminal C are used. On the touch panel shown in FIG. 7, “Create new form” in FIG. 7 is clicked and selected. In addition, in the database of “company car master” shown in FIG. 8, data input such as parking lot number, vehicle number, mission (transmission), equipment, start date of use, remarks, car name, address, display contents, etc. The item is set.

  When the “company car master” shown in FIG. 8 is created, the form information input screen 29 for creating a new form as shown in FIG. Display.

  The form information input screen 29 includes a new selection button 30 that is a radio button, a template use button 31 that is a radio button, a template selection box 32, a template selection button 33, a screen corresponding to the form creation method item. A title input box 34, a screen content input box 35, a category input box 36, a cancel button 37, a create button 38, and the like are displayed.

  The user selects and operates a template use button 31 that is a radio button by using the touch panel of the mouse 5 of the fixed terminals A and B or the display device 11 of the mobile terminal C, thereby creating a template of a template that has already been created. A list can be displayed, and a database template can be selected from this list and displayed in the template selection box 32.

  When the screen title input box 34, the screen content input box 35, the category input box 36, and the like are selected by touching the cursor (not shown) with the mouse 5 or the touch panel display device 11, the keyboards in the fixed terminals A and B are selected. 4 enables character input or the like to be performed in the screen title input box 34, the screen content input box 35, the category input box 36, and the like. This input can also be performed by touching a character button or the like displayed on the display device 11 on the mobile terminal C.

  Accordingly, the user moves to the screen title input box 34, the screen content input box 35, and the category input box 36 shown in FIG. 11 by using the touch panel of the display device 11 of the fixed terminal A and B or the mobile terminal C. The contents are input through the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. For example, as shown in FIG. 11, the title “company-owned car master” is input to the screen title input box 34, and the content of “company-owned car master” is displayed in the screen content input box 35. The screen content “is a master” is input, and a category “company car master” is input in the category input box 36. After this input, the creation button 38 on the screen of FIG. 11 is selected and operated.

By this selection operation, the database creation screen 39 shown in FIG. 12 is displayed by the customer area server 14 on the display devices 8 of the fixed terminals A and B and the display device 11 of the mobile terminal C. In this state, nothing is displayed in the screen creation area 40 or the input condition setting display area 43 of the database creation screen 39. From this state, when creating the parking lot number, vehicle number, mission, equipment, use start date, remarks, car name, address, display contents, etc. of “company-owned car master” shown in FIG. Will be described in order.
(Parking number)
When various icons in the control icon bar 42 are dragged and dropped into the screen creation area 40 by operating the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C, boxes and buttons corresponding to the icons are displayed in the customer area. Created in the screen creation area 40 by the server 14.

  Therefore, when creating the data input part for the item name related to the parking lot number, first, the text box creation control 45 of the control icon bar 42 is dragged and dropped into the screen creation area 40 as shown by the arrow A1 in FIG. As a result, a text box dB1 is created in the screen creation area 40.

  Along with this operation, the customer area server 14 displays the input condition setting display area 43 as shown in FIG. When the text box dB1 is created in the screen creation area 40 as a data input part, the item name input box 56 for inputting the item name of the text box dB1 and the item name input in the item name input box 56 are entered in the text box dB1. A label check box 57 for setting whether or not to use the label is displayed as an operation unit in the input condition setting display area 43. Hereinafter, display control to the input condition setting display area 43 is performed by the customer area server 14, but description of the customer area server 14 is omitted.

Then, by operating the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C, the item name is input to the item name input box 56, for example, “parking lot number”, and the label check box 57 is checked. When the tick mark is entered in the label check box 57 by operating, the item name “parking lot number” input in the item name input box 56 on the left side of the text box dB1 in the screen creation area 40 is used as the item name of the text box dB1. Is displayed.
(Other condition setting section)
In addition to the item name input box 56 and the label check box 57, the input condition setting display area 43 has other conditions for inputting necessary conditions in the text box dB1 created in the screen creation area 40. A setting unit (operation unit) is also displayed.

  In other words, in the input condition setting display area 43 in FIG. 14, a mandatory check box 58 for setting whether or not to make sure that characters and data are input to the data input portion overlaps with characters and data input to the data input portion. An operation unit such as a unique check box 59 for setting whether or not registration is prohibited and a search target check box 60 for setting whether or not to use characters or data input to the data input unit for search are displayed. Is done.

  Further, in the input condition setting display area 43, a display order input section (display order numeral input box) 61 for setting the display order in the list, a left-justified icon 62, a center-justified icon 63, and a right-justified icon 64 for setting display alignment. Etc. are displayed.

  The input condition setting display area 43 includes a help content input part (input condition setting part) 65 for explaining contents to be input to the data input part, an initial value input part (input condition setting part) 66, A prefix input unit (input condition setting unit) 67, a suffix input unit (input condition setting unit) 68, an input character number input unit (input condition setting unit) 69 of the data input unit, and an X coordinate input of the data input unit Label of the item name “parking lot number” of the label which is inputted to the part (input condition setting part) 70, the Y coordinate input part (input condition setting part) 71 and the item name input part 60 and created in the screen creation area 40 Operation units such as an X coordinate input unit (input condition setting unit) 72 and a label Y coordinate input unit (input condition setting unit) 73 are displayed.

In addition, other condition setting units for inputting necessary conditions (unique, arrangement, etc.) in the text box dB1 created in the screen creation area 40 are created by other boxes and buttons created in the screen creation area 40. In this case, the input condition setting display area 43 is used to set conditions such as (uniqueness, arrangement, etc.) of other boxes and buttons. Since the setting operation contents of the other condition setting units are performed in the same manner as in the case of the text box dB1, description of other condition setting units of other boxes and buttons is omitted in the following description.
(Vehicle number)
Next, the combo box creation control 46 of the control icon bar 42 is dragged and dropped to the screen creation area 40, and the region selection combo box dB2 is pasted to the screen creation area 40 as a data input section as shown in FIG. In this case, if the item name is input as “vehicle number_prefecture” in the item name input box 56 and a tick mark is put in the label check box 57, the region selection combo box dB2 on the left side of the screen creation area 40 is displayed. The item name “vehicle number_prefecture” input in the item name input box 56 is displayed as the item name of the region selection combo box dB2 as shown in FIG.

  The contents to be selected in the area selection combo box dB2 are displayed as an operation section in the input condition setting display area 43 by the selection contents input section 76. In this selection content input section 76, prefecture names such as “Kagawa, Ehime, Kochi...” Are input as a list of selection items. The name of the prefecture for selecting the area can be selected by operating the combo box dB2. If an incorrect box E is created in the screen creation area 40 as shown in FIG. 16, the box E can be deleted by dragging and dropping the box E to the trash can control 42a.

Also, as shown in FIG. 17, the numerical value input box creation control 48 is dragged and dropped to the right side of the region selection combo box dB2 to create a number input box dB21, and similarly shown in FIG. Thus, a number input box dB22 is created on the right side of the number input box dB21, and a number input box dB23 is created on the right side of the number input box dB21 as shown in FIG.
(Mission)
Next, as shown in FIG. 19, the radio button creation control 44 is dragged and dropped into the screen creation area 40, and radio buttons (RB1 in FIG. 19, RB1, RB2 in FIG. 20) are placed in the screen creation area 40. When created, an input condition setting display area 43 as shown in FIG. 19 is displayed. When the item name “mission” is input in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name of the radio button is “mission” on the left side of the radio button. "Is displayed.

  When a radio button is pasted into the screen creation area 40 using the radio button creation control 44 of the control icon bar 42 as shown in FIG. 19, the selection content input unit 74 for selecting the content to be selected with the radio button is input conditions. It is displayed in the setting display area 43 as an operation unit. In the selection content input section 74, as shown in FIG. 19, a list of selection contents AT (automatic car) and MT (manual car) to be selected by a radio button is set.

  Then, when the AT of the selection content input unit 74 is selected with the radio button created, the selection content “AT” is displayed to the right of the AT selection radio button RB1, as shown in FIG. The radio button becomes the AT selection radio button RB1.

  Further, the radio button creation control 44 is dragged and dropped to the screen creation area 40, and the radio button is pasted on the right side of the AT selection radio button RB1 as shown in FIG. Then, the radio button on the right side of the AT selection radio button RB1 becomes the MT selection radio button RB2. (Equipment) Next, as shown in FIG. 21, when the check button creation control 45 is dragged and dropped into the screen creation area 40 to create check boxes (ChB1, ChB2 in FIG. 22) in the screen creation area 40. An input condition setting display area 43 as shown in FIG. 21 is displayed. When an item name “equipment” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is entered in the label check box 57, the item name of the check box is “equipment” on the left side of the check box. "Is displayed.

Further, when a check box is pasted into the screen creation area 40 using the check button creation control 45 of the control icon bar 42 as shown in FIG. 21, a selection content input unit 75 for selecting a content to be selected with a radio button. Is displayed as an operation unit in the input condition setting display area 43. In this selection content input section 75, as shown in FIG. 21, a selection content to be selected by a check box is set as an ETC and navigation list. When the ETC of the selection content input unit 75 is selected with the check box created, the selection content “ETC” is displayed to the right of the check box, and the created check box becomes the ETC selection check box ChB1. . Next, when another check box is pasted on the right side of the ETC selection check box ChB1 and the navigation of the selection content input section 75 is selected, the check box on the right side of the ETC selection check box ChB1 is the check box for navigation selection. ChB2.
(Start date of use)
Further, when the date input box dB3 is pasted as a data input section as shown in FIG. 22 in the screen creation area 40 using the date entry box creation control 50 of the control icon bar 42, the input condition setting as shown in FIG. A display area 43 is displayed. When an item name “starting date of use” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is displayed on the left side of the date input box dB3. “Date of use start” and a calendar icon CL for date selection are displayed.

Accordingly, in the input condition setting display area 43, the initial value setting unit 79 for inputting the date in the date input box dB3 and the selecting unit 80 for selecting and setting the date display style are displayed in the input condition setting display area 43. Displayed as an operation unit.
(Remarks)
Next, by dragging and dropping the text box creation control 49 in the screen creation area 40, a long text input box is created in the screen creation area 40 as a remarks input box dB4. As shown in FIG. A condition setting display area 43 is displayed.

When the item name “remarks” is input in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is “remarks” on the left side of the remark input box dB4. Is displayed. (Car name)
Next, as shown in FIG. 25, when the text box creation control 45 of the control icon bar 42 is dragged and dropped onto the screen creation area 40 as shown by the arrow A2 in FIG. Created. Accordingly, an input condition setting display area 43 as shown in FIG. 25 is displayed.

  When an item name “car name” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is “car name” on the left side of the text box. And the text box becomes the car name input box dB5.

  Then, when the control batch setting button 55 in FIG. 26 is clicked, the item name, essential, unique, display order in the list, search target, display line, label as shown in FIG. 27 created in the “company car master” , Setting contents having items such as X coordinate, Y coordinate, and deletion are displayed, and the setting contents for the item names can be collectively confirmed. By operating the items of the setting contents, the setting contents can be changed. Thereafter, by clicking the apply button 81, the setting content is confirmed.

  In order to confirm the screen information of this “company car master”, the screen information setting button 54 for confirming screen information in FIG. 28 is clicked. As a result, the screen information shown in FIG. 29 is displayed. In this screen information, a screen title, screen content, category, application disclosure status, screen transition pattern, registration message, owner, form template, and the like are displayed. In this example, the screen title is “company-owned car master”, the screen content is “company-owned car master”, the category is “master”, the application disclosure status is “unpublished”, and the screen transition pattern is “registration> confirm> “Result display”, registration message, owner “manager 4”, and form template “template registration” are displayed. Setting a category makes it easier to search when the number of WebDBs increases. Further, as shown in FIG. 30, the transition pattern of the screen used by the user can be registered in the registration message. For example, if the number of inputs is large and there is no need to check each time, registration> result display is selected.

  In this content, if the application button 81 is clicked, the registration confirmation box 82 shown in FIG. 31 is displayed. If “Yes” is selected and clicked, the WebDB of the “owned car master” is displayed in the customer area. It is registered (recorded) in the server (data storage unit) 14. After this registration, click the WebDB on the DB management menu bar 28a, and click the WebDB list of WebDB to display a list of registered databases as shown in FIG. Since there is “company car master” in the database list of FIG. 32, it can be confirmed that “company car master” is registered. Since this registration is the first registration, it is Ver0.1. Note that the item “company car master” displayed in the screen title of the database list of FIG. 32 is also the master of the created database.

  Thereafter, when adding an item, for example, when adding an address or display content, drag and drop the URL input box creation control 51 to the screen creation area 40 as shown in FIG. 40, an address input box dB6 and a display content input box dB7 are created and registered.

By such an operation, it can be confirmed that Ver0.2 of “company car master” of the administrator 4 is created on the WebDB list screen as shown in FIG.
(2). Data input to “company-owned car master” When using this “company-owned car master”, click “WebDB use” in the DB management menu bar 28a to display the WebDB list screen shown in FIG. Click “Car Master” to select it. By this selection operation, the screen for inputting “company car master” as the screen title of FIG. 23 is displayed. Since it is a screen for inputting data for the first time in FIG. 263, nothing is registered. On this screen, the add button is clicked to display the data input screen of FIG.

In this data input screen, the keyboard 4 and the touch panel of the display device 11 are provided in the data input section such as each item name “parking lot number, vehicle number, mission, equipment, start date of use, remarks, car name, address, display contents”. After data entry is performed by using the WebDB data registration, the confirmation screen for data entered in the “company car master” shown in FIG. 38 is displayed. After confirming the input data on this confirmation screen, clicking the registration button completes the data input and registration to the “company car master”.
(3). Database creation of “company-owned car use management” using “company-owned car master” When using the data of “company-owned car master” created as described above in another database, for example, “company-owned car master” When creating a database whose screen title shown in FIG. 9 linked to is “company car management”, click WebDB on the DB management menu bar 28a in the same way as when creating a new form. Select and click Create new form from the pull-down menu of WebDB No.7. By this selection, the form information input screen 29 shown in FIG. 10 is displayed, and for example, “company car use management” is input to the screen title of this new form information input screen 29 as shown in FIG. Click Create to display the database creation screen 39 of FIG.

  On this database creation screen 39, the automatic number box creation control 54 of the control icon bar 42 is dragged and dropped into the screen creation area 40, and the registration number automatic creation box 83 is created in the screen creation area 40. It should be noted that the registration number automatic creation box 83 is automatically registered in the screen creation area 40 in the order in which the numerical values of the data numbers to be registered in the “company car use management” database are numbered.

  When the item name “automatic number 1” is entered in the item name input box 56 of the input condition setting display area 43 of the database creation screen 39, the registration number automatic creation box 83 of the screen creation area 40 as shown in FIG. "Auto number 1" is displayed in the box.

  Also, as shown in FIG. 41, when the item name “management number” is entered in the item name input box 56 and the label check box 57 is checked, the registration number automatic creation box 83 in the screen creation area 40 is displayed. The item name of the item name input box 56 “management number” is displayed.

  Next, as shown in FIG. 42, the master link box creation control 52 is dragged and dropped to the screen creation area 40 to create the linkage box 84 in the screen creation area 40 below the registration number automatic creation box 83. To do.

  When the item name of the link box 84 is set to “link source form” and the button for selecting the link box 84 is clicked, a selection list 84a shown in FIG. 43 is displayed. This selection list 84a is for setting which screen form information is linked as a master, and displays a master that has been created and registered in advance. As a function of the system, a master can be prepared in advance from the beginning and displayed in the selection list 84a. For example, a user master, affiliation master, post master, etc., which are described as this master, are prepared and selected. It can also be displayed in the list 84a. In FIG. 43, the registration number automatic creation box 83 of FIG. 42 is omitted for convenience of illustration.

  From this selection list 84a, the “company car master” which is the link source form is selected and input into the link box 84, and the link source form of “company car use management” is set to “company car master”. .

  Similarly, linkage boxes 85, 86, and 87 for setting contents related to the master selected in the linkage box 84 of the linkage source form are created in the screen creation area 40.

  Then, the item name of the link box 85 is set in the link key selection image, and the selection is made from the selection list 85a in the link box 85 and the parking lot number-vehicle name is input. The selection list 85a uses a unique item as a key, and selects the display method.

  Further, the item name of the linkage box 86 is set to the display format, and the key: label is input by selecting from the selection list 86a in the linkage box 86. The selection list 86a is used to set whether a key (display method specified by the linked key selection image) is a label, a key label, or a key when displayed on the screen.

  Further, the item name of the linkage box 87 is set as a label, and the vehicle name is selected and input from the selection list 87 a in the linkage box 87. In this selection list 87a, item names of company-owned vehicle masters are displayed. This setting is only an example, and the present invention is not limited to this.

  After the link setting is performed in this way, the link setting of the “company car use management” database is completed by clicking the apply button. Furthermore, additional settings can be made by dragging and dropping the master linkage box creation control 53.

In addition, the necessary items are created in the same way as the creation of “company-owned car master” in “company-owned car use management” linked to “company-owned car master” (detailed explanation is omitted). As a result, a database whose screen title shown in FIG. 9 is “company car use management” is created.
(4). Public use of database If the database such as “company-owned car master” and “company-owned car use management” created as described above is set to “public”, “company-owned” as shown in FIG. The items of the screen titles of “Car Master” and “Company Car Use Management” are displayed. By selecting the database of the “Company Car Master” and “Company Car Use Management” items, the database of the selected item is displayed. An input screen can be displayed to input data.
(5). Database access management 1
On the WebDB (web database) management screen (list screen) 28 of FIG. 6 described above, a DB management menu bar 28a and a selection list 28b are displayed. In addition, items such as “WebDB”, “system management”, “WebDB use”, and “logout” are displayed on the DB management menu bar 28a. Items such as screen title, owner (administrator), version, update date / time, screen content, type, disclosure (public / private), change, and deletion are displayed in the selection list 28b.

  When “system management” in FIG. 6 is selected by clicking with the mouse or touch operation in the case of a touch panel, items such as “user list”, “new user registration”, “group maintenance”, “system operation setting” are displayed. Is done. Further, when “WebDB” in the DB management menu bar 28a of FIG. 6 is selected, “WebDB list”, “Create new form”, “Screen access control” as shown in FIG. Items such as “Setting” and “Form template list” are displayed.

  When this “screen access control setting” is selected by a click operation with a mouse or a touch operation in the case of a touch panel, a database access management screen 28c as shown in FIG. 45 is displayed. An access management screen 28c selection bar BS is provided at the upper edge of the access management screen 28c. By opening the access management screen 28c, it is possible to display a WebDB list and access control setting status.

  The selection bar BS of the access management screen 28c is provided with an item “screen / group” s-1 and a “setting change unit” s-2. The access management screen 28c simultaneously displays a list of a plurality of databases created below the item “screen / group” s-1. In this database list, the name of the database group and the name of the database are displayed together with the folder icon.

  In addition, the “setting change unit” s-2 includes a database list authority management unit M1 and a group management unit GM. This authority management unit M1 has setting change items such as “inquiry”, “change”, “add”, and “delete”. Further, the group management unit GM has setting change items of “group deletion” and “group addition”.

  Here, FIG. 45 shows a plurality of databases created by the above-described database creation management system such as “company-owned car use management” and “company-owned car master” for the user access restriction to the database. As described above, it is possible to display a list of access restriction statuses on one screen and to perform centralized management such as addition / change of access restrictions.

  In FIG. 45, for example, when the folder of “Safety Confirmation Ledger” is opened, “Affiliation: Information System Headquarters”, “Affiliation: Information System Headquarters> System Development Department> System Development Third Team as a database of the contents of“ Safety Confirmation Ledger ” ", Affiliation: Culture Department> Photo Department", etc. are displayed under "Safety Confirmation Ledger".

  If you open the folder of the group name of each database and display the list of database names included in the group name, "Inquiry", "Change", "Add", A check box corresponding to a setting change item such as “delete” is displayed. In the “safety confirmation ledger” of the group database of FIG. 45, “affiliation: information system headquarters”, “affiliation: information system headquarters> system development department> system development third team”, “ Check boxes ch1b to ch4b are displayed on the right side of the database name such as “Affiliation: Culture Department> Photograph Department”.

  In this case, since the check box ch1b of “Affiliation: Information System Headquarters” is checked, all users belonging to “Information System Headquarters” and below can inquire (view) “Safety Confirmation Ledger”. Since the boxes ch2b to ch4b are not checked, data cannot be added, changed or deleted.

  In “Information System Headquarters> System Development Department> System Development 3rd Team”, check boxes ch2b to ch4b are checked, so only users belonging to “System Development 3rd Team” or lower can check “Safety Confirmation Ledger”. Can be added / changed / deleted.

In addition, when belonging to multiple groups among the set groups, access authority is set by logical sum for each authority (inquiry, change, addition, deletion) (inquiry authority is set) If you belong to any group, you have the query authority for WebDB).
(6). Database access control 2
By using the configuration from FIG. 46 onward, it is possible to manage access rights different from the above-described database access management 1 of (5).
(Administrator access rights)
Click the WebDB management button 26 in FIG. 5 to select a form template from the new form creation or form template list in FIG. 7, or select a database to be changed from the list of databases currently being created or created. The database creation screen (management software creation image) 39 shown is displayed. In the control icon bar 42 of FIG. 12, the above-described extended function icon 100 of FIG. 46 is not incorporated. However, in the following description, it is assumed that the extended function icon 100 of FIG. 46 is incorporated as described above.

  When the workflow control 102 is clicked on the database creation screen (management software creation image) 39, the approval screen for the mail account application form shown in FIG. 46 can be displayed on the database creation screen. In the configuration subsequent to FIG. 46, the access conditions described in the workflow setting of FIG. 47 described above can be set, and the access right can be set on the access right setting screen of FIG. In the access authority setting screen of FIG. 49, the access authority can be simply set only by checking a plurality of access target check boxes 130. A plurality of access targets can be set individually or in combination with individuals, groups, positions, etc. In FIG. 49, “All Groups”, “User: 11000566: Seiji Komatsu”, “Affiliation: Kochi Branch> Corporate Sales Department”, and “Position: Section Manager” are listed as access targets in the workflow authority column. ing.

When the mail account application control 102a is clicked, the administrator's mail account application screen shown in FIG. 50 can be displayed. On the administrator's mail account application screen, all data can be displayed as shown in FIG.
(General user access rights)
On the other hand, in the case of a general user, by clicking the WebDB use button 25 in FIG. 5, it is possible to set so that only data related to the user is displayed as shown in FIG. In FIG. 51, since “Kimura Haruyuki” is a list of mail account applicants who have logged in, only data related to “Kimura Haruyuki” is listed.

  50 and 51, “inquiry” S, “change” M, and access conditions (authentication conditions) are displayed. In this “inquiry” S, a “inquiry” search mark 151 is set for all data. The data of “change” M is an approval screen corresponding to the access target and access conditions (primary, secondary, tertiary,...) Checked in the check box 130 in the access right setting screen of FIG. A display icon 152 is set. The approval screen display icon 152 is displayed and set only for data corresponding to the access target and access conditions set in FIG. That is, the data is displayed in the data that matches the access target and the access condition checked by the check box 130.

  When one of the search marks 151 is clicked, the display of the approval data corresponding to the clicked search mark 151 is displayed for reference only. 50 and 51, for example, when the approval screen display icon 152 for data in which the applicant is “Haruyuki Kimura” and the primary approver is “Haruyuki Kimura” is clicked, the mail shown in FIG. The account application approval screen is displayed.

On this screen, the approval status is displayed as the status. For example, “Waiting for primary approval”, “Waiting for second approval”, “Waiting for third approval”, etc. are displayed. In FIGS. 50 and 51, the applicant is “Hiroyuki Kimura” and the primary approver is “ In the data “Hiroyuki Kimura”, the status is “Waiting for secondary approval”, so “Waiting for secondary approval” is displayed in the status of the approval screen of the mail account application form in FIG. However, since the secondary approver is “Yamanaka pure blue”, the approval is performed when only the secondary approver “Yamanaka pure blue” clicks the approval button 133.
(Other)
In the embodiment described above, an example in which the database creation management system for database creation and input according to the present invention is applied to the web server system 1 using the Internet is shown, but it is not necessarily limited to the web server system 1 using the Internet. The database creation management system of this invention is not applied. For example, the database creation management system according to the present invention can be applied to a server system using an intranet. Further, the database creation management system according to the invention can be used for a stand-alone computer in addition to a server system using the Internet or an intranet.
<Supplementary explanation 1>
As described above, the database access fixed management system according to the embodiment of the present invention is a recording means in which data management software for displaying a plurality of access operation target access right setting screens (access right setting screen in FIG. 49) is recorded. (Common management server 13), display means (display device 8) for displaying the data management screen, operation means (keyboard 4) for performing data operation on the data management screen, and the operation means (keyboard 4) And an arithmetic control means (arithmetic control circuit of the common management server 13) for displaying the access right setting screen on the display means (display device 8) based on the above operation. In addition, the arithmetic control means (the arithmetic control circuit of the common management server 13) has the plurality of access operation objects (for example, in the vertical direction or the horizontal direction of the access right setting screen (access right setting screen in FIG. 49) (for example, Personal, group, job title, etc.) and display the access conditions (application, primary, secondary ... n-th order of access after completion) on the other of the vertical or horizontal direction on the access right setting screen. In addition, access is permitted to the corresponding positions of the plurality of access operation objects (for example, individuals, groups, positions, etc.) and access conditions (after completion, application, first order, second order, n order of access). Each of the check boxes 130 that can be displayed is displayed.

According to this configuration, when there are multiple administrators to the database to be constructed, it is possible to display at a glance the access rights to the database of multiple administrators. It is possible to easily manage the right setting. Moreover, it is possible to simply set access conditions for a plurality of access operation targets (for example, individuals, groups, positions, etc.) simply by checking the check box 130. Further, since the access right setting screen is composed of only the access operation target, the access condition, and the check box 130, the access right setting screen is not complicated and management is facilitated.
<Supplementary explanation 2>
Further, in the database access right setting management system according to the embodiment of the present invention, the data management software performs an approval operation on the plurality of access operation objects (for example, individuals, groups, positions, etc.) (FIG. 48). E-mail account application form approval screen), and the access condition on the access right setting screen (after completion, application, primary, secondary,... N-th order of access) is the access operation target (for example, , Individuals, groups, job titles, etc.) on the approval screen (email account application approval screen shown in FIG. 48) on the approval conditions (after completion, application, primary, secondary ... n-th order of access) It is supposed to be set.

According to this configuration, the workflow setting on the approval screen can be easily performed.
<Supplementary explanation 3>
Furthermore, in the database authentication right setting management system according to the embodiment of the present invention, the management software has a database creation screen 39 provided with a screen creation area 40 for creating an input screen and a control icon bar 42. In addition, the calculation control means (the calculation control circuit of the common management server 13) is a data input or setting box (103 to 106, 108, 109, 109a) for the approval screen (account application approval screen of FIG. 48). To 109e) is created in the screen creation area 40, and when the workflow icon (workflow control 102) provided in the control icon bar 42 is clicked, the approval screen (account application approval screen in FIG. 48) is displayed. The workflow setting screen 120 (workflow setting screen in FIG. 47) provided with the approval number input box 123 to be executed in the workflow is displayed, and the access conditions corresponding to the number of approvals input in the approval number input box 123 are displayed. Approval conditions (after completion, application, primary, secondary ... nth access Is set as a forward).

According to this configuration, the access condition can be easily set as the approval condition according to the approval screen to be created.
<Supplementary explanation 4>
In the database authentication right setting management system according to the embodiment of the present invention, the approval screen is a screen for a mail account application form.

According to this configuration, it is possible to easily set the approval condition for the created mail account application.
<Supplementary explanation 5>
Further, in the database access right setting management system according to the embodiment of the present invention, the plurality of access conditions are approval orders that are approved in the order of primary, secondary,.

According to this configuration, the access order of access rights can be set easily.
<Supplementary explanation 6>
In the database access right setting management system according to the embodiment of the present invention, the approval operation target is any one or combination of an individual, a job title, and a group.

According to this configuration, the access right can be easily set regardless of an individual, a title, or a group.
<Supplementary explanation 7>
In the database access right setting management system according to the embodiment of the present invention, the calculation control means (the calculation control circuit of the common management server 13) is data for the approval screen (email account application approval screen in FIG. 48). After input or setting boxes (103 to 106, 108, 109, 109a to 109e, etc.) are created in the screen creation area 40, the workflow icon (workflow control 102) provided in the control icon bar 42 is clicked. In response to the number of approvals input in the approval number input box 123 for the control name item set in the data input or setting box (103 to 106, 108, 109, 109a to 109e, etc.). Access rights that can be handled by each access condition To display a constant screen.

According to this configuration, data entry or setting boxes (103 to 106, 108, 109, 109a to 109e, etc.) for an approval screen (email account application approval screen in FIG. 48) are created in the screen creation area 40. Later, by simply clicking the workflow icon (workflow control 102), the control name item set in the data input or setting box (103 to 106, 108, 109, 109a to 109e, etc.) is displayed on the access right setting screen. Can be automatically generated and displayed.
<Supplementary explanation 8>
In the database access right setting management system according to the embodiment of the present invention, the arithmetic control means (the arithmetic control circuit of the common management server 13) associates the item of the control name on the access right setting screen with the access condition. The access right of “inquiry” and “change” can be set to the cell to be set.

  According to this configuration, the access condition for the control name item can be easily set to the access rights of “inquiry” and “change”.

4 ... Keyboard (operating means)
8. Display device (display means)
13 ... Common management server (recording means, calculation control means)
39 ... Database creation screen 40 ... Screen creation area 42 ... Control icon bar 102 ... Workflow control (workflow icon)
103 ... Setting box 104 ... Application setting box 105 ... Application target setting box 106 ... Affiliation setting box 108 ... Date input box 109 ... Target input box 109a ... Character input box 109b ... Character input box 109c ... Address input box 109d ... Address input box 109e ... Address input box 110 ... Input box 123 ... Approval number input box 120 ... Workflow setting screen 130 ··Checkbox

Therefore, the present invention provides a recording means for recording data management software for displaying an access right setting screen for a plurality of access operation objects, a display means for displaying the data management screen, and a data operation on the data management screen. A database access right setting management system comprising: an operating means to be executed; and an arithmetic control means for causing the display means to display an access right setting screen based on an operation of the operating means, wherein the arithmetic control means includes the access The plurality of access operation objects are displayed in one of the right direction and the horizontal direction of the right setting screen, the access condition is displayed in the other of the right and left directions of the access right setting screen, and the plurality of the access operation objects are displayed. And a check box that allows access to the corresponding location in the access condition. It characterized in that it was over to access right setting management systems.

On this screen, the approval status is displayed as the status. For example, “Waiting for primary approval”, “Waiting for second approval”, “Waiting for third approval”, etc. are displayed. In FIGS. 50 and 51, the applicant is “Hiroyuki Kimura” and the primary approver is “ In the data “Hiroyuki Kimura”, the status is “Waiting for secondary approval”, so “Waiting for secondary approval” is displayed in the status of the approval screen of the mail account application form in FIG. However, since the secondary approver is “Yamanaka pure blue”, the approval is performed when only the secondary approver “Yamanaka pure blue” clicks the approval button 133.
(Other)
In the embodiment described above, an example in which the database creation management system for database creation and input according to the present invention is applied to the web server system 1 using the Internet is shown, but it is not necessarily limited to the web server system 1 using the Internet. The database creation management system of this invention is not applied. For example, the database creation management system according to the present invention can be applied to a server system using an intranet. Further, the database creation management system according to the invention can be used for a stand-alone computer in addition to a server system using the Internet or an intranet.
<Supplementary explanation 1>
Database Access Ken設 constant management system embodiment of the invention described above, the data management software for displaying a plurality of access operation target access right setting screen (access right setting screen in FIG. 49) is recorded Recording means (common management server 13), display means for displaying the data management screen (display device 8), operation means for operating data on the data management screen (keyboard 4), and operation means (keyboard) Computation control means (arithmetic control circuit of the common management server 13) for displaying the access right setting screen on the display means (display device 8) based on the operation of 4). In addition, the arithmetic control means (the arithmetic control circuit of the common management server 13) has the plurality of access operation objects (for example, in the vertical direction or the horizontal direction of the access right setting screen (access right setting screen in FIG. 49) (for example, Personal, group, job title, etc.) and display the access conditions (application, primary, secondary ... n-th order of access after completion) on the other of the vertical or horizontal direction on the access right setting screen. In addition, access is permitted to the corresponding positions of the plurality of access operation objects (for example, individuals, groups, positions, etc.) and access conditions (after completion, application, first order, second order, n order of access). Each of the check boxes 130 that can be displayed is displayed.

According to this configuration, the workflow setting on the approval screen can be easily performed.
<Supplementary explanation 3>
Furthermore, in the database access right setting management system according to the embodiment of the present invention, the management software has a database creation screen 39 provided with a screen creation area 40 for creating an input screen and a control icon bar 42. In addition, the calculation control means (the calculation control circuit of the common management server 13) is a data input or setting box (103 to 106, 108, 109, 109a) for the approval screen (account application approval screen of FIG. 48). To 109e) is created in the screen creation area 40, and when the workflow icon (workflow control 102) provided in the control icon bar 42 is clicked, the approval screen (account application approval screen in FIG. 48) is displayed. The workflow setting screen 120 (workflow setting screen in FIG. 47) provided with the approval number input box 123 to be executed in the workflow is displayed, and the access conditions corresponding to the number of approvals input in the approval number input box 123 are displayed. Approval conditions (after completion, application, primary, secondary ... nth access Is set as a forward).

According to this configuration, the access condition can be easily set as the approval condition according to the approval screen to be created.
<Supplementary explanation 4>
In the database access setting management system according to the embodiment of the present invention, the approval screen is a screen for a mail account application form.

Therefore, the present invention includes a database creation screen, a data input screen created on the database creation screen, and an approval operation for an e-mail account application form for the creation of the data input screen and an input data input condition setting operation. And an operation control means for controlling the operation of the data management software, the data management software used to display the access right setting screen for a plurality of access operation objects to the approval screen. A data management server system; and a terminal operated by the access target and connected to the server system via an online line or the Internet, and the terminal displays the respective screens. and database accession comprising operating means for causing the operation of each of the screens A scan right setting management system, the operation control means, the vertical direction or the one in the transverse direction to display the plurality of access operation target, vertical or horizontal direction of the access right setting screen of the access right setting screen display other to display the number of items acknowledgment indicating approval order of the plurality of the access operation target and of the authorization number of indicating approval order item corresponding allow granting access to position the check boxes, respectively And a database access right setting management system that displays on the approval screen the access path checked by the check box, the approval route of the approval order, and the approval date for the mail account application .

Claims (8)

Recording means for recording data management software for displaying an access right setting screen for a plurality of access operation targets;
Display means for displaying the data management screen;
Operating means for performing data operations on the data management screen;
A database authentication right setting management system comprising: arithmetic control means for displaying an access right setting screen on the display means based on an operation of the operation means,
The arithmetic control means displays the plurality of access operation targets in one of the vertical direction and the horizontal direction of the access right setting screen and displays an access condition in the other of the vertical direction and the horizontal direction of the access right setting screen. A database authentication right setting management system, wherein check boxes that permit access are displayed at positions corresponding to the plurality of access operation objects and access conditions.   2. The database access right setting management system according to claim 1, wherein the data management software has an approval screen for performing an approval operation on the plurality of access operation targets, and an access condition of the access right setting screen is the plurality of access conditions. A database access right setting management system, wherein an approval condition on the approval screen is set for an access operation target. The database authentication right setting management system according to claim 2, wherein the management software has a database creation screen having a screen creation area for creating an input screen and a control icon bar,
The calculation control means, when a data input or setting box for the approval screen is created in the screen creation area and then a workflow icon provided in the control icon bar is clicked, A database authentication right that displays a workflow setting screen provided with an approval number input box to be executed, and sets the number of access conditions corresponding to the number of approvals input in the approval number input box as the approval condition Configuration management system.   4. The database authentication right setting management system according to claim 3, wherein the approval screen is a screen of a mail account application form.   The database access right setting management system according to any one of claims 1 to 4, wherein the plurality of access conditions are approval orders that are approved in the order of primary, secondary, .... Access right setting management system.   The database access right setting management system according to any one of claims 1 to 5, wherein the approval operation target is any one or combination of an individual, a job title, and a group.   4. The database access right setting management system according to claim 3, wherein the calculation control means is provided in the control icon bar after a data input or setting box for the approval screen is created in the screen creation area. When the workflow icon is clicked, the number of access conditions corresponding to the number of approvals entered in the approval number input box can be handled for the control name item set in the data input or setting box. A database access right setting management system characterized by displaying an access right setting screen.   8. The database access right setting management system according to claim 7, wherein the calculation control means sets an access right of “inquiry” and “change” to a cell corresponding to the item of the control name and the access condition on the access right setting screen. A database access right setting management system characterized in that it can be set.