Schema TILDATUTORIAL

This schema is used by the tilda tutorials as part of its documentation.

Copyright (c) 2019, CapsicoHealth Inc., All rights reserved.

Covered under the Apache 2.0 License.

Fields Formulas Realized

Tables Graph

Views Graph

Tables

User    ^{details    top}

The Table TILDATUTORIAL.User:

Is mapped to the generated Java 8/PostgreSQL Tilda classes User_Factory, User_Data in the package tilda_tutorial.data.
Is configured for normal read/write access.

Is OCC-enabled. Default created/lastUpdated/deleted columns have been automatically generated.

Has the following identities:
Primary Key: refnum

Unique Index: id

Unique Index: email

Description: Users

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   refnum   long / bigint   ☐   -   ☑   -   The primary key for this record

2   id   String / varchar(40)   ☐   -   ☐   -   The user's id

3   email   String / varchar(255)   ☐   -   ☐   -   The user's email

4   name   String / varchar(255)   ☑   -   ☐   -   The user's full name

5   created   ZonedDateTime / timestamptz   ☐   AUTO   ☑   -   The timestamp for when the record was created. (TILDATUTORIAL.User)

6   lastUpdated   ZonedDateTime / timestamptz   ☐   AUTO   ☐   -   The timestamp for when the record was last updated. (TILDATUTORIAL.User)

7   deleted   ZonedDateTime / timestamptz   ☑   AUTO   ☐   -   The timestamp for when the record was deleted. (TILDATUTORIAL.User)

Form    ^{details    top}

The Table TILDATUTORIAL.Form:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Form_Factory, Form_Data in the package tilda_tutorial.data.
Is configured for normal read/write access.

Is OCC-enabled. Default created/lastUpdated/deleted columns have been automatically generated.

Defines foreign key(s) to TILDATUTORIAL • User, TILDA • ZoneInfo

Has the following identity:
Primary Key: refnum

Description: User-entered forms

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   refnum   long / bigint   ☐   -   ☑   -   The primary key for this record

2   userRefnum   long / bigint   ☐   -   ☐   -   The user who created the form
FK → TILDATUTORIAL • User: refnum

3   type   String / varchar(40)   ☐   -   ☐   -   Form template type

4   fillDateTZ   String / character(5)   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'fillDate'.
FK → TILDA • ZoneInfo: id

5   fillDate   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled

6   created   ZonedDateTime / timestamptz   ☐   AUTO   ☑   -   The timestamp for when the record was created. (TILDATUTORIAL.Form)

7   lastUpdated   ZonedDateTime / timestamptz   ☐   AUTO   ☐   -   The timestamp for when the record was last updated. (TILDATUTORIAL.Form)

8   deleted   ZonedDateTime / timestamptz   ☑   AUTO   ☐   -   The timestamp for when the record was deleted. (TILDATUTORIAL.Form)

TestQuestionAnswer    ^{details    top}

The Table TILDATUTORIAL.TestQuestionAnswer:

Is mapped to the generated Java 8/PostgreSQL Tilda classes TestQuestionAnswer_Factory, TestQuestionAnswer_Data in the package tilda_tutorial.data.
Is configured for normal read/write access.

Is OCC-enabled. Default created/lastUpdated/deleted columns have been automatically generated.

Has the following identities:
Primary Key: refnum

Unique Index: type, questionId, answerSeq

Description: Questions and answers for multiple-choice tests

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   refnum   long / bigint   ☐   -   ☑   -   The primary key for this record

2   type   String / varchar(60)   ☐   -   ☐   -   Form template type

3   questionSeq   int / integer   ☐   -   ☐   -   Sequence of the question for the test

4   questionId   String / varchar(60)   ☐   -   ☐   -   Question id

5   questionLabel   String / varchar(256)   ☐   -   ☐   -   Question label

6   answerSeq   int / integer   ☐   -   ☐   -   Sequence of the answer for the question in the test

7   answerId   String / varchar(60)   ☐   -   ☐   -   Answer id

8   answerLabel   String / varchar(256)   ☐   -   ☐   -   Answer label

9   correct   boolean / boolean   ☐   -   ☐   -   Whether the answer is a correct one or not for that question (technically, there could be more than one)

10   created   ZonedDateTime / timestamptz   ☐   AUTO   ☑   -   The timestamp for when the record was created. (TILDATUTORIAL.TestQuestionAnswer)

11   lastUpdated   ZonedDateTime / timestamptz   ☐   AUTO   ☐   -   The timestamp for when the record was last updated. (TILDATUTORIAL.TestQuestionAnswer)

12   deleted   ZonedDateTime / timestamptz   ☑   AUTO   ☐   -   The timestamp for when the record was deleted. (TILDATUTORIAL.TestQuestionAnswer)

TestAnswer    ^{details    top}

The Table TILDATUTORIAL.TestAnswer:

Is mapped to the generated Java 8/PostgreSQL Tilda classes TestAnswer_Factory, TestAnswer_Data in the package tilda_tutorial.data.
Is configured for normal read/write access.

Is OCC-enabled. Default created/lastUpdated/deleted columns have been automatically generated.

Defines a foreign key to TILDATUTORIAL • Form

Has the following identities:
Primary Key: refnum

Unique Index: formRefnum, questionId

Description: Test answers

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   refnum   long / bigint   ☐   -   ☑   -   The primary key for this record

2   formRefnum   long / bigint   ☐   -   ☑   -   The form's refnum
FK → TILDATUTORIAL • Form: refnum

3   questionId   String / varchar(60)   ☐   -   ☐   -   Question id

4   answerId   String / varchar(60)   ☑   -   ☐   -   Answer value

5   timeMillis   int / integer   ☐   -   ☐   -   Time in milliseconds for the time spent answering the question

6   correct   boolean / boolean   ☐   -   ☐   -   Whether the answer is correct or not

