SchemaSpy Analysis of transmart.amapp - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Jun 26 00:10 CEST 2019 |
| ||||||
|
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 |