Introduction

Account

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 PostgreSQL Tables

A Table is a basic necessity for most dynamic websites, applications, reports and queries. If you want to store, edit, retrieve or recombine data, chances are good that you will need one - or more Tables.  Younicycle.com does not impose specific limits on the number of Tables you may create within an Account.

A table consists of rows and columns. When you initially create a new Table, you begin by creating the Structure for that Table with Column(s) being the first (and required) building block.   Without at least 1 Column, you cannot store data within a database.  Simple as that.

  1. Each Table & each Column within that Table must be given a name.   Younicycle has established a basic set of rules:
  • Name each column using lower case, with no spaces or special characters.  Examples:
    • naming a column: People I Know  would be bad, as it includes Upper case and spaces
    • naming a column: peopleiknow would be ok, as would people_i_know.  How you name your column is your choice, but ideally it is short - and will make sense not only for you, but also for others that may use the table. p_known as an example.
    • each Column name within a Table must be unique.  You cannot have 2 columns named 'pets' - within the same Table.
    • It is usually a bad idea to create a Table, then add many columns that are extremely similar.  So if your Table is people, you probably should not create a separate column for andy ...jane ...abe...bill, etc.  You may be better off  to create 2 Columns: name_first and name_last.  Later, after your structure is complete - you would add these names in Rows - not Columns within your structure.  Think of a deep stack of paper instead of a long line of paper.  To get to paper piece # 3,258 - well, that would be a lot of walking.

Each column in a Table has a data type. The data type constrains the set of possible values that can be assigned to a column and assigns semantics to the data stored in the column so that it can be used for computations. For instance, a column declared to be of a numerical type will not accept arbitrary text strings (0.00 is not the same as 'zero point zero zero') and the data stored in such a column can be used for mathematical computations. By contrast, a column declared to be of a character string type will accept almost any kind of data but it does not lend itself to mathematical calculations, although other operations such as string concatenation are available.

The number of rows is variable — it reflects how much data is stored at a given moment. SQL does not automatically require that the information in rows be unique, so it is possible to have several completely identical rows in a table. This is a consequence of the mathematical model that underlies SQL but identical rows of data are usually not desirable.  You can control this and other 'automatic' behaviors when you create your Tables Structure.

Your first step is to Create a new Table

  • You may click the word Tables on the YTree, then click the button [New Table]. (easiest method)
  • Select Tools (top menu) Database Builder
  • Create a user application that launches the Editor
  • Click the Database Builder icon on your Internal Home Page

The Table Editor requires a recent version of the FlashPlayer to be installed on your local PC or Mac.  The Table Editor checks your license, even if it is a new Table.  If it is an existing Table - it will also load all the Table Structure information (Example below:
A Saved Table, being edited).  The Editor always opens to the first Tab (Columns)
Begin by clicking [New], which is located at the very bottom of the editor.  The image below has been vertically reduced.

When you click  [New] a popup will appear, giviing you options for selecting and designating properties for your column.

Field (Column) Properties include Name, Type, Length, Precision, Default, NotNull
and Description.  Required Properties depend
on the selected Column type.  The image (below right) shows that we named the Column: id and selected Autoincrement as the datatype.
Your possible Types include: Autoincrement, small int(eger), integer, bigint(eger),numeric, real, double precision, character varying, text, date, time, datetime, boolean and file.  In addition, any specific Composite types you have created will also be listed.

Continue reading for greater detail about each of the Tabs.

 

Example of a Saved Table, in Edit Structure Mode (vertically resized)