7   created   ZonedDateTime / timestamptz   ☐   AUTO   ☑   -   The timestamp for when the record was created. (TILDATUTORIAL.TestAnswer)

8   lastUpdated   ZonedDateTime / timestamptz   ☐   AUTO   ☐   -   The timestamp for when the record was last updated. (TILDATUTORIAL.TestAnswer)

9   deleted   ZonedDateTime / timestamptz   ☑   AUTO   ☐   -   The timestamp for when the record was deleted. (TILDATUTORIAL.TestAnswer)

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	refnum	long / bigint	☐	-	☑	-	The primary key for this record
2	id	String / varchar(40)	☐	-	☐	-	The user's id
3	email	String / varchar(255)	☐	-	☐	-	The user's email
4	name	String / varchar(255)	☑	-	☐	-	The user's full name
5	created	ZonedDateTime / timestamptz	☐	AUTO	☑	-	The timestamp for when the record was created. (TILDATUTORIAL.User)
6	lastUpdated	ZonedDateTime / timestamptz	☐	AUTO	☐	-	The timestamp for when the record was last updated. (TILDATUTORIAL.User)
7	deleted	ZonedDateTime / timestamptz	☑	AUTO	☐	-	The timestamp for when the record was deleted. (TILDATUTORIAL.User)

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	refnum	long / bigint	☐	-	☑	-	The primary key for this record
2	type	String / varchar(60)	☐	-	☐	-	Form template type
3	questionSeq	int / integer	☐	-	☐	-	Sequence of the question for the test
4	questionId	String / varchar(60)	☐	-	☐	-	Question id
5	questionLabel	String / varchar(256)	☐	-	☐	-	Question label
6	answerSeq	int / integer	☐	-	☐	-	Sequence of the answer for the question in the test
7	answerId	String / varchar(60)	☐	-	☐	-	Answer id
8	answerLabel	String / varchar(256)	☐	-	☐	-	Answer label
9	correct	boolean / boolean	☐	-	☐	-	Whether the answer is a correct one or not for that question (technically, there could be more than one)
10	created	ZonedDateTime / timestamptz	☐	AUTO	☑	-	The timestamp for when the record was created. (TILDATUTORIAL.TestQuestionAnswer)
11	lastUpdated	ZonedDateTime / timestamptz	☐	AUTO	☐	-	The timestamp for when the record was last updated. (TILDATUTORIAL.TestQuestionAnswer)
12	deleted	ZonedDateTime / timestamptz	☑	AUTO	☐	-	The timestamp for when the record was deleted. (TILDATUTORIAL.TestQuestionAnswer)

Views

TestAnswer_View ^{details top}
The View TILDATUTORIAL.TestAnswer_View:

Is mapped to the generated Java 8/PostgreSQL Tilda classes TestAnswer_View_Factory, TestAnswer_View_Data in the package tilda_tutorial.data.
Is OCC-enabled. Default created/lastUpdated/deleted columns have been automatically generated.

Defines a foreign key to TILDA • ZoneInfo

Description: A pivoted view of SAT_01 forms

This view depends on the following filter(s), sub-view(s), and/or root table(s):
TILDATUTORIAL • TestAnswer_View
Look at all forms and answers that have not been deleted.
    Form.deleted is null
and TestAnswer.deleted is null
    TILDATUTORIAL • Form
Root table for the view TILDATUTORIAL.TestAnswer_View
    TILDATUTORIAL • User
Standard join
    TILDATUTORIAL • TestAnswer
Standard join
    TILDATUTORIAL • TestQuestionAnswer
left  join TILDATUTORIAL.TestQuestionAnswer on TestQuestionAnswer."questionId" = TestAnswer."questionId" and TestQuestionAnswer."answerId" = TestAnswer."answerId"
This View contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   formRefnum   long / bigint   ☐   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Form • refnum

2   formType   String / varchar(40)   ☐   -   ☐   -   Form template type
→ TILDATUTORIAL • Form • type

3   formFillDateTZ   String / character(5)   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'formFillDate'.
→ TILDATUTORIAL • Form • fillDateTZ
→ TILDA • ZoneInfo • id

4   formFillDate   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled
→ TILDATUTORIAL • Form • fillDate

5   created   ZonedDateTime / timestamptz   ☐   AUTO   ☑   -   The timestamp for when the record was created. (TILDATUTORIAL.Form)
→ TILDATUTORIAL • Form • created

6   lastUpdated   ZonedDateTime / timestamptz   ☐   AUTO   ☐   -   The timestamp for when the record was last updated. (TILDATUTORIAL.Form)
→ TILDATUTORIAL • Form • lastUpdated

7   deleted   ZonedDateTime / timestamptz   ☑   AUTO   ☐   -   The timestamp for when the record was deleted. (TILDATUTORIAL.Form)
→ TILDATUTORIAL • Form • deleted

8   userRefnum   long / bigint   ☐   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • User • refnum

9   userId   String / varchar(40)   ☐   -   ☐   -   The user's id
→ TILDATUTORIAL • User • id

10   timeMillis   int / integer   ☐   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

11   correct   boolean / boolean   ☐   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

12   questionLabel   String / varchar(256)   ☐   -   ☐   -   Question label
→ TILDATUTORIAL • TestQuestionAnswer • questionLabel

13   questionSeq   int / integer   ☐   -   ☐   -   Sequence of the question for the test
→ TILDATUTORIAL • TestQuestionAnswer • questionSeq

14   answerLabel   String / varchar(256)   ☐   -   ☐   -   Answer label
→ TILDATUTORIAL • TestQuestionAnswer • answerLabel
Test_XYZ_PivotView ^{details top}
The View TILDATUTORIAL.Test_XYZ_PivotView:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_XYZ_PivotView_Factory, Test_XYZ_PivotView_Data in the package tilda_tutorial.data.
Configured to be Realized to TILDATUTORIAL • Test_XYZ_Realized through DB function TILDATUTORIAL • Refill_Test_XYZ_Realized().

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Defines a foreign key to TILDA • ZoneInfo

