{
    "path": "",
    "tables": [
        {
            "fields": [
                {
                    "name": "id",
                    "subtype": "integer",
                    "type": "number",
                    "uniques": 20,
                    "regex": "^[0-9]*$"
                },
                {
                    "name": "date_account_created",
                    
                    "type": "datetime",
                    "format": "%Y-%m-%d",
                    "uniques": 1                
                },
                {
                    "name": "timestamp_first_active",
                    
                    "type": "datetime",
                    "format": "%Y%m%d%H%M%S",
                    "uniques": 20
                },
                {
                    "name": "date_first_booking",
                    
                    "type": "datetime",
                    "format": "%Y-%m-%d",
                    "uniques": 7
                },
                {
                    "name": "gender",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 3
                },
                {
                    "name": "age",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 8
                },
                {
                    "name": "signup_method",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 2
                },
                {
                    "name": "signup_flow",
                    "subtype": "integer",
                    "type": "number",
                    "uniques": 2
                },
                {
                    "name": "language",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 2
                },
                {
                    "name": "affiliate_channel",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 4
                },
                {
                    "name": "affiliate_provider",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 3
                },
                {
                    "name": "first_affiliate_tracked",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 3
                },
                {
                    "name": "signup_app",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 2
                },
                {
                    "name": "first_device_type",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 5
                },
                {
                    "name": "first_browser",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 5
                },
                {
					"name": "country_destination",
					"ref": {
						"field": "country_destination",
						"table": "Countries"
					},
					"subtype": "integer",
					"type": "number",
					"uniques": 5
				}                
            ],
            "headers": true,
            "name": "Users",
            "path": "users_sample_replaced.csv",
            "primary_key": "id",
            "use": true
        },
        {
            "fields": [
                {
                    "name": "country_destination",
                    "subtype": "integer",
                    "type": "number",
                    "uniques": 3,
                    "regex": "^[0-9]*$"
                },
				{
                    "name": "lat_destination",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                },
				{
                    "name": "lng_destination",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                },
				{
                    "name": "distance_km",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                },
				{
                    "name": "destination_km2",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                },
				{
                    "name": "destination_language",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 2
                },
				{
                    "name": "language_levenshtein_distance",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                }
                
            ],
            "headers": true,
            "name": "Countries",
            "path": "countries_sample_replaced.csv",
            "primary_key": "country_destination",
            "use": true
        },
        {
            "fields": [
                {
					"name": "user_id",
					"ref": {
						"field": "id",
						"table": "Users"
					},
					"subtype": "integer",
					"type": "number",
					"uniques": 20
				},
				{
                    "name": "action",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 73
                },
				{
                    "name": "action_type",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 8
                },
				{
                    "name": "action_detail",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 38
                },
				{
                    "name": "device_type",
                    "subtype": "categorical",
                    "type": "categorical",
                    "uniques": 7
                },
				{
                    "name": "secs_elapsed",
                    "subtype": "float",
                    "type": "number",
                    "uniques": 0
                }
            ],
            "headers": true,
            "name": "Sessions",
            "path": "sessions_sample_replaced.csv",
            "use": true
        }
    ]
}