SchemaSpy Analysis of testdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue Nov 05 09:42 UTC 2024 |
| |||||
|
testdb.public contains 30 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
tms_problem_history | c_created | timestamp | 29,6 | √ | null | ||
tms_transport_order | c_created | timestamp | 29,6 | √ | null | ||
tms_problem_history | c_created_by | varchar | 255 | √ | null | ||
tms_transport_order | c_created_by | varchar | 255 | √ | null | ||
tms_transport_order | c_end_date | timestamp | 29,6 | √ | null | ||
tms_problem_history | c_fk_to | int8 | 19 | √ | null | ||
tms_problem_history | c_message_text | varchar | 255 | √ | null | ||
tms_transport_order | c_message_text | varchar | 255 | √ | null | ||
tms_problem_history | c_no | varchar | 255 | √ | null | ||
tms_transport_order | c_no | varchar | 255 | √ | null | ||
tms_problem_history | c_occurred | timestamp | 29,6 | √ | null | ||
tms_transport_order | c_occurred | timestamp | 29,6 | √ | null | ||
tms_problem_history | c_ol | int8 | 19 | √ | null | ||
tms_transport_order | c_ol | int8 | 19 | √ | null | ||
tms_transport_order | c_pid | varchar | 255 | ||||
tms_problem_history | c_pk | int8 | 19 | ||||
tms_transport_order | c_pk | int8 | 19 | ||||
tms_transport_order | c_priority | varchar | 255 | √ | null | ||
tms_transport_order | c_source_location | varchar | 255 | √ | null | ||
tms_transport_order | c_start_date | timestamp | 29,6 | √ | null | ||
tms_transport_order | c_state | varchar | 255 | √ | null | ||
tms_transport_order | c_target_location | varchar | 255 | √ | null | ||
tms_transport_order | c_target_location_group | varchar | 255 | √ | null | ||
tms_transport_order | c_transport_unit_bk | varchar | 255 | √ | null | ||
tms_problem_history | c_updated | timestamp | 29,6 | √ | null | ||
tms_transport_order | c_updated | timestamp | 29,6 | √ | null | ||
tms_problem_history | c_updated_by | varchar | 255 | √ | null | ||
tms_transport_order | c_updated_by | varchar | 255 | √ | null | ||
tms_problem_history | p_key | varchar | 255 | √ | null | ||
tms_transport_order | p_key | varchar | 255 | √ | null |