{"id":842,"date":"2024-11-09T11:38:52","date_gmt":"2024-11-09T03:38:52","guid":{"rendered":"https:\/\/web.neoedgecentral.com\/?p=842"},"modified":"2025-04-10T11:20:15","modified_gmt":"2025-04-10T03:20:15","slug":"it-service-database","status":"publish","type":"post","link":"https:\/\/www.ecloudedge.com\/en\/it-service-database\/","title":{"rendered":"IT Service - Database Description"},"content":{"rendered":"<p>When NeoFlow sends messages to your specified database system, it follows these operations:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>When the Gateway connects to the database system, it will automatically create the specified table if it does not already exist. Therefore, the database system user you provide must have privileges to create tables.<\/li>\n\n\n\n<li>The default table name is neoedge, which you can change in NeoFlow settings.<\/li>\n\n\n\n<li>The table field specifications are as follows:<\/li>\n\n\n\n<li>When a Message is generated, it will be added to the database using Insert SQL syntax.<\/li>\n\n\n\n<li>We recommend paying attention to the data volume in this data sheet and regularly removing unnecessary data.<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-stackable-columns stk-block-columns stk-block stk-fde28c2\" data-block-id=\"fde28c2\"><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-fde28c2-column\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-8e6c8a7 stk-block-background\" data-v=\"4\" data-block-id=\"8e6c8a7\"><style>.stk-8e6c8a7 {border-top-left-radius:6px !important;border-top-right-radius:6px !important;border-bottom-right-radius:6px !important;border-bottom-left-radius:6px !important;overflow:hidden !important;box-shadow:0 5px 5px 0 #123f5209 !important;border-style:solid !important;}<\/style><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-8e6c8a7-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-8e6c8a7-inner-blocks\">\n<div class=\"wp-block-stackable-columns stk-block-columns stk-block stk-013bac1\" data-block-id=\"013bac1\"><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-013bac1-column\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-1d33937\" data-v=\"4\" data-block-id=\"1d33937\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-1d33937-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-1d33937-inner-blocks\">\n<div class=\"wp-block-stackable-columns stk-block-columns stk-block stk-ebe4c6f\" data-block-id=\"ebe4c6f\"><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-ebe4c6f-column\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-7115ce2\" data-v=\"4\" data-block-id=\"7115ce2\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-7115ce2-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-7115ce2-inner-blocks\">\n<div class=\"wp-block-stackable-columns stk-block-columns stk-block stk-0ab494b\" data-block-id=\"0ab494b\"><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-0ab494b-column\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-e46ac07\" data-v=\"4\" data-block-id=\"e46ac07\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-e46ac07-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-e46ac07-inner-blocks\">\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<figure class=\"wp-block-table\">\n<table class=\"has-fixed-layout\" style=\"width: 100%; height: 60px;\">\n<tbody>\n<tr style=\"height: 20px;\">\n<td style=\"width: 8.4%; height: 20px;\"><strong>No<\/strong><\/td>\n<td style=\"width: 21.7334%; height: 20px;\"><strong>Column Name<\/strong><\/td>\n<td style=\"width: 23.9999%; height: 20px;\"><strong>Data Type<\/strong><\/td>\n<td style=\"width: 45.6%; height: 20px;\"><strong>Value Example<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 8.4%;\">1<\/td>\n<td style=\"width: 21.7334%;\">ID<\/td>\n<td style=\"width: 23.9999%;\">bigint, key<\/td>\n<td style=\"width: 45.6%;\">increasing number<\/td>\n<\/tr>\n<tr style=\"height: 20px;\">\n<td style=\"width: 8.4%; height: 20px;\">2<\/td>\n<td style=\"width: 21.7334%; height: 20px;\">timestamp<\/td>\n<td style=\"width: 23.9999%; height: 20px;\">BigInt<\/td>\n<td style=\"width: 45.6%; height: 20px;\">1728949646 milliseconds<\/td>\n<\/tr>\n<tr style=\"height: 20px;\">\n<td style=\"width: 8.4%; height: 20px;\">3<\/td>\n<td style=\"width: 21.7334%; height: 20px;\">payload<\/td>\n<td style=\"width: 23.9999%; height: 20px;\">text or nvarchar(max)<\/td>\n<td style=\"width: 45.6%; height: 20px;\"><a href=\"https:\/\/www.ecloudedge.com\/en\/neoflow-message-payload\/\" target=\"_blank\" rel=\"noreferrer noopener\">Message payload<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<\/div>\n<\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>NeoFlow \u5c07 \uff2dessage \u50b3\u9001\u5230\u60a8\u6307\u5b9a\u7684\u8cc7\u6599\u5eab\u7cfb\u7d71\u6642\uff0c\u6703\u4f9d\u5faa\u4e0b\u5217\u4f5c\u696d\uff1a No Column Name [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":843,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-support-documents"],"blocksy_meta":[],"uagb_featured_image_src":{"full":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-scaled.jpg",2560,1654,false],"thumbnail":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-150x150.jpg",150,150,true],"medium":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-300x194.jpg",300,194,true],"medium_large":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-768x496.jpg",768,496,true],"large":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-1024x662.jpg",1024,662,true],"1536x1536":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-1536x992.jpg",1536,992,true],"2048x2048":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-2048x1323.jpg",2048,1323,true],"trp-custom-language-flag":["https:\/\/www.ecloudedge.com\/wp-content\/uploads\/2024\/11\/database-18x12.jpg",18,12,true]},"uagb_author_info":{"display_name":"kevinkao","author_link":"https:\/\/www.ecloudedge.com\/en\/author\/kevinkao\/"},"uagb_comment_info":0,"uagb_excerpt":"NeoFlow \u5c07 \uff2dessage \u50b3\u9001\u5230\u60a8\u6307\u5b9a\u7684\u8cc7\u6599\u5eab\u7cfb\u7d71\u6642\uff0c\u6703\u4f9d\u5faa\u4e0b\u5217\u4f5c\u696d\uff1a No Column Name&hellip;","_links":{"self":[{"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/posts\/842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/comments?post=842"}],"version-history":[{"count":6,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/posts\/842\/revisions"}],"predecessor-version":[{"id":2701,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/posts\/842\/revisions\/2701"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/media\/843"}],"wp:attachment":[{"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/media?parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/categories?post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecloudedge.com\/en\/wp-json\/wp\/v2\/tags?post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}