Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	9 Aug 2004 09:15:34 -0000	1.1
@@ -0,0 +1,103 @@
+--
+-- Assessment Package
+--
+-- @author nperper@it.uc3m.es
+-- @creation-date 2004-08-05
+--
+
+-- Assessment Sessions
+create table as_sessions (
+	session_id integer
+		constraint as_sessions_session_id_pk
+		primary key
+		constraint as_sessions_session_id_fk
+		references cr_revisions(revision_id),
+	assessment_id integer
+		constraint as_sessions_assessment_id_fk
+		references as_assessments(assessment_id),
+	-- if subjects can't be "persons" then Assessment will have to define an as_subjects table for its own use.
+	subject_id integer
+		constraint as_sessions_subject_id_fk
+		references persons(person_id),
+	staff_id integer
+		constraint as_sessions_staff_id_fk
+		references users(user_id),
+	target_datetime timestamptz,
+	creation_datetime timestamptz,
+	first_mod_datetime timestamptz,
+	last_mod_datetime timestamptz,
+	completed_datetime timestamptz,
+	session_status varchar(20),
+	assessment_status varchar(20),
+	percent_score integer
+		constraint as_sessions_percent_score_ck
+		check (percent_score <= 100)
+);
+
+--Assessment Section Data
+create table as_section_data (
+	section_data_id integer
+		constraint as_section_data_section_data_id_pk
+		primary key
+		constraint as_section_data_section_data_id_fk
+		references cr_revisions(revision_id),
+	session_id integer
+		constraint as_section_data_session_id_fk
+		references as_sessions(session_id),
+	section_id integer
+		constraint as_section_data_section_id_fk
+		references as_sections(section_id),
+-- if subjects can't be "persons" then Assessment will have to define an as_subjects table for its own use.
+	subject_id integer
+		constraint as_section_data_subject_id_fk
+		references persons(person_id),
+	staff_id integer
+		constraint as_section_data_staff_id_fk
+		references users(user_id)
+);
+
+-- Assessment Item
+create table as_item_data (
+	item_data_id integer
+		constraint as_item_data_item_data_id_pk
+		primary key
+		constraint as_item_data_item_data_id_fk
+		references cr_revisions(revision_id),
+	session_id integer
+		constraint as_item_data_session_id_fk
+		references as_sessions(session_id),
+	-- if subjects can't be "persons" then Assessment will have to define an as_subjects table for its own use
+	subject_id integer
+		constraint as_item_data_subject_id_fk
+		references persons(person_id),
+	-- missing foreign key
+	staff_id integer
+		constraint as_item_data_staff_id_fk
+		references users(user_id),
+	item_id integer
+		constraint as_item_data_item_id
+		references as_items(as_item_id),
+	is_unknown_p char(1) default 'f'
+		constraint as_item_data_is_unknown_p_ck
+		check (is_unknown_p in ('t','f')),
+	-- references as_item_choices
+	choice_id_answer integer
+		constraint as_item_data_choice_id_answer_fk
+		references as_item_choices(choice_id),
+	boolean_answer boolean,
+	clob_answer text,
+	numeric_answer numeric,
+	integer_answer integer,
+	text_answer varchar(500),
+	timestamp_answer timestamptz,
+	-- references cr_revisions
+	content_answer integer
+		constraint as_item_data_content_answer_fk
+		references cr_revisions,
+	-- This field stores the signed entered data
+	signed_data varchar(500)
+	--percent_score integer
+	-- constraint as_item_data_percent_score_ck
+	--check (percent_score <=100)
+	-- to do: figure out how attachment answers should be supported; the Attachment package is still in need of considerable help. Can we rely on it here?
+);
Index: openacs-4/packages/assessment/sql/postgresql/assessment-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/assessment/sql/postgresql/assessment-create.sql	5 Aug 2004 11:11:34 -0000	1.11
+++ openacs-4/packages/assessment/sql/postgresql/assessment-create.sql	9 Aug 2004 09:15:35 -0000	1.12
@@ -8,3 +8,4 @@
 \i assessment-item-type-create.sql
 \i assessment-item-create.sql
 \i assessment-section-create.sql
+\i assessment-collected-data-create.sql