Specify schema

Title	Collection
Description	Collection

Name	Fields	Unique	Nullable
CollectionGuidIDX	GUID
CollectionNameIDX	CollectionName
FK3D0021605327F9429835ae9e	ModifiedByAgentID
FK3D0021607699B0039835ae9e	CreatedByAgentID
FK9835AE9E4CE675DE	DisciplineID
FK9835AE9E6F3E820E	AdminContactID
FK9835AE9E9EAB854A	InstitutionNetworkID
FK9835AE9EDE67F146	InstitutionNetworkID
PRIMARY	UserGroupScopeId
UserGroupScopeId	UserGroupScopeId

Name	Field	Related table	Related field
FK58743053D2DAD9A	UserGroupScopeId	agent	CollectionCCID
FK58743053D3567E9	UserGroupScopeId	agent	CollectionTCID
FK46F04F2A8C2288BA	UserGroupScopeId	autonumsch_coll	CollectionID
FKC1D4635D8C2288BA	UserGroupScopeId	collectionobject	CollectionID
FK1CAC96F5CB93CD98	UserGroupScopeId	collectionreltype	LeftSideCollectionID
FK1CAC96F5D54425AD	UserGroupScopeId	collectionreltype	RightSideCollectionID
FK4647A8D58C2288BA	UserGroupScopeId	fieldnotebook	CollectionID
FKD3F8383F8C2288BA	UserGroupScopeId	picklist	CollectionID
FKB3C452E78C2288BA	UserGroupScopeId	preptype	CollectionID
FK3A2F5C9B8C2288BA	UserGroupScopeId	spappresourcedir	CollectionID
FKF2333F228C2288BA	UserGroupScopeId	sptasksemaphore	CollectionID

Name	Field	Related table	Related field
FK3D0021605327F9429835ae9e	ModifiedByAgentID	agent	AgentID
FK3D0021607699B0039835ae9e	CreatedByAgentID	agent	AgentID
FK9835AE9E4CE675DE	DisciplineID	discipline	UserGroupScopeId
FK9835AE9E6F3E820E	AdminContactID	agent	AgentID
FK9835AE9E9EAB854A	InstitutionNetworkID	institutionnetwork	InstitutionNetworkID
FK9835AE9EDE67F146	InstitutionNetworkID	institution	UserGroupScopeId

View: Collection (Common)

<view name="Collection"
      class="edu.ku.brc.specify.datamodel.Collection"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectionBusRules">
    <desc><![CDATA[The Collection Object form.]]></desc>
    <altviews>
        <altview name="Collection View" viewdef="Collection" mode="view" validated="false"/>
        <altview name="Collection Edit" viewdef="Collection" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: Collection

<viewdef type="form"
      name="Collection"
      class="edu.ku.brc.specify.datamodel.Collection"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collection Data Entry Form]]></desc>
    <columnDef>115px,2px,299px,5px,120px,2px,284px,15px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,200px,15px,555px,15px,p:g</columnDef>
    <columnDef os="mac">135px,2px,300px,15px,580px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px,p:g,2px,p:g(2),15px,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="discipline" uitype="text" readonly="true" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="collectionName" uitype="text" isrequired="true" colspan="5"/> 
        </row>
        <row>
            <cell type="label" label="Numbering Scheme:" initialize="align=right;"/>
            <cell type="field" id="4" name="catalogNumberingSchemeLbl" uitype="text" readonly="true" ignore="true"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="code" uitype="text" isrequired="false"/>
            <cell type="field" id="6" name="isEmbeddedCollectingEvent" label="Add Collecting Event Automatically" uitype="checkbox"/> 
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="description" uitype="textareabrief" rows="2" colspan="5"/>
        </row>
        <row>
            <cell type="separator" label="ABCD Schema Fields (Optional)" colspan="7"/>
        </row>
         <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="kingdomCoverage" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="primaryFocus" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="collectionType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="primaryPurpose" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="preservationMethodType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="developmentStatus" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="14"/>
            <cell type="field" id="14" name="institutionType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="15"/>
            <cell type="field" id="15" name="scope" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="16"/>
            <cell type="field" id="16" name="dbContentVersion" uitype="text" isrequired="false" colspan="5"/>
        </row>                
    </rows>
</viewdef>

View: CollectionForGrid (Common)

<view name="CollectionForGrid"
      class="edu.ku.brc.specify.datamodel.Collection"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectionBusRules">
    <desc><![CDATA[The Collection Object form.]]></desc>
    <altviews>
        <altview name="CollectionGrid View" viewdef="CollectionForGrid" mode="view" validated="false"/>
    </altviews>
</view>

View def.: CollectionForGrid

<viewdef type="form"
      name="CollectionForGrid"
      class="edu.ku.brc.specify.datamodel.Collection"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collection Data Entry Form]]></desc>
    <columnDef>p,3dlu,p,4px,p,2px,p,f:p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="collectionName" uitype="text" isrequired="true"/> 
            <cell type="label" label=" "/>
            <cell type="field" id="6" name="isEmbeddedCollectingEvent" label="Add Collecting Event Automatically" uitype="checkbox"/> 
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="code" uitype="text" isrequired="false" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="discipline" uitype="text" readonly="true" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="description" uitype="textarea" colspan="6"/>
        </row>
    </rows>
</viewdef>

View: CollectionGrid (Common)

