Database types - Factor Documentation (original) (raw)

Database types
High-level tuple/database integration

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