Specify schema

Title	Permit
Description	Permit

Name	Fields	Unique	Nullable
FKC4E3841B5327F942	ModifiedByAgentID
FKC4E3841B7699B003	CreatedByAgentID
FKC4E3841B81223908	InstitutionID
FKC4E3841BCDCF181F	IssuedByID
FKC4E3841BCDD72143	IssuedToID
IssuedDateIDX	IssuedDate
PermitNumberIDX	PermitNumber
PRIMARY	PermitID

Name	Field	Related table	Related field
FK4F2602D5AD1F31F4	PermitID	accessionauthorization	PermitID
FK67DBF897AD1F31F4	PermitID	collectingeventauthorization	PermitID
FKDDDC20FCAD1F31F4	PermitID	collectingtripauthorization	PermitID
FK7064B77EAD1F31F4	PermitID	permitattachment	PermitID

Name	Field	Related table	Related field
FKC4E3841B5327F942	ModifiedByAgentID	agent	AgentID
FKC4E3841B7699B003	CreatedByAgentID	agent	AgentID
FKC4E3841B81223908	InstitutionID	institution	UserGroupScopeId
FKC4E3841BCDCF181F	IssuedByID	agent	AgentID
FKC4E3841BCDD72143	IssuedToID	agent	AgentID

View: Permit (Common)

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

View def.: Permit

<viewdef type="form"
      name="Permit"
      class="edu.ku.brc.specify.datamodel.Permit"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Permit Form.]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,200px,5px,88px,2px,200px,5px,100px,2px,123px,0px,15px,p,p:g</columnDef>
    <columnDef os="lnx">115px,2px,210px,5px,105px,2px,210px,5px,120px,2px,141px,0px,15px,p,p:g</columnDef>
    <columnDef os="mac">130px,2px,225px,5px,120px,2px,225px,5px,140px,2px,176px,0px,15px,p,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),0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="permitNumber" uitype="text"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="type" uitype="combobox" picklist="PermitType"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="issuedBy" uitype="querycbx" initialize="name=Agent"/>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="issuedTo" uitype="querycbx" initialize="name=Agent"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="issuedDate" uitype="formattedtext" uifieldformatter="Date"/>
        </row>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="endDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="renewalDate" uitype="formattedtext" uifieldformatter="Date"/>
        </row>
        <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
      <cell type="separator" label="Attachments" colspan="13"/>
        </row>
        <row>
            <cell type="subview" viewname="ObjectAttachment" id="10" name="permitAttachments" colspan="13" initialize="btn=true;icon=PermitAttachment"/>
        </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>

View: PermitForAccessions (Common)

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

View def.: PermitForAccessions

<viewdef type="form"
      name="PermitForAccessions"
      class="edu.ku.brc.specify.datamodel.Permit"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Permit subform for Acessions.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,p,2px,100px,2px,p,2px,60px,2px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="permitNumber" uitype="text"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="type" uitype="combobox" initialize="data=N/A, CITES, State, Federal, International"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="issuedBy" uitype="querycbx" initialize="name=Agent"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="issuedTo" uitype="querycbx" initialize="name=Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="issuedDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="renewalDate" uitype="formattedtext" uifieldformatter="Date"/>
        </row>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="endDate" uitype="formattedtext" uifieldformatter="Date"/>
        </row>
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="remarks" uitype="textareabrief" rows="2" colspan="9"/>
        </row>
    </rows>
</viewdef>

Name	Type	Index	Title	Pick list	Description
PermitID	int(11)	PRI
TimestampCreated	datetime		Created		The timestamp the record was created.
TimestampModified	datetime		Last edited		The timestamp the record was last edited.
Version	int(11)		Version		version
EndDate	date		End date		The date until which the permit is valid.
IssuedDate	date	MUL	Issued date		The date the permit was issued. This is usually the date the permit was signed by the Issued by and/or Issued to agent, and often pre- or post-dates the Start date of the permit.
Number1	float(20,10)		Number1		User definable
Number2	float(20,10)		Number2		User definable
PermitNumber	varchar(50)	MUL	Permit number		The permit number (or reference number from a letter), as provided by the issuing agent.
Remarks	text		Comments		Any additional comments about the permit.
RenewalDate	date		Renewal Date		Date of renewal
StartDate	date		Start date		The date from which the permit is valid.
Text1	text		Text1		User definable
Text2	text		Text2		User definable
Type	varchar(50)		Type	PermitType US Dept Wildlife Federal International no data State	Permit category - `CITES`, `Migratory Bird Treaty Act`, ...
YesNo1	bit(1)		Yes No1		User definable
YesNo2	bit(1)		Yes No2		User definable
CreatedByAgentID	int(11)	MUL
ModifiedByAgentID	int(11)	MUL
IssuedByID	int(11)	MUL
IssuedToID	int(11)	MUL
InstitutionID	int(11)	MUL
Copyright	varchar(256)		Copyright		copyright
IsAvailable	bit(1)		Is Available		isAvailable
IsRequired	bit(1)		Is Required		isRequired
PermitText	text		Permit Text		permitText
ReservedInteger1	int(11)		Reserved Integer1		reservedInteger1
ReservedInteger2	int(11)		Reserved Integer2		reservedInteger2
ReservedText3	varchar(128)		Reserved Text3		reservedText3
ReservedText4	varchar(128)		Reserved Text4		reservedText4
Status	varchar(64)		Status		status
StatusQualifier	varchar(128)		Status Qualifier		statusQualifier

MEL Specify schema browser

permit

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: Permit (Common)

View def.: Permit

View: PermitForAccessions (Common)

View def.: PermitForAccessions