SchemaSpy Analysis of transmart.amapp - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Jun 26 00:10 CEST 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

transmart.amapp contains 39 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
am_data_uid am_data_id int8 19
am_data_uid am_data_type varchar 100
am_data_uid unique_id varchar 300
am_tag_association object_type varchar 50  √  null
am_tag_association object_uid varchar 300
am_tag_association subject_uid varchar 300
am_tag_association tag_item_id int8 19  √  null
am_tag_display_vw display_value varchar 2147483647  √  null
am_tag_display_vw object_id int8 19  √  null
am_tag_display_vw object_type varchar 50  √  null
am_tag_display_vw object_uid varchar 300  √  null
am_tag_display_vw subject_uid varchar 300  √  null
am_tag_display_vw tag_item_id int8 19  √  null
am_tag_item active_ind bool 1
am_tag_item code_type_name varchar 200  √  null
am_tag_item display_name varchar 200
am_tag_item display_order int8 19  √  null
am_tag_item editable varchar 1  √  null
am_tag_item gui_handler varchar 200
am_tag_item max_values int8 19  √  null
am_tag_item required varchar 1  √  null
am_tag_item tag_item_attr varchar 300  √  null
am_tag_item tag_item_id int8 19
am_tag_item tag_item_subtype varchar 200  √  null
am_tag_item tag_item_type varchar 200  √  null
am_tag_item tag_item_uid varchar 300
am_tag_item tag_template_id int8 19
am_tag_item view_in_child_grid int2 5  √  null
am_tag_item view_in_grid int2 5  √  null
am_tag_template active_ind bool 1
am_tag_template tag_template_id int8 19
am_tag_template tag_template_name varchar 200
am_tag_template tag_template_subtype varchar 50  √  null
am_tag_template tag_template_type varchar 50
am_tag_template_association id int8 19  √  null
am_tag_template_association object_uid varchar 300
am_tag_template_association tag_template_id int8 19
am_tag_value tag_value_id int8 19
am_tag_value value varchar 2000  √  null