Description: A pivoted view of XYZ forms

This view depends on the following filter(s), sub-view(s), and/or root table(s):
TILDATUTORIAL • Test_XYZ_PivotView
Only look at XYZ forms and answers that have not been deleted.
    Form.type = 'XYZ'
and Form.deleted is null
and TestAnswer.deleted is null
    TILDATUTORIAL • Form
Root table for the view TILDATUTORIAL.Test_XYZ_PivotView
    TILDATUTORIAL • User
Standard join
    TILDATUTORIAL • TestAnswer
Standard join
A pivot was done as part of this view explicitly on the following columns and values:
questionId Question id
QX Question X
QY Question Y
QZ Question Z
This View contains the following columns:

Name   Type Nullable Realized Mode Invariant Protect Description

1   formRefnum   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Form • refnum

2   formType   String / varchar(40)   ☐   ☑   -   ☐   -   Form template type
→ TILDATUTORIAL • Form • type

3   formFillDateTZ   String / varchar(10)   ☑   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'formFillDate'.
→ TILDATUTORIAL • Form • fillDateTZ
→ TILDA • ZoneInfo • id

4   formFillDate   ZonedDateTime / timestamptz   ☑   ☑   -   ☐   -   The date the form was filled
→ TILDATUTORIAL • Form • fillDate

5   formUserRefnum   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • User • refnum

6   formUserEmail   String / varchar(255)   ☐   ☑   -   ☐   -   The user's email
→ TILDATUTORIAL • User • email

7   countCorrect   long / bigint   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

8   countIncorrect   long / bigint   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

9   timeMillisTotal   long / bigint   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

10   timeMillisAvg   double / double precision   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

11   timeMillisMin   int / integer   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

12   QX_correct   boolean / boolean   ☑   ☑   -   ☑   -   Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QX')

13   QX_timeMillis   int / integer   ☑   ☑   -   ☑   -   Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QX')

14   QY_correct   boolean / boolean   ☑   ☑   -   ☑   -   Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QY')

15   QY_timeMillis   int / integer   ☑   ☑   -   ☑   -   Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QY')

16   QZ_correct   boolean / boolean   ☑   ☑   -   ☑   -   Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QZ')

17   QZ_timeMillis   int / integer   ☑   ☑   -   ☑   -   Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QZ')
Test_View ^{details top}
The View TILDATUTORIAL.Test_View:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_View_Factory, Test_View_Data in the package tilda_tutorial.data.
Configured to be Realized to TILDATUTORIAL • Test_Realized through DB function TILDATUTORIAL • Refill_Test_Realized().

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Defines foreign key(s) to TILDA • ZoneInfo

Description: A pivoted view of SAT_01 forms

This view depends on the following filter(s), sub-view(s), and/or root table(s):
TILDATUTORIAL • Test_View
Look at all forms and answers that have not been deleted.
    Form.deleted is null
and TestAnswer.deleted is null
    TILDATUTORIAL • Form
Root table for the view TILDATUTORIAL.Test_View
    TILDATUTORIAL • User
Standard join
    TILDATUTORIAL • TestAnswer
Standard join
This View contains the following columns:

Name   Type Nullable Realized Mode Invariant Protect Description

1   type   String / varchar(40)   ☐   ☑   -   ☐   -   Form template type
→ TILDATUTORIAL • Form • type

2   testCount   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Form • refnum

3   testFirstTZ   String / varchar(10)   ☑   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'testFirst'.
→ TILDATUTORIAL • Form • fillDateTZ
→ TILDA • ZoneInfo • id

4   testFirst   ZonedDateTime / timestamptz   ☑   ☑   -   ☐   -   The date the form was filled
→ TILDATUTORIAL • Form • fillDate

5   testLastTZ   String / varchar(10)   ☑   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'testLast'.
→ TILDATUTORIAL • Form • fillDateTZ
→ TILDA • ZoneInfo • id

6   testLast   ZonedDateTime / timestamptz   ☑   ☑   -   ☐   -   The date the form was filled
→ TILDATUTORIAL • Form • fillDate

7   userCount   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • User • refnum

8   answerCount   long / bigint   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

9   answerCountCorrect   long / bigint   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

10   answerCountIncorrect   long / bigint   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • TestAnswer • correct

11   timeMillisTotal   long / bigint   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

12   timeMillisAvg   double / double precision   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

13   timeMillisMin   int / integer   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis

14   timeMillisMax   int / integer   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • TestAnswer • timeMillis
Test_XYZ_Analytics_View ^{details top}
The View TILDATUTORIAL.Test_XYZ_Analytics_View:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_XYZ_Analytics_View_Factory, Test_XYZ_Analytics_View_Data in the package tilda_tutorial.data.
Configured to be Realized to TILDATUTORIAL • Test_XYZ_Analytics_Realized through DB function TILDATUTORIAL • Refill_Test_XYZ_Analytics_Realized().

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Defines a foreign key to TILDA • ZoneInfo

Description: A view of XYZ forms with analytics

This view depends on the following filter(s), sub-view(s), and/or root table(s):
TILDATUTORIAL • Test_XYZ_Analytics_View
Unfiltered
    TILDATUTORIAL • Test_XYZ_PivotView
Only look at XYZ forms and answers that have not been deleted.
    Form.type = 'XYZ'
and Form.deleted is null
and TestAnswer.deleted is null
        TILDATUTORIAL • Form
Root table for the view TILDATUTORIAL.Test_XYZ_PivotView
        TILDATUTORIAL • User
Standard join
        TILDATUTORIAL • TestAnswer
Standard join
    TILDATUTORIAL • Test_View
Look at all forms and answers that have not been deleted.
    Form.deleted is null
and TestAnswer.deleted is null
        TILDATUTORIAL • Form
Root table for the view TILDATUTORIAL.Test_View
        TILDATUTORIAL • TestAnswer
