Interface NCSqlJoin


  • public interface NCSqlJoin
    Object presentation of SQL join (foreign key).

    In JSON/YAML generated model SQL joins are declared with the following data model metadata (example):

       sql:joins:
       - fromtable: "orders"
         fromcolumns:
         - "customer_id"
         totable: "customers"
         tocolumns:
         - "customer_id"
         jointype: "left"
     
    See Also:
    NCSqlSchemaBuilder.makeSchema(NCModel), NCSqlSchema.getJoins()
    • Method Detail

      • getFromTable

        String getFromTable()
        Gets the name of the originating table.
        Returns:
        Name of the originating table.
      • getToTable

        String getToTable()
        Gets the name of the target table.
        Returns:
        Name of the target table.
      • getFromColumns

        List<String> getFromColumns()
        Gets the list of columns in originating table.
        Returns:
        List of columns in originating table.
      • getToColumns

        List<String> getToColumns()
        Gets the list of columns in target table.
        Returns:
        List of columns in target table.
      • getType

        NCSqlJoinType getType()
        Gets type of the join.
        Returns:
        Type of join.