VRML Conferencing Members of the Terra Vista community are independandtly developing a wrap for a currently existing Conferencing community. This project will be developed, prototyped and developed over the next few months. This is a large project and can use as many helping hands as possible. It will be based on a premise of Adam Gruen's vCity. The Conference itself will be a portion of vCity and will be a Zone within Terra Vista. Each conference will be mirrored by a Segment within the Conference Zone. Each Segment will contain links to the related conference topics. The project will include the VisIt browser developed by John Gwinner. For more basics on how this will be developed, please go to the following link: Conference details Requested homes to be built Please contact the Terra Vista project if you are interested.
Hospitality World developers In conjunction with Pidwanger Productions, Terra Vista would like to announce thier co-operative project, Hospitality World. A Multi-User VRML 2.0 environment being developed for the Hospitality Industry. With the concept in his mind, Don Mayer of Pidwanger Productions was pointed to the Terra Vista community as a potential resource pool and example of how the concept may be put into place. After a short question and answer period, there appears to be a very good match between the Hospitality World concept and the Terra Vista community. It is viewed as a win-win for all involved. Don was a participant on the Irish Space project and brings his experience in co-operative VRML space building to his new project. Don is looking at creating a co-operative Zone within the Terra Vista environment. With this Zone and an offer from the Hospitality World members, there is quite a potential in this project. Along with the Zone, Don has proposed/offered the following: + A server on which to place Hospitality World and related/linked VRML environments + A limited release CD on which will reside a mirror of all related files and some complimentary software and items The benefit to Terra Vista will be increased exposure through links and references, increased land mass within the Terra Vista context, and benefit to Terra Vista members and participants in this project, through personal exposure. As Hospitality World will be a Zone managed by Don, all material which will be included in the Zone and the project must pass his inspection and approval. Once past that hurdle, the environments, etc will be put in queue to be released on the CD. This Zone and related sites will be MU VRML 2.0, with detail which will require a P100 minimum for processing. Please contact the Terra Vista project if you are interested.
Land Builders wanted The Terra Vista project is looking for individuals interested in Trail Blazing the new found land! The community project is looking for hard working individuals, willing to offer the time and effort to develop the new land that will be settled. Typing skills and access to a computer are necessary. Land development training is offered. Compensation is long term. Initially, the work will be voluntary. The benefits are learning how to create this new land. Longer term benefits are manyfold, as you learn the language and methods for creating these environments. Your talents will be very much in demand. Please contact the Terra Vista project if you are interested. Home Builders wanted The Terra Vista project is looking for individuals interested in Trail Blazing the new found land! The community project is looking for hard working individuals, willing to offer the time and effort to build homes upon the new land that is being developed. Typing skills and access to a computer are necessary. Home building training is offered. Compensation is long term. Initially, the work will be voluntary. The benefits are learning how to create these new homes. Longer term benefits are manyfold, as you learn the language and methods for creating these environments. Your talents will be very much in demand. Please contact the Terra Vista project if you are interested. Hi Touch environment seeks Hi Tech individuals Terra Vista project is seeking individuals who have a pinache for the abstract and a high sense of creativity. Individuals will be invited to develop methods of converting 2 dimensional data into 3 or more dimensional structures. Typing skills and access to a computer are necessary. Some training will be provided, though your ability to think within alternate realities is your long suit. Initial benefits are in the form of training and learning how to create these data structures. Long term benefits are tremendous as your learned skill will be very much in demand. Please contact the Terra Vista project for more information.
Back to Terra Vista
Mail me
if you are interested in providing opportunities within the community.
Warning:


{% extends 'base.html' %} {% block title %}Password reset Done{% endblock %} {% block content %}
Your password has been set. You may go ahead and sign in now.


A shell window
in Tycho provides a shell for interacting with
the Tcl interpreter. Note that Tk and Itcl are understood by
this interpreter, as are, of course, all Tycho commands.
If you are running a version of Tycho with Ptolemy attached,
the ptcl or pitcl commands are also understood.
(See the pitcl
page for more information).
By default, commands are executed at the global scope namespace
(::
),
but this can be changed by invoking the Set namespace
command in the Special
menu.
A shell windows is derived from the Edit window,
and therefore inherits all of its features.
This page documents the additional features provided.
Return
C-a
C-e
C-k
C-n or Down
C-p or Up
C-u
These bindings can be used to scroll back to previous commands, edit
them, and re-execute them. The bindings are designed to be maximally
convenient for single line commands, but they can still be used if the
commands themselves have multiple lines. However, it takes some
getting used to. In particular, C-p
will not move the
insertion cursor up one line a multi-line command, but rather will
erase the current command altogether and replace it with the previous
command in the command history. Similarly, C-n
will not
move down one line in a multi-line command. To edit a multi-line
command, use C-b
and C-f
or M-b
and
M-f
to move around within the command.
Note also that C-k
does not delete to the end of the current
line, but rather deletes to the end of the command.
The Shell window has a number of features designed to make it easier
to experiment with Tcl scripts. Foremost among these is the
history mechanism, which keeps a record of previously
executed commands. A Special
menu provides two commands
related to this:
Edit history
Clear history
Note that the Save As
command, unlike the
Edit History
command,
saves a snapshot of the previously executed command together with
the returned values and prompts.
Thus, it provides a mechanism for documenting an interaction
with the Tcl interpreter.
If a shell window has been designated "master" (using the -master
option), then it
will capture standard output generated by the Tcl puts
command, unless
that output is redirected to a file. If you start Tycho with a shell
window, that shell window is a master shell window.
Note that for output to appear in the master shell window it
may be necessary to call update
, update idletasks
,
::tycho::safeUpdate
.
A second feature of a master shell window is that when it is dismissed, the program is exited (after confirmation, of course).


