Database types
High-level tuple/database integration

Prev:Tuple database tutorial
Next:High-level tuple/database words


The db.types vocabulary maps Factor types to database types.

Primary and foreign keys:
+db-assigned-id+

+foreign-id+

+primary-key+

+user-assigned-id+

+random-id+


Null and boolean types:
NULL

BOOLEAN


Text types:
VARCHAR

TEXT


Number types:
INTEGER

BIG-INTEGER

SIGNED-BIG-INTEGER

UNSIGNED-BIG-INTEGER

DOUBLE

REAL


Calendar types:
DATE

DATETIME

TIME

TIMESTAMP


Factor byte-arrays:
BLOB


Arbitrary Factor objects:
FACTOR-BLOB


Factor URLs:
URL