Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System Manage fields

The first tab - Columns allows you to Add (New), Edit, or Delete (Drop) Columns.The Button 'New'  opens a dialog box for the Column attributes input.  The Button [Edit]  opens a dialog box for editing field properties.
Also, this dialog can be accessed by double-clicking a field in the list. 

Note the image below does not have any columns yet.

Name — Name of the column. The name of the column must be unique for this Table. You cannot create a table with two fields named the same. The name of the field must be in lower case Latin alphabet only. Only underscore is accepted as an additional symbol  ( _ ). 
— The type of data saved in the field. For example, NUMERIC type is appropriate for salary data.
— Controls the length of the line for CHARACTER VARYING type fields or the number of decimal places in NUMERIC type fields.
— Number of digits after the decimal separator for NUMERIC type fields.
— Sets a default value for data if no data is entered.  Similar to 'autoentering a value'.
Not Null
— Prohibits nulls.
— A description of the column. A line of text that does not affect the performance of the database and is there for the convenience of a user.

The Button [Drop] — Deletes a Column from the table.  Ideally, you should decide on your Table Structure and column datatypes before inserting too much data.

Delete a column from a table and the data in this column is deleted and cannot be recovered.


Hint: It's a good idea is to create a sample Table with one column assigned to each datatype.  Enter data and view your results.

A few generalizations - that are often true:

  • Allowing Null values in a Table can lead to unexpected Query results and be a general nuisance. 
  • Use Numeric for money
  • Use Character varying or Text if any non-numeric charcters are to be entered.  Example is a phone number formatted as '555-1212'.  As displayed, it is not truly, a number.
  • Write a good description.  Other users may need it - and if you forget, you'll have a reminder of what it means.
  • Avoid extremely long Names
Note that we use the words 'Column' and 'Field' interchangeably.  'Column' is more correct - but 'Field' may be more recognizeable by users of Applications such as Filemaker™, etc.
Edit fields