Standard join
This View contains the following columns:
Name   Type Nullable Realized Mode Invariant Protect Description/Formula

1   formRefnum   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Test_XYZ_PivotView • formRefnum
→ TILDATUTORIAL • Form • refnum

2   formType   String / varchar(40)   ☐   ☑   -   ☐   -   Form template type
→ TILDATUTORIAL • Test_XYZ_PivotView • formType
→ TILDATUTORIAL • Form • type

3   formFillDateTZ   String / varchar(10)   ☑   ☑   AUTO   ☐   -   Generated helper column to hold the time zone ID for 'formFillDate'.
→ TILDATUTORIAL • Test_XYZ_PivotView • formFillDateTZ
→ TILDA • ZoneInfo • id

4   formFillDate   ZonedDateTime / timestamptz   ☑   ☑   -   ☐   -   The date the form was filled
→ TILDATUTORIAL • Test_XYZ_PivotView • formFillDate
→ TILDATUTORIAL • Form • fillDate

5   formUserRefnum   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Test_XYZ_PivotView • formUserRefnum
→ TILDATUTORIAL • User • refnum

6   formUserEmail   String / varchar(255)   ☐   ☑   -   ☐   -   The user's email
→ TILDATUTORIAL • Test_XYZ_PivotView • formUserEmail
→ TILDATUTORIAL • User • email

7   formCountCorrect   boolean / boolean   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • Test_XYZ_PivotView • countCorrect
→ TILDATUTORIAL • TestAnswer • correct

8   formTimeMillisTotal   long / bigint   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • Test_XYZ_PivotView • timeMillisTotal
→ TILDATUTORIAL • TestAnswer • timeMillis

9   testCount   long / bigint   ☐   ☑   -   ☑   -   The primary key for this record
→ TILDATUTORIAL • Test_View • testCount
→ TILDATUTORIAL • Form • refnum

10   testAnswerCountCorrect   boolean / boolean   ☐   ☑   -   ☐   -   Whether the answer is correct or not
→ TILDATUTORIAL • Test_View • answerCountCorrect
→ TILDATUTORIAL • TestAnswer • correct

11   testTimeMillisAvg   double / double precision   ☐   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question
→ TILDATUTORIAL • Test_View • timeMillisAvg
→ TILDATUTORIAL • TestAnswer • timeMillis

12   isPassed   int / integer   ☑   ☑   -   ☑   -   Formula column 'Test Passed'
Description Whether the test was passed or not by answering at least 2 out of the 3 questions.
Formula
formCountCorrect >= 2
Ref Columns formCountCorrect

→ TILDATUTORIAL • Test_XYZ_PivotView • countCorrect → TILDATUTORIAL • TestAnswer • correct

Whether the answer is correct or not
×
Formula Dependencies

Schema Table/View Column/Formula
13 tookLongerThanAverage int / integer ☑ ☑ - ☑ - Formula column 'Test Took Longer Than Average'
Description Whether the test took longer that the average time spent across all tests.
Formula
formTimeMillisTotal > testTimeMillisAvg
Ref Columns formTimeMillisTotal

→ TILDATUTORIAL • Test_XYZ_PivotView • timeMillisTotal → TILDATUTORIAL • TestAnswer • timeMillis

Time in milliseconds for the time spent answering the question
testTimeMillisAvg

→ TILDATUTORIAL • Test_View • timeMillisAvg → TILDATUTORIAL • TestAnswer • timeMillis

Time in milliseconds for the time spent answering the question
×
Formula Dependencies

Schema Table/View Column/Formula
14 wasChallenging int / integer ☑ ☑ - ☑ - Formula column 'Test Was Challenging'
Description Whether the test was challenging in that:

it was passed,

and overall, less than a third of answers across all tests were answered correctly.
Formula
    isPassed=1
AND testAnswerCountCorrect < testCount*3/2
Values

0 The test was not challenging

1 The test was challenging

Ref Columns testAnswerCountCorrect

  → TILDATUTORIAL • Test_View • answerCountCorrect   → TILDATUTORIAL • TestAnswer • correct

Whether the answer is correct or not
testCount

  → TILDATUTORIAL • Test_View • testCount   → TILDATUTORIAL • Form • refnum

The primary key for this record

Ref Formulas isPassed

  → TILDATUTORIAL • Test_XYZ_Analytics_View • isPassed

Whether the test was passed or not by answering at least 2 out of the 3 questions.
×
Formula Dependencies

Schema Table/View Column/Formula

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	formRefnum	long / bigint	☐	-	☑	-	The primary key for this record → TILDATUTORIAL • Form • refnum
2	formType	String / varchar(40)	☐	-	☐	-	Form template type → TILDATUTORIAL • Form • type
3	formFillDateTZ	String / character(5)	☑	AUTO	☐	-	Generated helper column to hold the time zone ID for 'formFillDate'. → TILDATUTORIAL • Form • fillDateTZ → TILDA • ZoneInfo • id
4	formFillDate	ZonedDateTime / timestamptz	☑	-	☐	-	The date the form was filled → TILDATUTORIAL • Form • fillDate
5	created	ZonedDateTime / timestamptz	☐	AUTO	☑	-	The timestamp for when the record was created. (TILDATUTORIAL.Form) → TILDATUTORIAL • Form • created
6	lastUpdated	ZonedDateTime / timestamptz	☐	AUTO	☐	-	The timestamp for when the record was last updated. (TILDATUTORIAL.Form) → TILDATUTORIAL • Form • lastUpdated
7	deleted	ZonedDateTime / timestamptz	☑	AUTO	☐	-	The timestamp for when the record was deleted. (TILDATUTORIAL.Form) → TILDATUTORIAL • Form • deleted
8	userRefnum	long / bigint	☐	-	☑	-	The primary key for this record → TILDATUTORIAL • User • refnum
9	userId	String / varchar(40)	☐	-	☐	-	The user's id → TILDATUTORIAL • User • id
10	timeMillis	int / integer	☐	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
11	correct	boolean / boolean	☐	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
12	questionLabel	String / varchar(256)	☐	-	☐	-	Question label → TILDATUTORIAL • TestQuestionAnswer • questionLabel
13	questionSeq	int / integer	☐	-	☐	-	Sequence of the question for the test → TILDATUTORIAL • TestQuestionAnswer • questionSeq
14	answerLabel	String / varchar(256)	☐	-	☐	-	Answer label → TILDATUTORIAL • TestQuestionAnswer • answerLabel

	Name	Type	Nullable	Realized	Mode	Invariant	Protect	Description
