Code types - used formatted (ie. with decimals) sql columns for ICD9/10 external...
[openemr.git] / gacl / adodb / xmlschema.dtd
blob4a055da4e5643b72026f4ed83d9149c187432fd7
1 <?xml version="1.0"?>
2 <!DOCTYPE adodb_schema [
3 <!ELEMENT schema (table*, sql*)>
4 <!ATTLIST schema version CDATA #REQUIRED>
5 <!ELEMENT table ((field+|DROP), CONSTRAINT*, descr?, index*, data*)>
6 <!ELEMENT field ((NOTNULL|KEY|PRIMARY)?, (AUTO|AUTOINCREMENT)?, (DEFAULT|DEFDATE|DEFTIMESTAMP)?,
7 NOQUOTE?, CONSTRAINT*, descr?)>
8 <!ELEMENT data (row+)>
9 <!ELEMENT row (f+)>
10 <!ELEMENT f (#CDATA)>
11 <!ELEMENT descr (#CDATA)>
12 <!ELEMENT NOTNULL EMPTY>
13 <!ELEMENT KEY EMPTY>
14 <!ELEMENT PRIMARY EMPTY>
15 <!ELEMENT AUTO EMPTY>
16 <!ELEMENT AUTOINCREMENT EMPTY>
17 <!ELEMENT DEFAULT EMPTY>
18 <!ELEMENT DEFDATE EMPTY>
19 <!ELEMENT DEFTIMESTAMP EMPTY>
20 <!ELEMENT NOQUOTE EMPTY>
21 <!ELEMENT DROP EMPTY>
22 <!ELEMENT CONSTRAINT (#CDATA)>
23 <!ATTLIST table name CDATA #REQUIRED platform CDATA #IMPLIED version CDATA #IMPLIED>
24 <!ATTLIST field name CDATA #REQUIRED type (C|C2|X|X2|B|D|T|L|I|F|N) #REQUIRED size CDATA #IMPLIED>
25 <!ATTLIST data platform CDATA #IMPLIED>
26 <!ATTLIST f name CDATA #IMPLIED>
27 <!ATTLIST DEFAULT VALUE CDATA #REQUIRED>
28 <!ELEMENT index ((col+|DROP), CLUSTERED?, BITMAP?, UNIQUE?, FULLTEXT?, HASH?, descr?)>
29 <!ELEMENT col (#CDATA)>
30 <!ELEMENT CLUSTERED EMPTY>
31 <!ELEMENT BITMAP EMPTY>
32 <!ELEMENT UNIQUE EMPTY>
33 <!ELEMENT FULLTEXT EMPTY>
34 <!ELEMENT HASH EMPTY>
35 <!ATTLIST index name CDATA #REQUIRED platform CDATA #IMPLIED>
36 <!ELEMENT sql (query+, descr?)>
37 <!ELEMENT query (#CDATA)>
38 <!ATTLIST sql name CDATA #IMPLIED platform CDATA #IMPLIED, key CDATA, prefixmethod (AUTO|MANUAL|NONE) >
39 ] >