Customize & reserve parking space as per company, staff etc.
View empty parking slots on your phone along with reports.
Customize & reserve parking space as per company, staff, pay-&-park, etc.
QR code-based passes are instantly auto-generated for a visitor.
Parking passes generated can be on pay-&-park or a monthly pay basis.
Integrate parking passes with access control system - boom barriers, biometrics, etc.
Display empty slot info such as floor and bay on LED screens in the parking bay.
Monitor security guards on duty and shift changes in the parking bay area.
Levy instant penalty tickets, if any person or vehicle is found guilty of any time or rule violation.
Most parking spaces, including MLCP buildings, are manually managed. This makes managing multi-tenant, multi-level car parking chaotic - a headache for parking lot owners and providers.
VersionX’s parking management system digitizes the end-to-end management of parking spaces and all parking processes related to visitors, vehicles, & payments.
It eliminates manual monitoring and tracking of vehicles. With VersionX smart parking management system, you can define and customize areas like paid, visitor, staff, tenants, etc.
Allocation of slots becomes easy. Live countdown of occupied versus unoccupied slots, filled versus unfilled slots, etc. can be displayed on a LED screen and on the phone.
Manage the entire parking area using your handheld device.
It is based on cloud and mobile technology, and therefore reduces manual errors.
Guards are made more accountable since the system cannot be tampered with.
The system requires minimal hardware for efficient functioning.
Guards are made more accountable since the system cannot be tampered with.
Built-in statistical tools help you use the data captured for further decision making.


To advance to Warsmith your level must be over 40 and you must possess the Mark of the Guildsman, the Mark of Prosperity, and the Mark of the Maestro.
You are obviously not yet qualified for this advancement! Come back when you have fulfilled the requirements and I will advance your occupation to Warsmith.


Toggle navigation
AWS Security Fundamentals
Home
cloudonaut.io
LinkedIn
Twitter
AWS Security Fundamentals
Exercise 1: IAM User
Exercise 2: IAM Policy
Exercise 3: CloudTrail
Exercise 4: Encrypt Data at Rest
Clean up


|
Ext.NET Mobile
4.1.0
.NET Component Framework for Enterprise Level Apps
|
Public Member Functions | |
| Builder (TCarousel component) | |
| virtual TBuilder | Direction (CarouselDirection direction) |
| The direction of the Carousel, either 'horizontal' or 'vertical'. Defaults to: 'horizontal'. More... | |
| virtual TBuilder | Indicator (bool? indicator) |
| Provides an indicator while toggling between child items to let the user know where they are in the card stack. Defaults to: true. More... | |
| virtual TBuilder | UI (CarouselUI uI) |
| Style options for Carousel. Default is 'Dark'. 'Light' is also available. More... | |
| virtual TBuilder | Next () |
| virtual TBuilder | Previous () |
| virtual TBuilder | SetDirection (CarouselDirection direction) |
| virtual TBuilder | SetIndicator (bool? indicator) |
| virtual TBuilder | SetUI (CarouselUI ui) |
| Builder () | |
| Builder (Carousel component) | |
| Builder (Carousel.Config config) | |
| Public Member Functions inherited from Ext.Net.Mobile.Container.Builder< TCarousel, TBuilder > | |
| Builder (TContainer component) | |
| Builder () | |
| Builder (Container component) | |
| Builder (Container.Config config) | |
| virtual TBuilder | Listeners (Action< ContainerListeners > action) |
| Client-side JavaScript Event Handlers More... | |
| virtual TBuilder | DirectEvents (Action< ContainerDirectEvents > action) |
| Server-side Ajax Event Handlers More... | |
Static Public Member Functions | |
| static implicit | operator Builder (Carousel component) |
| Static Public Member Functions inherited from Ext.Net.Mobile.Container.Builder< TCarousel, TBuilder > | |
| static implicit | operator Builder (Container component) |
|
inline |
|
inline |
|
inline |
|
inline |
|
inlinevirtual |
The direction of the Carousel, either 'horizontal' or 'vertical'. Defaults to: 'horizontal'.
|
inlinevirtual |
Provides an indicator while toggling between child items to let the user know where they are in the card stack. Defaults to: true.
|
inlinevirtual |
|
inlinestatic |
|
inlinevirtual |
|
inlinevirtual |
|
inlinevirtual |
|
inlinevirtual |
|
inlinevirtual |
Style options for Carousel. Default is 'Dark'. 'Light' is also available.


Lovren: I worked hard behind the scenes
Cape Town - Liverpool defender Dejan Lovren admits he had to go back to basics in a bid to force his way back into manager Jurgen Klopp's first-team plans.
Croatia international Lovren endured a frustrating 2018-19 campaign, as several niggling injuries meant he was only able to feature 18 times across all competitions.
That allowed the likes of Joel Matip and Joe Gomez to move ahead of him in the pecking order on Merseyside, and, despite being fit at the start of this season, the 30-year-old didn’t even make the matchday squad for the Reds’ opening six Premier League games.
However, an injury suffered by Matip and Gomez’s own fitness concerns have afforded Lovren a chance in the first team in recent weeks and he appears to have seized that opportunity after starting four of Liverpool’s last five top-flight games.
It has been a long road back for Lovren, but he believes he is now being rewarded for adopting a patient approach.
“I started from zero again to prove that I deserve to be in the first XI but that’s football,” Lovren told Sky Sports.
“When you’ve been out for months in the last season and didn’t have so many minutes on the pitch, it’s about restarting. In pre-season, I did hard work behind the scenes.”
Lovren was linked with a move away from Liverpool when his first-team opportunities looked limited during the summer, with clubs in Italy reportedly shown an interest, but he believes he ultimately made the right decision to remain with Klopp’s European champions.
He added: “I would ask myself if we didn’t win (last season’s Champions League final), should I stay or not and there was some interest with some other clubs but I had a good conversation with the manager.
“After that, the decision was easy so I stayed and I think we are on the right path to do something big this season again.”


| We're all developing something. Come join us in making
the future. |
|
|
|
|
|
The HPE Developer Community
|
|
|
|
Monthly #73
|
|
|
|
|
|
|
|
|
|
|
|
|
Celebrating HPE GreenLake Day for storage, in this
month’s newsletter we offer three exciting blog
posts focused on new things you can do with HPE
GreenLake Data Services Cloud Console.
Building off of some of the blog posts we featured
in last month’s newsletter, we continue the blog
series on open-sourcing our Workshops-on-Demand
infrastructure, the series on handling application
performance monitoring, and the one on addressing
hybrid cloud application challenges.
We also have
news on Chapel and the HPE Cray Programming
environment. Lastly, don’t forget to check out the
events section to see what topics will be covered in
our technology talks this month!
|
|
|
|
Visit
HPE Developer Community
|
|
|
|
|
|
|
|
|
|
|
|
Enabling a managed
Istio service mesh in a Kubernetes
cluster
|
|
|
|
Understand how to deploy a containerized app or a
managed service on a Kubernetes-based container
stack using the cluster add-on feature provided by
HPE GreenLake for Private Cloud Enterprise:
Containers and access it over an external network.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
HPE
to acquire OpsRamp, advancing hybrid cloud
leadership into ITOps
|
|
|
|
HPE just announced it has entered into an agreement
to acquire OpsRamp, an ITOps management company.
 Make sure to check
