accessionauthorization

Table info.

Title Accession Authorization
Description Accession Authorization

Fields

Name Type Required Index Hidden On form Title Pick list Description
AccessionAuthorizationID 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
Remarks text Remarks Additional comments.
CreatedByAgentID int(11) MUL
PermitID int(11) MUL
AccessionID int(11) MUL
ModifiedByAgentID int(11) MUL
RepositoryAgreementID int(11) MUL

Indexes

Name Fields Unique Nullable
FK4F2602D53925EE20 AccessionID
FK4F2602D53EBC6278 RepositoryAgreementID
FK4F2602D55327F942 ModifiedByAgentID
FK4F2602D57699B003 CreatedByAgentID
FK4F2602D5AD1F31F4 PermitID
PRIMARY AccessionAuthorizationID

Many-to-one relationships

Name Field Related table Related field
FK4F2602D53925EE20 AccessionID accession AccessionID
FK4F2602D53EBC6278 RepositoryAgreementID repositoryagreement RepositoryAgreementID
FK4F2602D55327F942 ModifiedByAgentID agent AgentID
FK4F2602D57699B003 CreatedByAgentID agent AgentID
FK4F2602D5AD1F31F4 PermitID permit PermitID

View: AccessionAuthorization (Common)

<view name="AccessionAuthorization"
      objtitle="Accession
      Authorization"
      class="edu.ku.brc.specify.datamodel.AccessionAuthorization"
      busrules="edu.ku.brc.specify.datamodel.busrules.AccessionAuthorizationBusRules">
    <desc><![CDATA[Permit subform within the Accession form.]]></desc>
    <altviews>
        <altview name="AccessionAuthorization View" viewdef="AccessionAuthorization" mode="view" default="true"/>
        <altview name="AccessionAuthorization Edit" viewdef="AccessionAuthorization" mode="edit"/>
    </altviews>
</view>

View def.: AccessionAuthorization

<viewdef type="form"
      name="AccessionAuthorization"
      class="edu.ku.brc.specify.datamodel.AccessionAuthorization"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Permit subform for AccessionAuthorization.]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,210px,515px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,230px,550px,p:g</columnDef>
    <columnDef os="mac">130px,2px,215px,685px,p:g</columnDef>
    <columnDef os="exp">p,2px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="permit" uitype="querycbx" initialize="name=Permit"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="remarks" uitype="textareabrief" rows="2" colspan="2"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>
 

View: AgreementAuthorization (Common)

<view name="AgreementAuthorization"
      objtitle="Agreement
      Authorization"
      class="edu.ku.brc.specify.datamodel.AccessionAuthorization">
    <desc><![CDATA[Permit subform within the Accession form.]]></desc>
    <altviews>
        <altview name="AgreementAuthorization View" viewdef="AgreementAuthorization" mode="view" default="true"/>
        <altview name="AgreementAuthorization Edit" viewdef="AgreementAuthorization" mode="edit"/>
    </altviews>
</view>

View def.: AgreementAuthorization

<viewdef type="form"
      name="AgreementAuthorization"
      class="edu.ku.brc.specify.datamodel.AccessionAuthorization"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Permit subform for AccessionAuthorization.]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,205px,531px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,210px,590px,p:g</columnDef>
    <columnDef os="mac">130px,2px,275px,625px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,p:g(6)</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="permit" uitype="querycbx" initialize="name=Permit"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="remarks" uitype="textareabrief" rows="2" colspan="2"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>