Caravan Business Server>Help>Database>Viewing Table Structure |
Text
|
When the table structure for a table in the database is created, it is displayed as a link in the Caravan Database Manager screen.
Note All fields beginning with an underscore are system generated fields.
|
Figure 1
|
Click on the table link, to view the table structure. The detailsof the field structure-field name, type, dimension, flags, default value are displayed. You can delete or modify these fields. You can also add fields.
|
Figure 2
|
Editing Tables
Select a field and click on Delete Field to delete the selected field.
Click on Add Field to add a field.
Click on the Backup button to create a backup of the selected table. The backup table has the same name as the original tablebut is prefixed by an underscore (_). Example: File custbal will be backed up as _custbal. Modifying a field When you select a field and click on the Modify Field button, the field structure for the selected field is displayed. Say, for Telephone, Type = String, Size = 64,Dimension = 1. You can modify the details and click on Modify to modify the field.
|
Figure 3
|
Adding a field Click on Add Field in the selected table to add a field to the table. Enter the new field structure details in the screen displayed. Click on Add to add the field.
|
Figure 4
|
Deleting a field Select a field and click on Delete Field to delete the selected field. Backup a Table Click on the Backup button to create a backup of the selected table. The backup table has the same name as the original table but is prefixed by an underscore ( _ ).Example: File firsttable is backed up as _firsttable. Set Maximum Records Sometimes you may want to keep the number of records to be stored in a table to be fixed. In that case you can set the number of fields to say "5000" and click on the Set button. The number of records can be increased later, but once set, you cannot decrease the number.
|
Figure 5
|
Send Data Sometimes you may want to replicate the entiretable to a Caravan application running in another location connected through your network. A classic example would be to replicate the master tables like products, vendor information, etc to a newly opened branch instead of re-entering the entire data. This feature can also be used to take backup of the entire table to the backup Caravan Server. Enter the IP address and the port number of the Caravan Server to which you want the data to be replicated and click on Send.
|
Figure 6
|
View Data Click on Click to View/Edit Contents of table name to view each record. A screen displaying the field details is displayed. Click on the Next, Previous, Goto options to move through the records. Click on Modify, Delete to modify or delete the record. Click on New to add a new record
|
Figure 7
|
|
Figure 8
|
|
Back
|