I got this table:
id | name | |
---|---|---|
0 | 0 | Region_0 |
1 | 1 | Region_1 |
2 | 2 | Region_2 |
3 | 3 | Region_3 |
4 | 4 | Region_4 |
5 | 5 | Region_5 |
6 | 6 | Region_6 |
7 | 7 | Region_7 |
8 | 8 | Region_8 |
9 | 9 | Region_9 |
10 | 10 | Region_10 |
11 | 11 | Region_11 |
12 | 12 | Region_12 |
13 | 13 | Region_13 |
14 | 14 | Region_14 |
15 | 15 | Region_15 |
16 | 16 | Region_16 |
17 | 17 | Region_17 |
18 | 18 | Region_18 |
19 | 19 | Region_19 |
I trying to make new data. Metadata for this table:
database_metadata.update_column(
table_name='region',
column_name='id',
sdtype='id',
regex_format='[0-9]{2}'
)
database_metadata.set_primary_key(
table_name='region',
column_name='id'
)
database_metadata.add_relationship(
parent_table_name='region',
child_table_name='users',
parent_primary_key='id',
child_foreign_key='region_id'
)
'region': {'primary_key': 'id',
'columns': {'id': {'sdtype': 'id', 'regex_format': '[0-9]{2}'},
'name': {'sdtype': 'categorical'}}}
I need to make region's names unique. How to put this logic in model?
P.S. The constraint class 'Unique' is not currently supported for multi-table synthesizers.