-
Notifications
You must be signed in to change notification settings - Fork 0
/
ESqlDataType.cs
69 lines (51 loc) · 1.97 KB
/
ESqlDataType.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
using System.ComponentModel;
namespace PgsqlDataTypes
{
public enum EPgsqlDataTypes
{
//TEXT
//-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=--=-=-=-=-=-=-=-=-=-=
[Description("VARCHAR")]
Varchar,
[Description("TEXT")]
Text,
//NUMERIC
//-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=--=-=-=-=-=-=-=-=-=-=
[Description("INT")]
Int, //4 bytes typical choice for integer -2147483648 to +2147483647
[Description("SMALLINT")]
SmallInt, //2 bytes small-range integer -32768 to +32767
[Description("BIGINT")]
BigInt, //8 bytes large-range integer -9223372036854775808 to 9223372036854775807
[Description("FLOAT")]
Float,
[Description("BOOLEAN")]
Boolean, //1 byte state of true or false
[Description("DECIMAL")]
Decimal, // Up to 131072 digits before the decimal //
[Description("NUMERIC")]
Numeric, //Up to 131072 digits before the decimal,
[Description("MONEY")]
Money, //8 bytes currency amount -92233720368547758.08 to +92233720368547758.07
[Description("REAL")]
Real, //4 bytes variable-precision,inexact 6 decimal digits precision
[Description("SMALLSERIAL")]
Smallserial, //2 bytes small autoincrementing integer 1 to 32767
[Description("SERIAL")]
Serial, //4 bytes autoincrementing integer 1 to 2147483647
[Description("BIGSERIAL")]
Bigserial,
//DATE
//-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=--=-=-=-=-=-=-=-=-=-=
[Description("TIME")]
Time,
[Description("DATE")]
Date, //4 bytes date (no time of day) 4713 BC 5874897 AD
[Description("TIMESTAMP")]
Timestamp, //Storages Date and Time
[Description("TIMESTAMPTZ")]
Timestamptz, //Storages also timeszone
[Description("CURRENT_DATE")]
Current_Date, //Storages also timeszone
}
}