https://sdv.dev/SDV/developer_guides/sdv/metadata.html
{ "tables": { "students": { "primary_key": "student_id", "fields": { "student_id": { "type": "id", "subtype": "string", "regex": "21WT[0-9]{2}[1-9]" }, "student_name": { "type": "categorical", "pii": true, "pii_locales": ["jp-JP"], "pii_category": "name" }, "overall_gpa": { "type": "numerical", "subtype": "float" }, "obtained_credits": { "type": "numerical", "subtype": "integer" }, "enrolled_credits": { "type": "numerical", "subtype": "integer" }, "attendance_rate": { "type": "numerical", "subtype": "float" } } } } }
Type | Subtype | Additional Properties |
---|---|---|
numerical | integer | |
float* | ||
datetime | format | |
categorical | pii, pii_category, pii_locales | |
boolean | ||
id | integer | ref{field,table} |
string* | ref{field,table}, regex | |
name: for single field primary key | ||
*default if none is specified |