source: Scheduling/branches/GUI1.2/csSchema.xsd@ 1551

Last change on this file since 1551 was 614, checked in by Sam Habiel, 15 years ago

Initial committ of scheduling package

File size: 8.6 KB
Line 
1<?xml version="1.0" standalone="yes" ?>
2<xs:schema id="GlobalDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
3 <xs:element name="GlobalDataSet" msdata:IsDataSet="true">
4 <xs:complexType>
5 <xs:choice maxOccurs="unbounded">
6 <xs:element name="SchedulingUser">
7 <xs:complexType>
8 <xs:sequence>
9 <xs:element name="MANAGER" type="xs:string" minOccurs="0" />
10 </xs:sequence>
11 </xs:complexType>
12 </xs:element>
13 <xs:element name="AccessTypes">
14 <xs:complexType>
15 <xs:sequence>
16 <xs:element name="BMXIEN" type="xs:int" />
17 <xs:element name="ACCESS_TYPE_NAME" type="xs:string" minOccurs="0" />
18 <xs:element name="BLUE" type="xs:int" minOccurs="0" />
19 <xs:element name="DEPARTMENT_NAME" type="xs:string" minOccurs="0" />
20 <xs:element name="DISPLAY_COLOR" type="xs:string" minOccurs="0" />
21 <xs:element name="GREEN" type="xs:int" minOccurs="0" />
22 <xs:element name="INACTIVE" type="xs:string" minOccurs="0" />
23 <xs:element name="RED" type="xs:int" minOccurs="0" />
24 </xs:sequence>
25 </xs:complexType>
26 </xs:element>
27 <xs:element name="AccessGroup">
28 <xs:complexType>
29 <xs:sequence>
30 <xs:element name="BMXIEN" type="xs:int" minOccurs="0" />
31 <xs:element name="ACCESS_GROUP" type="xs:string" />
32 </xs:sequence>
33 </xs:complexType>
34 </xs:element>
35 <xs:element name="AccessGroupType">
36 <xs:complexType>
37 <xs:sequence>
38 <xs:element name="ACCESS_GROUP_TYPEID" type="xs:int" />
39 <xs:element name="ACCESS_GROUP_ID" type="xs:int" minOccurs="0" />
40 <xs:element name="ACCESS_GROUP" type="xs:string" minOccurs="0" />
41 <xs:element name="ACCESS_TYPE_ID" type="xs:int" minOccurs="0" />
42 <xs:element name="ACCESS_TYPE" type="xs:string" minOccurs="0" />
43 </xs:sequence>
44 </xs:complexType>
45 </xs:element>
46 <xs:element name="ResourceGroup">
47 <xs:complexType>
48 <xs:sequence>
49 <xs:element name="RESOURCE_GROUPID" type="xs:int" minOccurs="0" />
50 <xs:element name="RESOURCE_GROUP" type="xs:string" />
51 </xs:sequence>
52 </xs:complexType>
53 </xs:element>
54 <xs:element name="Resources">
55 <xs:complexType>
56 <xs:sequence>
57 <xs:element name="RESOURCEID" type="xs:int" />
58 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
59 <xs:element name="INACTIVE" type="xs:string" minOccurs="0" />
60 <xs:element name="TIMESCALE" type="xs:int" minOccurs="0" />
61 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" minOccurs="0" />
62 <xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" />
63 </xs:sequence>
64 </xs:complexType>
65 </xs:element>
66 <xs:element name="GroupResources">
67 <xs:complexType>
68 <xs:sequence>
69 <xs:element name="RESOURCE_GROUPID" type="xs:int" minOccurs="0" />
70 <xs:element name="RESOURCE_GROUP" type="xs:string" minOccurs="0" />
71 <xs:element name="RESOURCE_GROUP_ITEMID" type="xs:int" minOccurs="0" />
72 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
73 <xs:element name="RESOURCEID" type="xs:int" minOccurs="0" />
74 </xs:sequence>
75 </xs:complexType>
76 </xs:element>
77 <xs:element name="HospitalLocation">
78 <xs:complexType>
79 <xs:sequence>
80 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" />
81 <xs:element name="HOSPITAL_LOCATION" type="xs:string" minOccurs="0" />
82 <xs:element name="DEFAULT_PROVIDER" type="xs:string" minOccurs="0" />
83 <xs:element name="STOP_CODE_NUMBER" type="xs:string" minOccurs="0" />
84 <xs:element name="INACTIVATE_DATE" type="xs:dateTime" minOccurs="0" />
85 <xs:element name="REACTIVATE_DATE" type="xs:dateTime" minOccurs="0" />
86 </xs:sequence>
87 </xs:complexType>
88 </xs:element>
89 <xs:element name="ClinicSetupParameters">
90 <xs:complexType>
91 <xs:sequence>
92 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" />
93 <xs:element name="HOSPITAL_LOCATION" type="xs:string" minOccurs="0" />
94 <xs:element name="CREATE_VISIT" type="xs:string" minOccurs="0" />
95 <xs:element name="VISIT_SERVICE_CATEGORY" type="xs:string" minOccurs="0" />
96 <xs:element name="PROVIDER" msdata:ReadOnly="true" msdata:Expression="Parent.DEFAULT_PROVIDER"
97 type="xs:string" minOccurs="0" />
98 <xs:element name="CLINIC_STOP" msdata:ReadOnly="true" msdata:Expression="Parent.STOP_CODE_NUMBER"
99 type="xs:string" minOccurs="0" />
100 <xs:element name="INACTIVATE_DATE" msdata:ReadOnly="true" msdata:Expression="Parent.INACTIVATE_DATE"
101 type="xs:string" minOccurs="0" />
102 <xs:element name="REACTIVATE_DATE" msdata:ReadOnly="true" msdata:Expression="Parent.REACTIVATE_DATE"
103 type="xs:string" minOccurs="0" />
104 </xs:sequence>
105 </xs:complexType>
106 </xs:element>
107 <xs:element name="ScheduleUser">
108 <xs:complexType>
109 <xs:sequence>
110 <xs:element name="USERID" type="xs:int" />
111 <xs:element name="USERNAME" type="xs:string" minOccurs="0" />
112 </xs:sequence>
113 </xs:complexType>
114 </xs:element>
115 <xs:element name="ResourceUser">
116 <xs:complexType>
117 <xs:sequence>
118 <xs:element name="RESOURCEUSER_ID" type="xs:int" />
119 <xs:element name="RESOURCEID" type="xs:int" minOccurs="0" />
120 <xs:element name="OVERBOOK" type="xs:string" minOccurs="0" />
121 <xs:element name="MODIFY_SCHEDULE" type="xs:string" minOccurs="0" />
122 <xs:element name="USERID" type="xs:string" minOccurs="0" />
123 <xs:element name="USERID1" type="xs:int" minOccurs="0" />
124 </xs:sequence>
125 </xs:complexType>
126 </xs:element>
127 </xs:choice>
128 </xs:complexType>
129 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
130 <xs:selector xpath=".//AccessTypes" />
131 <xs:field xpath="BMXIEN" />
132 </xs:unique>
133 <xs:unique name="AccessGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
134 <xs:selector xpath=".//AccessGroup" />
135 <xs:field xpath="ACCESS_GROUP" />
136 </xs:unique>
137 <xs:unique name="Constraint2">
138 <xs:selector xpath=".//AccessGroup" />
139 <xs:field xpath="BMXIEN" />
140 </xs:unique>
141 <xs:unique name="AccessGroupType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
142 <xs:selector xpath=".//AccessGroupType" />
143 <xs:field xpath="ACCESS_GROUP_TYPEID" />
144 </xs:unique>
145 <xs:unique name="ResourceGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
146 <xs:selector xpath=".//ResourceGroup" />
147 <xs:field xpath="RESOURCE_GROUP" />
148 </xs:unique>
149 <xs:unique name="Resources_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
150 <xs:selector xpath=".//Resources" />
151 <xs:field xpath="RESOURCEID" />
152 </xs:unique>
153 <xs:unique name="HospitalLocation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
154 <xs:selector xpath=".//HospitalLocation" />
155 <xs:field xpath="HOSPITAL_LOCATION_ID" />
156 </xs:unique>
157 <xs:unique name="ClinicSetupParameters_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
158 <xs:selector xpath=".//ClinicSetupParameters" />
159 <xs:field xpath="HOSPITAL_LOCATION_ID" />
160 </xs:unique>
161 <xs:unique name="ScheduleUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
162 <xs:selector xpath=".//ScheduleUser" />
163 <xs:field xpath="USERID" />
164 </xs:unique>
165 <xs:unique name="ResourceUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
166 <xs:selector xpath=".//ResourceUser" />
167 <xs:field xpath="RESOURCEUSER_ID" />
168 </xs:unique>
169 <xs:keyref name="ResourceUser" refer="Resources_Constraint1">
170 <xs:selector xpath=".//ResourceUser" />
171 <xs:field xpath="RESOURCEID" />
172 </xs:keyref>
173 <xs:keyref name="GroupResource2" refer="Resources_Constraint1">
174 <xs:selector xpath=".//GroupResources" />
175 <xs:field xpath="RESOURCEID" />
176 </xs:keyref>
177 <xs:keyref name="GroupResource" refer="ResourceGroup_Constraint1">
178 <xs:selector xpath=".//GroupResources" />
179 <xs:field xpath="RESOURCE_GROUP" />
180 </xs:keyref>
181 <xs:keyref name="AccessGroupType" refer="Constraint2">
182 <xs:selector xpath=".//AccessGroupType" />
183 <xs:field xpath="ACCESS_GROUP_ID" />
184 </xs:keyref>
185 </xs:element>
186 <xs:annotation>
187 <xs:appinfo>
188 <msdata:Relationship name="HospitalLocationClinic" msdata:parent="HospitalLocation" msdata:child="ClinicSetupParameters"
189 msdata:parentkey="HOSPITAL_LOCATION_ID" msdata:childkey="HOSPITAL_LOCATION_ID" />
190 </xs:appinfo>
191 </xs:annotation>
192</xs:schema>
Note: See TracBrowser for help on using the repository browser.