Category | Symbol | Description | Example |
---|
| - | creates an attribute | - |
type | - [ b | bool | boolean ] | creates an attribute of type boolean | - boolean alive |
type | - [ c | char | character ] | creates an attribute of type character | - character status |
type | - bit | creates an attribute of type bit | - bit state |
type | - [ i | int | integer ] | creates an attribute of type integer | - integer count |
type | - [ d | dec | decimal ] | creates an attribute of type decimal | - decimal cost |
type | - [ f | float ] | creates an attribute of type float | - float weight |
type | - [ r | real ] | creates an attribute of type real | - real weight |
type | - [ dt | date ] | creates an attribute of type date | - date birthday |
type | - [ t | time ] | creates an attribute of type time | - time start |
type | - [ ts | timestamp ] | creates an attribute of type timestamp | - timestamp created |
type | - [ s | str | string ] | creates an attribute of type varchar(n) where n is the max in a range | - string message 10..255 |
type | - ^ | creates a reference to another entity | - ^ color |
flag | + | flags an attribute as a primary key | - xs code + |
flag | min..max | indicates the acceptable range for validation and precision. required for strings, recommended for numerical | - d price 0.00..999.99 |
flag | [ * | ** | *** | and more ] | flags a attribute(s) as unique with matching star count | - b alive * |
flag | ! | flags a value as not nullable | - b alive ! |
flag | ? | flags a value as default null | - b alive ? |
append modifier | | delimiter | creates an alias for a reference | - ^ dragon|mother |
prefix modifier | _ prefix | gives the readonly attribute to an entity | - _birthday ! |
flag | everything else | sets the default value for an attribute | - b alive false |