dnasequencingruncitation

Table info.

Title DNA Sequencing Run Citation
Description DNA Sequencing Run Citation

Fields

Name Type Required Index Hidden On form Title Pick list Description
DNASequencingRunCitationID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Number1 float(20,10) Number1 number1
Number2 float(20,10) Number2 number2
Remarks text Remarks remarks
Text1 text Text1 text1
Text2 text Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
CreatedByAgentID int(11) MUL
DNASequencingRunID int(11) MUL
ReferenceWorkID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK24CEBD5327F942 ModifiedByAgentID
FK24CEBD69734F30 ReferenceWorkID
FK24CEBD7699B003 CreatedByAgentID
FK24CEBD78F036AA DNASequencingRunID
PRIMARY DNASequencingRunCitationID

Many-to-one relationships

Name Field Related table Related field
FK24CEBD5327F942 ModifiedByAgentID agent AgentID
FK24CEBD69734F30 ReferenceWorkID referencework ReferenceWorkID
FK24CEBD7699B003 CreatedByAgentID agent AgentID
FK24CEBD78F036AA DNASequencingRunID dnasequencingrun DNASequencingRunID

View: DNASequencingRunCitation (Common)

<view name="DNASequencingRunCitation"
      class="edu.ku.brc.specify.datamodel.DNASequencingRunCitation">
    <desc><![CDATA[Locality form.]]></desc>
    <altviews>
        <altview name="DNASequencingRunCitation View" viewdef="DNASequencingRunCitation" mode="view"/>
        <altview name="DNASequencingRunCitation Edit" viewdef="DNASequencingRunCitation" mode="edit" default="true"/>
    </altviews>
</view>

View def.: DNASequencingRunCitation

<viewdef type="form"
      name="DNASequencingRunCitation"
      class="edu.ku.brc.specify.datamodel.DNASequencingRunCitation"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Locality]]></desc>
    <columnDef>105px,2px,200px,5px,103px,2px,150px,265px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,230px,5px,73px,2px,155px,p:g</columnDef>
    <columnDef os="mac">130px,2px,215px,5px,80px,2px,165px,433px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px,100px,2px,p:g,p:g(2)</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="referenceWork" uitype="querycbx" initialize="name=ReferenceWork;title=ReferenceWork" colspan="6"/>
        </row>            
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="remarks" uitype="textareabrief" rows="2" colspan="6"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="n1"/>
            <cell type="field" id="n1" name="number1" uitype="text"/>
            <cell type="label" labelfor="n2"/>
            <cell type="field" id="n2" name="number2" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t1"/>
            <cell type="field" id="t1" name="text1" uitype="text"/>
            <cell type="label" labelfor="t2"/>
            <cell type="field" id="t2" name="text2" uitype="text"/>
        </row>
        <row>
            <cell type="field" id="20" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="20" name="yesNo2" uitype="checkbox" initialize="editable=true"/>
        </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>