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.
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.
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)