olr-schema
Table Name OM Class Description
rdf_group RdfGroup  
rdf_user RdfUser  
rdf_literal RdfLiteral  
rdf_namespace RdfNamespace  
rdf_resource RdfResource  
rdf_schema RdfSchema  
rdf_statement RdfStatement  
model Model  
model_statement ModelStatement  
rdf_toolbar RdfToolbar  
rdf_track RdfTrack  

rdf_group

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
name VARCHAR (255)   Name
 
 
 
 
description VARCHAR     Description
 
 
 
 
role_admin INTEGER     RoleAdmin
 
 
 
 
role_contributor INTEGER     RoleContributor
 
 
 
 
role_user INTEGER     RoleUser
 
 
 
 
template VARCHAR (255)   Template
 
 
 
 

rdf_user

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
first_name VARCHAR (255)   FirstName
 
 
 
 
last_name VARCHAR (255)   LastName
 
 
 
 
description VARCHAR     Description
 
 
 
 
login VARCHAR (32)   Login
 
 
 
 
password VARCHAR (32)   Password
 
 
 
 
email VARCHAR     Email
 
 
 
 
last_access TIMESTAMP     LastAccess
 
 
 
 
session_key BIGINT     SessionKey
 
 
 
 
group_id INTEGER     GroupId
 
X
 
 

rdf_literal

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
literal VARCHAR     Literal
 
 
 
 
usr INTEGER     Usr
 
X
 
 
modified TIMESTAMP     Modified
 
 
 
 
garbage INTEGER   0 Garbage
 
 
 
 

rdf_namespace

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
ns_name VARCHAR (255)   NsName
 
 
 
 
usr INTEGER     Usr
 
X
 
 
modified TIMESTAMP     Modified
 
 
 
 
garbage INTEGER   0 Garbage
 
 
 
 

rdf_resource

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
ns INTEGER     Ns
 
X
X
 
ro_name VARCHAR (255)   RoName
 
 
 
 
usr INTEGER     Usr
 
X
 
 
modified TIMESTAMP     Modified
 
 
 
 
garbage INTEGER   0 Garbage
 
 
 
 

rdf_schema

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
ns_id INTEGER     NsId
 
X
 
 
short_name VARCHAR (40)   ShortName
 
 
 
 
iscourseschema CHAR (1) N Iscourseschema
 
 
 
 
isnecessary CHAR (1)   Isnecessary
 
 
 
 

rdf_statement

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
subject INTEGER     Subject
 
X
X
 
predicate INTEGER     Predicate
 
X
X
 
obj_resource INTEGER     ObjResource
 
X
X
 
obj_literal INTEGER     ObjLiteral
 
X
X
 
res CHAR (1)   Res
 
 
X
 
usr INTEGER     Usr
 
X
 
 
ispublic CHAR (1) Y Ispublic
 
 
X
 
modified TIMESTAMP     Modified
 
 
 
 
garbage BIGINT   0 Garbage
 
 
X
 

model

Name Type Size Default JavaName PK FK not null Description
id INTEGER     Id
X
 
X
 
name VARCHAR (255)   Name
 
 
 
 
locked BIGINT     Locked
 
 
 
 
locked_by INTEGER     LockedBy
 
X
 
 
is_course BIT   false IsCourse
 
 
 
 

model_statement

Name Type Size Default JavaName PK FK not null Description
model_id INTEGER     ModelId
X
X
X
 
statement_id INTEGER     StatementId
X
X
X
 
reified CHAR (1)   Reified
 
 
X
 
usr INTEGER     Usr
 
X
 
 
modified TIMESTAMP     Modified
 
 
 
 
name VARCHAR (255)   Name
 
 
 
 

rdf_toolbar

Name Type Size Default JavaName PK FK not null Description
uri VARCHAR (255)   Uri
X
 
X
 
title VARCHAR (255)   Title
 
 
X
 
usr INTEGER     Usr
X
X
X
 
schema CHAR (1)   Schema
 
 
X
 

rdf_track

Name Type Size Default JavaName PK FK not null Description
user_id INTEGER     UserId
 
X
X
 
resource_id INTEGER     ResourceId
 
X
X
 
session_key BIGINT     SessionKey
 
 
 
 
access_time TIMESTAMP     AccessTime
 
 
 
 
navi VARCHAR (12)   Navi
 
 
 
 
course_id INTEGER     CourseId
 
X
 
 
url VARCHAR     Url