Specify schema

Title	Address
Description	Address

Name	Fields	Unique	Nullable
FKBB979BF4384B3622	AgentID
FKBB979BF45327F942	ModifiedByAgentID
FKBB979BF47699B003	CreatedByAgentID
PRIMARY	AddressID

Name	Field	Related table	Related field
FK15BD30ADE6A64D00	AddressID	division	AddressID
FK3529A5B8E6A64D00	AddressID	institution	AddressID
FK945C5576E6A64D00	AddressID	institutionnetwork	AddressID

Name	Field	Related table	Related field
FKBB979BF4384B3622	AgentID	agent	AgentID
FKBB979BF45327F942	ModifiedByAgentID	agent	AgentID
FKBB979BF47699B003	CreatedByAgentID	agent	AgentID

View: Address (Discipline)

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

View def.: Address

<viewdef type="form"
      name="Address"
      class="edu.ku.brc.specify.datamodel.Address"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Address subform for Acessions.]]></desc>
 
    <columnDef>120px,2px,147px,5px,95px,2px,147px,5px,95px,2px,148px,5px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,125px,5px,90px,2px,125px,5px,99px,2px,125px,5px,90px,2px,125px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,130px,5px,115px,2px,130px,5px,127px,2px,130px,5px,115px,2px,130px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,113px,5px:g,p,2px,113px,5px:g,p,2px,113px,5px:g,p,2px,113px,p:g</columnDef>
    <rowDef>p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p</rowDef>
 
    <rows>
        <row>
            <cell type="label" labelfor="20"/>
            <cell type="field" id="20" name="typeOfAddr" uitype="combobox" colspan="2"/>
            <cell type="label" label="" colspan="4"/>
            <cell type="field" id="1" name="isCurrent" uitype="checkbox" colspan="2" initialize="align=right"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="address5" uitype="text" cols="50" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="address" uitype="text" cols="50" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="address2" uitype="text" cols="50" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="address3" uitype="text" cols="50" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="14"/>
            <cell type="field" id="14" name="address4" uitype="text" cols="50" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="city" uitype="text" cols="20"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="state" uitype="text" cols="15"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="postalCode" uitype="text" cols="11" colspan="2"/>
        </row>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="country" uitype="text" cols="20"/>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="phone1" uitype="text" cols="15"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="fax" uitype="text" cols="15" colspan="2"/>
        </row>
        <row>
            <cell type="label" labelfor="16"/>
            <cell type="field" id="16" name="startDate" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="15"/>
            <cell type="field" id="15" name="phone2" uitype="combobox" readonly="true"/>
            <cell type="label" labelfor="19"/>
            <cell type="field" id="19" name="positionHeld" uitype="text" colspan="2"/>
        </row>
        <!--row>
            <cell type="label" labelfor="18"/>
            <cell type="field" id="18" name="remarks" uitype="text" colspan="10"/>
        </row-->
        <!--row>
            <cell type="label" labelfor="17"/>
            <cell type="field" id="17" name="address5" uitype="text" colspan="10"/>
        </row-->
    </rows>
</viewdef>

View: AddressDiv (Common)

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

View def.: AddressDiv

<viewdef type="form"
      name="AddressDiv"
      class="edu.ku.brc.specify.datamodel.Address"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Address subform for Acessions.]]></desc>
 
    <columnDef>100px,2px,113px,5px,80px,2px,113px,5px,90px,2px,113px,5px,80px,2px,113px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,125px,5px,90px,2px,125px,5px,99px,2px,125px,5px,90px,2px,125px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,130px,5px,115px,2px,130px,5px,127px,2px,130px,5px,115px,2px,130px,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>p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p,2dlu,p</rowDef>
 
    <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="11"/>
            <cell type="field" id="11" name="roomOrBuilding" uitype="text"/>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="phone1" uitype="text"/>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="phone2" uitype="text"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="fax" uitype="text"/>
        </row>
    </rows>
</viewdef>

Name	Type	Index	Title	Description
AddressID	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
Address	varchar(255)		Address	The agent's address as it should appear on mailing labels.
Address2	varchar(255)		Address 2	The agent's address as it should appear on mailing labels.
Address3	varchar(64)		Address 3	The agent's address as it should appear on mailing labels.
Address4	varchar(64)		Attn	The person or position whose attention the mail requires
Address5	varchar(64)		Exchange paperwork	The e-mail address of the person to whom exchange paperwork should be sent.
City	varchar(64)		City	The city.
Country	varchar(64)		Country	The country.
EndDate	date		End Date	The last date the agent was at the address.
Fax	varchar(50)		Fax	The fax number.
IsCurrent	bit(1)		Is current	Indicates if this is the current address
IsPrimary	bit(1)		Is primary	Indicates whether this is the primary address
IsShipping	bit(1)		isshipping
Ordinal	int(11)		Ordinal	Allows multiple addresses to be ordered.
Phone1	varchar(50)		Phone	The agent's phone number
Phone2	varchar(50)		Phone 2	The agent's secondary phone number
PositionHeld	varchar(32)		Data format	The institution's preferred format for exchange data.
PostalCode	varchar(32)		Post code	Post code
Remarks	text		Loan paperwork	The e-mail address of the person to whom loans paperwork should be sent.
RoomOrBuilding	varchar(50)		Address 4	The agent's address as it should appear on mailing labels.
StartDate	date		Start date	The first date that the address was used by MEL
State	varchar(64)		State	The state within the country.
TypeOfAddr	varchar(32)		Exchange	Indicates if MEL has an exchange agreement with the institution
ModifiedByAgentID	int(11)	MUL
AgentID	int(11)	MUL
CreatedByAgentID	int(11)	MUL

MEL Specify schema browser

address

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: Address (Discipline)

View def.: Address

View: AddressDiv (Common)

View def.: AddressDiv