SchemaSpy Analysis of testdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Dec 25 22:26 UTC 2024 |
| |||||
|
testdb.public contains 47 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
mvm_problem_history | c_fk_movement | int8 | 19 | √ | null | ||
mvm_movement | c_group_pk | int8 | 19 | √ | null | ||
mvm_movement | c_ol | int8 | 19 | √ | null | ||
mvm_movement_group | c_ol | int8 | 19 | √ | null | ||
mvm_problem_history | c_ol | int8 | 19 | √ | null | ||
mvm_movement | c_pk | int8 | 19 | ||||
mvm_movement_group | c_pk | int8 | 19 | ||||
mvm_problem_history | c_pk | int8 | 19 | ||||
mvm_movement | c_end_date | timestamp | 22 | √ | null | ||
mvm_movement | c_latest_due | timestamp | 22 | √ | null | ||
mvm_movement | c_start_date | timestamp | 22 | √ | null | ||
mvm_movement | c_start_earliest_date | timestamp | 22 | √ | null | ||
mvm_movement | c_created | timestamp | 29,6 | √ | null | ||
mvm_movement_group | c_created | timestamp | 29,6 | √ | null | ||
mvm_problem_history | c_created | timestamp | 29,6 | √ | null | ||
mvm_movement | c_occurred | timestamp | 29,6 | √ | null | ||
mvm_problem_history | c_occurred | timestamp | 29,6 | √ | null | ||
mvm_movement | c_updated | timestamp | 29,6 | √ | null | ||
mvm_movement_group | c_updated | timestamp | 29,6 | √ | null | ||
mvm_problem_history | c_updated | timestamp | 29,6 | √ | null | ||
mvm_movement | c_created_by | varchar | 255 | √ | null | ||
mvm_movement_group | c_created_by | varchar | 255 | √ | null | ||
mvm_problem_history | c_created_by | varchar | 255 | √ | null | ||
mvm_movement | c_initiator | varchar | 255 | ||||
mvm_movement | c_mode | varchar | 255 | ||||
mvm_movement_group | c_name | varchar | 255 | ||||
mvm_movement | c_no | varchar | 255 | √ | null | ||
mvm_problem_history | c_no | varchar | 255 | √ | null | ||
mvm_movement | c_pid | varchar | 255 | ||||
mvm_movement_group | c_pid | varchar | 255 | ||||
mvm_problem_history | c_pid | varchar | 255 | ||||
mvm_movement | c_priority | varchar | 255 | ||||
mvm_movement | c_sku | varchar | 255 | √ | null | ||
mvm_movement | c_source_location | varchar | 255 | √ | null | ||
mvm_movement | c_source_location_group_name | varchar | 255 | √ | null | ||
mvm_movement | c_state | varchar | 255 | √ | null | ||
mvm_movement_group | c_state | varchar | 255 | √ | null | ||
mvm_movement | c_target_location | varchar | 255 | √ | null | ||
mvm_movement | c_target_location_group_name | varchar | 255 | ||||
mvm_movement | c_transport_unit_bk | varchar | 255 | ||||
mvm_movement | c_type | varchar | 255 | ||||
mvm_movement | c_updated_by | varchar | 255 | √ | null | ||
mvm_movement_group | c_updated_by | varchar | 255 | √ | null | ||
mvm_problem_history | c_updated_by | varchar | 255 | √ | null | ||
mvm_movement_group | c_user | varchar | 255 | √ | null | ||
mvm_movement | c_message | varchar | 1024 | √ | null | ||
mvm_problem_history | c_message | varchar | 1024 | √ | null |