Created
February 26, 2013 20:12
-
-
Save shofetim/5041724 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Password for user jordan: | |
| psql (9.1.8) | |
| SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) | |
| Type "help" for help. | |
| beehive=# \d | |
| List of relations | |
| Schema | Name | Type | Owner | |
| --------+----------------------------------------------------------+----------+-------- | |
| public | accounts_receivable_adjustment | table | jordan | |
| public | accounts_receivable_adjustment_id_seq | sequence | jordan | |
| public | accounts_receivable_adjustmentorderassoc | table | jordan | |
| public | accounts_receivable_adjustmentorderassoc_id_seq | sequence | jordan | |
| public | accounts_receivable_credit | table | jordan | |
| public | accounts_receivable_creditcardpayment | table | jordan | |
| public | accounts_receivable_creditdebitassoc | table | jordan | |
| public | accounts_receivable_creditdebitassoc_id_seq | sequence | jordan | |
| public | accounts_receivable_debit | table | jordan | |
| public | accounts_receivable_ordercredit | table | jordan | |
| public | accounts_receivable_ordercredit_id_seq | sequence | jordan | |
| public | accounts_receivable_payment | table | jordan | |
| public | accounts_receivable_payment_id_seq | sequence | jordan | |
| public | accounts_receivable_paymentprocessorcommunication | table | jordan | |
| public | accounts_receivable_paymentprocessorcommunication_id_seq | sequence | jordan | |
| public | accounts_receivable_paymenttermtype | table | jordan | |
| public | accounts_receivable_paymenttermtype_id_seq | sequence | jordan | |
| public | auth_group | table | jordan | |
| public | auth_group_id_seq | sequence | jordan | |
| public | auth_group_permissions | table | jordan | |
| public | auth_group_permissions_id_seq | sequence | jordan | |
| public | auth_message | table | jordan | |
| public | auth_message_id_seq | sequence | jordan | |
| public | auth_permission | table | jordan | |
| public | auth_permission_id_seq | sequence | jordan | |
| public | auth_user | table | jordan | |
| public | auth_user_groups | table | jordan | |
| public | auth_user_groups_id_seq | sequence | jordan | |
| public | auth_user_id_seq | sequence | jordan | |
| public | auth_user_user_permissions | table | jordan | |
| public | auth_user_user_permissions_id_seq | sequence | jordan | |
| public | barcodes_barcode | table | jordan | |
| public | barcodes_barcode_id_seq | sequence | jordan | |
| public | beehive_install_migration | table | jordan | |
| public | beehive_install_migration_id_seq | sequence | jordan | |
| public | beekeeper_beehiveconfig | table | jordan | |
| public | beekeeper_beehiveconfig_id_seq | sequence | jordan | |
| public | beekeeper_beehivepermission | table | jordan | |
| public | beekeeper_beehivepermission_id_seq | sequence | jordan | |
| public | beekeeper_beehiveuser | table | jordan | |
| public | beekeeper_beehiveuser_id_seq | sequence | jordan | |
| public | better500s_caughterror | table | jordan | |
| public | better500s_caughterror_id_seq | sequence | jordan | |
| public | better_500_caughterror | table | jordan | |
| public | better_500_caughterror_id_seq | sequence | jordan | |
| public | biblion_feedhit | table | jordan | |
| public | biblion_feedhit_id_seq | sequence | jordan | |
| public | biblion_image | table | jordan | |
| public | biblion_image_id_seq | sequence | jordan | |
| public | biblion_post | table | jordan | |
| public | biblion_post_id_seq | sequence | jordan | |
| public | biblion_revision | table | jordan | |
| public | biblion_revision_id_seq | sequence | jordan | |
| public | blog_blogcategory | table | jordan | |
| public | blog_blogcategory_id_seq | sequence | jordan | |
| public | blog_blogpost | table | jordan | |
| public | blog_blogpost_categories | table | jordan | |
| public | blog_blogpost_categories_id_seq | sequence | jordan | |
| public | blog_blogpost_id_seq | sequence | jordan | |
| public | blog_blogpost_related_posts | table | jordan | |
| public | blog_blogpost_related_posts_id_seq | sequence | jordan | |
| public | brands_brand | table | jordan | |
| public | brands_brand_id_seq | sequence | jordan | |
| public | brands_brandcategory | table | jordan | |
| public | brands_brandcategory_id_seq | sequence | jordan | |
| public | brands_brandgroup | table | jordan | |
| public | brands_brandgroup_id_seq | sequence | jordan | |
| public | catalogrequests_id_seq | sequence | jordan | |
| public | celery_beat_monitor | table | jordan | |
| public | celery_taskmeta | table | jordan | |
| public | celery_taskmeta_id_seq | sequence | jordan | |
| public | celery_tasksetmeta | table | jordan | |
| public | celery_tasksetmeta_id_seq | sequence | jordan | |
| public | conf_setting | table | jordan | |
| public | conf_setting_id_seq | sequence | jordan | |
| public | countries_canadianprovince | table | jordan | |
| public | countries_canadianprovince_id_seq | sequence | jordan | |
| public | countries_country | table | jordan | |
| public | countries_usstate | table | jordan | |
| public | countries_usstate_id_seq | sequence | jordan | |
| public | customer_service_ordermispick_id_seq | sequence | jordan | |
| public | customer_service_orderproblem | table | jordan | |
| public | customer_service_rmacomment | table | jordan | |
| public | customer_service_rmacomment_id_seq | sequence | jordan | |
| public | customer_service_rmarecord | table | jordan | |
| public | customer_service_rmarecord_id_seq | sequence | jordan | |
| public | customers_creditonfile_seq | sequence | jordan | |
| public | customers_customer | table | jordan | |
| public | customers_customer_customer_number_seq | sequence | jordan | |
| public | customers_customer_id_seq | sequence | jordan | |
| public | customers_customer_payment_terms | table | jordan | |
| public | customers_customer_payment_terms_id_seq | sequence | jordan | |
| public | customers_customeraddress | table | jordan | |
| public | customers_customeraddress_id_seq | sequence | jordan | |
| public | customers_customerpaymentterm | table | jordan | |
| public | customers_customerpaymentterm_id_seq | sequence | jordan | |
| public | customers_id_seq | sequence | jordan | |
| public | customers_savedcreditcard | table | jordan | |
| public | customers_savedcreditcard_id_seq | sequence | jordan | |
| public | django_admin_log | table | jordan | |
| public | django_admin_log_id_seq | sequence | jordan | |
| public | django_comment_flags | table | jordan | |
| public | django_comment_flags_id_seq | sequence | jordan | |
| public | django_comments | table | jordan | |
| public | django_comments_id_seq | sequence | jordan | |
| public | django_content_type | table | jordan | |
| public | django_content_type_id_seq | sequence | jordan | |
| public | django_granular_permissions_permission | table | jordan | |
| public | django_granular_permissions_permission_id_seq | sequence | jordan | |
| public | django_session | table | jordan | |
| public | django_site | table | jordan | |
| public | django_site_id_seq | sequence | jordan | |
| public | django_slow_log_avg_load | table | jordan | |
| public | django_slow_log_record | table | jordan | |
| public | django_slow_log_record_id_seq | sequence | jordan | |
| public | django_snailtracker_action | table | jordan | |
| public | django_snailtracker_action_id_seq | sequence | jordan | |
| public | django_snailtracker_snailtrack | table | jordan | |
| public | django_snailtracker_snailtrack_id_seq | sequence | jordan | |
| public | djcelery_crontabschedule | table | jordan | |
| public | djcelery_crontabschedule_id_seq | sequence | jordan | |
| public | djcelery_intervalschedule | table | jordan | |
| public | djcelery_intervalschedule_id_seq | sequence | jordan | |
| public | djcelery_periodictask | table | jordan | |
| public | djcelery_periodictask_id_seq | sequence | jordan | |
| public | djcelery_periodictasks | table | jordan | |
| public | djcelery_taskstate | table | jordan | |
| public | djcelery_taskstate_id_seq | sequence | jordan | |
| public | djcelery_workerstate | table | jordan | |
| public | djcelery_workerstate_id_seq | sequence | jordan | |
| public | drops_droppoint | table | jordan | |
| public | drops_droppoint_id_seq | sequence | jordan | |
| public | drops_droppointcontacttype | table | jordan | |
| public | drops_droppointcontacttype_id_seq | sequence | jordan | |
| public | drops_droppointmanagerpreferences | table | jordan | |
| public | drops_droppointmanagerpreferences_contact_type | table | jordan | |
| public | drops_droppointmanagerpreferences_contact_type_id_seq | sequence | jordan | |
| public | drops_droppointmanagerpreferences_id_seq | sequence | jordan | |
| public | drops_droppointmanagerpreferences_item_store | table | jordan | |
| public | drops_droppointmanagerpreferences_item_store_id_seq | sequence | jordan | |
| public | drops_droppointmembership | table | jordan | |
| public | drops_droppointmembership_id_seq | sequence | jordan | |
| public | drops_droppointstorablestype | table | jordan | |
| public | drops_droppointstorablestype_id_seq | sequence | jordan | |
| public | drops_droppointtrip | table | jordan | |
| public | drops_droppointtrip_id_seq | sequence | jordan | |
| public | drops_routedropassoc | table | jordan | |
| public | drops_routedropassoc_id_seq | sequence | jordan | |
| public | drops_sentcutoffnotification | table | jordan | |
| public | drops_sentcutoffnotification_id_seq | sequence | jordan | |
| public | favorites_favorite | table | jordan | |
| public | favorites_favorite_id_seq | sequence | jordan | |
| public | forms_field | table | jordan | |
| public | forms_field_id_seq | sequence | jordan | |
| public | forms_fieldentry | table | jordan | |
| public | forms_fieldentry_id_seq | sequence | jordan | |
| public | forms_form | table | jordan | |
| public | forms_formentry | table | jordan | |
| public | forms_formentry_id_seq | sequence | jordan | |
| public | galleries_gallery | table | jordan | |
| public | galleries_galleryimage | table | jordan | |
| public | galleries_galleryimage_id_seq | sequence | jordan | |
| public | generic_assignedkeyword | table | jordan | |
| public | generic_assignedkeyword_id_seq | sequence | jordan | |
| public | generic_imagesets_genericimage | table | jordan | |
| public | generic_imagesets_genericimage_id_seq | sequence | jordan | |
| public | generic_imagesets_genericimageset | table | jordan | |
| public | generic_imagesets_genericimageset_id_seq | sequence | jordan | |
| public | generic_keyword | table | jordan | |
| public | generic_keyword_id_seq | sequence | jordan | |
| public | generic_rating | table | jordan | |
| public | generic_rating_id_seq | sequence | jordan | |
| public | generic_threadedcomment | table | jordan | |
| public | grappelli_safe_bookmark | table | jordan | |
| public | grappelli_safe_bookmark_id_seq | sequence | jordan | |
| public | grappelli_safe_bookmarkitem | table | jordan | |
| public | grappelli_safe_bookmarkitem_id_seq | sequence | jordan | |
| public | grappelli_safe_help | table | jordan | |
| public | grappelli_safe_help_id_seq | sequence | jordan | |
| public | grappelli_safe_helpitem | table | jordan | |
| public | grappelli_safe_helpitem_id_seq | sequence | jordan | |
| public | grappelli_safe_navigation | table | jordan | |
| public | grappelli_safe_navigation_id_seq | sequence | jordan | |
| public | grappelli_safe_navigationitem | table | jordan | |
| public | grappelli_safe_navigationitem_groups | table | jordan | |
| public | grappelli_safe_navigationitem_groups_id_seq | sequence | jordan | |
| public | grappelli_safe_navigationitem_id_seq | sequence | jordan | |
| public | grappelli_safe_navigationitem_users | table | jordan | |
| public | grappelli_safe_navigationitem_users_id_seq | sequence | jordan | |
| public | inventory_inventoryvaluation | table | jordan | |
| public | inventory_inventoryvaluation_id_seq | sequence | jordan | |
| public | inventory_recountrequest | table | jordan | |
| public | inventory_recountrequest_id_seq | sequence | jordan | |
| public | inventory_stock | table | jordan | |
| public | inventory_stock_id_seq | sequence | jordan | |
| public | item_dimensions_id_seq | sequence | jordan | |
| public | item_links_id_seq | sequence | jordan | |
| public | item_loc_id_seq | sequence | jordan | |
| public | line_items_id_seq | sequence | jordan | |
| public | location_location | table | jordan | |
| public | location_location_id_seq | sequence | jordan | |
| public | loggers_search | table | jordan | |
| public | loggers_search_id_seq | sequence | jordan | |
| public | notification_notice | table | jordan | |
| public | notification_notice_id_seq | sequence | jordan | |
| public | notification_noticequeuebatch | table | jordan | |
| public | notification_noticequeuebatch_id_seq | sequence | jordan | |
| public | notification_noticesetting | table | jordan | |
| public | notification_noticesetting_id_seq | sequence | jordan | |
| public | notification_noticetype | table | jordan | |
| public | notification_noticetype_id_seq | sequence | jordan | |
| public | notification_observeditem | table | jordan | |
| public | notification_observeditem_id_seq | sequence | jordan | |
| public | notifications_beehiveusernotification | table | jordan | |
| public | notifications_beehiveusernotification_id_seq | sequence | jordan | |
| public | notifications_customernotification | table | jordan | |
| public | notifications_customernotification_id_seq | sequence | jordan | |
| public | notifications_customernotificationdismissal | table | jordan | |
| public | notifications_customernotificationdismissal_id_seq | sequence | jordan | |
| public | oembed_providerrule | table | jordan | |
| public | oembed_providerrule_id_seq | sequence | jordan | |
| public | oembed_storedoembed | table | jordan | |
| public | oembed_storedoembed_id_seq | sequence | jordan | |
| public | order_header_id_seq | sequence | jordan | |
| public | orders_historicalorderdata | table | jordan | |
| public | orders_historicalorderdata_id_seq | sequence | jordan | |
| public | orders_order | table | jordan | |
| public | orders_order_id_seq | sequence | jordan | |
| public | orders_orderfee | table | jordan | |
| public | orders_orderfee_id_seq | sequence | jordan | |
| public | orders_orderline | table | jordan | |
| public | orders_orderline_id_seq | sequence | jordan | |
| public | orders_orderpiece | table | jordan | |
| public | orders_orderpiece_id_seq | sequence | jordan | |
| public | orders_ordershipment | table | jordan | |
| public | orders_ordershipment_id_seq | sequence | jordan | |
| public | orders_soldtoaddress | table | jordan | |
| public | orders_soldtoaddress_id_seq | sequence | jordan | |
| public | orders_upsordershipment | table | jordan | |
| public | pages_link | table | jordan | |
| public | pages_page | table | jordan | |
| public | pages_page_id_seq | sequence | jordan | |
| public | pages_richtextpage | table | jordan | |
| public | palletizing_pallet | table | jordan | |
| public | palletizing_pallet_id_seq | sequence | jordan | |
| public | permissions_permissiontype | table | jordan | |
| public | permissions_permissiontype_id_seq | sequence | jordan | |
| public | pick_set_pickset | table | jordan | |
| public | pick_set_pickset_id_seq | sequence | jordan | |
| public | pick_set_picksetpdf | table | jordan | |
| public | pick_set_picksetpdf_id_seq | sequence | jordan | |
| public | picking_box | table | jordan | |
| public | picking_box_id_seq | sequence | jordan | |
| public | picking_orderpick | table | jordan | |
| public | picking_pickclaim | table | jordan | |
| public | picking_pickclaim_id_seq | sequence | jordan | |
| public | pricinglevels_id_seq | sequence | jordan | |
| public | pricingtable_id_seq | sequence | jordan | |
| public | product_meta_id_seq | sequence | jordan | |
| public | productivity_action | table | jordan | |
| public | productivity_action_id_seq | sequence | jordan | |
| public | productivity_announcement | table | jordan | |
| public | productivity_announcement_id_seq | sequence | jordan | |
| public | productivity_shortshipaction | table | jordan | |
| public | productivity_stockaction | table | jordan | |
| public | productivity_team | table | jordan | |
| public | productivity_team_id_seq | sequence | jordan | |
| public | products_id_seq | sequence | jordan | |
| public | products_product | table | jordan | |
| public | products_product_id_seq | sequence | jordan | |
| public | products_productcategory | table | jordan | |
| public | products_productcategory_id_seq | sequence | jordan | |
| public | products_productprice | table | jordan | |
| public | products_productprice_id_seq | sequence | jordan | |
| public | products_productstatus | table | jordan | |
| public | products_productstatus_id_seq | sequence | jordan | |
| public | products_simpleproduct | table | jordan | |
| public | products_varietypack | table | jordan | |
| public | products_varietypack_content | table | jordan | |
| public | products_varietypack_content_id_seq | sequence | jordan | |
| public | publishing_publicationfile | table | jordan | |
| public | publishing_publicationfile_id_seq | sequence | jordan | |
| public | purchase_id_seq | sequence | jordan | |
| public | purchase_line_id_seq | sequence | jordan | |
| public | purchasing_backhaulpickup | table | jordan | |
| public | purchasing_backhaulpickup_id_seq | sequence | jordan | |
| public | purchasing_backhaulpickupaddress | table | jordan | |
| public | purchasing_backhaulpickupaddress_id_seq | sequence | jordan | |
| public | purchasing_brokeraddress | table | jordan | |
| public | purchasing_brokeraddress_id_seq | sequence | jordan | |
| public | purchasing_commoncarrierpickupaddress | table | jordan | |
| public | purchasing_commoncarrierpickupaddress_id_seq | sequence | jordan | |
| public | purchasing_deliverylocation | table | jordan | |
| public | purchasing_deliverylocation_id_seq | sequence | jordan | |
| public | purchasing_purchase | table | jordan | |
| public | purchasing_purchase_id_seq | sequence | jordan | |
| public | purchasing_purchaseancillary | table | jordan | |
| public | purchasing_purchaseancillary_id_seq | sequence | jordan | |
| public | purchasing_purchaseline | table | jordan | |
| public | purchasing_purchaseline_id_seq | sequence | jordan | |
| public | registration_registrationprofile | table | jordan | |
| public | registration_registrationprofile_id_seq | sequence | jordan | |
| public | release_notes_release | table | jordan | |
| public | release_notes_release_id_seq | sequence | jordan | |
| public | release_notes_releasenote | table | jordan | |
| public | release_notes_releasenote_id_seq | sequence | jordan | |
| public | reports_customreport | table | jordan | |
| public | reports_customreport_id_seq | sequence | jordan | |
| public | reports_customreportinput | table | jordan | |
| public | reports_customreportinput_id_seq | sequence | jordan | |
| public | reports_outofstockreport | table | jordan | |
| public | reports_outofstockreport_id_seq | sequence | jordan | |
| public | routes_route | table | jordan | |
| public | routes_route_id_seq | sequence | jordan | |
| public | routes_routepostalcode | table | jordan | |
| public | routes_routepostalcode_id_seq | sequence | jordan | |
| public | routes_routepostalcode_route | table | jordan | |
| public | routes_routepostalcode_route_id_seq | sequence | jordan | |
| public | routes_routetrip | table | jordan | |
| public | routes_routetrip_id_seq | sequence | jordan | |
| public | sales_sheets_salessheet | table | jordan | |
| public | sales_sheets_salessheet_id_seq | sequence | jordan | |
| public | sales_sheets_salessheetline | table | jordan | |
| public | sales_sheets_salessheetline_id_seq | sequence | jordan | |
| public | shipping_shippingwizard | table | jordan | |
| public | shipping_shippingwizard_id_seq | sequence | jordan | |
| public | simple_cms_page | table | jordan | |
| public | simple_cms_page_id_seq | sequence | jordan | |
| public | snippets_snippet | table | jordan | |
| public | snippets_snippet_id_seq | sequence | jordan | |
| public | south_migrationhistory | table | jordan | |
| public | south_migrationhistory_id_seq | sequence | jordan | |
| public | stock_transfer_cart | table | jordan | |
| public | stock_transfer_cart_id_seq | sequence | jordan | |
| public | stock_transfer_stocktransfer | table | jordan | |
| public | stock_transfer_stocktransfer_id_seq | sequence | jordan | |
| public | telegram_channel | table | jordan | |
| public | telegram_channel_id_seq | sequence | jordan | |
| public | telegram_platform | table | jordan | |
| public | telegram_platform_id_seq | sequence | jordan | |
| public | telegram_platformmeta | table | jordan | |
| public | telegram_platformmeta_id_seq | sequence | jordan | |
| public | telegram_sendlog | table | jordan | |
| public | telegram_sendlog_id_seq | sequence | jordan | |
| public | telegram_subscription | table | jordan | |
| public | telegram_subscription_id_seq | sequence | jordan | |
| public | telegram_subscriptionmeta | table | jordan | |
| public | telegram_subscriptionmeta_id_seq | sequence | jordan | |
| public | telegram_subscriptionplatform | table | jordan | |
| public | telegram_subscriptionplatform_id_seq | sequence | jordan | |
| public | telegram_telegram | table | jordan | |
| public | telegram_telegram_id_seq | sequence | jordan | |
| public | threadedcomments_freethreadedcomment | table | jordan | |
| public | threadedcomments_freethreadedcomment_id_seq | sequence | jordan | |
| public | threadedcomments_testmodel | table | jordan | |
| public | threadedcomments_testmodel_id_seq | sequence | jordan | |
| public | threadedcomments_threadedcomment | table | jordan | |
| public | threadedcomments_threadedcomment_id_seq | sequence | jordan | |
| public | vendor_contact_id_seq | sequence | jordan | |
| public | vendor_id_seq | sequence | jordan | |
| public | vendor_paymentterm | table | jordan | |
| public | vendor_paymentterm_id_seq | sequence | jordan | |
| public | vendor_products_id_seq | sequence | jordan | |
| public | vendor_vendor | table | jordan | |
| public | vendor_vendor_id_seq | sequence | jordan | |
| public | vendor_vendor_route | table | jordan | |
| public | vendor_vendor_route_id_seq | sequence | jordan | |
| public | vendor_vendorcontact | table | jordan | |
| public | vendor_vendorcontact_id_seq | sequence | jordan | |
| public | vendor_vendorpiece | table | jordan | |
| public | vendor_vendorpiece_id_seq | sequence | jordan | |
| public | vendor_vendorpiececost | table | jordan | |
| public | vendor_vendorpiececost_id_seq | sequence | jordan | |
| public | vendor_vendorpromotion | table | jordan | |
| public | vendor_vendorpromotion_id_seq | sequence | jordan | |
| public | vendor_vendorpromotionline | table | jordan | |
| public | vendor_vendorpromotionline_id_seq | sequence | jordan | |
| public | vendor_vendorpromotionline_sales_sheets | table | jordan | |
| public | vendor_vendorpromotionline_sales_sheets_id_seq | sequence | jordan | |
| public | warehouse_pieces_basemarkup | table | jordan | |
| public | warehouse_pieces_basemarkup_id_seq | sequence | jordan | |
| public | warehouse_pieces_breakdownmarkup | table | jordan | |
| public | warehouse_pieces_breakdownmarkup_id_seq | sequence | jordan | |
| public | warehouse_pieces_piece | table | jordan | |
| public | warehouse_pieces_piece_barcodes | table | jordan | |
| public | warehouse_pieces_piece_barcodes_id_seq | sequence | jordan | |
| public | warehouse_pieces_piece_id_seq | sequence | jordan | |
| public | warehouse_pieces_piecebreakdown | table | jordan | |
| public | warehouse_pieces_piecebreakdown_id_seq | sequence | jordan | |
| public | warehouse_pieces_piecemeta | table | jordan | |
| public | warehouse_pieces_piecemeta_id_seq | sequence | jordan | |
| public | warehouse_pieces_piecemeta_substitutions | table | jordan | |
| public | warehouse_pieces_piecemeta_substitutions_id_seq | sequence | jordan | |
| public | warehouse_pieces_piecesaleshistory | table | jordan | |
| public | warehouse_pieces_piecesaleshistory_id_seq | sequence | jordan | |
| public | warehouse_pieces_retailmarkup | table | jordan | |
| public | warehouse_pieces_retailmarkup_id_seq | sequence | jordan | |
| public | web_home_page_feedback | table | jordan | |
| public | web_home_page_feedback_id_seq | sequence | jordan | |
| public | web_home_page_homepage | table | jordan | |
| public | web_home_page_homepage_id_seq | sequence | jordan | |
| public | webforms_catalogrequest | table | jordan | |
| public | webforms_catalogrequest_id_seq | sequence | jordan | |
| public | website_registration_registrationprofile | table | jordan | |
| public | website_registration_registrationprofile_id_seq | sequence | jordan | |
| (405 rows) | |
| beehive=# \d drops_droppointtrip | |
| Table "public.drops_droppointtrip" | |
| Column | Type | Modifiers | |
| ----------------------------------------------+--------------------------+------------------------------------------------------------------ | |
| id | integer | not null default nextval('drops_droppointtrip_id_seq'::regclass) | |
| created_at | timestamp with time zone | | |
| created_by | integer | | |
| updated_at | timestamp with time zone | | |
| updated_by | integer | | |
| drop_point_id | integer | not null | |
| route_trip_id | integer | not null | |
| cached_ordered_amount | numeric(12,2) | | |
| cached_distance | integer | | |
| cached_name | character varying(255) | | |
| cached_sequence | integer | | |
| cached_ordered_volume_cubic_ft | double precision | | |
| cached_ordered_weight | double precision | | |
| color_number | integer | | |
| will_definitely_pick | boolean | | |
| sequence_recalculation_needed | boolean | | |
| distance_recalculation_needed | boolean | | |
| name_recalculation_needed | boolean | | |
| ordered_weight_recalculation_needed | boolean | | |
| ordered_amount_recalculation_needed | boolean | | |
| ordered_volume_cubic_ft_recalculation_needed | boolean | | |
| Indexes: | |
| "drops_droppointtrip_pkey" PRIMARY KEY, btree (id) | |
| "drops_droppointtrip_route_trip_id_key" UNIQUE CONSTRAINT, btree (route_trip_id, cached_sequence) | |
| "drops_droppointtrip_drop_point_id" btree (drop_point_id) | |
| "drops_droppointtrip_route_trip_id" btree (route_trip_id) | |
| Referenced by: | |
| TABLE "customer_service_rmarecord" CONSTRAINT "customer_service_rmarecord_drop_point_trip_id_fkey" FOREIGN KEY (drop_point_trip_id) REFERENCES drops_droppointtrip(id) DEFERRABLE INITIALLY DEFERRED | |
| beehive=# \d drops_droppointtrip | |
| Table "public.drops_droppointtrip" | |
| Column | Type | Modifiers | |
| ----------------------------------------------+--------------------------+------------------------------------------------------------------ | |
| id | integer | not null default nextval('drops_droppointtrip_id_seq'::regclass) | |
| created_at | timestamp with time zone | | |
| created_by | integer | | |
| updated_at | timestamp with time zone | | |
| updated_by | integer | | |
| drop_point_id | integer | not null | |
| route_trip_id | integer | not null | |
| cached_ordered_amount | numeric(12,2) | | |
| cached_distance | integer | | |
| cached_name | character varying(255) | | |
| cached_sequence | integer | | |
| cached_ordered_volume_cubic_ft | double precision | | |
| cached_ordered_weight | double precision | | |
| color_number | integer | | |
| will_definitely_pick | boolean | | |
| sequence_recalculation_needed | boolean | | |
| distance_recalculation_needed | boolean | | |
| name_recalculation_needed | boolean | | |
| ordered_weight_recalculation_needed | boolean | | |
| ordered_amount_recalculation_needed | boolean | | |
| ordered_volume_cubic_ft_recalculation_needed | boolean | | |
| cached_picked_weight | double precision | | |
| picked_weight_recalculation_needed | boolean | not null | |
| cached_picked_volume | double precision | | |
| picked_volume_recalculation_needed | boolean | not null | |
| Indexes: | |
| "drops_droppointtrip_pkey" PRIMARY KEY, btree (id) | |
| "drops_droppointtrip_route_trip_id_key" UNIQUE CONSTRAINT, btree (route_trip_id, cached_sequence) | |
| "drops_droppointtrip_drop_point_id" btree (drop_point_id) | |
| "drops_droppointtrip_route_trip_id" btree (route_trip_id) | |
| Referenced by: | |
| TABLE "customer_service_rmarecord" CONSTRAINT "customer_service_rmarecord_drop_point_trip_id_fkey" FOREIGN KEY (drop_point_trip_id) REFERENCES drops_droppointtrip(id) DEFERRABLE INITIALLY DEFERRED | |
| beehive=# |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment