project_field_lookup_table


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
lookup_table_log.lookup_id FK_iq12tn5cnhqw5e9itguklpbn0 R
can_edit_data BIT 1 null
can_edit_schema BIT 1 null
can_view_data BIT 1 null
description VARCHAR 80 √ null
last_modified DATETIME 23 √ null
lookup_column VARCHAR 50 null
table_name VARCHAR 50 null
sort_column VARCHAR 255 √ null
sort_order VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
table_name Must be unique Asc table_name

Relationships

Close relationships within degrees of separation