1	formRefnum	long / bigint	☐	☑	-	☑	-	The primary key for this record → TILDATUTORIAL • Form • refnum
2	formType	String / varchar(40)	☐	☑	-	☐	-	Form template type → TILDATUTORIAL • Form • type
3	formFillDateTZ	String / varchar(10)	☑	☑	AUTO	☐	-	Generated helper column to hold the time zone ID for 'formFillDate'. → TILDATUTORIAL • Form • fillDateTZ → TILDA • ZoneInfo • id
4	formFillDate	ZonedDateTime / timestamptz	☑	☑	-	☐	-	The date the form was filled → TILDATUTORIAL • Form • fillDate
5	formUserRefnum	long / bigint	☐	☑	-	☑	-	The primary key for this record → TILDATUTORIAL • User • refnum
6	formUserEmail	String / varchar(255)	☐	☑	-	☐	-	The user's email → TILDATUTORIAL • User • email
7	countCorrect	long / bigint	☐	☑	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
8	countIncorrect	long / bigint	☐	☑	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
9	timeMillisTotal	long / bigint	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
10	timeMillisAvg	double / double precision	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
11	timeMillisMin	int / integer	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
12	QX_correct	boolean / boolean	☑	☑	-	☑	-	Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QX')
13	QX_timeMillis	int / integer	☑	☑	-	☑	-	Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QX')
14	QY_correct	boolean / boolean	☑	☑	-	☑	-	Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QY')
15	QY_timeMillis	int / integer	☑	☑	-	☑	-	Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QY')
16	QZ_correct	boolean / boolean	☑	☑	-	☑	-	Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QZ')
17	QZ_timeMillis	int / integer	☑	☑	-	☑	-	Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QZ')

	Name	Type	Nullable	Realized	Mode	Invariant	Protect	Description
1	type	String / varchar(40)	☐	☑	-	☐	-	Form template type → TILDATUTORIAL • Form • type
2	testCount	long / bigint	☐	☑	-	☑	-	The primary key for this record → TILDATUTORIAL • Form • refnum
3	testFirstTZ	String / varchar(10)	☑	☑	AUTO	☐	-	Generated helper column to hold the time zone ID for 'testFirst'. → TILDATUTORIAL • Form • fillDateTZ → TILDA • ZoneInfo • id
4	testFirst	ZonedDateTime / timestamptz	☑	☑	-	☐	-	The date the form was filled → TILDATUTORIAL • Form • fillDate
5	testLastTZ	String / varchar(10)	☑	☑	AUTO	☐	-	Generated helper column to hold the time zone ID for 'testLast'. → TILDATUTORIAL • Form • fillDateTZ → TILDA • ZoneInfo • id
6	testLast	ZonedDateTime / timestamptz	☑	☑	-	☐	-	The date the form was filled → TILDATUTORIAL • Form • fillDate
7	userCount	long / bigint	☐	☑	-	☑	-	The primary key for this record → TILDATUTORIAL • User • refnum
8	answerCount	long / bigint	☐	☑	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
9	answerCountCorrect	long / bigint	☐	☑	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
10	answerCountIncorrect	long / bigint	☐	☑	-	☐	-	Whether the answer is correct or not → TILDATUTORIAL • TestAnswer • correct
11	timeMillisTotal	long / bigint	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
12	timeMillisAvg	double / double precision	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
13	timeMillisMin	int / integer	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis
14	timeMillisMax	int / integer	☐	☑	-	☐	-	Time in milliseconds for the time spent answering the question → TILDATUTORIAL • TestAnswer • timeMillis

Realized Views

Test_XYZ_Realized    ^{details    top}

The Table TILDATUTORIAL.Test_XYZ_Realized:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_XYZ_Realized_Factory, Test_XYZ_Realized_Data in the package tilda_tutorial.data.
Is Realized from TILDATUTORIAL • Test_XYZ_PivotView through DB function TILDATUTORIAL • Refill_Test_XYZ_Realized().

Is configured for normal read/write access.

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Defines foreign key(s) to TILDATUTORIAL • Form, TILDATUTORIAL • User

Has the following identity:
Primary Key: formRefnum

Description: Realized table for view TILDATUTORIAL.Test_XYZ_PivotView: A pivoted view of XYZ forms

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   formRefnum   long / bigint   ☐   -   ☑   -   The primary key for this record (from TILDATUTORIAL.Test_XYZ_PivotView.formRefnum)

2   formType   String / varchar(40)   ☑   -   ☐   -   Form template type (from TILDATUTORIAL.Test_XYZ_PivotView.formType)

3   formFillDateTZ   String / varchar(10)   ☑   -   ☐   -   Generated helper column to hold the time zone ID for 'formFillDate'. (from TILDATUTORIAL.Test_XYZ_PivotView.formFillDateTZ)

4   formFillDate   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled (from TILDATUTORIAL.Test_XYZ_PivotView.formFillDate)

5   formUserRefnum   long / bigint   ☑   -   ☐   -   The primary key for this record (from TILDATUTORIAL.Test_XYZ_PivotView.formUserRefnum)

6   formUserEmail   String / varchar(255)   ☑   -   ☐   -   The user's email (from TILDATUTORIAL.Test_XYZ_PivotView.formUserEmail)

7   countCorrect   long / bigint   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_PivotView.countCorrect)