out our newest:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Leveraging tech to
address global challenges & health
|
|
|
April 19, 2023
5pm CET/ 8am PT
|
|
|
|
Digital transformation and partnerships can help
build a more sustainable and equitable world. Hear
about specific initiatives HPE is involved with to
achieve our mission of being able to advance the way
people live and work by addressing pressing global
challenges.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Divide and conquer
with Micro Frontends
|
|
|
April 26, 2023
5pm CET/ 8am PT
|
|
|
|
Explore micro frontends, a design paradigm that
extends the concepts of micro services to the
frontend world, helping to scale team development
processes in delivering complex applications. Learn
how it can also help transform legacy apps and guide
you on splitting teams to achieve your desired
results.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hewlett Packard Enterprise leads with
enterprise and open source solutions with the
expertise to help developers and
customers innovate and solve problems.
|
|
|
We're all developing something.
Come join us in making the future.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
View in
Browser
|
|
|
You received this email because you subscribed via
the HPE Developer website or had it forwarded from
someone who did. If
you have not yet subscribed but would like to, you
can do so
here.
We'll be sorry to see you go but you can
unsubscribe
instantly. You can also review your subscription
settings with us
on
this page.
Learn more about the
HPE
Privacy Policy.
HPE Developer and its accompanying resources are
part of Hewlett Packard Enterprise, LP.
|
|
|
|


sug white
Explorer
Home
Wallet
NETWORK
Error, yay ∠( ᐛ 」∠)
Search!
Circulating supply:
Loading...
Height
Time
Hash
Transactions
Load more
Load more
Outputs:
0
Inputs:
0
Transactions:
0
Load more
×


{% load invoice_tags %}
| Invoice | Created | Amount | Sent | Paid | Actions |
|---|---|---|---|---|---|
| {{ invoice }} | {{ invoice.created.date }} | £{{ invoice.total|default:0|floatformat:2 }} | done{% else %} grey-text">clear{% endif %} | done{% else %} grey-text">clear{% endif %} | {% include 'helpers/table_buttons.html' with type='invoice' item=invoice %} |


Home
Gallery
Gmax
Youtube
MEMORIES OF 26/02/2017
I love you guys ❤
Here's Jeremy's video of the day spent together with Jap Group:


Click on the product, out of the three displayed that you would be most likely to purchase.You will be shown 25 screens of random products.


Clare Balding leads new BT campaign to show more women's football in UK pubs
The Red Lion in the City of London has been transformed to the Red Lioness as part of a new BT Sport initiative
by Matt Lawless, https://www.facebook.com/MattLawlessMirror/A London pub has received a radical makeover to promote women’s football.
The Red Lion boozer in the City has been aptly re-named The Red Lioness for the next week and decorated with memorabilia, trophies and iconic photography.
It is part of a major BT Sport initiative to increase the profile of the game domestically, with 750 Greene King venues around the country signing up to a pledge to showcase some of the top women’s matches.
The Red Lioness will host a number of events to celebrate and promote women’s football with BT Sport’s women’s football experts.
And it includes a screening of this weekend’s North London Derby between Tottenham Hotspur and Arsenal Women - the first WSL match to be played at the new Tottenham Hotspur Stadium.
BT Sport presenter Clare Balding is among the high profile names - including Arsenal striker Danielle Carter and Reading midfielder Fara Williams - backing the campaign to show more women’s football in pubs.
“I love the new branding of the Red Lion as the Red Lioness as it amplifies the support for the Lionesses as they expand their fan base,” she said, speaking before England were beaten 2-1 against Germany in front of 90,000 fans at Wembley.
"The sold out game at Wembley is just the start of a major wave of support for the women’s game in this country.
"Pubs have always been a place where people congregate to watch football and I hope many more will join the Red Lioness Pledge.”
This season is BT Sport’s biggest season of women’s football yet, with more matches than ever before.
Over the whole campaign, they will broadcast at least 30 live women’s football matches - including the Lionesses, Barclays FA Women’s Super League, FA Women’s Continental League Cup and the Women’s FA Cup.
Pete Jeavons, marketing communications director, BT, said: “BT is proud to have broadcast women’s football since 2013 and we are committed to helping grow the women’s game.
"We would encourage any football fans to visit the Red Lioness and take in some fantastic experiences over the coming days.”


Why does the "Optimize Now" column say N/A after I have installed RooJet?
RooJet runs on a schedule of every hour to analyze and suggest new optimized prices. If you would like to override this you may use the checkboxes on the left of your products and then click “Optimize Prices” at the bottom right of your dashboard. You can then either choose the products you would like to update or click “Back to Dashboard”
The “Optimized Price” column says “More Data Needed” for my products that do not have any sales.
Yes - RooJet needs at least one sale to feed our prediction engine in order to predict the next best optimized price for that item.
Where does RooJet get the data?
We connect your RooJet account to the Shopify API to analyze your unique data and make specific pricing predictions for your store.
Will RooJet ever price below my cost?
No - you are able to set your cost of good in your dashboard so that RooJet will never price your products at a loss.
How Long does RooJet take?
It all depends, but the more volume your store does, the faster the data will be able to be optimized.
How long is my free trial?
Every new RooJet account enjoys a 10 day free trial.
How do I upgrade my RooJet account to handle more products?
Please click on the Account and choose the appropriate plan.
I have more questions - who should I contact?
Please feel free to ask any questions you may have to scott@roojet.com