<view name="CollectionGrid"
      class="edu.ku.brc.specify.datamodel.Collection"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectionBusRules">
    <desc><![CDATA[The Collection Object form.]]></desc>
    <altviews>
        <altview name="CollectionGrid View" viewdef="CollectionGrid" mode="view" validated="false"/>
        <altview name="CollectionGrid Edit" viewdef="CollectionGrid" mode="edit" validated="true"/>
    </altviews>
</view>

View def.: CollectionGrid

<viewdef type="formtable"
      name="CollectionGrid"
      class="edu.ku.brc.specify.datamodel.Collection"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collection Grid View.]]></desc>
    <definition>CollectionForGrid</definition>
</viewdef>

View: CollectionGridViewOnly (Common)

<view name="CollectionGridViewOnly"
      class="edu.ku.brc.specify.datamodel.Collection"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectionBusRules">
    <desc><![CDATA[The Collection Object form.]]></desc>
    <altviews>
        <altview name="Collection View" viewdef="CollectionGrid" mode="view" validated="false"/>
    </altviews>
</view>

View def.: CollectionGrid

<viewdef type="formtable"
      name="CollectionGrid"
      class="edu.ku.brc.specify.datamodel.Collection"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collection Grid View.]]></desc>
    <definition>CollectionForGrid</definition>
</viewdef>

View: CollectionSub (Common)

<view name="CollectionSub"
      class="edu.ku.brc.specify.datamodel.Collection"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectionBusRules">
    <desc><![CDATA[The Collection Object form.]]></desc>
    <altviews>
        <altview name="CollectionSub View" viewdef="CollectionSub" mode="view" validated="false"/>
        <altview name="CollectionSub Edit" viewdef="CollectionSub" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: CollectionSub

<viewdef type="form"
      name="CollectionSub"
      class="edu.ku.brc.specify.datamodel.Collection"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collection Data Entry Form]]></desc>
    <columnDef>115px,2px,299px,5px,120px,2px,284px,10px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,200,15px,560px,10px,p:g</columnDef>
    <columnDef os="mac">135px,2px,300px,15px,400px,10px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px,p:g(2),2px,p:g,10px</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="collectionName" uitype="text" isrequired="true" colspan="5"/> 
        </row>
        <row>
            <cell type="label" label="Numbering Scheme:" initialize="align=right;"/>
            <cell type="field" id="4" name="catalogNumberingSchemeLbl" uitype="text" readonly="true" ignore="true"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="code" uitype="text" isrequired="false"/>
            <cell type="field" id="6" name="isEmbeddedCollectingEvent" label="Add Collecting Event Automatically" uitype="checkbox"/> 
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="description" uitype="textareabrief" rows="2" colspan="5"/>
        </row>
        <row>
            <cell type="separator" label="ABCD Schema Fields (Optional)" colspan="7"/>
        </row>
         <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="kingdomCoverage" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="primaryFocus" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="collectionType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="primaryPurpose" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="preservationMethodType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="developmentStatus" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="14"/>
            <cell type="field" id="14" name="institutionType" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="15"/>
            <cell type="field" id="15" name="scope" uitype="text" isrequired="false" colspan="5"/>
        </row>
         <row>
            <cell type="label" labelfor="16"/>
            <cell type="field" id="16" name="dbContentVersion" uitype="text" isrequired="false" colspan="5"/>
        </row>                
    </rows>
</viewdef>

Name	Type	Index	Title	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
CatalogFormatNumName	varchar(64)
Code	varchar(50)		Code	Unique code for collection.
collectionId	int(11)
CollectionName	varchar(50)	MUL	Collection name	The name of the collection.
CollectionType	varchar(32)		Collection Type	Textual description of collection. ABCD schema field.
DbContentVersion	varchar(32)		Db Content Version	ABCD schema field.
Description	text		Description	Textual description of collection.
DevelopmentStatus	varchar(32)		Development Status	ABCD schema field.
EstimatedSize	int(11)		Estimated Size	ABCD schema field.
GUID	varchar(128)	MUL	Guid	guid
InstitutionType	varchar(32)		Institution Type	ABCD schema field.
IsEmbeddedCollectingEvent	bit(1)		Is Embedded Collecting Event	Yes if collecting event is one-to-one relationship.
IsaNumber	varchar(24)		ISA Number	ISA number.
KingdomCoverage	varchar(32)		Kingdom Coverage	ABCD schema field.
PreservationMethodType	varchar(32)		Preservation Method Type	ABCD schema field.
PrimaryFocus	varchar(32)		Primary Focus	ABCD schema field.
PrimaryPurpose	varchar(32)		Primary Purpose	ABCD schema field.
RegNumber	varchar(24)		Reg Number	regNumber
Remarks	text		Remarks	Additional comments.
Scope	text		Scope	ABCD schema field.
WebPortalURI	varchar(255)		Web Portal URI	webPortalURI
WebSiteURI	varchar(255)		Web Site URI	webSiteURI
DisciplineID	int(11)	MUL
InstitutionNetworkID	int(11)	MUL
AdminContactID	int(11)	MUL

MEL Specify schema browser

collection

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: Collection (Common)

View def.: Collection

View: CollectionForGrid (Common)

View def.: CollectionForGrid

View: CollectionGrid (Common)

View def.: CollectionGrid

View: CollectionGridViewOnly (Common)

View def.: CollectionGrid

View: CollectionSub (Common)

View def.: CollectionSub