addressofrecord

Table info.

Title Address Of Record
Description Address Of Record

Fields

Name Type Required Index Hidden On form Title Pick list Description
AddressOfRecordID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Address varchar(255) Address Primary address of record.
Address2 varchar(255) Address2 Secondary address of record.
City varchar(64) City City of record.
Country varchar(64) Country Country of record.
PostalCode varchar(32) Postal Code Postal code of record (zip code).
Remarks text Remarks Additional comments.
State varchar(64) State State of record.
CreatedByAgentID int(11) MUL
AgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKDBAAE4DC384B3622 AgentID
FKDBAAE4DC5327F942 ModifiedByAgentID
FKDBAAE4DC7699B003 CreatedByAgentID
PRIMARY AddressOfRecordID

One-to-many relationships

Name Field Related table Related field
FK81EF3824DC8B4810 AddressOfRecordID accession AddressOfRecordID
FKAD8CA9F5DC8B4810 AddressOfRecordID borrow AddressOfRecordID
FK366E9E88DC8B4810 AddressOfRecordID exchangein AddressOfRecordID
FK97654A4BDC8B4810 AddressOfRecordID exchangeout AddressOfRecordID
FK306930DC8B4810 AddressOfRecordID gift AddressOfRecordID
FK32C4F0DC8B4810 AddressOfRecordID loan AddressOfRecordID
FKA5A38A00DC8B4810 AddressOfRecordID repositoryagreement AddressOfRecordID

Many-to-one relationships

Name Field Related table Related field
FKDBAAE4DC384B3622 AgentID agent AgentID
FKDBAAE4DC5327F942 ModifiedByAgentID agent AgentID
FKDBAAE4DC7699B003 CreatedByAgentID agent AgentID

View: AddressOfRecord (Common)

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

View def.: AddressOfRecord

<viewdef type="form"
      name="AddressOfRecord"
      class="edu.ku.brc.specify.datamodel.AddressOfRecord"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Address of Record subform.]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,110px,5px,80px,2px,110px,5px,103px,2px,110px,5px,81px,2px,110px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,129px,5px,72px,2px,129px,5px,110px,2px,129px,5px,80px,2px,129px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,148px,5px,81px,2px,148px,5px,113px,2px,148px,5px,91px,2px,148px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="address" uitype="text" colspan="14"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="address2" uitype="text" colspan="14"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="city" uitype="text"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="state" uitype="text"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="postalCode" uitype="text"/>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="country" uitype="text"/>
        </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>