journal

Table info.

Title Journal
Description Journal

Fields

Name Type Required Index Hidden On form Title Pick list Description
JournalID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
GUID varchar(128) MUL GUID guid
ISSN varchar(16) ISSN issn
JournalAbbreviation varchar(50) Journal Abbreviation journalAbbreviation
JournalName varchar(255) MUL Journal Name Full name of hte journal.
Remarks text Remarks remarks
Text1 varchar(32) Text1 User definable.
InstitutionID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKAB64AF375327F942 ModifiedByAgentID
FKAB64AF377699B003 CreatedByAgentID
FKAB64AF3781223908 InstitutionID
JournalGUIDIDX GUID
JournalNameIDX JournalName
PRIMARY JournalID

One-to-many relationships

Name Field Related table Related field
FK5F7C68DC748AEC6 JournalID referencework JournalID

Many-to-one relationships

Name Field Related table Related field
FKAB64AF375327F942 ModifiedByAgentID agent AgentID
FKAB64AF377699B003 CreatedByAgentID agent AgentID
FKAB64AF3781223908 InstitutionID institution UserGroupScopeId