| Title | Institution |
|---|---|
| Description | Institution |
| Name | Type | Required | Index | Hidden | On form | Title | Pick list | Description |
|---|---|---|---|---|---|---|---|---|
| UserGroupScopeId | int(11) | PRI | ||||||
| TimestampCreated | datetime | Timestamp Created | The timestamp the record was created. | |||||
| TimestampModified | datetime | Timestamp Modified | The timestamp the record was last modified. | |||||
| Version | int(11) | Version | version | |||||
| CreatedByAgentID | int(11) | MUL | ||||||
| ModifiedByAgentID | int(11) | MUL | ||||||
| AltName | varchar(128) | Alt Name | altName | |||||
| Code | varchar(64) | Code | code | |||||
| Copyright | text | Copyright | copyright | |||||
| Description | text | Description | description | |||||
| Disclaimer | text | Disclaimer | Disclaimer statement, e.g. concerning responsibility for data quality or legal implications. | |||||
| HasBeenAsked | bit(1) | Has Been Asked | hasBeenAsked | |||||
| IconURI | varchar(255) | Icon URI | iconURI | |||||
| institutionId | int(11) | |||||||
| Ipr | text | IPR | A sequence of statements related to Intellectual Property Rights, credit and acknowledgement. | |||||
| IsAccessionsGlobal | bit(1) | Are Accessions Global | isAccessionsGlobal | |||||
| IsAnonymous | bit(1) | Is Anonymous | isAnonymous | |||||
| IsSecurityOn | bit(1) | Is Security On | isSecurityOn | |||||
| IsServerBased | bit(1) | Is Server Based | isServerBased | |||||
| IsSharingLocalities | bit(1) | Is Sharing Localities | isSharingLocalities | |||||
| IsSingleGeographyTree | bit(1) | Is Single Geography Tree | isSingleGeographyTree | |||||
| License | text | License | license | |||||
| LsidAuthority | varchar(64) | LSID Authority | lsidAuthority | |||||
| Name | varchar(255) | MUL | Name | name | ||||
| RegNumber | varchar(24) | Reg Number | regNumber | |||||
| Remarks | text | Remarks | Additional Comments | |||||
| TermsOfUse | text | Terms Of Use | Defines conditions under which the data may be analyzed, distributed or changed. "Terms of use" includes concepts like "Usage conditions" and "Specific Restrictions". | |||||
| Uri | varchar(255) | URI | uri | |||||
| StorageTreeDefID | int(11) | MUL | ||||||
| AddressID | int(11) | MUL | ||||||
| CurrentManagedRelVersion | varchar(8) | Current Managed Rel Version | currentManagedRelVersion | |||||
| CurrentManagedSchemaVersion | varchar(8) | Current Managed Schema Version | currentManagedSchemaVersion | |||||
| IsReleaseManagedGlobally | bit(1) | Is Release Managed Globally | isReleaseManagedGlobally | |||||
| MinimumPwdLength | tinyint(4) | Minimum Pwd Length | minimumPwdLength | |||||
| GUID | varchar(128) | MUL | Guid | guid |
| Name | Fields | Unique | Nullable |
|---|---|---|---|
| FK3529A5B853C7EFD6 | StorageTreeDefID | ||
| FK3529A5B8E6A64D00 | AddressID | ||
| FK3D0021605327F9423529a5b8 | ModifiedByAgentID | ||
| FK3D0021607699B0033529a5b8 | CreatedByAgentID | ||
| InstGuidIDX | GUID | ||
| InstNameIDX | Name | ||
| PRIMARY | UserGroupScopeId | ||
| UserGroupScopeId | UserGroupScopeId |
| Name | Field | Related table | Related field |
|---|---|---|---|
| FK587430587E99F68 | UserGroupScopeId | agent | InstitutionCCID |
| FK587430587F159B7 | UserGroupScopeId | agent | InstitutionTCID |
| FK9835AE9EDE67F146 | UserGroupScopeId | collection | InstitutionNetworkID |
| FK15BD30AD81223908 | UserGroupScopeId | division | InstitutionID |
| FKAB64AF3781223908 | UserGroupScopeId | journal | InstitutionID |
| FKC4E3841B81223908 | UserGroupScopeId | permit | InstitutionID |
| FK5F7C68DC81223908 | UserGroupScopeId | referencework | InstitutionID |
| Name | Field | Related table | Related field |
|---|---|---|---|
| FK3529A5B853C7EFD6 | StorageTreeDefID | storagetreedef | StorageTreeDefID |
| FK3529A5B8E6A64D00 | AddressID | address | AddressID |
| FK3D0021605327F9423529a5b8 | ModifiedByAgentID | agent | AgentID |
| FK3D0021607699B0033529a5b8 | CreatedByAgentID | agent | AgentID |
<view name="Institution" class="edu.ku.brc.specify.datamodel.Institution"> <desc><![CDATA[The Institution Object form.]]></desc> <altviews> <altview name="Institution View" viewdef="Institution" mode="view" validated="false"/> <altview name="Institution Edit" viewdef="Institution" mode="edit" validated="true" default="true"/> </altviews> </view>
<viewdef type="form" name="Institution" class="edu.ku.brc.specify.datamodel.Institution" gettable="edu.ku.brc.af.ui.forms.DataGetterForObj" settable="edu.ku.brc.af.ui.forms.DataSetterForObj"> <desc><![CDATA[Institution Data Entry Form]]></desc> <columnDef>100px,2px,398px,5px,80px,2px,240px,0px,15px,p:g</columnDef> <columnDef os="lnx">115px,2px,430px,5px,93px,2px,270px,0px,15px,p:g</columnDef> <columnDef os="mac">130px,2px,490px,5px,113px,2px,290px,0px,15px,p:g</columnDef> <columnDef os="exp">100px,2px,p:g(4),5px:g,p,2px,p:g(2),0px,15px,p:g</columnDef> <rowDef auto="true" cell="p" sep="2dlu"/> <rows> <row> <cell type="label" labelfor="1"/> <cell type="field" id="1" name="name" uitype="text" colspan="6" isrequired="true"/> </row> <row> <cell type="label" label=""/> <cell type="field" id="10" name="isSecurityOn" uitype="checkbox"/> <!--<cell type="label" label=""/> <cell type="field" id="11" name="isAccessionsGlobal" uitype="checkbox"/>--> </row> <row> <cell type="label" labelfor="2"/> <cell type="field" id="2" name="altName" uitype="text"/> <cell type="label" labelfor="3"/> <cell type="field" id="3" name="code" uitype="text"/> </row> <row> <cell type="label" labelfor="lsidAuthority"/> <cell type="field" id="lsidAuthority" name="lsidAuthority" uitype="text" colspan="6"/> </row> <row> <cell type="label" labelfor="4"/> <cell type="field" id="4" name="ipr" uitype="textareabrief" colspan="6" rows="2"/> </row> <row> <cell type="label" labelfor="5"/> <cell type="field" id="5" name="copyright" uitype="textareabrief" rows="2" colspan="6"/> </row> <row> <cell type="label" labelfor="6"/> <cell type="field" id="6" name="termsOfUse" uitype="textareabrief" rows="2" colspan="6"/> </row> <row> <cell type="label" labelfor="7"/> <cell type="field" id="7" name="disclaimer" uitype="textareabrief" rows="2" colspan="6"/> </row> <row> <cell type="label" labelfor="8"/> <cell type="field" id="8" name="remarks" uitype="textareabrief" rows="2" colspan="6"/> </row> <row> <cell type="separator" id="relmgrsep" label="Managed Releases" colspan="9"/> </row> <row> <cell type="label" id="relmgrlabel" label=" "/> <cell type="panel" id="relmgrpanel" name="mgrpanel" coldef="p,2px,p,20px,p,1px,p" rowdef="p" colspan="7"> <rows> <row> <cell type="label" label=" "/> <cell type="field" id="isRelMgrGlb" name="isReleaseManagedGlobally" uitype="checkbox"/> <cell type="label" id="curMgrRelVerLbl" labelfor="curMgrRelVer"/> <cell type="field" id="curMgrRelVer" name="currentManagedRelVersion" uitype="combobox"/> </row> </rows> </cell> </row> <row> <cell type="subview" viewname="Address" id="12" name="address" colspan="9" initialize="btn=true"/> </row> <row> <cell type="subview" viewname="DivisionOnly" id="9" name="divisions" colspan="9"/> </row> </rows> </viewdef>