web涓枔浠舵暩(sh霉)鎿�(j霉)搴�(k霉)鎺ュ彛瀛楁瑾�(shu艒)鏄�
閰嶇疆瀹屾暩(sh霉)鎿�(j霉)婧愪箣鍚庯紝涓枔浠舵渻(hu矛)鑷嫊(d貌ng)鍓�(chu脿ng)寤� smsserver_in銆乻msserver_out銆乻msserver_calls 涓夊嫉琛�锛宻msserver_out 琛ㄧ敤浜庡瓨鏀惧緟鐧�(f膩)閫佺殑鐭俊浠ュ強鐭俊鐨勭櫦(f膩)閫佺祼(ji茅)鏋�,灏囬渶瑕佺櫦(f膩)閫佺殑鐭俊鎻掑叆鍒拌┎琛�锛屼腑闁撲欢鏈�(hu矛)鑷嫊(d貌ng)鐧�(f膩)閫侊紝骞跺皣鐧�(f膩)閫佺祼(ji茅)鏋滆閷勫埌瑭茶〃銆�
Smsserver_in 琛�锛屼腑闁撲欢鏀跺埌鐭俊浠ュ強鐙€鎱�(t脿i)鍫�(b脿o)鍛婁箣鍚�锛屾渻(hu矛)灏囧叾瀛樺叆瑭茶〃銆�
Smsserver_calls 琛�锛屼腑闁撲欢鎺ュ埌闆昏┍涔嬪悗鏈�(hu矛)灏囧叾瀛樺叆瑭茶〃銆�
鏁�(sh霉)鎿�(j霉)搴�(k霉)鎺ュ彛鏀寔鐨勯枊鐧�(f膩)瑾�(y菙)瑷€锛�java 銆�C銆�C++銆�C#銆�PHP銆�Ruby銆�VB 绛変竴鍒囧彲浠ユ搷浣滄暩(sh霉)鎿�(j霉)搴�(k霉)鐨勭法绋嬭獮(y菙)瑷€銆�
鏁�(sh霉)鎿�(j霉)搴�(k霉)琛ㄧ祼(ji茅)妲�(g貌u)瑾�(shu艒)鏄庯細
Smsserver_in 琛細
瀛楁鍚� 椤� 鍨� 灞� 鎬� 鎻� 杩�
id INT 鑷嫊(d貌ng) primary key.
process INT NOT NULL 闋�(y霉)鐣欏倷鐢�
originator CHAR(16) NOT NULL 鐧�(f膩)浠朵汉
type CHAR(1) NOT NULL 鐭俊椤炲瀷锛�"I"鏅€氱煭淇�, "S"鐭俊鐙€鎱�(t脿i)鍫�(b脿o)鍛�
encoding CHAR(1) NOT NULL 绶ㄧ⒓鏍煎紡锛�"7" for 7bit, "8" for 8bit and "U" for Unicode/UCS2
message_date DATETIME NOT NULL 鐭俊鐧�(f膩)閫佹棩鏈熸檪(sh铆)闁�
receive_date DATETIME NOT NULL 鎺ユ敹鏃ユ湡鏅�(sh铆)闁�
text CHAR(xxx) NOT NULL 姝ｆ枃
original_ref_no CHAR(64) NULL 鐢ㄤ簬鐭俊鐙€鎱�(t脿i)鍫�(b脿o)鍛�: 姝よ櫉(h脿o)纰煎皪(du矛)鎳�(y墨ng)浜庡鐧�(f膩)鐨勭煭淇″簭铏�(h脿o)
original_receive_date DATETIME NULL 鐢ㄤ簬鐭俊鐙€鎱�(t脿i)鍫�(b脿o)鍛�: 灏�(du矛)鏂规敹鍒扮煭淇＄殑鏃ユ湡鏅�(sh铆)闁�
gateway_id CHAR(64) NOT NULL 閫氶亾妯�(bi膩o)璀�(sh铆)锛岀敤浜庢(bi膩o)璀�(sh铆)鏄摢鍊�(g猫)閫氶亾鏀跺埌鐨勭煭淇�
Smsserver_out 琛ㄧ祼(ji茅)妲�(g貌u)瑾�(shu艒)鏄庯細
Smsserver_calls 琛ㄧ祼(ji茅)妲�(g貌u)瑾�(shu艒)鏄庯細
瀛楁鍚� 椤� 鍨� 灞� 鎬� 鎻� 杩�
id INT 鑷嫊(d貌ng) primary key.
call_date DATETIME NOT NULL 闆昏┍鍛煎叆鏅�(sh铆)闁�
gateway_id CHAR(64) NOT NULL 閫氶亾妯�(bi膩o)璀�(sh铆)
caller_id CHAR(16) NOT NULL 灏�(du矛)鏂硅櫉(h脿o)纰