π OData Feedο
Main OData Feed
Diagramο
OData Schema generated by XOData serviceο
XML Schemaο
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="1.0"
xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
<edmx:DataServices m:DataServiceVersion="1.0" m:MaxDataServiceVersion="3.0"
xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<Schema Namespace="BrsProjectsModel"
xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
<EntityType Name="Projects">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="ts" Type="Edm.Int32" />
<Property Name="name" Type="Edm.String" MaxLength="300" FixedLength="false" Unicode="true" />
<Property Name="nameshort" Type="Edm.String" MaxLength="300" FixedLength="false" Unicode="true" />
<Property Name="datestart" Type="Edm.DateTime" Precision="3" />
<Property Name="dateend" Type="Edm.DateTime" Precision="3" />
<Property Name="statusId" Type="Edm.Int32" />
<Property Name="statusName" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="budget" Type="Edm.Decimal" Precision="19" Scale="4" />
<Property Name="isUmbrella" Type="Edm.Boolean" />
<Property Name="umbrellaId" Type="Edm.Guid" />
<Property Name="umbrellaName" Type="Edm.String" MaxLength="300" FixedLength="false" Unicode="true" />
<Property Name="umbrellaNameShort" Type="Edm.String" MaxLength="300" FixedLength="false" Unicode="true" />
<Property Name="managingOrgId" Type="Edm.Guid" />
<Property Name="managingOrgName" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="isGlobal" Type="Edm.Boolean" />
<Property Name="description" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="objectives" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="activities" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="webpage" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="imagesurl" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="brs_docsfeedfilter" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="updated" Type="Edm.DateTime" Precision="3" />
<NavigationProperty Name="Agreements" Relationship="BrsProjectsModel.assPrjAgr" ToRole="ProjectsAgreements" FromRole="Projects" />
<NavigationProperty Name="Beneficiaries" Relationship="BrsProjectsModel.assPrjBenef" ToRole="ProjectsBeneficiaries" FromRole="Projects" />
<NavigationProperty Name="Donors" Relationship="BrsProjectsModel.assPrjDonors" ToRole="ProjectsDonors" FromRole="Projects" />
<NavigationProperty Name="Implementedby" Relationship="BrsProjectsModel.assPrjImpl" ToRole="ProjectsImplementedby" FromRole="Projects" />
<NavigationProperty Name="Terms" Relationship="BrsProjectsModel.assPrjTerms" ToRole="ProjectsTerms" FromRole="Projects" />
</EntityType>
<EntityType Name="ProjectsAgreements">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="projectId" Type="Edm.Guid" Nullable="false" />
<Property Name="agreementId" Type="Edm.Guid" Nullable="false" />
<Property Name="name" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="nameShort" Type="Edm.String" MaxLength="150" FixedLength="false" Unicode="true" />
<NavigationProperty Name="Projects" Relationship="BrsProjectsModel.assPrjAgr" ToRole="Projects" FromRole="ProjectsAgreements" />
</EntityType>
<EntityType Name="ProjectsBeneficiaries">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="projectId" Type="Edm.Guid" Nullable="false" />
<Property Name="beneficiaryId" Type="Edm.Guid" Nullable="false" />
<Property Name="country" Type="Edm.String" MaxLength="2" FixedLength="false" Unicode="true" />
<Property Name="countryNameEn" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="countryNameFr" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
<Property Name="countryNameEs" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
<Property Name="countryRegionUn" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="isDeveloping" Type="Edm.Boolean" />
<Property Name="isLDC" Type="Edm.Boolean" />
<Property Name="isSIDS" Type="Edm.Boolean" />
<Property Name="bceif" Type="Edm.DateTime" Precision="3" />
<Property Name="rceif" Type="Edm.DateTime" Precision="3" />
<Property Name="sceif" Type="Edm.DateTime" Precision="3" />
<NavigationProperty Name="Projects" Relationship="BrsProjectsModel.assPrjBenef" ToRole="Projects" FromRole="ProjectsBeneficiaries" />
</EntityType>
<EntityType Name="ProjectsDonors">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="projectId" Type="Edm.Guid" Nullable="false" />
<Property Name="donorId" Type="Edm.Guid" Nullable="false" />
<Property Name="Name" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="shortName" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="categoryId" Type="Edm.Int32" />
<Property Name="categoryName" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="web" Type="Edm.String" MaxLength="200" FixedLength="false" Unicode="true" />
<Property Name="email" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="true" />
<Property Name="address" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="postalCode" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="poBox" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="city" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="country" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="phone" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="fax" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<NavigationProperty Name="Projects" Relationship="BrsProjectsModel.assPrjDonors" ToRole="Projects" FromRole="ProjectsDonors" />
</EntityType>
<EntityType Name="ProjectsImplementedby">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="projectId" Type="Edm.Guid" Nullable="false" />
<Property Name="implementedById" Type="Edm.Guid" Nullable="false" />
<Property Name="Name" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="shortName" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="categoryId" Type="Edm.Int32" />
<Property Name="categoryName" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="email1" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="true" />
<Property Name="phone1" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="Fax" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="address" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="poBox" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="postalCode" Type="Edm.String" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Name="city" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="country" Type="Edm.String" MaxLength="4000" FixedLength="false" Unicode="true" />
<Property Name="web" Type="Edm.String" MaxLength="200" FixedLength="false" Unicode="true" />
<Property Name="modified" Type="Edm.DateTime" Precision="3" />
<NavigationProperty Name="Projects" Relationship="BrsProjectsModel.assPrjImpl" ToRole="Projects" FromRole="ProjectsImplementedby" />
</EntityType>
<EntityType Name="ProjectsTerms">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="projectId" Type="Edm.Guid" Nullable="false" />
<Property Name="termId" Type="Edm.Guid" Nullable="false" />
<Property Name="term" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="parentTermNames" Type="Edm.String" MaxLength="2000" FixedLength="false" Unicode="false" />
<NavigationProperty Name="Projects" Relationship="BrsProjectsModel.assPrjTerms" ToRole="Projects" FromRole="ProjectsTerms" />
</EntityType>
<EntityType Name="Countries">
<Key>
<PropertyRef Name="id" />
</Key>
<Property Name="id" Type="Edm.Guid" Nullable="false" />
<Property Name="countryCode2" Type="Edm.String" MaxLength="2" FixedLength="false" Unicode="true" />
<Property Name="countryCode3" Type="Edm.String" MaxLength="3" FixedLength="false" Unicode="true" />
<Property Name="countryNameEn" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="countryNameFr" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
<Property Name="countryNameEs" Type="Edm.String" MaxLength="100" FixedLength="false" Unicode="false" />
<Property Name="countryNameOfficialEn" Type="Edm.String" MaxLength="250" FixedLength="false" Unicode="true" />
<Property Name="countryRegionUn" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="countryRegionFAO" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="isDeveloping" Type="Edm.Boolean" />
<Property Name="isLDC" Type="Edm.Boolean" />
<Property Name="isSIDS" Type="Edm.Boolean" />
<Property Name="preferredLanguage" Type="Edm.String" MaxLength="Max" FixedLength="false" Unicode="true" />
<Property Name="BcEntryIntoForce" Type="Edm.DateTime" Precision="3" />
<Property Name="RcEntryIntoForce" Type="Edm.DateTime" Precision="3" />
<Property Name="ScEntryIntoForce" Type="Edm.DateTime" Precision="3" />
</EntityType>
<Association Name="assPrjAgr">
<End Type="BrsProjectsModel.Projects" Role="Projects" Multiplicity="1" />
<End Type="BrsProjectsModel.ProjectsAgreements" Role="ProjectsAgreements" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Projects">
<PropertyRef Name="id" />
</Principal>
<Dependent Role="ProjectsAgreements">
<PropertyRef Name="projectId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="assPrjBenef">
<End Type="BrsProjectsModel.Projects" Role="Projects" Multiplicity="1" />
<End Type="BrsProjectsModel.ProjectsBeneficiaries" Role="ProjectsBeneficiaries" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Projects">
<PropertyRef Name="id" />
</Principal>
<Dependent Role="ProjectsBeneficiaries">
<PropertyRef Name="projectId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="assPrjDonors">
<End Type="BrsProjectsModel.Projects" Role="Projects" Multiplicity="1" />
<End Type="BrsProjectsModel.ProjectsDonors" Role="ProjectsDonors" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Projects">
<PropertyRef Name="id" />
</Principal>
<Dependent Role="ProjectsDonors">
<PropertyRef Name="projectId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="assPrjImpl">
<End Type="BrsProjectsModel.Projects" Role="Projects" Multiplicity="1" />
<End Type="BrsProjectsModel.ProjectsImplementedby" Role="ProjectsImplementedby" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Projects">
<PropertyRef Name="id" />
</Principal>
<Dependent Role="ProjectsImplementedby">
<PropertyRef Name="projectId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="assPrjTerms">
<End Type="BrsProjectsModel.Projects" Role="Projects" Multiplicity="1" />
<End Type="BrsProjectsModel.ProjectsTerms" Role="ProjectsTerms" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Projects">
<PropertyRef Name="id" />
</Principal>
<Dependent Role="ProjectsTerms">
<PropertyRef Name="projectId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
<Schema Namespace="Projects"
xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
<EntityContainer Name="BrsProjectsEntities" m:IsDefaultEntityContainer="true">
<EntitySet Name="Projects" EntityType="BrsProjectsModel.Projects" />
<EntitySet Name="ProjectsAgreements" EntityType="BrsProjectsModel.ProjectsAgreements" />
<EntitySet Name="ProjectsBeneficiaries" EntityType="BrsProjectsModel.ProjectsBeneficiaries" />
<EntitySet Name="ProjectsDonors" EntityType="BrsProjectsModel.ProjectsDonors" />
<EntitySet Name="ProjectsImplementedby" EntityType="BrsProjectsModel.ProjectsImplementedby" />
<EntitySet Name="ProjectsTerms" EntityType="BrsProjectsModel.ProjectsTerms" />
<EntitySet Name="Countries" EntityType="BrsProjectsModel.Countries" />
<AssociationSet Name="assPrjAgr" Association="BrsProjectsModel.assPrjAgr">
<End Role="Projects" EntitySet="Projects" />
<End Role="ProjectsAgreements" EntitySet="ProjectsAgreements" />
</AssociationSet>
<AssociationSet Name="assPrjBenef" Association="BrsProjectsModel.assPrjBenef">
<End Role="Projects" EntitySet="Projects" />
<End Role="ProjectsBeneficiaries" EntitySet="ProjectsBeneficiaries" />
</AssociationSet>
<AssociationSet Name="assPrjDonors" Association="BrsProjectsModel.assPrjDonors">
<End Role="Projects" EntitySet="Projects" />
<End Role="ProjectsDonors" EntitySet="ProjectsDonors" />
</AssociationSet>
<AssociationSet Name="assPrjImpl" Association="BrsProjectsModel.assPrjImpl">
<End Role="Projects" EntitySet="Projects" />
<End Role="ProjectsImplementedby" EntitySet="ProjectsImplementedby" />
</AssociationSet>
<AssociationSet Name="assPrjTerms" Association="BrsProjectsModel.assPrjTerms">
<End Role="Projects" EntitySet="Projects" />
<End Role="ProjectsTerms" EntitySet="ProjectsTerms" />
</AssociationSet>
</EntityContainer>
</Schema>
</edmx:DataServices>
</edmx:Edmx>