institutionnetwork

Table info.

Title Institution Network
Description institutionnetwork

Fields

Name Type Required Index Hidden On form Title Pick list Description
InstitutionNetworkID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
AltName varchar(128) Alt Name altName
Code varchar(64) Code code
Description text Description description
Disclaimer text Disclaimer disclaimer
IconURI varchar(255) Icon U R I iconURI
Ipr text Ipr ipr
License text License license
Name varchar(255) Name name
Remarks text Remarks remarks
TermsOfUse text Terms Of Use termsOfUse
Uri varchar(255) Uri uri
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
AddressID int(11) MUL

Indexes

Name Fields Unique Nullable
FK945C55765327F942 ModifiedByAgentID
FK945C55767699B003 CreatedByAgentID
FK945C5576E6A64D00 AddressID
PRIMARY InstitutionNetworkID

One-to-many relationships

Name Field Related table Related field
FK58743054834EDBB InstitutionNetworkID agent InstitutionTCID
FK9835AE9E9EAB854A InstitutionNetworkID collection InstitutionNetworkID

Many-to-one relationships

Name Field Related table Related field
FK945C55765327F942 ModifiedByAgentID agent AgentID
FK945C55767699B003 CreatedByAgentID agent AgentID
FK945C5576E6A64D00 AddressID address AddressID