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.

Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation de l'API
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

Vous pouvez également nous fournir des fichiers au format xlsx, csv ou json. -> Exemple CSV

Nom de la ligne	Type	Exemple
float_column * floating around, something in between 3 or 4 or even more. But it MUST be given! Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. * requis	float	3.14
last_source_id Id of the last Source which updated the record Généré automatiquement	integer	33
last_import_id Id of the last import which updated the record Généré automatiquement	integer	337
data_origin Origin of the data, generic or name of the api Généré automatiquement	string	generic
custom Saves additional imported data out of standard structure Généré automatiquement	jsonb	{ "some": "key" }
organization_id References Organization of data Généré automatiquement	integer	1
import_id References Import of data Généré automatiquement	integer	1
source_id References Source of data Généré automatiquement	integer	1
updated_at Timestamp when row was updated Généré automatiquement	datetime	2021-05-03 6:23:55
created_at Timestamp when row was inserted Généré automatiquement	datetime	2021-05-03 6:23:55
enum_column A column which can only store predefined values	enum: a, b, c	b
something_uid int_column; Referencing something, stored in another table. Used for joining. Build as int_column. Généré automatiquement	string	somecrayzyuid12423
personal_column Something personal.	string	Personal Text
name_column 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 p14n	string	pater paul stored as fe42o3p2
date_column give us a date so we know when it happened	date	2021-02-22
time_column give us a timestamp so we know when it happened	datetime	2021-02-22 12:34:56 UTC
bool_column A simple yes or no is enough. But we need to know.	boolean	true
int_column Here we store a number if you provide us one. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	integer	5
uid 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! Généré automatiquement	string	The UUID - 12434534