RelationshipOneToOne

How to define a "Has One" reference between models

Please refer to here for general informations about models.

If you want to define a "has one" reference between models you have to use a Reference type field.

Example of Reference in HelloKitto

# Hair.yalm
ModelName: Hair
...
Fields:
  Hair_Id: String(32) not null primary key
    IsVisible: False
    DefaultValue: %COMPACT_GUID%
.....

# Girl.yalm
ModelName: Girl
Fields:
  Hair: Reference(Hair)
    PhysicalName: FK_GIRL_HAIR
    Fields:
      HairId:
        PhysicalName: HAIR_ID
...

Note that:

• Hair is the logical field name.
• the subnode PhysicalName (in this case FK_GIRL_HAIR) is the name of the constraint that Kitto will use as Alias to build join in Sql command text.
• the subnode Fields contains the field HairId that make up the key to the model Hair.

The subnode Fields must contain all fields that makes up the key to the other model. These fields only need names, as their data types and other properties are taken from the corresponding fields in the referenced model's primary key.

A reference field is rendered in user interface as a combo box:

in case of reference to a model with the option IsLarge: True setted the combo box will page as in the following example from Taskitto:

# Employee.yalm
ModelName: EMPLOYEE
IsLarge: True
Fields:
  EMPLOYEE_ID: String(32) not null primary key
    IsVisible: False
    DefaultValue: %COMPACT_GUID%

# Activity.yalm
ModelName: ACTIVITY
Fields:
....
  EMPLOYEE: Reference(EMPLOYEE) not null
    Fields:
      EMPLOYEE_ID:
        PhysicalName: EMPLOYEE_ID
....

If you prefer you can ask kitto to open an existing view instead of render a combo. Just set IsLookup: True in theview:

# view Employees 
Type: Data
IsLookup: True