Loading color scheme

Data Types - FEKL

The Data Types in FEKL are based on the Data Types available for Value Types in the Boston conceptual modelling software.

NB Value Types in Object-Role Modeling software require Data Types such that the corresponding Column/Attribute/Property/Field within the respective Entity-Relationship Diagram and Property Graph Schema have a Data Type that is commensurate with the Data Type of the corresponding Column/Attribute/Property/Field within any underlying/connected database.

NB Some Data Types require either a Length or a Precision to be specified.

E.g. Data Type with Length

        
E.g. Data Type with Precision

        

The following are a list of Data Types in Boston.

LogicalTrueFalse
LogicalYesNo
AutoCounter
Decimal
FloatCustomPrecision
FloatDoublePrecision
FloatSinglePrecistion
Money
SignedBigInteger
SignedInteger
SignedSmallInteger
UnsignedBigInteger
UnsignedInteger
UnsignedSmallInteger
UnsignedTinyInteger
ObjectID
RowID
RawDataFixedLength
RawDataLargeLength
RawDataOLEObject
RawDataPicture
VariableLength
AutoTimestamp
Date
DateTime
Time
StringFixedLength  (NB Converted to TextFixedLength in Boston)
StringLargeLength  (NB Converted to TextLargeLength in Boston)
StringVariableLength  (NB Converted to TextVariableLength in Boston)
TextFixedLength
TextLargeLength
TextVariableLength

Data Types with Length

Data Types with Precision

Railway Diagram | EBNF