r5117 - trunk/gnue-common/doc/technotes

[johannes]

Author: johannes
Date: 2004-02-18 09:21:48 -0600 (Wed, 18 Feb 2004)
New Revision: 5117

Added:
   trunk/gnue-common/doc/technotes/00012.txt
Log:
Introduced a datatype spec for GSD files.


Added: trunk/gnue-common/doc/technotes/00012.txt
===================================================================
--- trunk/gnue-common/doc/technotes/00012.txt   2004-02-17 18:23:57 UTC (rev 
5116)
+++ trunk/gnue-common/doc/technotes/00012.txt   2004-02-18 15:21:48 UTC (rev 
5117)
@@ -0,0 +1,39 @@
+Title:   Valid datatypes for GNUe Schema Definitions (gsd)
+Status:  Current 
+Created: 2004-02-18
+Revised: 2004-02-18
+
+This technote describes the preferred datatypes for use in GNUe Schema
+Definitions (GSD).
+
+
+Datatype        Description
+--------        -----------
+string          Text
+                If no length is given, this datatype is meant to be without
+                a restriction in length. In most cases this would translate to
+                a SQL type like 'text'.
+
+date            Date
+                This datatype should be used to store only the datepart of a
+                date/time.
+
+time            Time
+                This datatype should be used to store only the timepart of a
+                date/time.
+
+datetime        Date plus time
+                Use this datatype if you need both, date and time part of a
+                date/time.
+
+number          Numeric data
+                Number is an alias for all kinds of numeric data. The datatype
+                finally used depends on the 'precision' and 'length' of the
+                field definition.
+                
+boolean         Boolean
+                Use this datatype to store boolean values.
+
+key             Key value type
+                This datatype is an alias for a database specific type, which
+                should be used for storing key values.