No database without tables - the place to store you records consisting of the same field structure.
Selecting a table for modification or to create a new table, rename an existing one or drop a table completely, use the appropriate entries in the table popup menu. In order to export or import (= create) a table scheme, select the import or export scheme entries in the popup menu.
Once you have selected a table DocCleaner looks for the precise field details and lists them in the field list. You cann add new fields, remove a field or select a field to modify its definition.
Every field consists of a name and a type, some fields need a length too, i.e. variable char fields. You may add an extra default value automatically inserted for new records.
If you want the database to force any record to contain a real value, you may leave NULL unchecked - if a field is allowed to contain no values at all, check NULL. Of interest is the auto-increment feature where the database controls incresing values (esp. useful for internal unique id fields).
Finally - mainly for speed reasons - you may define a key (or simetimes called an index) to a field on one of three ways: no key at all, mul-tiple (for a key with multiple record having the same value) or a a pri-mary key (which the database forces to be unique in all records of a table).
Changes to a field are updated to the database only if needed, but you may force your cahnge with the apply button.
|