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 imported data which was given but not mentioned in table structure below 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. | |||||
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 |