Documentation: test

This is the description of the table. This table saves test data and is used to test things like import / anonymization / types / views and whatever you can think of. Some column names are reserved id - used internally as id created_at - timestamp when record was inserted updated_at - timestamp when record was updated source_id - the id of the data source import import_id - the id of the exact import process which created / updated the data custom - json column to store all provided data which was given but not mentioned in table structure below, will not be shared with anonymized visibility. visibility - in views - what level of visibility was provided source_name - in views - name of the datasource source_organization_name - in views - name of the organization which provided the data Type is one of the rails db migration types.
To import data in this format you can use our API. -> API Documentation
You can also supply us with files in xlsx, csv or json format. -> Example CSV
type p14n blurred autogenerated required
uid string ⤫ ⤫ ✓ ⤫
organization_id + something_uid; A nice description of the column. This here is the external uid provided by the one who is uploading the data. It is build from organization_id and something_uid. This description is required. Otherwise nobody will know what it is. I should be well written and explaining everything. Must be unique to the data source!
int_column integer ⤫ ⤫ ⤫ ⤫
Here we store a number if you provide us one.
bool_column boolean ⤫ ⤫ ⤫ ⤫
A simple yes or no is enough. But we need to know.
float_column float ⤫ ⤫ ⤫ ✓
floating around, something in between 3 or 4 or even more. But it MUST be given!
time_column datetime ⤫ ⤫ ⤫ ⤫
give us a timestamp so we know when it happened
name_column string ✓ ⤫ ⤫ ⤫
Name of customer. It will not be stored plainly but hashed - so that different names are different, but the the personal information is gone. e.g. Jack Smith as jasdm213mn5, Jacky Smith as oqmq123
personal_column string ⤫ ⤫ ⤫ ⤫
Something personal. This column should not be shared at all when visibility is anonymized
something_uid string ⤫ ⤫ ✓ ⤫
int_column; Referencing something, stored in another table. Used for joining. Build as int_column.
enum_column enum: a, b, c ⤫ ⤫ ⤫ ⤫
A column which can only store predefined values
id integer ⤫ ⤫ ✓ ⤫
Internal primary key
created_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was inserted
updated_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was updated
source_id integer ⤫ ⤫ ✓ ⤫
References Source of data
import_id integer ⤫ ⤫ ✓ ⤫
References Import of data
organization_id integer ⤫ ⤫ ✓ ⤫
References Organization of data
custom jsonb ⤫ ⤫ ✓ ⤫
Saves additional imported data out of standard structure
data_origin string ⤫ ⤫ ✓ ⤫
Origin of the data, generic or name of the api
trust_score float ⤫ ⤫ ✓ ⤫
calculated value how much we trust data
last_import_id integer ⤫ ⤫ ✓ ⤫
Id of the last import which updated the record
last_source_id integer ⤫ ⤫ ✓ ⤫
Id of the last Source which updated the record