dictionary_od_field

139 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('tdh_sys.dictionary_od_field_id_seq'::regclass)
class_id int4 10 null
attribute_id int4 10 null
table_name varchar 80 null
field_name varchar 80 null
field_name_en varchar 80 null
field_name_de varchar 100 null
field_name_fr varchar 100 null
field_name_it varchar 100 null
field_name_ro varchar 100 null
field_description_en text 2147483647 null
field_description_de text 2147483647 null
field_description_fr text 2147483647 null
field_description_it text 2147483647 null
field_description_ro text 2147483647 null
field_mandatory "tdh_od"."_plantype" 2147483647 null
field_visible bool 1 null
field_datatype varchar 40 null
field_unit_de varchar 20 null
field_unit_description_de varchar 90 null
field_unit_en varchar 20 null
field_unit_description_en varchar 90 null
field_unit_fr varchar 20 null
field_unit_description_fr varchar 90 null
field_unit_it varchar 20 null
field_unit_description_it varchar 90 null
field_unit_ro varchar 20 null
field_unit_description_ro varchar 90 null
field_min numeric 0 null
field_max numeric 0 null

Indexes

Constraint Name Type Sort Column(s)
is_dictionary_od_field_pkey Primary key Asc id
in_dictionary_od_field Must be unique Asc/Asc class_id + attribute_id

Relationships