arara-schema
Table Name OM Class Description
ARARA_ARTIFACT Artifact Artifact
ARARA_ATTACHMENT Attachment Piece of information associated to an artifact
ARARA_USER AraraUser User
ARARA_ATTACHMENT_TYPE AttachmentType Possible types of attachments (ie: Comment, File)

ARARA_ARTIFACT

Artifact

Name Type Size Default JavaName PK FK not null Description
ARTIFACT_ID INTEGER   ArtifactId X   X Unique identifier

ARARA_ATTACHMENT

Piece of information associated to an artifact

Name Type Size Default JavaName PK FK not null Description
ATTACHMENT_ID INTEGER   AttachmentId X   X Unique identifier
ARTIFACT_ID INTEGER   ArtifactId   X   Artifact this attachment is related to
ATTACHMENT_TYPE_ID INTEGER   TypeId   X X Type of attachment
ATTACHMENT_NAME VARCHAR (255)   Name     X Name displayed on the UI
ATTACHMENT_DATA VARBINARY   Data       Actual information constitutin the attachment
ATTACHMENT_FILE_PATH VARCHAR (255)   FileName       Server side location of the file (relative to the central file storage
ATTACHMENT_MIME_TYPE VARCHAR (25)   MimeType     X MIME type of attachment
MODIFIED_BY INTEGER   ModifiedBy   X   Person that made last modification
CREATED_BY INTEGER   CreatedBy   X   person that created the attachment
MODIFIED_DATE TIMESTAMP   ModifiedDate       Last modification date
CREATED_DATE TIMESTAMP   CreatedDate       Creation date
DELETED INTEGER (1) 0 Deleted       Flag marking if it was deleted

ARARA_USER

User

Name Type Size Default JavaName PK FK not null Description
USER_ID INTEGER   UserId X   X Unique identifier

ARARA_ATTACHMENT_TYPE

Possible types of attachments (ie: Comment, File)

Name Type Size Default JavaName PK FK not null Description
ATTACHMENT_TYPE_ID INTEGER   AttachmentTypeId X   X Unique identifier
ATTACHMENT_TYPE_NAME VARCHAR (255)   Name     X type name
SEARCHABLE INTEGER (1) 0 Searchable       Flag marking a text searchable attachment