Creating a database

To create a database,

1. Click the Create button. The Create Database dialog will appear. The meanings of the fields are:

   DB

   The database name.

   Description

   A brief explanation for the database.

   Tables

   If you choose yes, the Patient, Macro and Micro tables will be created when creating the database. If you choose no, they will not. Choose yes if you are going to create a database for inserting data by your hand. To restore the database with the volume dump or import the exported data, you should select yes. On the contrary, choose no if you are going to create a database for the database dump because the dump file contains the table definitions. Refer to Section 6.4 ( page) for restoring databases.

   Encryption

   If you choose bf or aes, the data in the First_Name, Last_Name and ID columns will be encrypted. bf and aes mean Blowfish and AES, respectively.

   Caution : tkDerm doesn't support encryption of multi-byte characters such as Japanese Kana and Kanji.

   Body_Diagram

   You can choose the body diagram on the distribution dialog. eruption32 is for skin diseases in general, while decubitus32 is for decubitus. You can draw the diagram by yourself with the distribution editor, which is explained in Chapter 11 ( page).

   PNG

   Choose yes if you are going to create a database to which tkDerm touch running on the iPad connects. If you choose yes, choosing yes as Tables, bf or aes as Encryption and eruption32 as Body_Diagram is required. In addition, you must already set up the server software suite as described in tkDerm touch Documentation, which you can get via the tkDerm touch support page (http://tkderm.sourceforge.net/touch.html).

2. After completing the fields, click the Add button.
3. You will be prompted for the postgres password. Please give it.

   Hint : If you turn the "Crypto.Function" option on in the "Enable contrib modules" dialog during the installation of PostgreSQL on Windows, you will not be prompted for the postgres password at this step.

4. You will be asked to type an encryption key if you selected bf or aes in the Encryption field. Be sure to remember the key as it will be required whenever you are going to connect to the database.

   Caution : You cannot decrypt the data if you forget the encryption key.

   Hint : You can encrypt a database without encryption later by clicking the Encrypt/Decrypt button. Conversely, you can decrypt an encrypted database by clicking the same button. To know more about this topic, see Section 6.7 ( page).

5. If the database is created successfully, you will be connected to it automatically.