SqfEntityFieldRelationship class
Constructors
-
SqfEntityFieldRelationship({SqfEntityTable? parentTable, DeleteRule? deleteRule, String? fieldName, bool? isPrimaryKeyField, dynamic defaultValue, dynamic minValue, dynamic maxValue, String? formLabelText, String? formDropDownTextField, RelationType? relationType, String? manyToManyTableName, bool? isNotNull, bool? isUnique, bool? isIndex, int? isIndexGroup, String? checkCondition, Collate? collate})
-
Create a field which has a relation with another table.
So you can see all related children rows or a parent row
Simple virtual field definition must be below:
const
Properties
-
checkCondition
→ String?
-
Use SQLite CHECH Constraint. if the condition phrase is:
CHECK (length(phone) >= 10)
chechCondition string must be:
checkCondition = 'length(phone) >= 10'
for more information: https://www.sqlitetutorial.net/sqlite-check-constraint/
final
-
collate
→ Collate?
-
final
-
dbType
→ DbType?
-
Set type of field
no setteroverride
-
defaultValue
→ dynamic
-
set a default value before the save action if it is past null
final
-
deleteRule
→ DeleteRule?
-
Set a delete rule to avoid damaging the rows related to each other
final
-
fieldName
→ String?
-
Table column name that will be created
final
-
formDropDownTextField
→ String?
-
Specify a field to use in DropDown control as a Text field. Value field is set automatically as a primary key field
final
-
formLabelText
→ String?
-
final
-
hashCode
→ int
-
The hash code for this object.
no setterinherited
-
isIndex
→ bool?
-
Set as a INDEX field
final
-
isIndexGroup
→ int?
-
Set an indexed field as a group index to set indexes more than one and grouped.
If you want to search people by FirstName & LastName, it is better to set these fields' property isIndex:true and isIndexGroup:1
final
-
isNotNull
→ bool?
-
if true, you can't pass null
final
-
isPrimaryKeyField
→ bool?
-
Set field as a primary key. You can set more than one fields as a primary key field
final
-
isUnique
→ bool?
-
if true, each value must be unique
final
-
manyToManyTableName
→ String?
-
you are able to set the table name of created that MANY-TO-MANY Relationship needs
final
-
maxValue
→ dynamic
-
set maximum value both SQLite rule & form input limit
final
-
minValue
→ dynamic
-
set minimum value both SQLite rule & form input limit
final
-
parentTable
→ SqfEntityTable?
-
Specify a table which you want to relate to
final
-
relationType
→ RelationType?
-
Set a relation type between the tables which are related to each other
final
-
runtimeType
→ Type
-
A representation of the runtime type of the object.
no setterinherited
-
sequencedBy
→ SqfEntitySequence?
-
Set a sequence to increase value of the field automatically according to the assigned sequence
no setteroverride
Methods
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
toString()
→ String
-
A string representation of this object.
inherited