8   countIncorrect   long / bigint   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_PivotView.countIncorrect)

9   timeMillisTotal   long / bigint   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisTotal)

10   timeMillisAvg   double / double precision   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisAvg)

11   timeMillisMin   int / integer   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisMin)

12   QX_correct   boolean / boolean   ☑   -   ☐   -   Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QX') (from TILDATUTORIAL.Test_XYZ_PivotView.QX_correct)

13   QX_timeMillis   int / integer   ☑   -   ☐   -   Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QX') (from TILDATUTORIAL.Test_XYZ_PivotView.QX_timeMillis)

14   QY_correct   boolean / boolean   ☑   -   ☐   -   Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QY') (from TILDATUTORIAL.Test_XYZ_PivotView.QY_correct)

15   QY_timeMillis   int / integer   ☑   -   ☐   -   Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QY') (from TILDATUTORIAL.Test_XYZ_PivotView.QY_timeMillis)

16   QZ_correct   boolean / boolean   ☑   -   ☐   -   Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QZ') (from TILDATUTORIAL.Test_XYZ_PivotView.QZ_correct)

17   QZ_timeMillis   int / integer   ☑   -   ☐   -   Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QZ') (from TILDATUTORIAL.Test_XYZ_PivotView.QZ_timeMillis)

Test_Realized    ^{details    top}

The Table TILDATUTORIAL.Test_Realized:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_Realized_Factory, Test_Realized_Data in the package tilda_tutorial.data.
Is Realized from TILDATUTORIAL • Test_View through DB function TILDATUTORIAL • Refill_Test_Realized().

Is configured for normal read/write access.

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Has the following identity:
Primary Key: type

Description: Realized table for view TILDATUTORIAL.Test_View: A pivoted view of SAT_01 forms

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   type   String / varchar(40)   ☐   -   ☑   -   Form template type (from TILDATUTORIAL.Test_View.type)

2   testCount   long / bigint   ☑   -   ☐   -   The primary key for this record (from TILDATUTORIAL.Test_View.testCount)

3   testFirstTZ   String / varchar(10)   ☑   -   ☐   -   Generated helper column to hold the time zone ID for 'testFirst'. (from TILDATUTORIAL.Test_View.testFirstTZ)

4   testFirst   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled (from TILDATUTORIAL.Test_View.testFirst)

5   testLastTZ   String / varchar(10)   ☑   -   ☐   -   Generated helper column to hold the time zone ID for 'testLast'. (from TILDATUTORIAL.Test_View.testLastTZ)

6   testLast   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled (from TILDATUTORIAL.Test_View.testLast)

7   userCount   long / bigint   ☑   -   ☐   -   The primary key for this record (from TILDATUTORIAL.Test_View.userCount)

8   answerCount   long / bigint   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCount)

9   answerCountCorrect   long / bigint   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCountCorrect)

10   answerCountIncorrect   long / bigint   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCountIncorrect)

11   timeMillisTotal   long / bigint   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisTotal)

12   timeMillisAvg   double / double precision   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisAvg)

13   timeMillisMin   int / integer   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisMin)

14   timeMillisMax   int / integer   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisMax)

Test_XYZ_Analytics_Realized    ^{details    top}

The Table TILDATUTORIAL.Test_XYZ_Analytics_Realized:

Is mapped to the generated Java 8/PostgreSQL Tilda classes Test_XYZ_Analytics_Realized_Factory, Test_XYZ_Analytics_Realized_Data in the package tilda_tutorial.data.
Is Realized from TILDATUTORIAL • Test_XYZ_Analytics_View through DB function TILDATUTORIAL • Refill_Test_XYZ_Analytics_Realized().

Is configured for normal read/write access.

Is not OCC-Enabled. No record lifecycle columns (created/updated/deleted) have been generated.

Defines foreign key(s) to TILDATUTORIAL • Form, TILDATUTORIAL • User

Has the following identity:
Primary Key: formRefnum

Description: Realized table for view TILDATUTORIAL.Test_XYZ_Analytics_View: A view of XYZ forms with analytics

This Table contains the following columns:

Name   Type Nullable Mode Invariant Protect Description

1   formRefnum   long / bigint   ☐   -   ☑   -   The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.formRefnum)

2   formType   String / varchar(40)   ☑   -   ☐   -   Form template type (from TILDATUTORIAL.Test_XYZ_Analytics_View.formType)

3   formFillDateTZ   String / varchar(10)   ☑   -   ☐   -   Generated helper column to hold the time zone ID for 'formFillDate'. (from TILDATUTORIAL.Test_XYZ_Analytics_View.formFillDateTZ)

4   formFillDate   ZonedDateTime / timestamptz   ☑   -   ☐   -   The date the form was filled (from TILDATUTORIAL.Test_XYZ_Analytics_View.formFillDate)

5   formUserRefnum   long / bigint   ☑   -   ☐   -   The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.formUserRefnum)

6   formUserEmail   String / varchar(255)   ☑   -   ☐   -   The user's email (from TILDATUTORIAL.Test_XYZ_Analytics_View.formUserEmail)

7   formCountCorrect   boolean / boolean   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_Analytics_View.formCountCorrect)

8   formTimeMillisTotal   long / bigint   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_Analytics_View.formTimeMillisTotal)

9   testCount   long / bigint   ☑   -   ☐   -   The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.testCount)

10   testAnswerCountCorrect   boolean / boolean   ☑   -   ☐   -   Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_Analytics_View.testAnswerCountCorrect)

11   testTimeMillisAvg   double / double precision   ☑   -   ☐   -   Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_Analytics_View.testTimeMillisAvg)

12   isPassed   int / integer   ☑   -   ☐   -   Formula column 'Test Passed' (from TILDATUTORIAL.Test_XYZ_Analytics_View.isPassed)
  → TILDATUTORIAL • Test_XYZ_Analytics_View • isPassed

