MEL Specify schema browser

Table info.

Title	Voucher Relationship
Description	Voucher Relationship

Fields

Name	Type	Required	Index	Hidden	On form	Title	Pick list	Description
VoucherRelationshipID	int(11)		PRI
TimestampCreated	datetime					Timestamp Created		timestampCreated
TimestampModified	datetime					Timestamp Modified		timestampModified
Version	int(11)					Version		version
CollectionMemberID	int(11)					Collection Member Id		collectionMemberId
CollectionCode	varchar(64)					Collection Code		collectionCode
InstitutionCode	varchar(64)					Institution Code		institutionCode
Integer1	int(11)					Integer1		integer1
Integer2	int(11)					Integer2		integer2
Integer3	int(11)					Integer3		integer3
Number1	float					Number1		number1
Number2	float					Number2		number2
Number3	float					Number3		number3
Remarks	text					Remarks		remarks
Text1	text					Text1		text1
Text2	text					Text2		text2
Text3	text					Text3		text3
UrlLink	varchar(1024)					Url Link		urlLink
VoucherNumber	varchar(256)					Voucher Number		voucherNumber
YesNo1	bit(1)					Yes No1		yesNo1
YesNo2	bit(1)					Yes No2		yesNo2
YesNo3	bit(1)					Yes No3		yesNo3
CreatedByAgentID	int(11)		MUL
ModifiedByAgentID	int(11)		MUL
CollectionObjectID	int(11)		MUL

Indexes

Name	Fields	Unique	Nullable
FKE5366FE65327F942	ModifiedByAgentID
FKE5366FE675E37458	CollectionObjectID
FKE5366FE67699B003	CreatedByAgentID
PRIMARY	VoucherRelationshipID

Many-to-one relationships

Name	Field	Related table	Related field
FKE5366FE65327F942	ModifiedByAgentID	agent	AgentID
FKE5366FE675E37458	CollectionObjectID	collectionobject	CollectionObjectID
FKE5366FE67699B003	CreatedByAgentID	agent	AgentID