| BASE TABLE | patient | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | patient | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | patient | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | patient | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | patient | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | patient | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | patient | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | patient | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | patient | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | patient | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | patient | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | patient | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | patient | id | int(11) | NO | Primary key (patient ID) on the source tablet device |
| BASE TABLE | patient | forename | varchar(255) | NO | Forename |
| BASE TABLE | patient | surname | varchar(255) | NO | Surname |
| BASE TABLE | patient | dob | varchar(32) | NO | Date of birth |
| BASE TABLE | patient | sex | varchar(1) | NO | Sex (M, F) |
| BASE TABLE | patient | address | text | YES | Address |
| BASE TABLE | patient | gp | text | YES | General practitioner (GP) |
| BASE TABLE | patient | other | text | YES | Other details |
| BASE TABLE | patient | idnum1 | int(11) | YES | ID number 1 |
| BASE TABLE | patient | iddesc1 | varchar(255) | YES | ID description 1 |
| BASE TABLE | patient | idshortdesc1 | varchar(255) | YES | ID short description 1 |
| BASE TABLE | patient | idnum2 | int(11) | YES | ID number 2 |
| BASE TABLE | patient | iddesc2 | varchar(255) | YES | ID description 2 |
| BASE TABLE | patient | idshortdesc2 | varchar(255) | YES | ID short description 2 |
| BASE TABLE | patient | idnum3 | int(11) | YES | ID number 3 |
| BASE TABLE | patient | iddesc3 | varchar(255) | YES | ID description 3 |
| BASE TABLE | patient | idshortdesc3 | varchar(255) | YES | ID short description 3 |
| BASE TABLE | patient | idnum4 | int(11) | YES | ID number 4 |
| BASE TABLE | patient | iddesc4 | varchar(255) | YES | ID description 4 |
| BASE TABLE | patient | idshortdesc4 | varchar(255) | YES | ID short description 4 |
| BASE TABLE | patient | idnum5 | int(11) | YES | ID number 5 |
| BASE TABLE | patient | iddesc5 | varchar(255) | YES | ID description 5 |
| BASE TABLE | patient | idshortdesc5 | varchar(255) | YES | ID short description 5 |
| BASE TABLE | patient | idnum6 | int(11) | YES | ID number 6 |
| BASE TABLE | patient | iddesc6 | varchar(255) | YES | ID description 6 |
| BASE TABLE | patient | idshortdesc6 | varchar(255) | YES | ID short description 6 |
| BASE TABLE | patient | idnum7 | int(11) | YES | ID number 7 |
| BASE TABLE | patient | iddesc7 | varchar(255) | YES | ID description 7 |
| BASE TABLE | patient | idshortdesc7 | varchar(255) | YES | ID short description 7 |
| BASE TABLE | patient | idnum8 | int(11) | YES | ID number 8 |
| BASE TABLE | patient | iddesc8 | varchar(255) | YES | ID description 8 |
| BASE TABLE | patient | idshortdesc8 | varchar(255) | YES | ID short description 8 |
| BASE TABLE | pclc | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | pclc | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | pclc | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | pclc | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | pclc | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | pclc | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | pclc | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | pclc | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | pclc | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | pclc | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | pclc | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | pclc | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | pclc | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | pclc | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | pclc | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | pclc | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | pclc | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | pclc | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | pclc | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | pclc | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | pclc | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | pclc | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | pclc | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | pclc | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | pclc | q1 | int(11) | YES | |
| BASE TABLE | pclc | q2 | int(11) | YES | |
| BASE TABLE | pclc | q3 | int(11) | YES | |
| BASE TABLE | pclc | q4 | int(11) | YES | |
| BASE TABLE | pclc | q5 | int(11) | YES | |
| BASE TABLE | pclc | q6 | int(11) | YES | |
| BASE TABLE | pclc | q7 | int(11) | YES | |
| BASE TABLE | pclc | q8 | int(11) | YES | |
| BASE TABLE | pclc | q9 | int(11) | YES | |
| BASE TABLE | pclc | q10 | int(11) | YES | |
| BASE TABLE | pclc | q11 | int(11) | YES | |
| BASE TABLE | pclc | q12 | int(11) | YES | |
| BASE TABLE | pclc | q13 | int(11) | YES | |
| BASE TABLE | pclc | q14 | int(11) | YES | |
| BASE TABLE | pclc | q15 | int(11) | YES | |
| BASE TABLE | pclc | q16 | int(11) | YES | |
| BASE TABLE | pclc | q17 | int(11) | YES | |
| BASE TABLE | pclm | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | pclm | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | pclm | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | pclm | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | pclm | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | pclm | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | pclm | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | pclm | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | pclm | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | pclm | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | pclm | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | pclm | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | pclm | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | pclm | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | pclm | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | pclm | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | pclm | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | pclm | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | pclm | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | pclm | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | pclm | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | pclm | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | pclm | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | pclm | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | pclm | q1 | int(11) | YES | |
| BASE TABLE | pclm | q2 | int(11) | YES | |
| BASE TABLE | pclm | q3 | int(11) | YES | |
| BASE TABLE | pclm | q4 | int(11) | YES | |
| BASE TABLE | pclm | q5 | int(11) | YES | |
| BASE TABLE | pclm | q6 | int(11) | YES | |
| BASE TABLE | pclm | q7 | int(11) | YES | |
| BASE TABLE | pclm | q8 | int(11) | YES | |
| BASE TABLE | pclm | q9 | int(11) | YES | |
| BASE TABLE | pclm | q10 | int(11) | YES | |
| BASE TABLE | pclm | q11 | int(11) | YES | |
| BASE TABLE | pclm | q12 | int(11) | YES | |
| BASE TABLE | pclm | q13 | int(11) | YES | |
| BASE TABLE | pclm | q14 | int(11) | YES | |
| BASE TABLE | pclm | q15 | int(11) | YES | |
| BASE TABLE | pclm | q16 | int(11) | YES | |
| BASE TABLE | pclm | q17 | int(11) | YES | |
| BASE TABLE | pcls | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | pcls | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | pcls | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | pcls | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | pcls | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | pcls | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | pcls | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | pcls | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | pcls | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | pcls | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | pcls | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | pcls | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | pcls | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | pcls | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | pcls | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | pcls | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | pcls | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | pcls | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | pcls | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | pcls | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | pcls | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | pcls | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | pcls | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | pcls | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | pcls | q1 | int(11) | YES | |
| BASE TABLE | pcls | q2 | int(11) | YES | |
| BASE TABLE | pcls | q3 | int(11) | YES | |
| BASE TABLE | pcls | q4 | int(11) | YES | |
| BASE TABLE | pcls | q5 | int(11) | YES | |
| BASE TABLE | pcls | q6 | int(11) | YES | |
| BASE TABLE | pcls | q7 | int(11) | YES | |
| BASE TABLE | pcls | q8 | int(11) | YES | |
| BASE TABLE | pcls | q9 | int(11) | YES | |
| BASE TABLE | pcls | q10 | int(11) | YES | |
| BASE TABLE | pcls | q11 | int(11) | YES | |
| BASE TABLE | pcls | q12 | int(11) | YES | |
| BASE TABLE | pcls | q13 | int(11) | YES | |
| BASE TABLE | pcls | q14 | int(11) | YES | |
| BASE TABLE | pcls | q15 | int(11) | YES | |
| BASE TABLE | pcls | q16 | int(11) | YES | |
| BASE TABLE | pcls | q17 | int(11) | YES | |
| BASE TABLE | pcls | event | text | YES | |
| BASE TABLE | pcls | eventdate | text | YES | |
| BASE TABLE | photo | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | photo | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | photo | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | photo | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | photo | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | photo | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | photo | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | photo | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | photo | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | photo | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | photo | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | photo | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | photo | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | photo | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | photo | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | photo | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | photo | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | photo | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | photo | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | photo | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | photo | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | photo | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | photo | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | photo | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | photo | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | photo | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | photo | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | photo | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | photo | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | photo | description | text | YES | Description of the photograph |
| BASE TABLE | photo | photo_blobid | int(11) | YES | ID of the BLOB (foreign key to blobs.id, given matching device and current/frozen record status) |
| BASE TABLE | photo | rotation | int(11) | YES | Rotation (clockwise, in degrees) to be applied for viewing |
| BASE TABLE | photosequence | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | photosequence | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | photosequence | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | photosequence | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | photosequence | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | photosequence | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | photosequence | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | photosequence | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | photosequence | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | photosequence | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | photosequence | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | photosequence | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | photosequence | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | photosequence | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | photosequence | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | photosequence | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | photosequence | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | photosequence | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | photosequence | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | photosequence | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | photosequence | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | photosequence | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | photosequence | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | photosequence | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | photosequence | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | photosequence | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | photosequence | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | photosequence | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | photosequence | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | photosequence | sequence_description | text | YES | Description of the sequence of photographs |
| BASE TABLE | photosequence_photos | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | photosequence_photos | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | photosequence_photos | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | photosequence_photos | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | photosequence_photos | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | photosequence_photos | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | photosequence_photos | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | photosequence_photos | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | photosequence_photos | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | photosequence_photos | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | photosequence_photos | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | photosequence_photos | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | photosequence_photos | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | photosequence_photos | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | photosequence_photos | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | photosequence_photos | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | photosequence_photos | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | photosequence_photos | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | photosequence_photos | id | int(11) | NO | (ANCILLARY) Primary key on the tablet device |
| BASE TABLE | photosequence_photos | photosequence_id | int(11) | NO | |
| BASE TABLE | photosequence_photos | seqnum | int(11) | NO | |
| BASE TABLE | photosequence_photos | description | text | YES | Description of the photograph |
| BASE TABLE | photosequence_photos | photo_blobid | int(11) | YES | ID of the BLOB (foreign key to blobs.id, given matching device and current/frozen record status) |
| BASE TABLE | photosequence_photos | rotation | int(11) | YES | Rotation (clockwise, in degrees) to be applied for viewing |
| BASE TABLE | phq15 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | phq15 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | phq15 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | phq15 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | phq15 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | phq15 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | phq15 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | phq15 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | phq15 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | phq15 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | phq15 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | phq15 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | phq15 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | phq15 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | phq15 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | phq15 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | phq15 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | phq15 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | phq15 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | phq15 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | phq15 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | phq15 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | phq15 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | phq15 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | phq15 | q1 | int(11) | YES | |
| BASE TABLE | phq15 | q2 | int(11) | YES | |
| BASE TABLE | phq15 | q3 | int(11) | YES | |
| BASE TABLE | phq15 | q4 | int(11) | YES | |
| BASE TABLE | phq15 | q5 | int(11) | YES | |
| BASE TABLE | phq15 | q6 | int(11) | YES | |
| BASE TABLE | phq15 | q7 | int(11) | YES | |
| BASE TABLE | phq15 | q8 | int(11) | YES | |
| BASE TABLE | phq15 | q9 | int(11) | YES | |
| BASE TABLE | phq15 | q10 | int(11) | YES | |
| BASE TABLE | phq15 | q11 | int(11) | YES | |
| BASE TABLE | phq15 | q12 | int(11) | YES | |
| BASE TABLE | phq15 | q13 | int(11) | YES | |
| BASE TABLE | phq15 | q14 | int(11) | YES | |
| BASE TABLE | phq15 | q15 | int(11) | YES | |
| BASE TABLE | phq15_SUMMARY_TEMP | phq15_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | phq15_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | phq15_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | phq15_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | phq15_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | phq15_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | phq9 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | phq9 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | phq9 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | phq9 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | phq9 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | phq9 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | phq9 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | phq9 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | phq9 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | phq9 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | phq9 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | phq9 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | phq9 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | phq9 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | phq9 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | phq9 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | phq9 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | phq9 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | phq9 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | phq9 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | phq9 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | phq9 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | phq9 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | phq9 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | phq9 | q1 | int(11) | YES | |
| BASE TABLE | phq9 | q2 | int(11) | YES | |
| BASE TABLE | phq9 | q3 | int(11) | YES | |
| BASE TABLE | phq9 | q4 | int(11) | YES | |
| BASE TABLE | phq9 | q5 | int(11) | YES | |
| BASE TABLE | phq9 | q6 | int(11) | YES | |
| BASE TABLE | phq9 | q7 | int(11) | YES | |
| BASE TABLE | phq9 | q8 | int(11) | YES | |
| BASE TABLE | phq9 | q9 | int(11) | YES | |
| BASE TABLE | phq9 | q10 | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | phq9_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | phq9_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | phq9_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | phq9_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | phq9_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | n_core | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | n_other | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | n_total | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | is_mds | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | is_ods | int(11) | YES | |
| BASE TABLE | phq9_SUMMARY_TEMP | severity | text | YES | |
| BASE TABLE | progressnote | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | progressnote | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | progressnote | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | progressnote | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | progressnote | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | progressnote | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | progressnote | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | progressnote | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | progressnote | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | progressnote | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | progressnote | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | progressnote | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | progressnote | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | progressnote | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | progressnote | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | progressnote | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | progressnote | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | progressnote | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | progressnote | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | progressnote | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | progressnote | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | progressnote | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | progressnote | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | progressnote | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | progressnote | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | progressnote | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | progressnote | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | progressnote | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | progressnote | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | progressnote | location | text | YES | Location |
| BASE TABLE | progressnote | note | text | YES | Clinical note |
| BASE TABLE | psychiatricclerking | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | psychiatricclerking | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | psychiatricclerking | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | psychiatricclerking | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | psychiatricclerking | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | psychiatricclerking | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | psychiatricclerking | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | psychiatricclerking | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | psychiatricclerking | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | psychiatricclerking | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | psychiatricclerking | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | psychiatricclerking | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | psychiatricclerking | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | psychiatricclerking | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | psychiatricclerking | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | psychiatricclerking | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | psychiatricclerking | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | psychiatricclerking | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | psychiatricclerking | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | psychiatricclerking | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | psychiatricclerking | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | psychiatricclerking | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | psychiatricclerking | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | psychiatricclerking | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | psychiatricclerking | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | psychiatricclerking | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | psychiatricclerking | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | psychiatricclerking | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | psychiatricclerking | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | psychiatricclerking | location | text | YES | |
| BASE TABLE | psychiatricclerking | contact_type | text | YES | |
| BASE TABLE | psychiatricclerking | reason_for_contact | text | YES | |
| BASE TABLE | psychiatricclerking | presenting_issue | text | YES | |
| BASE TABLE | psychiatricclerking | systems_review | text | YES | |
| BASE TABLE | psychiatricclerking | collateral_history | text | YES | |
| BASE TABLE | psychiatricclerking | diagnoses_psychiatric | text | YES | |
| BASE TABLE | psychiatricclerking | diagnoses_medical | text | YES | |
| BASE TABLE | psychiatricclerking | operations_procedures | text | YES | |
| BASE TABLE | psychiatricclerking | allergies_adverse_reactions | text | YES | |
| BASE TABLE | psychiatricclerking | medications | text | YES | |
| BASE TABLE | psychiatricclerking | recreational_drug_use | text | YES | |
| BASE TABLE | psychiatricclerking | family_history | text | YES | |
| BASE TABLE | psychiatricclerking | developmental_history | text | YES | |
| BASE TABLE | psychiatricclerking | personal_history | text | YES | |
| BASE TABLE | psychiatricclerking | premorbid_personality | text | YES | |
| BASE TABLE | psychiatricclerking | forensic_history | text | YES | |
| BASE TABLE | psychiatricclerking | current_social_situation | text | YES | |
| BASE TABLE | psychiatricclerking | mse_appearance_behaviour | text | YES | |
| BASE TABLE | psychiatricclerking | mse_speech | text | YES | |
| BASE TABLE | psychiatricclerking | mse_mood_subjective | text | YES | |
| BASE TABLE | psychiatricclerking | mse_mood_objective | text | YES | |
| BASE TABLE | psychiatricclerking | mse_thought_form | text | YES | |
| BASE TABLE | psychiatricclerking | mse_thought_content | text | YES | |
| BASE TABLE | psychiatricclerking | mse_perception | text | YES | |
| BASE TABLE | psychiatricclerking | mse_cognition | text | YES | |
| BASE TABLE | psychiatricclerking | mse_insight | text | YES | |
| BASE TABLE | psychiatricclerking | physical_examination_general | text | YES | |
| BASE TABLE | psychiatricclerking | physical_examination_cardiovascular | text | YES | |
| BASE TABLE | psychiatricclerking | physical_examination_respiratory | text | YES | |
| BASE TABLE | psychiatricclerking | physical_examination_abdominal | text | YES | |
| BASE TABLE | psychiatricclerking | physical_examination_neurological | text | YES | |
| BASE TABLE | psychiatricclerking | assessment_scales | text | YES | |
| BASE TABLE | psychiatricclerking | investigations_results | text | YES | |
| BASE TABLE | psychiatricclerking | safety_alerts | text | YES | |
| BASE TABLE | psychiatricclerking | risk_assessment | text | YES | |
| BASE TABLE | psychiatricclerking | relevant_legal_information | text | YES | |
| BASE TABLE | psychiatricclerking | current_problems | text | YES | |
| BASE TABLE | psychiatricclerking | patient_carer_concerns | text | YES | |
| BASE TABLE | psychiatricclerking | impression | text | YES | |
| BASE TABLE | psychiatricclerking | management_plan | text | YES | |
| BASE TABLE | psychiatricclerking | information_given | text | YES | |
| BASE TABLE | qolbasic | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | qolbasic | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | qolbasic | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | qolbasic | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | qolbasic | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | qolbasic | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | qolbasic | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | qolbasic | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | qolbasic | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | qolbasic | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | qolbasic | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | qolbasic | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | qolbasic | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | qolbasic | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | qolbasic | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | qolbasic | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | qolbasic | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | qolbasic | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | qolbasic | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | qolbasic | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | qolbasic | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | qolbasic | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | qolbasic | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | qolbasic | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | qolbasic | tto | double | YES | |
| BASE TABLE | qolbasic | rs | double | YES | |
| BASE TABLE | qolbasic_SUMMARY_TEMP | qolbasic_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | qolbasic_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | qolbasic_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | qolbasic_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | qolbasic_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | qolbasic_SUMMARY_TEMP | tto_qol | double | YES | |
| BASE TABLE | qolbasic_SUMMARY_TEMP | rs_qol | double | YES | |
| BASE TABLE | qolsg | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | qolsg | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | qolsg | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | qolsg | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | qolsg | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | qolsg | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | qolsg | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | qolsg | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | qolsg | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | qolsg | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | qolsg | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | qolsg | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | qolsg | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | qolsg | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | qolsg | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | qolsg | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | qolsg | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | qolsg | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | qolsg | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | qolsg | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | qolsg | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | qolsg | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | qolsg | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | qolsg | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | qolsg | category_start_time | text | YES | |
| BASE TABLE | qolsg | category_responded | int(11) | YES | |
| BASE TABLE | qolsg | category_response_time | text | YES | |
| BASE TABLE | qolsg | category_chosen | text | YES | |
| BASE TABLE | qolsg | gamble_fixed_option | text | YES | |
| BASE TABLE | qolsg | gamble_lottery_option_p | text | YES | |
| BASE TABLE | qolsg | gamble_lottery_option_q | text | YES | |
| BASE TABLE | qolsg | gamble_lottery_on_left | int(11) | YES | |
| BASE TABLE | qolsg | gamble_starting_p | double | YES | |
| BASE TABLE | qolsg | gamble_start_time | text | YES | |
| BASE TABLE | qolsg | gamble_responded | int(11) | YES | |
| BASE TABLE | qolsg | gamble_response_time | text | YES | |
| BASE TABLE | qolsg | gamble_p | double | YES | |
| BASE TABLE | qolsg | utility | double | YES | |
| BASE TABLE | rand36 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | rand36 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | rand36 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | rand36 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | rand36 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | rand36 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | rand36 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | rand36 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | rand36 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | rand36 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | rand36 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | rand36 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | rand36 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | rand36 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | rand36 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | rand36 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | rand36 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | rand36 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | rand36 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | rand36 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | rand36 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | rand36 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | rand36 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | rand36 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | rand36 | q1 | int(11) | YES | |
| BASE TABLE | rand36 | q2 | int(11) | YES | |
| BASE TABLE | rand36 | q3 | int(11) | YES | |
| BASE TABLE | rand36 | q4 | int(11) | YES | |
| BASE TABLE | rand36 | q5 | int(11) | YES | |
| BASE TABLE | rand36 | q6 | int(11) | YES | |
| BASE TABLE | rand36 | q7 | int(11) | YES | |
| BASE TABLE | rand36 | q8 | int(11) | YES | |
| BASE TABLE | rand36 | q9 | int(11) | YES | |
| BASE TABLE | rand36 | q10 | int(11) | YES | |
| BASE TABLE | rand36 | q11 | int(11) | YES | |
| BASE TABLE | rand36 | q12 | int(11) | YES | |
| BASE TABLE | rand36 | q13 | int(11) | YES | |
| BASE TABLE | rand36 | q14 | int(11) | YES | |
| BASE TABLE | rand36 | q15 | int(11) | YES | |
| BASE TABLE | rand36 | q16 | int(11) | YES | |
| BASE TABLE | rand36 | q17 | int(11) | YES | |
| BASE TABLE | rand36 | q18 | int(11) | YES | |
| BASE TABLE | rand36 | q19 | int(11) | YES | |
| BASE TABLE | rand36 | q20 | int(11) | YES | |
| BASE TABLE | rand36 | q21 | int(11) | YES | |
| BASE TABLE | rand36 | q22 | int(11) | YES | |
| BASE TABLE | rand36 | q23 | int(11) | YES | |
| BASE TABLE | rand36 | q24 | int(11) | YES | |
| BASE TABLE | rand36 | q25 | int(11) | YES | |
| BASE TABLE | rand36 | q26 | int(11) | YES | |
| BASE TABLE | rand36 | q27 | int(11) | YES | |
| BASE TABLE | rand36 | q28 | int(11) | YES | |
| BASE TABLE | rand36 | q29 | int(11) | YES | |
| BASE TABLE | rand36 | q30 | int(11) | YES | |
| BASE TABLE | rand36 | q31 | int(11) | YES | |
| BASE TABLE | rand36 | q32 | int(11) | YES | |
| BASE TABLE | rand36 | q33 | int(11) | YES | |
| BASE TABLE | rand36 | q34 | int(11) | YES | |
| BASE TABLE | rand36 | q35 | int(11) | YES | |
| BASE TABLE | rand36 | q36 | int(11) | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | rand36_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | rand36_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | rand36_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | rand36_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | rand36_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | overall | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | physical_functioning | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | role_limitations_physical | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | role_limitations_emotional | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | energy | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | emotional_wellbeing | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | social_functioning | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | pain | double | YES | |
| BASE TABLE | rand36_SUMMARY_TEMP | general_health | double | YES | |
| BASE TABLE | slums | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | slums | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | slums | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | slums | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | slums | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | slums | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | slums | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | slums | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | slums | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | slums | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | slums | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | slums | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | slums | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | slums | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | slums | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | slums | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | slums | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | slums | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | slums | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | slums | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | slums | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | slums | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | slums | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | slums | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | slums | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | slums | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | slums | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | slums | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | slums | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | slums | alert | int(11) | YES | |
| BASE TABLE | slums | highschooleducation | int(11) | YES | |
| BASE TABLE | slums | q1 | int(11) | YES | |
| BASE TABLE | slums | q2 | int(11) | YES | |
| BASE TABLE | slums | q3 | int(11) | YES | |
| BASE TABLE | slums | q5a | int(11) | YES | |
| BASE TABLE | slums | q5b | int(11) | YES | |
| BASE TABLE | slums | q6 | int(11) | YES | |
| BASE TABLE | slums | q7a | int(11) | YES | |
| BASE TABLE | slums | q7b | int(11) | YES | |
| BASE TABLE | slums | q7c | int(11) | YES | |
| BASE TABLE | slums | q7d | int(11) | YES | |
| BASE TABLE | slums | q7e | int(11) | YES | |
| BASE TABLE | slums | q8b | int(11) | YES | |
| BASE TABLE | slums | q8c | int(11) | YES | |
| BASE TABLE | slums | q9a | int(11) | YES | |
| BASE TABLE | slums | q9b | int(11) | YES | |
| BASE TABLE | slums | q10a | int(11) | YES | |
| BASE TABLE | slums | q10b | int(11) | YES | |
| BASE TABLE | slums | q11a | int(11) | YES | |
| BASE TABLE | slums | q11b | int(11) | YES | |
| BASE TABLE | slums | q11c | int(11) | YES | |
| BASE TABLE | slums | q11d | int(11) | YES | |
| BASE TABLE | slums | clockpicture_blobid | int(11) | YES | |
| BASE TABLE | slums | shapespicture_blobid | int(11) | YES | |
| BASE TABLE | slums | comments | text | YES | |
| BASE TABLE | slums_SUMMARY_TEMP | slums_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | slums_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | slums_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | slums_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | slums_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | slums_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | smast | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | smast | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | smast | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | smast | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | smast | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | smast | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | smast | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | smast | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | smast | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | smast | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | smast | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | smast | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | smast | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | smast | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | smast | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | smast | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | smast | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | smast | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | smast | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | smast | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | smast | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | smast | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | smast | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | smast | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | smast | q1 | varchar(1) | YES | |
| BASE TABLE | smast | q2 | varchar(1) | YES | |
| BASE TABLE | smast | q3 | varchar(1) | YES | |
| BASE TABLE | smast | q4 | varchar(1) | YES | |
| BASE TABLE | smast | q5 | varchar(1) | YES | |
| BASE TABLE | smast | q6 | varchar(1) | YES | |
| BASE TABLE | smast | q7 | varchar(1) | YES | |
| BASE TABLE | smast | q8 | varchar(1) | YES | |
| BASE TABLE | smast | q9 | varchar(1) | YES | |
| BASE TABLE | smast | q10 | varchar(1) | YES | |
| BASE TABLE | smast | q11 | varchar(1) | YES | |
| BASE TABLE | smast | q12 | varchar(1) | YES | |
| BASE TABLE | smast | q13 | varchar(1) | YES | |
| BASE TABLE | smast_SUMMARY_TEMP | smast_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | smast_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | smast_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | smast_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | smast_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | smast_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | storedvars | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | storedvars | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | storedvars | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | storedvars | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | storedvars | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | storedvars | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | storedvars | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | storedvars | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | storedvars | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | storedvars | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | storedvars | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | storedvars | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | storedvars | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | storedvars | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | storedvars | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | storedvars | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | storedvars | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | storedvars | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | storedvars | id | int(11) | NO | Arbitrary numerical primary key on the source tablet device |
| BASE TABLE | storedvars | name | varchar(255) | NO | Variable name (effectively the actual primary key on the source tablet device) |
| BASE TABLE | storedvars | type | varchar(255) | NO | Variable type ('integer', 'real', 'text') |
| BASE TABLE | storedvars | valueInteger | int(11) | YES | Value of an integer variable |
| BASE TABLE | storedvars | valueText | text | YES | Value of a text variable |
| BASE TABLE | storedvars | valueReal | double | YES | Value of a real (floating-point) variable |