13   tookLongerThanAverage   int / integer   ☑   -   ☐   -   Formula column 'Test Took Longer Than Average' (from TILDATUTORIAL.Test_XYZ_Analytics_View.tookLongerThanAverage)
  → TILDATUTORIAL • Test_XYZ_Analytics_View • tookLongerThanAverage

14   wasChallenging   int / integer   ☑   -   ☐   -   Formula column 'Test Was Challenging' (from TILDATUTORIAL.Test_XYZ_Analytics_View.wasChallenging)
  → TILDATUTORIAL • Test_XYZ_Analytics_View • wasChallenging

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	formRefnum	long / bigint	☐	-	☑	-	The primary key for this record (from TILDATUTORIAL.Test_XYZ_PivotView.formRefnum)
2	formType	String / varchar(40)	☑	-	☐	-	Form template type (from TILDATUTORIAL.Test_XYZ_PivotView.formType)
3	formFillDateTZ	String / varchar(10)	☑	-	☐	-	Generated helper column to hold the time zone ID for 'formFillDate'. (from TILDATUTORIAL.Test_XYZ_PivotView.formFillDateTZ)
4	formFillDate	ZonedDateTime / timestamptz	☑	-	☐	-	The date the form was filled (from TILDATUTORIAL.Test_XYZ_PivotView.formFillDate)
5	formUserRefnum	long / bigint	☑	-	☐	-	The primary key for this record (from TILDATUTORIAL.Test_XYZ_PivotView.formUserRefnum)
6	formUserEmail	String / varchar(255)	☑	-	☐	-	The user's email (from TILDATUTORIAL.Test_XYZ_PivotView.formUserEmail)
7	countCorrect	long / bigint	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_PivotView.countCorrect)
8	countIncorrect	long / bigint	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_PivotView.countIncorrect)
9	timeMillisTotal	long / bigint	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisTotal)
10	timeMillisAvg	double / double precision	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisAvg)
11	timeMillisMin	int / integer	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_PivotView.timeMillisMin)
12	QX_correct	boolean / boolean	☑	-	☐	-	Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QX') (from TILDATUTORIAL.Test_XYZ_PivotView.QX_correct)
13	QX_timeMillis	int / integer	☑	-	☐	-	Question X (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QX') (from TILDATUTORIAL.Test_XYZ_PivotView.QX_timeMillis)
14	QY_correct	boolean / boolean	☑	-	☐	-	Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QY') (from TILDATUTORIAL.Test_XYZ_PivotView.QY_correct)
15	QY_timeMillis	int / integer	☑	-	☐	-	Question Y (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QY') (from TILDATUTORIAL.Test_XYZ_PivotView.QY_timeMillis)
16	QZ_correct	boolean / boolean	☑	-	☐	-	Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.correct) on TILDATUTORIAL.TestAnswer.questionId='QZ') (from TILDATUTORIAL.Test_XYZ_PivotView.QZ_correct)
17	QZ_timeMillis	int / integer	☑	-	☐	-	Question Z (pivot of MAX(TILDATUTORIAL.TestAnswer.timeMillis) on TILDATUTORIAL.TestAnswer.questionId='QZ') (from TILDATUTORIAL.Test_XYZ_PivotView.QZ_timeMillis)

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	type	String / varchar(40)	☐	-	☑	-	Form template type (from TILDATUTORIAL.Test_View.type)
2	testCount	long / bigint	☑	-	☐	-	The primary key for this record (from TILDATUTORIAL.Test_View.testCount)
3	testFirstTZ	String / varchar(10)	☑	-	☐	-	Generated helper column to hold the time zone ID for 'testFirst'. (from TILDATUTORIAL.Test_View.testFirstTZ)
4	testFirst	ZonedDateTime / timestamptz	☑	-	☐	-	The date the form was filled (from TILDATUTORIAL.Test_View.testFirst)
5	testLastTZ	String / varchar(10)	☑	-	☐	-	Generated helper column to hold the time zone ID for 'testLast'. (from TILDATUTORIAL.Test_View.testLastTZ)
6	testLast	ZonedDateTime / timestamptz	☑	-	☐	-	The date the form was filled (from TILDATUTORIAL.Test_View.testLast)
7	userCount	long / bigint	☑	-	☐	-	The primary key for this record (from TILDATUTORIAL.Test_View.userCount)
8	answerCount	long / bigint	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCount)
9	answerCountCorrect	long / bigint	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCountCorrect)
10	answerCountIncorrect	long / bigint	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_View.answerCountIncorrect)
11	timeMillisTotal	long / bigint	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisTotal)
12	timeMillisAvg	double / double precision	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisAvg)
13	timeMillisMin	int / integer	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisMin)
14	timeMillisMax	int / integer	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_View.timeMillisMax)

	Name	Type	Nullable	Mode	Invariant	Protect	Description
