RdsDiagram
Curriculum
id: GUID
learningArea: lookup.id (GUID)
subject: lookup.id (GUID)
level: lookup.id (GUID)
achievementStandard: VARCHAR(5000)
pathway: lookup.id (GUID)
sequence: lookup.id (GUID)
Lookup
id: lookup.id (GUID)
type: INTEGER
title: VARCHAR(255)
ordering: INTEGER
GUID
Portfolio
id: GUID
curriculum: GUID
achievementLevel: lookup.id (GUID)
introduction: VARCHAR(5000)
description: VARCHAR(5000)
copyright: VARCHAR(255)
edition: VARCHAR(255)
curriculum.id
(GUID)
lookup.id
(GUID)
Worksample
id: GUID
Portfolio_id: GUID
relevantAchievementStandard: VARCHAR(5000)
taskTitle: VARCHAR(255)
taskSummary: VARCHAR(255)
acknowledgements: VARCHAR(255)
copyright: VARCHAR(255)
portfolio.id
(GUID)
Artefact
id: GUID
worksample: GUID
title: VARCHAR(255)
artefactType: lookup.id (GUID)
url: VARCHAR(255)
file: GUID
worksample.id
(GUID)
File
id: GUID
contentType: lookup.id (GUID)
name: VARCHAR(255)
blob: blob.id (GUID)
file.id (GUID)
Blob
id: blob.id (GUID)
data: VARBINARY(0)
blob.id (GUID)
Annotation
id: GUID
Artefact_id: GUID
text: VARCHAR(500)
location: VARCHAR(255)
dotStyle: VARCHAR(255)
artefact.id
(GUID)