Example: tables_with_primary_key

./examples/tables_with_primary_key.json

Source Code: ./examples/tables_with_primary_key.json

{
  "csnInteropEffective": "1.0",
  "$version": "2.0",
  "meta": {
    "document": {
      "version": "1.2.3"
    },
    "features": {
      "complete": true
    }
  },
  "definitions": {
    "Airline": {
      "kind": "entity",
      "elements": {
        "AirlineID": {
          "key": true,
          "type": "cds.String",
          "length": 3
        },
        "Name": {
          "type": "cds.String",
          "length": 40
        },
        "AirlinePicURL": {
          "type": "cds.String",
          "length": 1000
        }
      }
    },
    "Airport": {
      "kind": "entity",
      "elements": {
        "AirportID": {
          "key": true,
          "type": "cds.String",
          "length": 3
        },
        "Name": {
          "type": "cds.String",
          "length": 40
        },
        "City": {
          "type": "cds.String",
          "length": 40
        },
        "CountryCode_code": {
          "type": "cds.String",
          "length": 3
        }
      }
    },
    "Countries": {
      "kind": "entity",
      "elements": {
        "code": {
          "key": true,
          "type": "cds.String",
          "length": 3
        }
      }
    },
    "Countries_texts": {
      "kind": "entity",
      "elements": {
        "code": {
          "key": true,
          "type": "cds.String",
          "length": 3
        },
        "locale": {
          "key": true,
          "type": "cds.String",
          "length": 14
        },
        "name": {
          "type": "cds.String",
          "length": 255
        },
        "descr": {
          "type": "cds.String",
          "length": 1000
        }
      }
    },
    "FlightConnection": {
      "kind": "entity",
      "elements": {
        "AirlineID": {
          "key": true,
          "type": "cds.String",
          "length": 3
        },
        "ConnectionID": {
          "key": true,
          "type": "cds.String",
          "length": 4
        },
        "DepartureAirport_AirportID": {
          "type": "cds.String",
          "length": 3
        },
        "DestinationAirport_AirportID": {
          "type": "cds.String",
          "length": 3
        },
        "DepartureTime": {
          "type": "cds.Time"
        },
        "ArrivalTime": {
          "type": "cds.Time"
        },
        "Distance": {
          "type": "cds.Integer"
        },
        "DistanceUnit": {
          "type": "cds.String",
          "length": 3
        }
      }
    },
    "Flight": {
      "kind": "entity",
      "elements": {
        "AirlineID": {
          "key": true,
          "type": "cds.String",
          "length": 3
        },
        "FlightDate": {
          "key": true,
          "type": "cds.Date"
        },
        "ConnectionID": {
          "key": true,
          "type": "cds.String",
          "length": 4
        },
        "Price": {
          "type": "cds.Decimal",
          "precision": 16,
          "scale": 3
        },
        "CurrencyCode_code": {
          "type": "cds.String",
          "length": 3
        },
        "PlaneType": {
          "type": "cds.String",
          "length": 10
        },
        "MaximumSeats": {
          "type": "cds.Integer"
        },
        "OccupiedSeats": {
          "type": "cds.Integer"
        }
      }
    }
  }
}