1	formRefnum	long / bigint	☐	-	☑	-	The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.formRefnum)
2	formType	String / varchar(40)	☑	-	☐	-	Form template type (from TILDATUTORIAL.Test_XYZ_Analytics_View.formType)
3	formFillDateTZ	String / varchar(10)	☑	-	☐	-	Generated helper column to hold the time zone ID for 'formFillDate'. (from TILDATUTORIAL.Test_XYZ_Analytics_View.formFillDateTZ)
4	formFillDate	ZonedDateTime / timestamptz	☑	-	☐	-	The date the form was filled (from TILDATUTORIAL.Test_XYZ_Analytics_View.formFillDate)
5	formUserRefnum	long / bigint	☑	-	☐	-	The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.formUserRefnum)
6	formUserEmail	String / varchar(255)	☑	-	☐	-	The user's email (from TILDATUTORIAL.Test_XYZ_Analytics_View.formUserEmail)
7	formCountCorrect	boolean / boolean	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_Analytics_View.formCountCorrect)
8	formTimeMillisTotal	long / bigint	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_Analytics_View.formTimeMillisTotal)
9	testCount	long / bigint	☑	-	☐	-	The primary key for this record (from TILDATUTORIAL.Test_XYZ_Analytics_View.testCount)
10	testAnswerCountCorrect	boolean / boolean	☑	-	☐	-	Whether the answer is correct or not (from TILDATUTORIAL.Test_XYZ_Analytics_View.testAnswerCountCorrect)
11	testTimeMillisAvg	double / double precision	☑	-	☐	-	Time in milliseconds for the time spent answering the question (from TILDATUTORIAL.Test_XYZ_Analytics_View.testTimeMillisAvg)
12	isPassed	int / integer	☑	-	☐	-	Formula column 'Test Passed' (from TILDATUTORIAL.Test_XYZ_Analytics_View.isPassed) → TILDATUTORIAL • Test_XYZ_Analytics_View • isPassed
13	tookLongerThanAverage	int / integer	☑	-	☐	-	Formula column 'Test Took Longer Than Average' (from TILDATUTORIAL.Test_XYZ_Analytics_View.tookLongerThanAverage) → TILDATUTORIAL • Test_XYZ_Analytics_View • tookLongerThanAverage
14	wasChallenging	int / integer	☑	-	☐	-	Formula column 'Test Was Challenging' (from TILDATUTORIAL.Test_XYZ_Analytics_View.wasChallenging) → TILDATUTORIAL • Test_XYZ_Analytics_View • wasChallenging

Parallel Refill Schedule

Use the following grouping(s) if you want to refill all the realized tables in this schema and their dependencies. For example, you can execute in parallel (maybe from some ETL tool or Java code) all Refill functions from group 1, then all from group 2 etc...

Refill Calls Dependency Links Refill Dependencies From Prior Group

Group 1

select TILDATUTORIAL.Refill_Test_Realized();
select TILDATUTORIAL.Refill_Test_XYZ_Realized();
TILDATUTORIAL • Test_View
TILDATUTORIAL • Test_XYZ_PivotView

Group 2

select TILDATUTORIAL.Refill_Test_XYZ_Analytics_Realized();
TILDATUTORIAL • Test_XYZ_Analytics_View
TILDATUTORIAL.Refill_Test_Realized();
TILDATUTORIAL.Refill_Test_XYZ_Realized();

Refill Calls	Dependency Links	Refill Dependencies From Prior Group
Group 1
select TILDATUTORIAL.Refill_Test_Realized(); select TILDATUTORIAL.Refill_Test_XYZ_Realized();	TILDATUTORIAL • Test_View TILDATUTORIAL • Test_XYZ_PivotView
Group 2
select TILDATUTORIAL.Refill_Test_XYZ_Analytics_Realized();	TILDATUTORIAL • Test_XYZ_Analytics_View	TILDATUTORIAL.Refill_Test_Realized(); TILDATUTORIAL.Refill_Test_XYZ_Realized();

- End -

TILDATUTORIAL • TestAnswer_View	Look at all forms and answers that have not been deleted. Form.deleted is null and TestAnswer.deleted is null
TILDATUTORIAL • Form	Root table for the view TILDATUTORIAL.TestAnswer_View
TILDATUTORIAL • User	Standard join
TILDATUTORIAL • TestAnswer	Standard join
TILDATUTORIAL • TestQuestionAnswer	left join TILDATUTORIAL.TestQuestionAnswer on TestQuestionAnswer."questionId" = TestAnswer."questionId" and TestQuestionAnswer."answerId" = TestAnswer."answerId"

TILDATUTORIAL • Test_XYZ_PivotView	Only look at XYZ forms and answers that have not been deleted. Form.type = 'XYZ' and Form.deleted is null and TestAnswer.deleted is null
TILDATUTORIAL • Form	Root table for the view TILDATUTORIAL.Test_XYZ_PivotView
TILDATUTORIAL • User	Standard join
TILDATUTORIAL • TestAnswer	Standard join

questionId	Question id
	QX	Question X
	QY	Question Y
	QZ	Question Z

TILDATUTORIAL • Test_View	Look at all forms and answers that have not been deleted. Form.deleted is null and TestAnswer.deleted is null
TILDATUTORIAL • Form	Root table for the view TILDATUTORIAL.Test_View
TILDATUTORIAL • User	Standard join
TILDATUTORIAL • TestAnswer	Standard join

TILDATUTORIAL • Test_XYZ_Analytics_View	Unfiltered
TILDATUTORIAL • Test_XYZ_PivotView	Only look at XYZ forms and answers that have not been deleted. Form.type = 'XYZ' and Form.deleted is null and TestAnswer.deleted is null
TILDATUTORIAL • Form	Root table for the view TILDATUTORIAL.Test_XYZ_PivotView
TILDATUTORIAL • User	Standard join
TILDATUTORIAL • TestAnswer	Standard join
TILDATUTORIAL • Test_View	Look at all forms and answers that have not been deleted. Form.deleted is null and TestAnswer.deleted is null
TILDATUTORIAL • Form	Root table for the view TILDATUTORIAL.Test_View
TILDATUTORIAL • TestAnswer	Standard join

Schema TILDATUTORIAL

Tables

User details top

Form details top

TestQuestionAnswer details top

TestAnswer details top

Views

TestAnswer_View details top

Test_XYZ_PivotView details top

Test_View details top

Test_XYZ_Analytics_View details top

Formula Dependencies

Formula Dependencies

Formula Dependencies

Realized Views

Test_XYZ_Realized details top

Test_Realized details top

Test_XYZ_Analytics_Realized details top

Parallel Refill Schedule

User ^{details top}

Form ^{details top}

TestQuestionAnswer ^{details top}

TestAnswer ^{details top}

TestAnswer_View ^{details top}

Test_XYZ_PivotView ^{details top}

Test_View ^{details top}

Test_XYZ_Analytics_View ^{details top}

Test_XYZ_Realized ^{details top}

Test_Realized ^{details top}

Test_XYZ_Analytics_Realized ^{details top}