testdb.public contains 194 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
com_account	c_created	timestamp	29,6	√		null
com_account	c_created_by	varchar	255	√		null
com_account	c_default	bool	1
com_account	c_identifier	varchar	255
com_account	c_name	varchar	255
com_account	c_ol	int8	19	√		null
com_account	c_pid	varchar	255
com_account	c_pk	int8	19
com_account	c_updated	timestamp	29,6	√		null
com_account	c_updated_by	varchar	255	√		null
com_barcode	c_created	timestamp	29,6	√		null
com_barcode	c_created_by	varchar	255	√		null
com_barcode	c_current	varchar	40	√		null
com_barcode	c_name	varchar	255	√		null
com_barcode	c_ol	int8	19	√		null
com_barcode	c_pk	int8	19
com_barcode	c_updated	timestamp	29,6	√		null
com_barcode	c_updated_by	varchar	255	√		null
com_location	c_account	varchar	255	√		null
com_location	c_aisle	varchar	255	√		null
com_location	c_area	varchar	255	√		null
com_location	c_classification	varchar	255	√		null
com_location	c_considered_in_allocation	bool	1	√		null
com_location	c_created	timestamp	29,6	√		null
com_location	c_created_by	varchar	255	√		null
com_location	c_description	varchar	255	√		null
com_location	c_erp_code	varchar	255	√		null
com_location	c_group	varchar	255	√		null
com_location	c_incoming_active	bool	1	√		null
com_location	c_labels	varchar	1024	√		null
com_location	c_last_movement	timestamp	29,6	√		null
com_location	c_lg_counting_active	bool	1	√		null
com_location	c_location_group	int8	19	√		null
com_location	c_location_type	int8	19	√		null
com_location	c_maximum_weight	numeric	19,2	√		null
com_location	c_no_max_transport_units	int4	10	√		null
com_location	c_ol	int8	19	√		null
com_location	c_outgoing_active	bool	1	√		null
com_location	c_pid	varchar	255
com_location	c_pk	int8	19
com_location	c_plc_code	varchar	255	√		null
com_location	c_plc_state	int4	10	√		null
com_location	c_sort	int4	10	√		null
com_location	c_stock_zone	varchar	255	√		null
com_location	c_updated	timestamp	29,6	√		null
com_location	c_updated_by	varchar	255	√		null
com_location	c_x	varchar	255	√		null
com_location	c_y	varchar	255	√		null
com_location	c_z	varchar	255	√		null
com_location_group	c_account	varchar	255	√		null
com_location_group	c_created	timestamp	29,6	√		null
com_location_group	c_created_by	varchar	255	√		null
com_location_group	c_description	varchar	255	√		null
com_location_group	c_group_counting_active	bool	1	√		null
com_location_group	c_group_state_in	varchar	255
com_location_group	c_group_state_out	varchar	255
com_location_group	c_group_type	varchar	255	√		null
com_location_group	c_in_locker	int8	19	√		null
com_location_group	c_max_fill_level	float4	8,8	√		null
com_location_group	c_name	varchar	255
com_location_group	c_ol	int8	19	√		null
com_location_group	c_op_mode	varchar	255	√		null
com_location_group	c_out_locker	int8	19	√		null
com_location_group	c_parent	int8	19	√		null
com_location_group	c_pid	varchar	255
com_location_group	c_pk	int8	19
com_location_group	c_system_code	varchar	255	√		null
com_location_group	c_system_name	varchar	255	√		null
com_location_group	c_updated	timestamp	29,6	√		null
com_location_group	c_updated_by	varchar	255	√		null
com_location_message	c_location_id	int8	19
com_location_message	c_message_id	int8	19
com_location_type	c_created	timestamp	29,6	√		null
com_location_type	c_created_by	varchar	255	√		null
com_location_type	c_description	varchar	255	√		null
com_location_type	c_height	int4	10	√		null
com_location_type	c_length	int4	10	√		null
com_location_type	c_ol	int8	19	√		null
com_location_type	c_pid	varchar	255
com_location_type	c_pk	int8	19
com_location_type	c_type	varchar	255
com_location_type	c_updated	timestamp	29,6	√		null
com_location_type	c_updated_by	varchar	255	√		null
com_location_type	c_width	int4	10	√		null
com_message	c_created	timestamp	29,6	√		null
com_message	c_created_by	varchar	255	√		null
com_message	c_message_no	int4	10	√		null
com_message	c_message_text	varchar	255	√		null
com_message	c_ol	int8	19	√		null
com_message	c_pk	int8	19
com_message	c_updated	timestamp	29,6	√		null
com_message	c_updated_by	varchar	255	√		null
com_replica_registry	c_application_name	varchar	255
com_replica_registry	c_created	timestamp	29,6	√		null
com_replica_registry	c_created_by	varchar	255	√		null
com_replica_registry	c_ol	int8	19	√		null
com_replica_registry	c_pid	varchar	255
com_replica_registry	c_pk	int8	19
com_replica_registry	c_registered_at	timestamp	29,6	√		null
com_replica_registry	c_removal_endpoint	varchar	255	√		null
com_replica_registry	c_request_removal_endpoint	varchar	255	√		null
com_replica_registry	c_state	varchar	255
com_replica_registry	c_unregistered_at	timestamp	29,6	√		null
com_replica_registry	c_updated	timestamp	29,6	√		null
com_replica_registry	c_updated_by	varchar	255	√		null
com_srv_revision	c_pk	int8	19
com_srv_revision	c_timestamp	int8	19	√		null
com_srv_revision	c_trace_id	varchar	255	√		null
com_srv_revision	c_user	varchar	255	√		null
com_transport_unit	c_actual_location	int8	19
com_transport_unit	c_actual_location_date	timestamp	29,6	√		null
com_transport_unit	c_barcode	varchar	20
com_transport_unit	c_created	timestamp	29,6	√		null
com_transport_unit	c_created_by	varchar	255	√		null
com_transport_unit	c_empty	bool	1	√		null
com_transport_unit	c_group_name	varchar	255	√		null
com_transport_unit	c_inventory_date	timestamp	29,6	√		null
com_transport_unit	c_inventory_user	varchar	255	√		null
com_transport_unit	c_ol	int8	19	√		null
com_transport_unit	c_parent	int8	19	√		null
com_transport_unit	c_pid	varchar	255
com_transport_unit	c_pk	int8	19
com_transport_unit	c_state	varchar	255	√		null
com_transport_unit	c_target_location	int8	19	√		null
com_transport_unit	c_transport_unit_type	int8	19
com_transport_unit	c_updated	timestamp	29,6	√		null
com_transport_unit	c_updated_by	varchar	255	√		null
com_transport_unit	c_weight	numeric	19,2	√		null
com_transport_unit	c_weight_uom	int4	10	√		null
com_transport_unit_log	c_actual_location	int8	19	√		null
com_transport_unit_log	c_actual_location_date	timestamp	29,6	√		null
com_transport_unit_log	c_barcode	varchar	20	√		null
com_transport_unit_log	c_created	timestamp	29,6	√		null
com_transport_unit_log	c_created_by	varchar	255	√		null
com_transport_unit_log	c_empty	bool	1	√		null
com_transport_unit_log	c_group_name	varchar	255	√		null
com_transport_unit_log	c_inventory_date	timestamp	29,6	√		null
com_transport_unit_log	c_inventory_user	varchar	255	√		null
com_transport_unit_log	c_parent	int8	19	√		null
com_transport_unit_log	c_pid	varchar	255	√		null
com_transport_unit_log	c_pk	int8	19
com_transport_unit_log	c_rev	int8	19
com_transport_unit_log	c_rev_type	int2	5	√		null
com_transport_unit_log	c_state	varchar	255	√		null
com_transport_unit_log	c_target_location	int8	19	√		null
com_transport_unit_log	c_transport_unit_type	int8	19	√		null
com_transport_unit_log	c_updated	timestamp	29,6	√		null
com_transport_unit_log	c_updated_by	varchar	255	√		null
com_transport_unit_log	c_weight	numeric	19,2	√		null
com_transport_unit_log	c_weight_uom	int4	10	√		null
com_transport_unit_type	c_compatibility	varchar	255	√		null
com_transport_unit_type	c_created	timestamp	29,6	√		null
com_transport_unit_type	c_created_by	varchar	255	√		null
com_transport_unit_type	c_description	varchar	255	√		null
com_transport_unit_type	c_height	int4	10	√		null
com_transport_unit_type	c_length	int4	10	√		null
com_transport_unit_type	c_ol	int8	19	√		null
com_transport_unit_type	c_payload	numeric	19,2	√		null
com_transport_unit_type	c_pid	varchar	255
com_transport_unit_type	c_pk	int8	19
com_transport_unit_type	c_type	varchar	255
com_transport_unit_type	c_updated	timestamp	29,6	√		null
com_transport_unit_type	c_updated_by	varchar	255	√		null
com_transport_unit_type	c_weight_max	numeric	19,2	√		null
com_transport_unit_type	c_weight_tare	numeric	19,2	√		null
com_transport_unit_type	c_width	int4	10	√		null
com_type_placing_rule	c_allowed_location_type	int8	19
com_type_placing_rule	c_created	timestamp	29,6	√		null
com_type_placing_rule	c_created_by	varchar	255	√		null
com_type_placing_rule	c_ol	int8	19	√		null
com_type_placing_rule	c_pk	int8	19
com_type_placing_rule	c_privilege_level	int4	10
com_type_placing_rule	c_tut_id	int8	19
com_type_placing_rule	c_updated	timestamp	29,6	√		null
com_type_placing_rule	c_updated_by	varchar	255	√		null
com_type_stacking_rule	c_allowed_transport_unit_type	int8	19
com_type_stacking_rule	c_created	timestamp	29,6	√		null
com_type_stacking_rule	c_created_by	varchar	255	√		null
com_type_stacking_rule	c_no_transport_units	int4	10
com_type_stacking_rule	c_ol	int8	19	√		null
com_type_stacking_rule	c_pk	int8	19
com_type_stacking_rule	c_transport_unit_type	int8	19	√		null
com_type_stacking_rule	c_updated	timestamp	29,6	√		null
com_type_stacking_rule	c_updated_by	varchar	255	√		null
com_unit_error	c_created	timestamp	29,6	√		null
com_unit_error	c_created_by	varchar	255	√		null
com_unit_error	c_error_no	varchar	255	√		null
com_unit_error	c_error_text	varchar	255	√		null
com_unit_error	c_ol	int8	19	√		null
com_unit_error	c_pid	varchar	255
com_unit_error	c_pk	int8	19
com_unit_error	c_tu_id	int8	19
com_unit_error	c_updated	timestamp	29,6	√		null
com_unit_error	c_updated_by	varchar	255	√		null