Supported Types
OrientDB supports several types natively. Below is the complete table.
#id | Type | Description | Java type | Minimum Maximum |
Auto-conversion from/to |
---|---|---|---|---|---|
0 | Boolean | Handles only the values True or False | java.lang.Boolean or boolean |
0 1 |
String |
1 | Integer | 32-bit signed Integers | java.lang.Integer or int |
-2,147,483,648 +2,147,483,647 |
Any Number, String |
2 | Short | Small 16-bit signed integers | java.lang.Short or short |
-32,768 32,767 |
Any Number, String |
3 | Long | Big 64-bit signed integers | java.lang.Long or long |
-263 +263-1 |
Any Number, String |
4 | Float | Decimal numbers | java.lang.Float or float |
2-149 (2-2-23)*2127 |
Any Number, String |
5 | Double | Decimal numbers with high precision | java.lang.Double or double |
2-1074 (2-2-52)*21023 |
Any Number, String |
6 | Datetime | Any date with the precision up to milliseconds. To know more about it, look at Managing Dates | java.util.Date |
- 1002020303 |
Date, Long, String |
7 | String | Any string as alphanumeric sequence of chars | java.lang.String |
- - |
- |
8 | Binary | Can contain any value as byte array | byte[] |
0 2,147,483,647 |
String |
9 | Embedded | The Record is contained inside the owner. The contained Record has no Record ID | ORecord |
- - |
ORecord |
10 | Embedded list | The Records are contained inside the owner. The contained records have no Record ID's and are reachable only by navigating the owner record | List<Object> |
0 41,000,000 items |
String |
11 | Embedded set | The Records are contained inside the owner. The contained Records have no Record ID and are reachable only by navigating the owner record | Set<Object> |
0 41,000,000 items |
String |
12 | Embedded map | The Records are contained inside the owner as values of the entries, while the keys can only be Strings. The contained ords e no Record IDs and are reachable only by navigating the owner Record | Map<String, ORecord> |
0 41,000,000 items |
Collection<? extends ORecord<?>> , String |
13 | Link | Link to another Record. It's a common one-to-one relationship | ORID , <? extends ORecord> |
1:-1 32767:2^63-1 |
String |
14 | Link list | Links to other Records. It's a common one-to-many relationship where only the Record IDs are stored | List<? extends ORecord |
0 41,000,000 items |
String |
15 | Link set | Links to other Records. It's a common one-to-many relationship | Set<? extends ORecord> |
0 41,000,000 items |
Collection<? extends ORecord> , String |
16 | Link map | Links to other Records as value of the entries, while keys can only be Strings. It's a common One-to-Many Relationship. Only the Record IDs are stored | Map<String, ? extends Record> |
0 41,000,000 items |
String |
17 | Byte | Single byte. Useful to store small 8-bit signed integers | java.lang.Byte or byte |
-128 +127 |
Any Number, String |
18 | Transient | Any value not stored on database | |||
19 | Date | Any date as year, month and day. To know more about it, look at Managing Dates | java.util.Date |
- |
Date, Long, String |
20 | Custom | used to store a custom type providing the marshall and unmarshall methods | OSerializableStream |
0 X |
- |
21 | Decimal | Decimal numbers without rounding | java.math.BigDecimal |
? ? |
Any Number, String |
22 | LinkBag | List of Record IDs as spec RidBag | ORidBag |
? ? |
- |
23 | Any | Not determinated type, used to specify Collections of mixed type, and null | - | - | - |