| create {fs} | R Documentation |
The functions file_create()
and dir_create()
ensure that path
exists;
if it already exists it will be left unchanged. That means that compared to
file.create()
, file_create()
will not truncate an existing file, and
compared to dir.create()
, dir_create()
will silently ignore existing
directories.
file_create(path, ..., mode = "u=rw,go=r") dir_create(path, ..., mode = "u=rwx,go=rx", recurse = TRUE, recursive) link_create(path, new_path, symbolic = TRUE)
path |
A character vector of one or more paths. |
... |
Additional arguments passed to |
mode |
If file/directory is created, what mode should it have? Links do not have mode; they inherit the mode of the file they link to. |
recurse |
should intermediate directories be created if they do not exist? |
recursive |
(Deprecated) If |
new_path |
The path where the link should be created. |
symbolic |
Boolean value determining if the link should be a symbolic (the default) or hard link. |
The path to the created object (invisibly).
file_create("foo") is_file("foo") # dir_create applied to the same path will fail try(dir_create("foo")) dir_create("bar") is_dir("bar") # file_create applied to the same path will fail try(file_create("bar")) # Cleanup file_delete("foo") dir_delete("bar")


--- title: 'Scroll Helper' head: title: 'zKit: Scroll Helper (lib/controllers)' description: 'zKit, a collection of framework-agnostic components for modern web.' layout_width: '1024px' --- {% include "../../_inc/head_open.html" %} {% include "../../_inc/head_close.html" %}
scroll:change
event
to handle motion, direction update and boundary hit
watch
method to get
notified as DOM elements move inside or enter/exit the viewport
scrollTo
method with
smooth scrolling facility
Add the data-ui-load
attribute to the element implementing the scroll (usually body
or a div
element)
<body data-ui-load="@lib/controllers/scroll_helper"
data-ui-context="scroll-helper">
</body>
data-ui-load="@lib/controllers/scroll_helper"
constructorscroll_helper
controller on the element.
data-ui-context
optionalBefore component is loaded
var scrollHelper; // it will be == null until component is loaded
zuix.context('scroll-helper', function() {
// component loaded
scrollHelper = this;
});
or at any time after component is loaded
var scrollHelper = zuix.context('scroll-helper');
scrollHelper.on('scroll:change', function(e, data) {
switch (data.event) {
case 'hit-top':
// reached top of page
break;
case 'scroll':
if (data.info.shift.y < 0) {
// scrolling up
} else if (data.info.shift.y > 0) {
// scrolling down
}
// for all fields of the data.info
// object see next paragraph
break;
case 'hit-bottom':
// reached end of page
break;
}
});
// get the scroll info object
const info = scrollHelper.info();
info -> {
// last event timestamp
timestamp:<PHONE_NUMBER>438,
// movement since previous event
shift: {
x: 0,
y: -3
},
// total scroll area size
size: {
width: 1280,
height: 5281
},
// visible area size and position
viewport: {
x: 0,
y: -3313,
width: 1280,
height: 720
}
}
The watch
method takes one argument that can be either an element object or a valid
DOM query selector expression.
// watch elements having the 'watchable' class
scrollHelper.watch('.watchable', function(el, data) {
switch (data.event) {
case 'enter':
// element entered the visible area
break;
case 'exit':
// element out of the visible area
break;
case 'scroll':
// element is being scrolled in the visible area
break;
case 'off-scroll':
// element is being scrolled out of the visible area
break;
}
});
The data
object passed to the watch callback is described below
data = {
// event: 'enter' | 'exit' | 'scroll' | 'off-scroll'
event,
// element position, status, rect and frame
x, // float
y, // float
visible, // boolean
rect: { // DOMRect
x,
y,
height,
width,
left,
right,
top,
bottom
},
frame: { // relative center position
dx,
dy,
}
}
The frame
object represents the position of the center of the element
relative to the viewport size. Specifically, dx
and dy
are
float numbers that have values between 0
and 1
when the element
is inside the viewport. So when the element is at the center of the viewport, dx
and dy
will have a value of 0.5
.
Otherwise it will be less than 0
if the element is above the viewport top or
lastly greater than 1
when the element is below the viewport bottom.
This value can be used to create responsive and synchronized scroll animations based on
current viewport offset and elements position.
// scroll to the start of page
scrollHelper.scrollStart( [duration_ms] );
// scroll to the end of page
scrollHelper.scrollEnd( [duration_ms] );
// scroll to element or offset
scrollHelper.scrollTo( element | offset_px );
Source code is available in the lib/controllers
folder of zKit repository.