author

Table info.

Title Author
Description Author

Fields

Name Type Required Index Hidden On form Title Pick list Description
AuthorID 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
OrderNumber smallint(6) Order Number the order of AgentID relative to other authors of reference.
Remarks text Remarks Additional comments.
ReferenceWorkID int(11) MUL
CreatedByAgentID int(11) MUL
AgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
AgentIDX ReferenceWorkID, AgentID
FKAC2D218B384B3622 AgentID
FKAC2D218B5327F942 ModifiedByAgentID
FKAC2D218B69734F30 ReferenceWorkID
FKAC2D218B7699B003 CreatedByAgentID
PRIMARY AuthorID

Many-to-one relationships

Name Field Related table Related field
FKAC2D218B384B3622 AgentID agent AgentID
FKAC2D218B5327F942 ModifiedByAgentID agent AgentID
FKAC2D218B69734F30 ReferenceWorkID referencework ReferenceWorkID
FKAC2D218B7699B003 CreatedByAgentID agent AgentID

View: Authors (Discipline)

<view name="Authors"
      class="edu.ku.brc.specify.datamodel.Author"
      busrules="edu.ku.brc.specify.datamodel.busrules.AuthorBusRules"
      usedefbusrule="false"
      resourcelabels="false">
    <desc><![CDATA[The Author subform for Reference Work form.]]></desc>
    <altviews>
        <!--  <altview name="Author View" viewdef="Author" mode="view"/>
        <altview name="Author Edit" viewdef="Author" mode="edit" default="true"/>  -->
        <altview name="Authors Table View" viewdef="Authors Table" mode="view"/>
        <altview name="Authors Table Edit" viewdef="Authors Table" mode="edit"/>
    </altviews>
</view>

View def.: Authors Table

<viewdef type="formtable"
      name="Authors Table"
      class="edu.ku.brc.specify.datamodel.Author"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Author subform for Reference Work.]]></desc>
    <definition>Authors</definition>
</viewdef>