-
Notifications
You must be signed in to change notification settings - Fork 13
/
proparse.schema
1939 lines (1939 loc) · 52.2 KB
/
proparse.schema
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
:: sports 1
: Benefits 8866
EmpNum 8867 INTEGER 0
HealthCare 8868 CHARACTER 0
LifeInsurance 8869 INTEGER 0
Pension401K 8870 INTEGER 0
StockPurchase 8871 INTEGER 0
MedicalSpending 8872 INTEGER 0
DependentCare 8873 INTEGER 0
: BillTo 8933
CustNum 8934 INTEGER 0
BillToID 8935 INTEGER 0
Name 8936 CHARACTER 0
Address 8937 CHARACTER 0
Address2 8938 CHARACTER 0
City 8939 CHARACTER 0
State 8940 CHARACTER 0
PostalCode 8941 CHARACTER 0
Contact 8942 CHARACTER 0
Phone 8943 CHARACTER 0
: Bin 9036
WarehouseNum 9038 INTEGER 0
Itemnum 9039 INTEGER 0
Qty 9040 INTEGER 0
BinNum 9041 INTEGER 0
BinName 9042 CHARACTER 0
: Customer 8578
CustNum 8581 INTEGER 0
Name 8582 CHARACTER 0
Address 8583 CHARACTER 0
Address2 8584 CHARACTER 0
City 8585 CHARACTER 0
State 8586 CHARACTER 0
Country 8587 CHARACTER 0
Phone 8588 CHARACTER 0
Contact 8589 CHARACTER 0
SalesRep 8590 CHARACTER 0
Comments 8591 CHARACTER 0
CreditLimit 8592 DECIMAL 0
Balance 8593 DECIMAL 0
Terms 8594 CHARACTER 0
Discount 8595 INTEGER 0
PostalCode 8596 CHARACTER 0
Fax 8608 CHARACTER 0
EmailAddress 8609 CHARACTER 0
: Department 8854
DeptCode 8855 CHARACTER 0
DeptName 8856 CHARACTER 0
: Employee 8753
LastName 8755 CHARACTER 0
FirstName 8756 CHARACTER 0
Address 8757 CHARACTER 0
Address2 8758 CHARACTER 0
City 8759 CHARACTER 0
State 8760 CHARACTER 0
PostalCode 8761 CHARACTER 0
DeptCode 8768 CHARACTER 0
Position 8769 CHARACTER 0
HomePhone 8770 CHARACTER 0
WorkPhone 8771 CHARACTER 0
VacationDaysLeft 8772 INTEGER 0
SickDaysLeft 8773 INTEGER 0
EmpNum 8774 INTEGER 0
StartDate 8775 DATE 0
Birthdate 8776 DATE 0
: Family 8844
RelativeName 8845 CHARACTER 0
Relation 8846 CHARACTER 0
Birthdate 8847 DATE 0
BenefitDate 8848 DATE 0
CoveredOnBenefits 8849 LOGICAL 0
EmpNum 8850 INTEGER 0
: Feedback 8729
Contact 8730 CHARACTER 0
Company 8736 CHARACTER 0
EmailAddress 8737 CHARACTER 0
Phone 8738 CHARACTER 0
Fax 8739 CHARACTER 0
Comments 8740 CHARACTER 0
Department 8741 CHARACTER 0
Rating 8742 INTEGER 0
: InventoryTrans 9120
InvTransNum 9122 INTEGER 0
WarehouseNum 9123 INTEGER 0
BinNum 9124 INTEGER 0
Qty 9125 INTEGER 0
Itemnum 9126 INTEGER 0
TransDate 9127 DATE 0
InvType 9128 CHARACTER 0
PONum 9129 INTEGER 0
Ordernum 9130 INTEGER 0
Transtime 9131 CHARACTER 0
: Invoice 8559
Invoicenum 8562 INTEGER 0
CustNum 8563 INTEGER 0
InvoiceDate 8564 DATE 0
Amount 8565 DECIMAL 0
TotalPaid 8566 DECIMAL 0
Adjustment 8567 DECIMAL 0
OrderNum 8568 INTEGER 0
ShipCharge 8569 DECIMAL 0
: Item 8621
Itemnum 8625 INTEGER 0
ItemName 8626 CHARACTER 0
CatPage 8627 INTEGER 0
Price 8628 DECIMAL 0
CatDescription 8629 CHARACTER 0
Onhand 8630 INTEGER 0
Allocated 8631 INTEGER 0
ReOrder 8632 INTEGER 0
OnOrder 8633 INTEGER 0
Category1 8634 CHARACTER 0
Category2 8635 CHARACTER 0
Special 8640 CHARACTER 0
Weight 8641 DECIMAL 0
Minqty 8642 INTEGER 0
: LocalDefault 8691
Country 8693 CHARACTER 0
Region1Label 8694 CHARACTER 0
Region2Label 8695 CHARACTER 0
PostalLabel 8696 CHARACTER 0
PostalFormat 8704 CHARACTER 0
TelFormat 8705 CHARACTER 0
DateFormat 8706 CHARACTER 0
CurrencySymbol 8707 CHARACTER 0
LocalDefNum 8708 INTEGER 0
: Order 8947
Ordernum 8949 INTEGER 0
CustNum 8950 INTEGER 0
OrderDate 8960 DATE 0
ShipDate 8961 DATE 0
PromiseDate 8962 DATE 0
Carrier 8963 CHARACTER 0
Instructions 8964 CHARACTER 0
PO 8965 CHARACTER 0
Terms 8966 CHARACTER 0
SalesRep 8967 CHARACTER 0
BillToID 8968 INTEGER 0
ShipToID 8969 INTEGER 0
OrderStatus 8970 CHARACTER 0
WarehouseNum 8971 INTEGER 0
Creditcard 8972 CHARACTER 0
: OrderLine 8655
Ordernum 8659 INTEGER 0
Linenum 8660 INTEGER 0
Itemnum 8661 INTEGER 0
Price 8662 DECIMAL 0
Qty 8663 INTEGER 0
Discount 8664 INTEGER 0
ExtendedPrice 8665 DECIMAL 0
OrderLineStatus 8666 CHARACTER 0
: POLine 9141
Linenum 9152 INTEGER 0
Itemnum 9153 INTEGER 0
Price 9154 DECIMAL 0
Qty 9155 INTEGER 0
Discount 9156 INTEGER 0
ExtendedPrice 9157 DECIMAL 0
PONum 9158 INTEGER 0
POLineStatus 9159 CHARACTER 0
: PurchaseOrder 9132
PONum 9134 INTEGER 0
DateEntered 9135 DATE 0
SupplierIDNum 9136 INTEGER 0
ReceiveDate 9137 DATE 0
POStatus 9138 CHARACTER 0
: RefCall 8711
CallNum 8713 CHARACTER 0
CustNum 8714 INTEGER 0
CallDate 8715 DATE 0
SalesRep 8716 CHARACTER 0
Parent 8717 CHARACTER 0
Txt 8718 CHARACTER 0
: Salesrep 8678
RepName 8679 CHARACTER 0
Region 8680 CHARACTER 0
SalesRep 8681 CHARACTER 0
MonthQuota 8682 INTEGER 12
: ShipTo 8876
CustNum 8877 INTEGER 0
ShipToID 8878 INTEGER 0
Contact 8879 CHARACTER 0
Address 8880 CHARACTER 0
Address2 8881 CHARACTER 0
City 8882 CHARACTER 0
State 8883 CHARACTER 0
PostalCode 8884 CHARACTER 0
Phone 8885 CHARACTER 0
Comments 8928 CHARACTER 0
Name 8929 CHARACTER 0
: State 8685
State 8686 CHARACTER 0
StateName 8687 CHARACTER 0
Region 8688 CHARACTER 0
: Supplier 8984
SupplierIDNum 8994 INTEGER 0
Name 8995 CHARACTER 0
Address 8996 CHARACTER 0
Address2 8997 CHARACTER 0
City 8998 CHARACTER 0
State 8999 CHARACTER 0
Country 9000 CHARACTER 0
Phone 9001 CHARACTER 0
Password 9002 CHARACTER 0
LoginDate 9003 DATE 0
Comments 9004 CHARACTER 0
ShipAmount 9005 INTEGER 0
PostalCode 9006 CHARACTER 0
Discount 9007 INTEGER 0
: SupplierItemXref 9163
SupplierIDNum 9164 INTEGER 0
Itemnum 9165 INTEGER 0
: TimeSheet 8784
EmpNum 8785 INTEGER 0
DayRecorded 8786 DATE 0
TypeRecorded 8787 CHARACTER 0
AMTimeIn 8788 CHARACTER 0
AMTimeOut 8789 CHARACTER 0
PMTimeIn 8790 CHARACTER 0
PMTimeOut 8791 CHARACTER 0
RegularHours 8832 DECIMAL 0
OvertimeHours 8833 DECIMAL 0
: Vacation 8837
EmpNum 8838 INTEGER 0
StartDate 8839 DATE 0
EndDate 8840 DATE 0
: Warehouse 9010
WarehouseNum 9012 INTEGER 0
WarehouseName 9024 CHARACTER 0
Country 9025 CHARACTER 0
Address 9026 CHARACTER 0
Address2 9027 CHARACTER 0
City 9028 CHARACTER 0
State 9029 CHARACTER 0
PostalCode 9030 CHARACTER 0
Phone 9031 CHARACTER 0
:: dictdb 0
: SYSATTACHTBLS 3621
OWNER 5058 CHARACTER 0
TBL 5059 CHARACTER 0
REMOWNER 5060 CHARACTER 0
REMTBL 5061 CHARACTER 0
LINKOWNER 5062 CHARACTER 0
DB_LINK 5063 CHARACTER 0
: SYSBIGINTSTAT 3650
TBLID 5324 INTEGER 0
COLID 5325 INTEGER 0
PROPERTY 5326 INTEGER 0
ATTRIBUTE 5327 INTEGER 0
VALUE 5328 BIGINT 0
: SYSCALCTABLE 3618
FLD 5038 INTEGER 0
: SYSCHARSTAT 3636
TBLID 5296 INTEGER 0
COLID 5297 INTEGER 0
PROPERTY 5298 INTEGER 0
ATTRIBUTE 5299 INTEGER 0
VALUE 5300 CHARACTER 0
: SYSCHKCONSTR_NAME_MAP 3656
OWNER 5363 CHARACTER 0
TBLNAME 5364 CHARACTER 0
CNSTRNAME 5365 CHARACTER 0
SEQ 5366 INTEGER 0
NAME_LOC 5367 INTEGER 0
: SYSCOLAUTH 3609
GRANTOR 4933 CHARACTER 0
GRANTEE 4934 CHARACTER 0
TBLOWNER 4935 CHARACTER 0
TBL 4936 CHARACTER 0
COL 4937 CHARACTER 0
UPD 4938 CHARACTER 0
REF 4939 CHARACTER 0
SEL 4940 CHARACTER 0
: SYSCOLSTAT 3628
TBLID 5207 INTEGER 0
COLID 5248 INTEGER 0
PROPERTY 5249 INTEGER 0
ATTRIBUTE 5250 INTEGER 0
VALUE 5251 INTEGER 0
VAL_TS 5252 TIMESTAMP 0
: SYSCOLUMNS 3604
ID 4868 INTEGER 0
COL 4869 CHARACTER 0
TBL 4870 CHARACTER 0
OWNER 4871 CHARACTER 0
COLTYPE 4872 CHARACTER 0
WIDTH 4873 INTEGER 0
SCALE 4874 INTEGER 0
NULLFLAG 4875 CHARACTER 0
DFLT_VALUE 4876 CHARACTER 0
CHARSET 4877 CHARACTER 0
COLLATION 4878 CHARACTER 0
: SYSCOLUMNS_FULL 3627
ID 5170 INTEGER 0
COL 5171 CHARACTER 0
TBL 5172 CHARACTER 0
OWNER 5173 CHARACTER 0
COLTYPE 5174 CHARACTER 0
WIDTH 5175 INTEGER 0
SCALE 5176 INTEGER 0
NULLFLAG 5184 FIXCHAR 0
DFLT_VALUE 5185 CHARACTER 0
CHARSET 5186 CHARACTER 0
COLLATION 5187 CHARACTER 0
COL_SUBTYPE 5188 INTEGER 0
LABEL 5189 CHARACTER 0
FORMAT 5190 CHARACTER 0
FIELD_RPOS 5191 INTEGER 0
DISPLAY_ORDER 5192 INTEGER 0
ARRAY_EXTENT 5193 INTEGER 0
VALEXP 5194 CHARACTER 0
VALMSG 5195 CHARACTER 0
HELP 5196 CHARACTER 0
DESCRIPTION 5197 CHARACTER 0
COL_LABEL 5198 CHARACTER 0
VIEW_AS 5199 CHARACTER 0
DFLT_VALUE_SA 5200 CHARACTER 0
LABEL_SA 5201 CHARACTER 0
FORMAT_SA 5202 CHARACTER 0
VALMSG_SA 5203 CHARACTER 0
HELP_SA 5204 CHARACTER 0
COL_LABEL_SA 5205 CHARACTER 0
USER_MISC 5206 CHARACTER 0
: SYSDATATYPES 3617
DHTYPENAME 5025 CHARACTER 0
DATATYPE 5026 SHORT 0
TYPEPRECISION 5027 INTEGER 0
LITERALPREFIX 5028 CHARACTER 0
LITERALSUFFIX 5029 CHARACTER 0
CREATEPARAMS 5030 CHARACTER 0
NULLABLE 5031 SHORT 0
CASESENSITIVE 5032 SHORT 0
SEARCHABLE 5033 SHORT 0
UNSIGNEDATTR 5034 SHORT 0
ODBCMONEY 5035 SHORT 0
AUTOINCR 5036 SHORT 0
LOCALTYPENAME 5037 CHARACTER 0
: SYSDATESTAT 3633
TBLID 5281 INTEGER 0
COLID 5282 INTEGER 0
PROPERTY 5283 INTEGER 0
ATTRIBUTE 5284 INTEGER 0
VALUE 5285 DATE 0
: SYSDBAUTH 3607
GRANTEE 4911 CHARACTER 0
DBA_ACC 4912 CHARACTER 0
RES_ACC 4913 CHARACTER 0
: SYSDBLINKS 3611
OWNER 4948 CHARACTER 0
DB_LINK 4949 CHARACTER 0
USERNAME 4950 CHARACTER 0
PASSWORD 4951 CHARACTER 0
HOST 4952 CHARACTER 0
: SYSFLOATSTAT 3634
TBLID 5286 INTEGER 0
COLID 5287 INTEGER 0
PROPERTY 5288 INTEGER 0
ATTRIBUTE 5289 INTEGER 0
VALUE 5290 DOUBLE 0
: SYSIDXSTAT 3620
TBLID 5044 INTEGER 0
IDXID 5045 INTEGER 0
PROPERTY 5046 INTEGER 0
ATTRIBUTE 5047 INTEGER 0
VALUE 5056 INTEGER 0
VAL_TS 5057 TIMESTAMP 0
: SYSINDEXES 3606
ID 4884 INTEGER 0
IDXSEGID 4885 INTEGER 0
IDXNAME 4886 CHARACTER 0
IDXOWNER 4887 CHARACTER 0
TBL 4888 CHARACTER 0
TBLOWNER 4896 CHARACTER 0
COLNAME 4897 CHARACTER 0
IDXTYPE 4898 FIXCHAR 0
IDXORDER 4899 FIXCHAR 0
IDXCOMPRESS 4900 FIXCHAR 0
IDXMETHOD 4901 CHARACTER 0
IDXSEQ 4902 INTEGER 0
RSSID 4903 INTEGER 0
ACTIVE 4904 LOGICAL 0
WORDIDX 4905 INTEGER 0
desc 4906 CHARACTER 0
ABBREVIATE 4907 LOGICAL 0
UNSORTED 4908 LOGICAL 0
INDEX_USER_MISC 4909 CHARACTER 0
IXCOL_USER_MISC 4910 CHARACTER 0
: SYSINTSTAT 3631
TBLID 5263 INTEGER 0
COLID 5264 INTEGER 0
PROPERTY 5265 INTEGER 0
ATTRIBUTE 5266 INTEGER 0
VALUE 5267 INTEGER 0
: SYSNCHARSTAT 3651
TBLID 5329 INTEGER 0
COLID 5330 INTEGER 0
PROPERTY 5331 INTEGER 0
ATTRIBUTE 5332 INTEGER 0
VALUE 5333 FIXCHAR 0
: SYSNUMSTAT 3632
TBLID 5268 INTEGER 0
COLID 5269 INTEGER 0
PROPERTY 5270 INTEGER 0
ATTRIBUTE 5271 INTEGER 0
VALUE 5280 DECIMAL 0
: SYSNVARCHARSTAT 3652
TBLID 5334 INTEGER 0
COLID 5335 INTEGER 0
PROPERTY 5344 INTEGER 0
ATTRIBUTE 5345 INTEGER 0
VALUE 5346 CHARACTER 0
: SYSPROCBIN 3760
RSSID 5760 INTEGER 0
ID 5761 INTEGER 0
PROC_TYPE 5762 FIXCHAR 0
SEQ 5763 INTEGER 0
PROC_BIN 5764 RAW 0
: SYSPROCCOLUMNS 3623
ID 5073 INTEGER 0
COL 5074 CHARACTER 0
PROC_ID 5075 INTEGER 0
RSSID 5076 INTEGER 0
DATATYPE 5077 CHARACTER 0
ARGTYPE 5078 CHARACTER 0
WIDTH 5079 INTEGER 0
SCALE 5080 INTEGER 0
NULLFLAG 5088 FIXCHAR 0
DFLT_VALUE 5089 CHARACTER 0
: SYSPROCEDURES 3622
PROC_ID 5064 INTEGER 0
PROC_NAME 5065 CHARACTER 0
CREATOR 5066 CHARACTER 0
OWNER 5067 CHARACTER 0
RSSID 5068 INTEGER 0
PROC_TYPE 5069 CHARACTER 0
HAS_RESULTSET 5070 FIXCHAR 0
HAS_RETURN_VAL 5071 FIXCHAR 0
LANG 5072 INTEGER 0
: SYSPROCTEXT 3776
RSSID 5765 INTEGER 0
ID 5766 INTEGER 0
PROC_TYPE 5767 FIXCHAR 0
SEQ 5768 INTEGER 0
PROC_TEXT 5769 CHARACTER 0
: SYSREALSTAT 3637
TBLID 5301 INTEGER 0
COLID 5302 INTEGER 0
PROPERTY 5303 INTEGER 0
ATTRIBUTE 5312 INTEGER 0
VALUE 5313 FLOAT 0
: SYSROLES 3657
ROLENAME 5368 CHARACTER 0
GRANTOR 5408 CHARACTER 0
GRANTEE 5409 CHARACTER 0
ADMIN 5410 LOGICAL 0
: SYSSCHEMAS 3658
SCHEMANAME 5411 CHARACTER 0
OWNER 5412 CHARACTER 0
: SYSSEQAUTH 3654
GRANTOR 5352 CHARACTER 0
GRANTEE 5353 CHARACTER 0
SEQ-OWNER 5354 CHARACTER 0
SEQ-NAME 5355 CHARACTER 0
UPD 5356 CHARACTER 0
REF 5357 CHARACTER 0
SEL 5358 CHARACTER 0
: SYSSEQUENCES 3660
SEQ-NAME 5418 CHARACTER 0
SEQ-NUM 5417 INTEGER 0
SEQ-INIT 5419 INTEGER 0
SEQ-INCR 5420 INTEGER 0
SEQ-MIN 5421 INTEGER 0
SEQ-MAX 5422 INTEGER 0
CYCLE-OK 5423 LOGICAL 0
SEQ-MISC 5424 CHARACTER 8
DB-RECID 5425 RECID 0
USER-MISC 5426 CHARACTER 0
SEQ-OWNER 5427 CHARACTER 0
: SYSSMINTSTAT 3630
TBLID 5258 INTEGER 0
COLID 5259 INTEGER 0
PROPERTY 5260 INTEGER 0
ATTRIBUTE 5261 INTEGER 0
VALUE 5262 SHORT 0
: SYSSQL_PROPERTIES 3659
PROPERTY 5413 INTEGER 0
ATTRIBUTE 5414 INTEGER 0
VALUE_N 5415 INTEGER 0
VALUE_CH 5416 CHARACTER 0
: SYSSYNONYMS 3610
SNAME 4941 CHARACTER 0
SOWNER 4942 CHARACTER 0
SCREATOR 4943 CHARACTER 0
STBL 4944 CHARACTER 0
STBLOWNER 4945 CHARACTER 0
ISPUBLIC 4946 SHORT 0
SREMDB 4947 CHARACTER 0
: SYSTABAUTH 3608
GRANTOR 4914 CHARACTER 0
GRANTEE 4915 CHARACTER 0
TBLOWNER 4916 CHARACTER 0
TBL 4917 CHARACTER 0
INS 4918 CHARACTER 0
DEL 4919 CHARACTER 0
UPD 4920 CHARACTER 0
SEL 4928 CHARACTER 0
EXE 4929 FIXCHAR 0
NDX 4930 CHARACTER 0
ALT 4931 CHARACTER 0
REF 4932 CHARACTER 0
: SYSTABLES 3603
ID 4817 INTEGER 0
TBL 4818 CHARACTER 0
CREATOR 4819 CHARACTER 0
OWNER 4820 CHARACTER 0
TBLTYPE 4821 CHARACTER 0
SEGID 4822 INTEGER 0
HAS_PCNSTRS 4823 CHARACTER 0
HAS_FCNSTRS 4824 CHARACTER 0
HAS_CCNSTRS 4864 CHARACTER 0
HAS_UCNSTRS 4865 CHARACTER 0
TBL_STATUS 4866 CHARACTER 0
RSSID 4867 INTEGER 0
: SYSTABLES_FULL 3626
ID 5105 INTEGER 0
TBL 5106 CHARACTER 0
CREATOR 5107 CHARACTER 0
OWNER 5108 CHARACTER 0
TBLTYPE 5109 CHARACTER 0
SEGID 5110 INTEGER 0
HAS_PCNSTRS 5111 CHARACTER 0
HAS_FCNSTRS 5112 CHARACTER 0
HAS_CCNSTRS 5152 CHARACTER 0
HAS_UCNSTRS 5153 CHARACTER 0
TBL_STATUS 5154 CHARACTER 0
RSSID 5155 INTEGER 0
PRIME_INDEX 5156 INTEGER 0
DESCRIPTION 5157 CHARACTER 0
VALEXP 5158 CHARACTER 0
VALMSG 5159 CHARACTER 0
LAST_CHANGE 5160 INTEGER 0
HIDDEN 5161 LOGICAL 0
FROZEN 5162 LOGICAL 0
DUMP_NAME 5163 CHARACTER 0
FILE_LABEL 5164 CHARACTER 0
CAN_DUMP 5165 CHARACTER 0
CAN_LOAD 5166 CHARACTER 0
VALMSG_SA 5167 CHARACTER 0
FILE_LABEL_SA 5168 CHARACTER 0
USER_MISC 5169 CHARACTER 0
: SYSTBLSTAT 3619
TBLID 5039 INTEGER 0
PROPERTY 5040 INTEGER 0
ATTRIBUTE 5041 INTEGER 0
VALUE 5042 INTEGER 0
VAL_TS 5043 TIMESTAMP 0
: SYSTIMESTAT 3635
TBLID 5291 INTEGER 0
COLID 5292 INTEGER 0
PROPERTY 5293 INTEGER 0
ATTRIBUTE 5294 INTEGER 0
VALUE 5295 TIME 0
: SYSTINYINTSTAT 3649
TBLID 5319 INTEGER 0
COLID 5320 INTEGER 0
PROPERTY 5321 INTEGER 0
ATTRIBUTE 5322 INTEGER 0
VALUE 5323 INTEGER 0
: SYSTRIGCOLS 3625
TRIGGERNAME 5102 CHARACTER 0
OWNER 5103 CHARACTER 0
COLID 5104 INTEGER 0
: SYSTRIGGER 3624
TRIGGERID 5090 INTEGER 0
TRIGGERNAME 5091 CHARACTER 0
OWNER 5092 CHARACTER 0
TBL 5093 CHARACTER 0
TBLOWNER 5094 CHARACTER 0
TRIGGER_TIME 5095 CHARACTER 0
TRIGGER_EVENT 5096 CHARACTER 0
REFERS_TO_OLD 5097 FIXCHAR 0
REFERS_TO_NEW 5098 FIXCHAR 0
STATEMENT_OR_ROW 5099 FIXCHAR 0
RSSID 5100 INTEGER 0
FIRE_4GL 5101 LOGICAL 0
: SYSTSSTAT 3648
TBLID 5314 INTEGER 0
COLID 5315 INTEGER 0
PROPERTY 5316 INTEGER 0
ATTRIBUTE 5317 INTEGER 0
VALUE 5318 TIMESTAMP 0
: SYSTSTZSTAT 3653
TBLID 5347 INTEGER 0
COLID 5348 INTEGER 0
PROPERTY 5349 INTEGER 0
ATTRIBUTE 5350 INTEGER 0
VALUE 5351 DATETIME-TZ 0
: SYSVARCHARSTAT 3629
TBLID 5253 INTEGER 0
COLID 5254 INTEGER 0
PROPERTY 5255 INTEGER 0
ATTRIBUTE 5256 INTEGER 0
VALUE 5257 CHARACTER 0
: SYSVIEWS 3605
VIEWNAME 4879 CHARACTER 0
CREATOR 4880 CHARACTER 0
OWNER 4881 CHARACTER 0
SEQ 4882 INTEGER 0
VIEWTEXT 4883 CHARACTER 0
: SYSVIEWS_NAME_MAP 3655
OWNER 5359 CHARACTER 0
VIEWNAME 5360 CHARACTER 0
SEQ 5361 INTEGER 0
NAME_LOC 5362 INTEGER 0
: SYS_CHKCOL_USAGE 3616
OWNER 5014 CHARACTER 0
TBLNAME 5015 CHARACTER 0
CNSTRNAME 5016 CHARACTER 0
COLNAME 5024 CHARACTER 0
: SYS_CHK_CONSTRS 3614
OWNER 5004 CHARACTER 0
TBLNAME 5005 CHARACTER 0
CNSTRNAME 5006 CHARACTER 0
CHKSEQ 5007 INTEGER 0
CHKCLAUSE 5008 CHARACTER 0
: SYS_KEYCOL_USAGE 3612
OWNER 4992 CHARACTER 0
TBLNAME 4993 CHARACTER 0
CNSTRNAME 4994 CHARACTER 0
COLNAME 4995 CHARACTER 0
COLPOSITION 4996 INTEGER 0
: SYS_REF_CONSTRS 3613
OWNER 4997 CHARACTER 0
TBLNAME 4998 CHARACTER 0
CNSTRNAME 4999 CHARACTER 0
REFOWNER 5000 CHARACTER 0
REFTBLNAME 5001 CHARACTER 0
REFCNSTRNAME 5002 CHARACTER 0
DELETERULE 5003 CHARACTER 0
: SYS_TBL_CONSTRS 3615
OWNER 5009 CHARACTER 0
TBLNAME 5010 CHARACTER 0
CNSTRNAME 5011 CHARACTER 0
CNSTRTYPE 5012 CHARACTER 0
IDXNAME 5013 CHARACTER 0
: _ActAILog 6611
_AiLog-Id 7079 INTEGER 0
_AiLog-TotWrites 7080 INTEGER 0
_AiLog-AIWWrites 7081 INTEGER 0
_AiLog-RecWriten 7082 INTEGER 0
_AiLog-BytesWritn 7083 INTEGER 0
_AiLog-BBuffWaits 7084 INTEGER 0
_AiLog-NoBufAvail 7085 INTEGER 0
_AiLog-PartialWrt 7086 INTEGER 0
_AiLog-ForceWaits 7087 INTEGER 0
_AiLog-Trans 7088 INTEGER 0
_AiLog-UpTime 7089 INTEGER 0
_AiLog-Misc 7090 INTEGER 0
: _ActBILog 6610
_BiLog-Id 7051 INTEGER 0
_BiLog-TotalWrts 7052 INTEGER 0
_BiLog-BIWWrites 7053 INTEGER 0
_BiLog-RecWriten 7054 INTEGER 0
_BiLog-BytesWrtn 7055 INTEGER 0
_BiLog-TotReads 7056 INTEGER 0
_BiLog-RecRead 7057 INTEGER 0
_BiLog-BytesRead 7058 INTEGER 0
_BiLog-ClstrClose 7059 INTEGER 0
_BiLog-BBuffWaits 7060 INTEGER 0
_BiLog-EBuffWaits 7072 INTEGER 0
_BiLog-ForceWaits 7073 INTEGER 0
_BiLog-ForceWrts 7074 INTEGER 0
_BiLog-PartialWrts 7075 INTEGER 0
_BiLog-Trans 7076 INTEGER 0
_BiLog-UpTime 7077 INTEGER 0
_BiLog-Misc 7078 INTEGER 0
: _ActBuffer 6608
_Buffer-Id 7010 INTEGER 0
_Buffer-LogicRds 7011 INTEGER 0
_Buffer-LogicWrts 7012 INTEGER 0
_Buffer-OSRds 7013 INTEGER 0
_Buffer-OSWrts 7014 INTEGER 0
_Buffer-Chkpts 7015 INTEGER 0
_Buffer-Marked 7016 INTEGER 0
_Buffer-Flushed 7017 INTEGER 0
_Buffer-Deferred 7018 INTEGER 0
_Buffer-LRUSkips 7019 INTEGER 0
_Buffer-LRUWrts 7020 INTEGER 0
_Buffer-APWEnq 7021 INTEGER 0
_Buffer-Trans 7022 INTEGER 0
_Buffer-UpTime 7023 INTEGER 0
_Buffer-Misc 7024 INTEGER 0
: _ActIndex 6616
_Index-Id 7217 INTEGER 0
_Index-Find 7218 INTEGER 0
_Index-Create 7219 INTEGER 0
_Index-Delete 7220 INTEGER 0
_Index-Remove 7232 INTEGER 0
_Index-Splits 7233 INTEGER 0
_Index-Free 7234 INTEGER 0
_Index-Trans 7235 INTEGER 0
_Index-UpTime 7236 INTEGER 0
_Index-Misc 7237 INTEGER 0
: _ActIOFile 6614
_IOFile-Id 7177 INTEGER 0
_IOFile-FileName 7178 CHARACTER 0
_IOFile-Reads 7179 INTEGER 0
_IOFile-Writes 7180 INTEGER 0
_IOFile-Extends 7181 INTEGER 0
_IOFile-Trans 7182 INTEGER 0
_IOFile-BufWrites 7183 INTEGER 0
_IOFile-UbufWrites 7184 INTEGER 0
_IOFile-BufReads 7185 INTEGER 0
_IOFile-UbufReads 7186 INTEGER 0
_IOFile-UpTime 7187 INTEGER 0
_IOFile-Misc 7188 INTEGER 0
: _ActIOType 6613
_IOType-Id 7123 INTEGER 0
_IOType-IdxRds 7124 INTEGER 0
_IOType-DataReads 7125 INTEGER 0
_IOType-BiRds 7168 INTEGER 0
_IOType-AiRds 7169 INTEGER 0
_IOType-IdxWrts 7170 INTEGER 0
_IOType-DataWrts 7171 INTEGER 0
_IOType-BiWrts 7172 INTEGER 0
_IOType-AiWrts 7173 INTEGER 0
_IOType-Trans 7174 INTEGER 0
_IOType-UpTime 7175 INTEGER 0
_IOType-Misc 7176 INTEGER 0
: _ActLock 6612
_Lock-Id 7091 INTEGER 0
_Lock-ShrReq 7092 INTEGER 0
_Lock-ExclReq 7104 INTEGER 0
_Lock-UpgReq 7105 INTEGER 0
_Lock-RecGetReq 7106 INTEGER 0
_Lock-ShrLock 7107 INTEGER 0
_Lock-ExclLock 7108 INTEGER 0
_Lock-UpgLock 7109 INTEGER 0
_Lock-RecGetLock 7110 INTEGER 0
_Lock-ShrWait 7111 INTEGER 0
_Lock-ExclWait 7112 INTEGER 0
_Lock-UpgWait 7113 INTEGER 0
_Lock-RecGetWait 7114 INTEGER 0
_Lock-CanclReq 7115 INTEGER 0
_Lock-Downgrade 7116 INTEGER 0
_Lock-RedReq 7117 INTEGER 0
_Lock-Trans 7118 INTEGER 0
_Lock-UpTime 7119 INTEGER 0
_Lock-ExclFind 7121 INTEGER 0
_Lock-ShrFind 7122 INTEGER 0
_Lock-Misc 7120 INTEGER 0
: _ActOther 6618
_Other-Id 7329 INTEGER 0
_Other-Commit 7330 INTEGER 0
_Other-Undo 7331 INTEGER 0
_Other-Wait 7332 INTEGER 0
_Other-FlushMblk 7333 INTEGER 0
_Other-Trans 7334 INTEGER 0
_Other-UpTime 7335 INTEGER 0
_Other-Misc 7336 INTEGER 0
: _ActPWs 6609
_PW-Id 7025 INTEGER 0
_PW-TotDBWrites 7026 INTEGER 0
_PW-DBWrites 7027 INTEGER 0
_PW-ScanWrites 7028 INTEGER 0
_PW-ApwQWrites 7040 INTEGER 0
_PW-CkpQWrites 7041 INTEGER 0
_PW-ScanCycles 7042 INTEGER 0
_PW-BuffsScaned 7043 INTEGER 0
_PW-BufsCkp 7044 INTEGER 0
_PW-Checkpoints 7045 INTEGER 0
_PW-Marked 7046 INTEGER 0
_PW-Flushed 7047 INTEGER 0
_PW-Trans 7048 INTEGER 0
_PW-UpTime 7049 INTEGER 0
_PW-Misc 7050 INTEGER 0
: _ActRecord 6617
_Record-Id 7238 INTEGER 0
_Record-RecRead 7239 INTEGER 0
_Record-RecUpd 7240 INTEGER 0
_Record-RecCreat 7241 INTEGER 0
_Record-RecDel 7242 INTEGER 0
_Record-FragRead 7243 INTEGER 0
_Record-FragCreat 7244 INTEGER 0
_Record-FragDel 7245 INTEGER 0
_Record-FragUpd 7246 INTEGER 0
_Record-BytesRead 7247 INTEGER 0
_Record-BytesCreat 7248 INTEGER 0
_Record-BytesDel 7249 INTEGER 0
_Record-BytesUpd 7250 INTEGER 0
_Record-Trans 7251 INTEGER 0
_Record-UpTime 7252 INTEGER 0
_Record-Misc 7328 INTEGER 0
: _ActServer 6607
_Server-Id 6987 INTEGER 0
_Server-MsgRec 6988 INTEGER 0
_Server-MsgSent 6989 INTEGER 0
_Server-ByteRec 6990 INTEGER 0
_Server-ByteSent 6991 INTEGER 0
_Server-RecRec 6992 INTEGER 0
_Server-RecSent 6993 INTEGER 0
_Server-QryRec 6994 INTEGER 0
_Server-TimeSlice 6995 INTEGER 0
_Server-Trans 6996 INTEGER 0
_Server-UpTime 7008 INTEGER 0
_Server-Misc 7009 INTEGER 0
: _ActSpace 6615
_Space-Id 7200 INTEGER 0
_Space-DbExd 7201 INTEGER 0
_Space-TakeFree 7202 INTEGER 0
_Space-RetFree 7203 INTEGER 0
_Space-AllocNewRm 7204 INTEGER 0
_Space-FromRm 7205 INTEGER 0
_Space-FromFree 7206 INTEGER 0
_Space-BytesAlloc 7207 INTEGER 0
_Space-Examined 7208 INTEGER 0
_Space-Removed 7209 INTEGER 0
_Space-FrontAdd 7210 INTEGER 0
_Space-BackAdd 7211 INTEGER 0
_Space-Front2Back 7212 INTEGER 0
_Space-Locked 7213 INTEGER 0
_Space-Trans 7214 INTEGER 0
_Space-UpTime 7215 INTEGER 0
_Space-Misc 7216 INTEGER 0
: _ActSummary 6606
_Summary-Id 6957 INTEGER 0
_Summary-Commits 6958 INTEGER 0
_Summary-Undos 6959 INTEGER 0
_Summary-RecReads 6960 INTEGER 0
_Summary-RecUpd 6961 INTEGER 0
_Summary-RecCreat 6962 INTEGER 0
_Summary-RecDel 6963 INTEGER 0
_Summary-RecLock 6964 INTEGER 0
_Summary-RecWait 6965 INTEGER 0
_Summary-DbReads 6976 INTEGER 0
_Summary-DbWrites 6977 INTEGER 0
_Summary-BiReads 6978 INTEGER 0
_Summary-BiWrites 6979 INTEGER 0
_Summary-AiWrites 6980 INTEGER 0
_Summary-Chkpts 6981 INTEGER 0
_Summary-Flushed 6982 INTEGER 0
_Summary-TransComm 6983 INTEGER 0
_Summary-UpTime 6984 INTEGER 0
_Summary-DbAccesses 6985 INTEGER 0
_Summary-Misc 6986 INTEGER 0
: _Area 3464
_Area-version 4133 INTEGER 0
_Area-number 4134 INTEGER 0
_Area-name 4135 CHARACTER 0
_Area-type 4136 INTEGER 0
_Area-block 4137 RECID 0
_Area-attrib 4138 INTEGER 0
_Area-clustersize 4139 INTEGER 0
_Area-blocksize 4140 INTEGER 0
_Area-recbits 4141 INTEGER 0
_Area-extents 4142 INTEGER 0
_Area-misc 4143 INTEGER 8
: _AreaExtent 3466
_Area-recid 4144 RECID 0
_Extent-version 4145 INTEGER 0
_Extent-number 4146 INTEGER 0
_Area-number 4147 INTEGER 0
_Extent-type 4148 INTEGER 0
_Extent-attrib 4149 INTEGER 0
_Extent-system 4150 INTEGER 0
_Extent-size 4224 INTEGER 0
_Extent-path 4225 CHARACTER 0
_Extent-misc 4226 INTEGER 8
: _AreaStatus 6639
_AreaStatus-Id 7618 INTEGER 0
_AreaStatus-Areaname 7620 CHARACTER 0
_AreaStatus-Areanum 7619 INTEGER 0
_AreaStatus-Totblocks 7621 INTEGER 0
_AreaStatus-Hiwater 7622 INTEGER 0
_AreaStatus-Extents 7623 INTEGER 0
_AreaStatus-Lastextent 7624 CHARACTER 0
_AreaStatus-Freenum 7625 INTEGER 0
_AreaStatus-Rmnum 7626 INTEGER 0
: _AreaThreshold 6645
_AreaThreshold-ID 7699 INTEGER 0
_AreaThresholdArea 7700 INTEGER 0
_AreaThreshold 7712 INTEGER 0
: _Block 6624
_Block-Id 7337 INTEGER 0
_Block-Dbkey 7338 INTEGER 0
_Block-Type 7339 CHARACTER 0
_Block-ChainType 7340 CHARACTER 0
_Block-BkupCtr 7341 INTEGER 0
_Block-NextDbkey 7342 INTEGER 0
_Block-Update 7343 INTEGER 0
_Block-Area 7344 INTEGER 0
_Block-Block 7345 CHARACTER 0
_Block-Misc 7346 INTEGER 0
: _BuffStatus 6599
_BfStatus-Id 6785 INTEGER 0
_BfStatus-TotBufs 6786 INTEGER 0
_BfStatus-HashSize 6787 INTEGER 0
_BfStatus-UsedBuffs 6788 INTEGER 0
_BfStatus-LRU 6789 INTEGER 0
_BfStatus-APWQ 6790 INTEGER 0
_BfStatus-CKPQ 6791 INTEGER 0
_BfStatus-ModBuffs 6792 INTEGER 0
_BfStatus-CKPMarked 6793 INTEGER 0
_BfStatus-LastCkpNum 6794 INTEGER 0
_BfStatus-Misc 6795 INTEGER 0
: _Checkpoint 6627
_Checkpoint-Id 7380 INTEGER 0
_Checkpoint-Time 7381 CHARACTER 0
_Checkpoint-Len 7456 CHARACTER 0
_Checkpoint-Dirty 7457 INTEGER 0
_Checkpoint-CptQ 7458 INTEGER 0
_Checkpoint-Scan 7459 INTEGER 0
_Checkpoint-ApwQ 7460 INTEGER 0
_Checkpoint-Flush 7461 INTEGER 0
_Checkpoint-Misc 7462 INTEGER 0
: _Client-Session 3662
_Client-session-uuid 5428 CHARACTER 0
_Client-name 5429 CHARACTER 0
_User-id 5504 CHARACTER 0
_Authentication-date-time 5505 DATETIME-TZ 0
_Server-uuid 5506 CHARACTER 0
_Authentication-domain-type 5507 CHARACTER 0
_Authentication-domain-name 5508 CHARACTER 0
_Db-guid 5509 CHARACTER 0
_Session-custom-detail 5510 CHARACTER 0
_Audit-data-security-level 5512 INTEGER 0
_Data-seal 5511 CHARACTER 0
: _Code-Feature 6644
_CodeFeature-ID 7693 INTEGER 0
_CodeFeature_Name 7694 CHARACTER 0
_CodeFeature_Supported 7695 CHARACTER 0
_CodeFeature_Required 7696 CHARACTER 0
_CodeFeature-Res01 7697 CHARACTER 10
_CodeFeature-Res02 7698 INTEGER 10
: _Codepage 3469
_Cp-Name 4227 CHARACTER 0
_Cp-Sequence 4228 INTEGER 0
_Cp-Dbrecid 4229 RECID 0
_Cp-Attr 4230 RAW 0
: _Collation 3472
_Coll-Name 4231 CHARACTER 0
_Coll-Sequence 4232 INTEGER 0
_Coll-Cp 4233 INTEGER 0
_Coll-Tran-Version 4234 INTEGER 0
_Coll-Tran-Subtype 4235 INTEGER 0
_Coll-Segment 4236 INTEGER 0
_Coll-Data 4237 RAW 0
: _Connect 6596
_Connect-Id 6656 INTEGER 0
_Connect-Usr 6657 INTEGER 0
_Connect-Type 6658 CHARACTER 0
_Connect-Name 6659 CHARACTER 0
_Connect-Device 6660 CHARACTER 0
_Connect-Time 6661 CHARACTER 0
_Connect-Pid 6662 INTEGER 0
_Connect-Server 6663 INTEGER 0
_Connect-Wait1 6664 INTEGER 0
_Connect-Wait 6665 CHARACTER 0
_Connect-TransId 6666 INTEGER 0
_Connect-SemNum 6667 INTEGER 0
_Connect-semid 6668 INTEGER 0
_Connect-Disconnect 6669 INTEGER 0
_Connect-Resync 6670 INTEGER 0
_Connect-Interrupt 6671 INTEGER 0
_Connect-2phase 6672 INTEGER 0
_Connect-Batch 6673 CHARACTER 0
_Connect-Misc 6674 INTEGER 0
: _Database-Feature 6643
_DBFeature-ID 7687 INTEGER 0
_DBFeature_Name 7688 CHARACTER 0
_DBFeature_Enabled 7689 CHARACTER 0
_DBFeature_Active 7690 CHARACTER 0
_DBFeature-Res01 7691 CHARACTER 10
_DBFeature-Res02 7692 INTEGER 10
: _Db 3441
_Db-name 4014 CHARACTER 0
_Db-addr 4015 CHARACTER 0
_Db-type 4016 CHARACTER 0
_Db-comm 4017 CHARACTER 0
_Db-revision 4018 INTEGER 0
_Db-misc1 4019 INTEGER 8
_Db-misc2 4020 CHARACTER 8
_Db-slave 4021 LOGICAL 0
_Db-local 4022 LOGICAL 0
_Db-res1 4032 INTEGER 8
_Db-res2 4033 CHARACTER 8
_Db-xlate 4034 RAW 2
_Db-xl-name 4035 CHARACTER 0
_Db-collate 4036 RAW 10
_Db-coll-name 4037 CHARACTER 0
_User-Misc 4038 CHARACTER 0
_Db-guid 4039 CHARACTER 0
: _Db-Detail 3665
_Db-guid 5513 CHARACTER 0
_Db-description 5537 CHARACTER 0
_Db-mac-key 5538 RAW 0
_Db-custom-detail 5539 CHARACTER 0
: _Db-Option 3682
_Db-recid 5540 RECID 0
_Db-option-type 5541 INTEGER 0