Data type Range Storage bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807), 19位有效數字 8 Bytes 萬用序號ID, ttyyyymmddhhnnssqqqq, TT(標籤不含在欄位內容中), (時間(14)+序號(4)=18位) int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647), 10位有效數字 4 Bytes smallint -2^15 (-32,768) to 2^15-1 (32,767) 2 Bytes tinyint 0 to 255 1 Byte