Tablo No : 1062
Tablo Adı : mye_UserDataScheme | Tablo : Kullanıcı Veri Taslakları |
No | Alan Adı | Tip | Açıklama | Detay |
0 | TableID | Integer | Tablo No | |
1 | FieldOrder | Integer | ||
2 | FieldName | Nvarchar(40) | Alan adı | |
3 | DisplayName | Nvarchar(80) | ||
4 | FieldType | Tinyint | Alan tipi | 0:String 1:Integer 2:Real 3:Date 4:Time 5:Decimal 6:Money 7:Logical 8:Numeric 9:Float 10:Pascal String 14:Unsigned Integer 15:Autoincr 53:Date |
5 | FieldLength | Integer | ||
6 | DecimalLength | Integer | ||
7 | LookUpKind | Tinyint | ||
8 | LookUpTable | Integer | ||
9 | LookUpField | Nvarchar(80) | ||
10 | LookUpChoose | Nvarchar(80) | ||
11 | LookUpMultiSelect | Bit | ||
12 | LookUpString | Nvarchar(4000) | ||
13 | LookUpF10Mandatory | Bit | ||
14 | GroupName | Nvarchar(80) | ||
15 | ApplyCriteria | Bit | ||
16 | Cr1Field | Tinyint | ||
17 | Cr1Operation | Tinyint | ||
18 | Cr1Value | Nvarchar(80) | ||
19 | Cr1Link | Tinyint | ||
20 | Cr2Field | Tinyint | ||
21 | Cr2Operation | Tinyint | ||
22 | Cr2Value | Nvarchar(80) | ||
23 | Cr2Link | Tinyint | ||
24 | Cr3Field | Tinyint | ||
25 | Cr3Operation | Tinyint | ||
26 | Cr3Value | Nvarchar(80) | ||
27 | Cr3Link | Tinyint | ||
28 | RaporDesignId | Integer |
Indeks Tablosu | |||
Indeks | Özellik | Alanlar | |
NDX_mye_UserDataScheme_00 | CONSTRAINT PRIMARY KEY | TableID, FieldName |