SQL/fb.txt at master · Testudinate/SQL · GitHub

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
http://obninskpro.ru/index.php/bazy-dannykh/70-ustanavlivaem-servis-firebird-i-subd-ibexpert


select RDB$FIELD_NAME,RDB$RELATION_NAME  from rdb$relation_fields
where RDB$RELATION_NAME in (select RDB$RELATION_NAME from RDB$RELATIONS
where (RDB$SYSTEM_FLAG = 0) AND (RDB$RELATION_TYPE = 0)
order by RDB$RELATION_NAME) AND RDB$FIELD_NAME IN (
'TREATDATE',
'CREATETIME',
'FILIAL',
'DOCTOR',
'HISTNUM',
'BDATE',
'GENDER',
'NAL',
'MKBCODE',
'NAMEPLACE',
'GROUPNAME',
'NAMEPARAMS',
'VALUEOUT',
'MINNORMVALUE',
'MAXNORMVALUE',
'NORMTEXT',
'TYPEPARAMS',
'PLACEID',
'PROTOCOLID',
'TREATCODE',
'CODEPARAMS',
'DCODE',
'PCODE',
'ID',
'ORGANID',
'GROUPID',
'ORGANNAME'
)