개정판 b051b166
sql fix
Change-Id: If974ce49b67aef43824e6f4ab1e80e576d5db489
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 3 | 3 |
NOT NULL, |
| 4 | 4 |
Code NVARCHAR (32) NOT NULL |
| 5 | 5 |
UNIQUE, |
| 6 |
Type NVARCHAR (MAX),
|
|
| 7 |
Allowables NVARCHAR (MAX)
|
|
| 6 |
Type NVARCHAR(MAX), |
|
| 7 |
Allowables NVARCHAR(MAX) |
|
| 8 | 8 |
); |
| 9 | 9 |
|
| 10 | 10 |
CREATE TABLE SymbolType ( |
| ... | ... | |
| 86 | 86 |
UID INTEGER NOT NULL |
| 87 | 87 |
PRIMARY KEY, |
| 88 | 88 |
SymbolType_UID INTEGER REFERENCES SymbolType (UID), |
| 89 |
Category NVARCHAR (MAX) NOT NULL,
|
|
| 89 |
Category NVARCHAR(MAX) NOT NULL, |
|
| 90 | 90 |
Type NVARCHAR(37), |
| 91 |
Name NVARCHAR (MAX) NOT NULL
|
|
| 91 |
Name NVARCHAR(MAX) NOT NULL |
|
| 92 | 92 |
); |
| 93 | 93 |
INSERT INTO SymbolName (UID,SymbolType_UID,Category,"Type",Name) VALUES ( |
| 94 | 94 |
1,26,'Piping','Fire & Safety','Fire Hydrant With Monitor Noz'); |
| ... | ... | |
| 2138 | 2138 |
UID INTEGER PRIMARY KEY IDENTITY(1,1), |
| 2139 | 2139 |
Name NVARCHAR(64) NOT NULL, |
| 2140 | 2140 |
SymbolType_UID INTEGER NOT NULL, |
| 2141 |
Type NVARCHAR (MAX),
|
|
| 2141 |
Type NVARCHAR(MAX), |
|
| 2142 | 2142 |
Threshold REAL NOT NULL |
| 2143 | 2143 |
DEFAULT (0.75), |
| 2144 | 2144 |
MinMatchPoint INTEGER NOT NULL |
| ... | ... | |
| 2151 | 2151 |
DEFAULT 0, |
| 2152 | 2152 |
IsContainChild INTEGER NOT NULL |
| 2153 | 2153 |
DEFAULT 0, |
| 2154 |
OriginalPoint NVARCHAR (MAX),
|
|
| 2155 |
ConnectionPoint NVARCHAR (MAX),
|
|
| 2156 |
BaseSymbol NVARCHAR (MAX),
|
|
| 2157 |
AdditionalSymbol NVARCHAR (MAX),
|
|
| 2154 |
OriginalPoint NVARCHAR(MAX), |
|
| 2155 |
ConnectionPoint NVARCHAR(MAX), |
|
| 2156 |
BaseSymbol NVARCHAR(MAX), |
|
| 2157 |
AdditionalSymbol NVARCHAR(MAX), |
|
| 2158 | 2158 |
IsExceptDetect INTEGER DEFAULT 0, |
| 2159 | 2159 |
HasInstrumentLabel INTEGER DEFAULT 0, |
| 2160 | 2160 |
Width INTEGER, |
| ... | ... | |
| 2163 | 2163 |
Image NVARCHAR(MAX), |
| 2164 | 2164 |
Svg NVARCHAR(MAX), |
| 2165 | 2165 |
Image_display NVARCHAR(MAX), |
| 2166 |
TextArea NVARCHAR (MAX),
|
|
| 2166 |
TextArea NVARCHAR(MAX), |
|
| 2167 | 2167 |
FOREIGN KEY ( |
| 2168 | 2168 |
SymbolType_UID |
| 2169 | 2169 |
) |
| ... | ... | |
| 2192 | 2192 |
) |
| 2193 | 2193 |
VALUES |
| 2194 | 2194 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'Line NO'), |
| 2195 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'NVARCHAR (MAX)'),
|
|
| 2195 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'Text'),
|
|
| 2196 | 2196 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'Trim Line NO'), |
| 2197 | 2197 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'Unknown'), |
| 2198 | 2198 |
(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,4,0,0,0.4,NULL,-1,'Line'), |
| ... | ... | |
| 2204 | 2204 |
UID NVARCHAR (37) CONSTRAINT Drawings_PK PRIMARY KEY |
| 2205 | 2205 |
NOT NULL, |
| 2206 | 2206 |
NAME NVARCHAR(256) NOT NULL, |
| 2207 |
DATETIME NVARCHAR (MAX),
|
|
| 2207 |
DATETIME NVARCHAR(MAX), |
|
| 2208 | 2208 |
OCCUPIED NVARCHAR(256), |
| 2209 | 2209 |
Image varbinary(max) |
| 2210 | 2210 |
); |
| ... | ... | |
| 2220 | 2220 |
Width INTEGER, |
| 2221 | 2221 |
Height INTEGER, |
| 2222 | 2222 |
Rotation REAL, |
| 2223 |
Area NVARCHAR (MAX),
|
|
| 2223 |
Area NVARCHAR(MAX), |
|
| 2224 | 2224 |
Value NVARCHAR (1024), |
| 2225 | 2225 |
Owner NVARCHAR (37), |
| 2226 | 2226 |
[From] [NVARCHAR](37) NULL, |
| 2227 | 2227 |
[To] [NVARCHAR](37) NULL, |
| 2228 | 2228 |
Connected NVARCHAR (37), |
| 2229 |
[Supplied By] NVARCHAR (MAX),
|
|
| 2229 |
[Supplied By] NVARCHAR(MAX), |
|
| 2230 | 2230 |
SpecialItemTypes_UID NVARCHAR (37) REFERENCES SpecialItemTypes (UID), |
| 2231 | 2231 |
[Freeze] [int] NULL, |
| 2232 | 2232 |
OriginIndex INTEGER NOT NULL DEFAULT (0), |
| 2233 | 2233 |
[Connected Item] NVARCHAR (37) NULL, |
| 2234 | 2234 |
Flip INTEGER NULL, |
| 2235 |
SceneOriginPoint NVARCHAR (MAX)
|
|
| 2235 |
SceneOriginPoint NVARCHAR(MAX) |
|
| 2236 | 2236 |
); |
| 2237 | 2237 |
|
| 2238 | 2238 |
|
| 2239 | 2239 |
CREATE TABLE Associations ( |
| 2240 | 2240 |
UID NVARCHAR (37) PRIMARY KEY |
| 2241 | 2241 |
NOT NULL, |
| 2242 |
Type NVARCHAR (MAX) NOT NULL,
|
|
| 2242 |
Type NVARCHAR(MAX) NOT NULL, |
|
| 2243 | 2243 |
Components_UID NVARCHAR(37) REFERENCES Components (UID) |
| 2244 | 2244 |
NOT NULL, |
| 2245 | 2245 |
Association NVARCHAR(37) REFERENCES Components (UID) |
| ... | ... | |
| 2250 | 2250 |
PRIMARY KEY, |
| 2251 | 2251 |
SymbolType_UID INTEGER, |
| 2252 | 2252 |
Attribute NVARCHAR(32) NOT NULL, |
| 2253 |
DisplayAttribute NVARCHAR (MAX) NOT NULL,
|
|
| 2254 |
AttributeType NVARCHAR (MAX) NOT NULL,
|
|
| 2255 |
Expression NVARCHAR (MAX),
|
|
| 2253 |
DisplayAttribute NVARCHAR(MAX) NOT NULL, |
|
| 2254 |
AttributeType NVARCHAR(MAX) NOT NULL, |
|
| 2255 |
Expression NVARCHAR(MAX), |
|
| 2256 | 2256 |
[index] INT NOT NULL, |
| 2257 | 2257 |
AttrAt INTEGER DEFAULT 0, |
| 2258 | 2258 |
Length INTEGER, |
| 2259 |
Target NVARCHAR (MAX) DEFAULT 'ALL',
|
|
| 2259 |
Target NVARCHAR(MAX) DEFAULT 'ALL', |
|
| 2260 | 2260 |
Property INTEGER DEFAULT 0, |
| 2261 | 2261 |
FOREIGN KEY ( |
| 2262 | 2262 |
SymbolType_UID |
| ... | ... | |
| 2269 | 2269 |
); |
| 2270 | 2270 |
|
| 2271 | 2271 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2272 |
'f69f55c8-a388-428a-b07b-2c35e392f75c','35','Opening Action','Opening Action','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',0,0,NULL,'ALL',0);
|
|
| 2272 |
'f69f55c8-a388-428a-b07b-2c35e392f75c','35','Opening Action','Opening Action','Text Item','item.text()',0,0,NULL,'ALL',0);
|
|
| 2273 | 2273 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2274 |
'e630853f-8b08-45b8-949b-3005c02674b4','21','Type','Type','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[1:]',1,0,NULL,'ALL',0);
|
|
| 2274 |
'e630853f-8b08-45b8-949b-3005c02674b4','21','Type','Type','Text Item','item.text()[1:]',1,0,NULL,'ALL',0);
|
|
| 2275 | 2275 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2276 |
'94cfa92b-1e0c-49c1-866e-d540dc8c23a4','21','SeqNumber','Tag Seq Number','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)() if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[:-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[:-2] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[:-3]))',2,1,NULL,'ALL',0);
|
|
| 2276 |
'94cfa92b-1e0c-49c1-866e-d540dc8c23a4','21','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
|
|
| 2277 | 2277 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2278 |
'b21acc50-ca25-4d37-a121-b654c4e8b155','21','MEASURED_VARIABLE','MEASURED_VARIABLE','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[0]',0,0,NULL,'ALL',0);
|
|
| 2278 |
'b21acc50-ca25-4d37-a121-b654c4e8b155','21','MEASURED_VARIABLE','MEASURED_VARIABLE','Text Item','item.text()[0]',0,0,NULL,'ALL',0);
|
|
| 2279 | 2279 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2280 |
'eb5cbcca-9f4c-484e-a4cb-ca4fcc14499f','25','Type','Type','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[1:]',1,0,NULL,'ALL',0);
|
|
| 2280 |
'eb5cbcca-9f4c-484e-a4cb-ca4fcc14499f','25','Type','Type','Text Item','item.text()[1:]',1,0,NULL,'ALL',0);
|
|
| 2281 | 2281 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2282 |
'0816f270-c098-4284-901f-61b7b5c856ef','25','SeqNumber','Tag Seq Number','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)() if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[:-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[:-2] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[:-3]))',2,1,NULL,'ALL',0);
|
|
| 2282 |
'0816f270-c098-4284-901f-61b7b5c856ef','25','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',2,1,NULL,'ALL',0);
|
|
| 2283 | 2283 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2284 |
'4271299e-a197-4250-b195-c748aa46b9a2','25','MEASURED_VARIABLE','MEASURED_VARIABLE','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[0]',0,0,NULL,'ALL',0);
|
|
| 2284 |
'4271299e-a197-4250-b195-c748aa46b9a2','25','MEASURED_VARIABLE','MEASURED_VARIABLE','Text Item','item.text()[0]',0,0,NULL,'ALL',0);
|
|
| 2285 | 2285 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2286 |
'0cd32053-c458-4c39-9b4c-f26bd2d14a05','35','Size','Size','Size NVARCHAR (MAX) Item','self.EvaluatedSize',1,0,NULL,'ALL',1);
|
|
| 2286 |
'0cd32053-c458-4c39-9b4c-f26bd2d14a05','35','Size','Size','Size Text Item','self.EvaluatedSize',1,0,NULL,'ALL',1);
|
|
| 2287 | 2287 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2288 |
'805bcf6e-19c7-4b84-82e2-6c5eff48bfcd','36','Main Size','Main Size','Size NVARCHAR (MAX) Item','item.mainSize',0,0,NULL,'ALL',1);
|
|
| 2288 |
'805bcf6e-19c7-4b84-82e2-6c5eff48bfcd','36','Main Size','Main Size','Size Text Item','item.mainSize',0,0,NULL,'ALL',1);
|
|
| 2289 | 2289 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2290 |
'8c0a0f8c-983a-4eeb-af7a-8c46070c5447','36','Sub Size','Sub Size','Size NVARCHAR (MAX) Item','item.subSize',1,0,NULL,'ALL',1);
|
|
| 2290 |
'8c0a0f8c-983a-4eeb-af7a-8c46070c5447','36','Sub Size','Sub Size','Size Text Item','item.subSize',1,0,NULL,'ALL',1);
|
|
| 2291 | 2291 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2292 |
'7c2c7a3c-934c-4a70-98d6-5aece3557596','12','Size','Size','Size NVARCHAR (MAX) Item','self.EvaluatedSize',0,0,NULL,'ALL',1);
|
|
| 2292 |
'7c2c7a3c-934c-4a70-98d6-5aece3557596','12','Size','Size','Size Text Item','self.EvaluatedSize',0,0,NULL,'ALL',1);
|
|
| 2293 | 2293 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2294 |
'943b91c7-6815-4866-9128-d72f91ffc825','17','Size','Size','Size NVARCHAR (MAX) Item','self.EvaluatedSize',0,0,NULL,'ALL',1);
|
|
| 2294 |
'943b91c7-6815-4866-9128-d72f91ffc825','17','Size','Size','Size Text Item','self.EvaluatedSize',0,0,NULL,'ALL',1);
|
|
| 2295 | 2295 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2296 | 2296 |
'f0b46e68-23b0-4bb7-909a-a48e16ab4288','30','OWNERSYMBOL','OWNERSYMBOL','Line Item','item',0,0,NULL,'ALL',2); |
| 2297 | 2297 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| ... | ... | |
| 2331 | 2331 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2332 | 2332 |
'f8478dcd-e1cc-46ef-a789-5bcc507b5a0d','37','Description','Description','String',NULL,0,1,0,'ALL',0); |
| 2333 | 2333 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2334 |
'95a7c4fa-6d25-429e-b774-bff385a733ad','37','Number','Number','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',1,0,0,'ALL',0);
|
|
| 2334 |
'95a7c4fa-6d25-429e-b774-bff385a733ad','37','Number','Number','Text Item','item.text()',1,0,0,'ALL',0);
|
|
| 2335 | 2335 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2336 |
'7c7ba284-af5b-4e51-8905-e774ff3f1cfc','0','FluidCode','FluidCode','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',1,1,NULL,'ALL',3);
|
|
| 2336 |
'7c7ba284-af5b-4e51-8905-e774ff3f1cfc','0','FluidCode','FluidCode','Text Item','item.text()',1,1,NULL,'ALL',3);
|
|
| 2337 | 2337 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2338 |
'a7c8ebd7-8241-4e4a-8729-0c37717bfcf4','0','InsulationPurpose','InsulationPurpose','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',2,2,NULL,'ALL',3);
|
|
| 2338 |
'a7c8ebd7-8241-4e4a-8729-0c37717bfcf4','0','InsulationPurpose','InsulationPurpose','Text Item','item.text()',2,2,NULL,'ALL',3);
|
|
| 2339 | 2339 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2340 |
'c9af746e-f8a8-4319-884a-3354dcc7f6ea','0','PnIDNumber','PnIDNumber','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',3,3,NULL,'ALL',3);
|
|
| 2340 |
'c9af746e-f8a8-4319-884a-3354dcc7f6ea','0','PnIDNumber','PnIDNumber','Text Item','item.text()',3,3,NULL,'ALL',3);
|
|
| 2341 | 2341 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2342 |
'1f65e4b7-ef2d-4121-b30a-9bbada20b16b','0','PipingMaterialsClass','PipingMaterialsClass','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',4,4,NULL,'ALL',3);
|
|
| 2342 |
'1f65e4b7-ef2d-4121-b30a-9bbada20b16b','0','PipingMaterialsClass','PipingMaterialsClass','Text Item','item.text()',4,4,NULL,'ALL',3);
|
|
| 2343 | 2343 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2344 |
'0b37b3a1-ae56-4f4a-b7e5-587f36469802','0','UnitNumber','UnitNumber','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',5,5,NULL,'ALL',3);
|
|
| 2344 |
'0b37b3a1-ae56-4f4a-b7e5-587f36469802','0','UnitNumber','UnitNumber','Text Item','item.text()',5,5,NULL,'ALL',3);
|
|
| 2345 | 2345 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2346 |
'aa8f1cab-de52-41da-8905-553bcf6513c5','0','NominalDiameter','NominalDiameter','Size NVARCHAR (MAX) Item','self.EvaluatedSize',0,0,NULL,'ALL',3);
|
|
| 2346 |
'aa8f1cab-de52-41da-8905-553bcf6513c5','0','NominalDiameter','NominalDiameter','Size Text Item','self.EvaluatedSize',0,0,NULL,'ALL',3);
|
|
| 2347 | 2347 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2348 |
'6d63a700-8918-443d-975b-f16eaa28c21d','17','Opening Action','Opening Action','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',1,0,NULL,'ALL',0);
|
|
| 2348 |
'6d63a700-8918-443d-975b-f16eaa28c21d','17','Opening Action','Opening Action','Text Item','item.text()',1,0,NULL,'ALL',0);
|
|
| 2349 | 2349 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2350 |
'c701193b-1fdf-4e9c-9729-b9bd7e1d45f1','19','MEASURED_VARIABLE','MEASURED_VARIABLE','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[0]',1,0,NULL,'ALL',0);
|
|
| 2350 |
'c701193b-1fdf-4e9c-9729-b9bd7e1d45f1','19','MEASURED_VARIABLE','MEASURED_VARIABLE','Text Item','item.text()[0]',1,0,NULL,'ALL',0);
|
|
| 2351 | 2351 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2352 |
'235c62dc-02ca-483b-bcd6-eb8ee5c86f9a','19','Type','Type','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()[1:]',2,0,NULL,'ALL',0);
|
|
| 2352 |
'235c62dc-02ca-483b-bcd6-eb8ee5c86f9a','19','Type','Type','Text Item','item.text()[1:]',2,0,NULL,'ALL',0);
|
|
| 2353 | 2353 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2354 |
'16b674b2-9c10-4309-9d98-c36035ab0922','19','SeqNumber','Tag Seq Number','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)() if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[:-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[:-2] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[:-3]))',3,1,NULL,'ALL',0);
|
|
| 2354 |
'16b674b2-9c10-4309-9d98-c36035ab0922','19','SeqNumber','Tag Seq Number','Text Item','item.text() if item.text()[-1].isdecimal() else (item.text()[:-1] if item.text()[-2].isdecimal() else (item.text()[:-2] if item.text()[-3].isdecimal() else item.text()[:-3]))',3,1,NULL,'ALL',0);
|
|
| 2355 | 2355 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2356 |
'a5b5ff96-c33c-43e2-91ed-b0e2ad583a53','19','Suffix','Tag Suffix','NVARCHAR (MAX) Item',''''' if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[-2:] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[-3:]))',4,1,NULL,'ALL',0);
|
|
| 2356 |
'a5b5ff96-c33c-43e2-91ed-b0e2ad583a53','19','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',4,1,NULL,'ALL',0);
|
|
| 2357 | 2357 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2358 |
'7b22bbba-9323-43af-9ca3-973c0a2a2b37','21','Suffix','Tag Suffix','NVARCHAR (MAX) Item',''''' if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[-2:] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[-3:]))',3,1,NULL,'ALL',0);
|
|
| 2358 |
'7b22bbba-9323-43af-9ca3-973c0a2a2b37','21','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
|
|
| 2359 | 2359 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2360 |
'28a2680b-3125-4cb7-a637-26ec54d594b1','25','Suffix','Tag Suffix','NVARCHAR (MAX) Item',''''' if item.NVARCHAR (MAX)()[-1].isdecimal() else (item.NVARCHAR (MAX)()[-1] if item.NVARCHAR (MAX)()[-2].isdecimal() else (item.NVARCHAR (MAX)()[-2:] if item.NVARCHAR (MAX)()[-3].isdecimal() else item.NVARCHAR (MAX)()[-3:]))',3,1,NULL,'ALL',0);
|
|
| 2360 |
'28a2680b-3125-4cb7-a637-26ec54d594b1','25','Suffix','Tag Suffix','Text Item',''''' if item.text()[-1].isdecimal() else (item.text()[-1] if item.text()[-2].isdecimal() else (item.text()[-2:] if item.text()[-3].isdecimal() else item.text()[-3:]))',3,1,NULL,'ALL',0);
|
|
| 2361 | 2361 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2362 |
'66cef7da-9f34-4dd8-8f23-b804b2cc6e16','19','SP','SP','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',5,0,NULL,'ALL',0);
|
|
| 2362 |
'66cef7da-9f34-4dd8-8f23-b804b2cc6e16','19','SP','SP','Text Item','item.text()',5,0,NULL,'ALL',0);
|
|
| 2363 | 2363 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2364 |
'2dda2e01-ad37-4ff3-a4d1-0fbf54944d7b','19','SP Tag','SP Tag','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',6,1,NULL,'ALL',0);
|
|
| 2364 |
'2dda2e01-ad37-4ff3-a4d1-0fbf54944d7b','19','SP Tag','SP Tag','Text Item','item.text()',6,1,NULL,'ALL',0);
|
|
| 2365 | 2365 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2366 | 2366 |
'a0b800a7-bb02-458c-8a06-061c86c24b5c','39','Name','Name','Tag No','self.EvaluatedName',0,0,NULL,'ALL',1); |
| 2367 | 2367 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| ... | ... | |
| 2369 | 2369 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2370 | 2370 |
'83ffef92-3c94-47ce-a6ec-737ba4a79a93','40','To_eq','To_eq','EQ Item','item.EvaluatedName',1,1,NULL,'ALL',2); |
| 2371 | 2371 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2372 |
'37dec918-c089-4a15-8a14-ac1267e014f6','31','From_To','From_To','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',0,0,NULL,'ALL',1);
|
|
| 2372 |
'37dec918-c089-4a15-8a14-ac1267e014f6','31','From_To','From_To','Text Item','item.text()',0,0,NULL,'ALL',1);
|
|
| 2373 | 2373 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2374 |
'aab2e6ec-67d1-4eec-8e79-47334b5d4787','25','Alarm1','Alarm1','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',4,2,NULL,'ALL',0);
|
|
| 2374 |
'aab2e6ec-67d1-4eec-8e79-47334b5d4787','25','Alarm1','Alarm1','Text Item','item.text()',4,2,NULL,'ALL',0);
|
|
| 2375 | 2375 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2376 |
'9fdc7a1e-c7b9-4bb3-bea4-c40f9b1e0ad1','25','Alarm2','Alarm2','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',5,3,NULL,'ALL',0);
|
|
| 2376 |
'9fdc7a1e-c7b9-4bb3-bea4-c40f9b1e0ad1','25','Alarm2','Alarm2','Text Item','item.text()',5,3,NULL,'ALL',0);
|
|
| 2377 | 2377 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2378 |
'ee46d7d8-d000-4d66-b2a5-932cdbd0b5cd','25','Alarm3','Alarm3','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',6,5,NULL,'ALL',0);
|
|
| 2378 |
'ee46d7d8-d000-4d66-b2a5-932cdbd0b5cd','25','Alarm3','Alarm3','Text Item','item.text()',6,5,NULL,'ALL',0);
|
|
| 2379 | 2379 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2380 |
'85310e1f-1556-4008-9ee5-8fcef0abe080','25','Alarm4','Alarm4','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',7,4,NULL,'ALL',0);
|
|
| 2380 |
'85310e1f-1556-4008-9ee5-8fcef0abe080','25','Alarm4','Alarm4','Text Item','item.text()',7,4,NULL,'ALL',0);
|
|
| 2381 | 2381 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2382 |
'8bcc898b-b6fc-449d-b63e-62223e70276e','17','Fail Action','Fail Action','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',2,1,NULL,'ALL',0);
|
|
| 2382 |
'8bcc898b-b6fc-449d-b63e-62223e70276e','17','Fail Action','Fail Action','Text Item','item.text()',2,1,NULL,'ALL',0);
|
|
| 2383 | 2383 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2384 |
'ed1355df-ffb8-462a-a43e-59c94d88572b','0','Line No','Line No','NVARCHAR (MAX) Item','item.NVARCHAR (MAX)()',6,6,NULL,'ALL',0);
|
|
| 2384 |
'ed1355df-ffb8-462a-a43e-59c94d88572b','0','Line No','Line No','Text Item','item.text()',6,6,NULL,'ALL',0);
|
|
| 2385 | 2385 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2386 | 2386 |
'fbada9c7-0a5b-45c6-b082-2d3763e19abd','39','Tag Prefix','Tag Prefix','Tag No','item.EvaluatedAttribute(''EQ_TYPE'')',1,0,NULL,'ALL',0);
|
| 2387 | 2387 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| ... | ... | |
| 2389 | 2389 |
INSERT INTO SymbolAttribute (UID,SymbolType_UID,"Attribute",DisplayAttribute,AttributeType,Expression,"index",AttrAt,"Length",Target,Property) VALUES ( |
| 2390 | 2390 |
'258e8b06-21bd-4c5b-901b-7abdbb2d0dca','39','Tag Suffix','Tag Suffix','Tag No','item.EvaluatedAttribute(''EQ_SUX'')',3,0,NULL,'ALL',0);
|
| 2391 | 2391 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2392 |
VALUES('3cbbffc0-9f60-4d6c-9c64-e5983adac9c0', '22', 'Outlet Size', 'Outlet Size', 'Size NVARCHAR (MAX) Item', 'item.mainSize', 3, 0, NULL, 'ALL', 1);
|
|
| 2392 |
VALUES('3cbbffc0-9f60-4d6c-9c64-e5983adac9c0', '22', 'Outlet Size', 'Outlet Size', 'Size Text Item', 'item.mainSize', 3, 0, NULL, 'ALL', 1);
|
|
| 2393 | 2393 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2394 |
VALUES('cd89a739-66f8-433a-9043-aa2c9ddcb611', '22', 'Inlet Size', 'Inlet Size', 'Size NVARCHAR (MAX) Item', 'item.subSize', 1, 0, NULL, 'ALL', 1);
|
|
| 2394 |
VALUES('cd89a739-66f8-433a-9043-aa2c9ddcb611', '22', 'Inlet Size', 'Inlet Size', 'Size Text Item', 'item.subSize', 1, 0, NULL, 'ALL', 1);
|
|
| 2395 | 2395 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2396 |
VALUES('ea98eb26-f79d-4d15-9c97-4375353c3bc7', '22', 'Size Delimiter', 'Size Delimiter', 'Size NVARCHAR (MAX) Item', 'item.sizeDelimiter', 2, 0, NULL, 'ALL', 1);
|
|
| 2396 |
VALUES('ea98eb26-f79d-4d15-9c97-4375353c3bc7', '22', 'Size Delimiter', 'Size Delimiter', 'Size Text Item', 'item.sizeDelimiter', 2, 0, NULL, 'ALL', 1);
|
|
| 2397 | 2397 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2398 |
VALUES('d863d5b6-0054-4476-8eed-2884dcfdd96f', '22', 'Set Pressure', 'Set Pressure', 'NVARCHAR (MAX) Item', 'item.NVARCHAR (MAX)().replace('' '', '''').replace(''SET'', '''').replace(''@'', '''').replace(''\n'', '''').replace(''Barg'', '''')', 0, 0, NULL, 'ALL', 1);
|
|
| 2398 |
VALUES('d863d5b6-0054-4476-8eed-2884dcfdd96f', '22', 'Set Pressure', 'Set Pressure', 'Text Item', 'item.text().replace('' '', '''').replace(''SET'', '''').replace(''@'', '''').replace(''\n'', '''').replace(''Barg'', '''')', 0, 0, NULL, 'ALL', 1);
|
|
| 2399 | 2399 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2400 | 2400 |
VALUES('d7aea36b-4cfe-4eb9-bc3d-0340f22a38f9', '27', 'Size', 'Size', 'String', 'self.EvaluatedSize', 0, 0, NULL, 'ALL', 1);
|
| 2401 | 2401 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2402 |
VALUES('36dc35d5-f053-47ee-b266-aec00c2ba5d7', '36', 'Size', 'Size', 'Size NVARCHAR (MAX) Item', 'item.NVARCHAR (MAX)()', 2, 0, NULL, 'ALL', 1);
|
|
| 2402 |
VALUES('36dc35d5-f053-47ee-b266-aec00c2ba5d7', '36', 'Size', 'Size', 'Size Text Item', 'item.text()', 2, 0, NULL, 'ALL', 1);
|
|
| 2403 | 2403 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2404 | 2404 |
VALUES('7232a784-65e7-42ad-967b-718686367cfd', '34', 'Size', 'Size', 'String', 'self.EvaluatedSize', 0, 0, NULL, 'ALL', 1);
|
| 2405 | 2405 |
INSERT INTO SymbolAttribute (UID, SymbolType_UID, "Attribute", DisplayAttribute, AttributeType, Expression, "index", AttrAt, "Length", Target, Property) |
| 2406 |
VALUES('782d4a36-931a-4cc1-bdd6-504d0e42c11a', '22', 'Size', 'Size', 'Size NVARCHAR (MAX) Item', 'item.NVARCHAR (MAX)()', 4, 0, NULL, 'ALL', 1);
|
|
| 2406 |
VALUES('782d4a36-931a-4cc1-bdd6-504d0e42c11a', '22', 'Size', 'Size', 'Size Text Item', 'item.text()', 4, 0, NULL, 'ALL', 1);
|
|
| 2407 | 2407 |
|
| 2408 | 2408 |
|
| 2409 | 2409 |
CREATE TABLE Attributes ( |
| ... | ... | |
| 2425 | 2425 |
RED INTEGER, |
| 2426 | 2426 |
GREEN INTEGER, |
| 2427 | 2427 |
BLUE INTEGER, |
| 2428 |
PROPERTY NVARCHAR (MAX),
|
|
| 2429 |
VALUE NVARCHAR (MAX),
|
|
| 2428 |
PROPERTY NVARCHAR(MAX), |
|
| 2429 |
VALUE NVARCHAR(MAX), |
|
| 2430 | 2430 |
CONSTRAINT Colors_PK PRIMARY KEY ( |
| 2431 | 2431 |
UID |
| 2432 | 2432 |
) |
| ... | ... | |
| 2645 | 2645 |
CREATE TABLE Configuration ( |
| 2646 | 2646 |
Section NVARCHAR(64) NOT NULL, |
| 2647 | 2647 |
[Key] NVARCHAR(64) NOT NULL, |
| 2648 |
Value NVARCHAR (MAX),
|
|
| 2648 |
Value NVARCHAR(MAX), |
|
| 2649 | 2649 |
CONSTRAINT Configuration_PK PRIMARY KEY ( |
| 2650 | 2650 |
Section, |
| 2651 | 2651 |
[Key] |
| ... | ... | |
| 2818 | 2818 |
NOT NULL, |
| 2819 | 2819 |
Code NVARCHAR (32) NOT NULL |
| 2820 | 2820 |
UNIQUE, |
| 2821 |
Description NVARCHAR (MAX),
|
|
| 2822 |
Allowables NVARCHAR (MAX)
|
|
| 2821 |
Description NVARCHAR(MAX), |
|
| 2822 |
Allowables NVARCHAR(MAX) |
|
| 2823 | 2823 |
); |
| 2824 | 2824 |
|
| 2825 | 2825 |
CREATE TABLE FluidCode ( |
| 2826 | 2826 |
UID NVARCHAR (37) NOT NULL PRIMARY KEY, |
| 2827 | 2827 |
CODE NVARCHAR(32) NOT NULL, |
| 2828 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 2829 |
Allowables NVARCHAR (MAX),
|
|
| 2828 |
DESCRIPTION NVARCHAR(MAX), |
|
| 2829 |
Allowables NVARCHAR(MAX), |
|
| 2830 | 2830 |
UNIQUE(CODE) |
| 2831 | 2831 |
); |
| 2832 | 2832 |
|
| 2833 | 2833 |
CREATE TABLE HMB ( |
| 2834 | 2834 |
UID NVARCHAR (37) NOT NULL, |
| 2835 |
STREAM_NO NVARCHAR (MAX) NOT NULL,
|
|
| 2836 |
NAME NVARCHAR (MAX) NOT NULL,
|
|
| 2837 |
UNIT NVARCHAR (MAX),
|
|
| 2838 |
VALUE NVARCHAR (MAX),
|
|
| 2835 |
STREAM_NO NVARCHAR(MAX) NOT NULL, |
|
| 2836 |
NAME NVARCHAR(MAX) NOT NULL, |
|
| 2837 |
UNIT NVARCHAR(MAX), |
|
| 2838 |
VALUE NVARCHAR(MAX), |
|
| 2839 | 2839 |
PRIMARY KEY ( UID ) |
| 2840 | 2840 |
); |
| 2841 | 2841 |
|
| ... | ... | |
| 2844 | 2844 |
NOT NULL, |
| 2845 | 2845 |
CODE NVARCHAR (32) NOT NULL |
| 2846 | 2846 |
UNIQUE, |
| 2847 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 2848 |
Allowables NVARCHAR (MAX)
|
|
| 2847 |
DESCRIPTION NVARCHAR(MAX), |
|
| 2848 |
Allowables NVARCHAR(MAX) |
|
| 2849 | 2849 |
); |
| 2850 | 2850 |
|
| 2851 | 2851 |
CREATE TABLE LINE_DATA_LIST ( |
| 2852 | 2852 |
UID NVARCHAR (37) PRIMARY KEY, |
| 2853 |
LINE_SIZE NVARCHAR (MAX),
|
|
| 2854 |
LINE_SYMBOL NVARCHAR (MAX),
|
|
| 2855 |
LINE_NO NVARCHAR (MAX),
|
|
| 2856 |
LINE_CLASS NVARCHAR (MAX),
|
|
| 2857 |
LINE_ROUTING_FROM NVARCHAR (MAX),
|
|
| 2858 |
LINE_ROUTING_TO NVARCHAR (MAX),
|
|
| 2859 |
SERVICE_FLUID NVARCHAR (MAX),
|
|
| 2860 |
SERVICE_DENSITY NVARCHAR (MAX),
|
|
| 2861 |
SERVICE_STATE NVARCHAR (MAX),
|
|
| 2862 |
OPERATION_CONDITION_TEMP NVARCHAR (MAX),
|
|
| 2863 |
OPERATION_CONDITION_PRESS NVARCHAR (MAX),
|
|
| 2864 |
DESIGN_CONDITION_TEMP NVARCHAR (MAX),
|
|
| 2865 |
DESIGN_CONDITION_PRESS NVARCHAR (MAX),
|
|
| 2866 |
TEST_CONDITION_TEMP NVARCHAR (MAX),
|
|
| 2867 |
TEST_CONDITION_PRESS NVARCHAR (MAX),
|
|
| 2868 |
INSUL_CODE NVARCHAR (MAX),
|
|
| 2869 |
PAINT_CODE NVARCHAR (MAX),
|
|
| 2870 |
NDE_CODE NVARCHAR (MAX),
|
|
| 2871 |
PWHT NVARCHAR (MAX),
|
|
| 2853 |
LINE_SIZE NVARCHAR(MAX), |
|
| 2854 |
LINE_SYMBOL NVARCHAR(MAX), |
|
| 2855 |
LINE_NO NVARCHAR(MAX), |
|
| 2856 |
LINE_CLASS NVARCHAR(MAX), |
|
| 2857 |
LINE_ROUTING_FROM NVARCHAR(MAX), |
|
| 2858 |
LINE_ROUTING_TO NVARCHAR(MAX), |
|
| 2859 |
SERVICE_FLUID NVARCHAR(MAX), |
|
| 2860 |
SERVICE_DENSITY NVARCHAR(MAX), |
|
| 2861 |
SERVICE_STATE NVARCHAR(MAX), |
|
| 2862 |
OPERATION_CONDITION_TEMP NVARCHAR(MAX), |
|
| 2863 |
OPERATION_CONDITION_PRESS NVARCHAR(MAX), |
|
| 2864 |
DESIGN_CONDITION_TEMP NVARCHAR(MAX), |
|
| 2865 |
DESIGN_CONDITION_PRESS NVARCHAR(MAX), |
|
| 2866 |
TEST_CONDITION_TEMP NVARCHAR(MAX), |
|
| 2867 |
TEST_CONDITION_PRESS NVARCHAR(MAX), |
|
| 2868 |
INSUL_CODE NVARCHAR(MAX), |
|
| 2869 |
PAINT_CODE NVARCHAR(MAX), |
|
| 2870 |
NDE_CODE NVARCHAR(MAX), |
|
| 2871 |
PWHT NVARCHAR(MAX), |
|
| 2872 | 2872 |
PNID_NO NVARCHAR(256), |
| 2873 |
STREAM_NO NVARCHAR (MAX)
|
|
| 2873 |
STREAM_NO NVARCHAR(MAX) |
|
| 2874 | 2874 |
); |
| 2875 | 2875 |
|
| 2876 | 2876 |
CREATE TABLE LineProperties ( |
| 2877 | 2877 |
UID NVARCHAR (37) NOT NULL, |
| 2878 |
Name NVARCHAR (MAX) NOT NULL,
|
|
| 2879 |
DisplayName NVARCHAR (MAX),
|
|
| 2880 |
Type NVARCHAR (MAX),
|
|
| 2878 |
Name NVARCHAR(MAX) NOT NULL, |
|
| 2879 |
DisplayName NVARCHAR(MAX), |
|
| 2880 |
Type NVARCHAR(MAX), |
|
| 2881 | 2881 |
LimitNumber INTEGER, |
| 2882 |
Expression NVARCHAR (MAX),
|
|
| 2882 |
Expression NVARCHAR(MAX), |
|
| 2883 | 2883 |
[Index] INTEGER, |
| 2884 | 2884 |
PRIMARY KEY ( |
| 2885 | 2885 |
UID |
| ... | ... | |
| 2913 | 2913 |
Components_UID NVARCHAR (37) NOT NULL |
| 2914 | 2914 |
REFERENCES Components (UID), |
| 2915 | 2915 |
LineProperties_UID NVARCHAR (37) NOT NULL, |
| 2916 |
Value NVARCHAR (MAX),
|
|
| 2916 |
Value NVARCHAR(MAX), |
|
| 2917 | 2917 |
UNIQUE ( |
| 2918 | 2918 |
Components_UID, |
| 2919 | 2919 |
LineProperties_UID |
| ... | ... | |
| 2923 | 2923 |
CREATE TABLE LineTypes ( |
| 2924 | 2924 |
UID NVARCHAR (37) NOT NULL, |
| 2925 | 2925 |
Name NVARCHAR(64) NOT NULL, |
| 2926 |
Type1 NVARCHAR (MAX),
|
|
| 2927 |
Conditions1 NVARCHAR (MAX),
|
|
| 2928 |
Type2 NVARCHAR (MAX),
|
|
| 2929 |
Conditions2 NVARCHAR (MAX),
|
|
| 2926 |
Type1 NVARCHAR(MAX), |
|
| 2927 |
Conditions1 NVARCHAR(MAX), |
|
| 2928 |
Type2 NVARCHAR(MAX), |
|
| 2929 |
Conditions2 NVARCHAR(MAX), |
|
| 2930 | 2930 |
PRIMARY KEY ( |
| 2931 | 2931 |
UID |
| 2932 | 2932 |
), |
| ... | ... | |
| 2962 | 2962 |
Metric REAL, |
| 2963 | 2963 |
Inch REAL, |
| 2964 | 2964 |
InchStr NVARCHAR(32), |
| 2965 |
AllowableInchStr NVARCHAR (MAX),
|
|
| 2965 |
AllowableInchStr NVARCHAR(MAX), |
|
| 2966 | 2966 |
MetricStr NVARCHAR(32), |
| 2967 |
AllowableMetricStr NVARCHAR (MAX)
|
|
| 2967 |
AllowableMetricStr NVARCHAR(MAX) |
|
| 2968 | 2968 |
); |
| 2969 | 2969 |
INSERT INTO NominalDiameter (UID,Code,Metric,Inch,InchStr,AllowableInchStr,MetricStr,AllowableMetricStr) VALUES ( |
| 2970 | 2970 |
'07e609cc-0bb3-49fb-958a-cfb9a8230021','a',950,38,'38"','38'',38II,38','950',''); |
| ... | ... | |
| 3100 | 3100 |
CREATE TABLE NOTE_DATA_LIST ( |
| 3101 | 3101 |
UID NVARCHAR (37), |
| 3102 | 3102 |
NOTE_NO NVARCHAR (32), |
| 3103 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 3103 |
DESCRIPTION NVARCHAR(MAX), |
|
| 3104 | 3104 |
PNID_NO NVARCHAR(256) NOT NULL, |
| 3105 | 3105 |
CONSTRAINT NOTE_DATA_LIST_PK PRIMARY KEY ( |
| 3106 | 3106 |
UID |
| ... | ... | |
| 3121 | 3121 |
NOT NULL, |
| 3122 | 3122 |
Drawings_UID NVARCHAR (37) REFERENCES Drawings (UID) |
| 3123 | 3123 |
NOT NULL, |
| 3124 |
Type NVARCHAR (MAX),
|
|
| 3124 |
Type NVARCHAR(MAX), |
|
| 3125 | 3125 |
Owner NVARCHAR (37) REFERENCES Components (UID) |
| 3126 | 3126 |
NOT NULL, |
| 3127 | 3127 |
[Index] INTEGER NOT NULL |
| ... | ... | |
| 3143 | 3143 |
NOT NULL, |
| 3144 | 3144 |
CODE NVARCHAR (32) NOT NULL |
| 3145 | 3145 |
UNIQUE, |
| 3146 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 3147 |
Allowables NVARCHAR (MAX)
|
|
| 3146 |
DESCRIPTION NVARCHAR(MAX), |
|
| 3147 |
Allowables NVARCHAR(MAX) |
|
| 3148 | 3148 |
); |
| 3149 | 3149 |
|
| 3150 | 3150 |
CREATE TABLE PnIDNumber ( |
| ... | ... | |
| 3152 | 3152 |
NOT NULL, |
| 3153 | 3153 |
CODE NVARCHAR (32) NOT NULL |
| 3154 | 3154 |
UNIQUE, |
| 3155 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 3156 |
Allowables NVARCHAR (MAX)
|
|
| 3155 |
DESCRIPTION NVARCHAR(MAX), |
|
| 3156 |
Allowables NVARCHAR(MAX) |
|
| 3157 | 3157 |
); |
| 3158 | 3158 |
|
| 3159 | 3159 |
CREATE TABLE Points ( |
| ... | ... | |
| 3162 | 3162 |
X REAL NOT NULL, |
| 3163 | 3163 |
Y REAL NOT NULL, |
| 3164 | 3164 |
Connected NVARCHAR (37), |
| 3165 |
Connected_At NVARCHAR (MAX),
|
|
| 3165 |
Connected_At NVARCHAR(MAX), |
|
| 3166 | 3166 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
| 3167 | 3167 |
Components_UID |
| 3168 | 3168 |
) |
| ... | ... | |
| 3179 | 3179 |
NOT NULL, |
| 3180 | 3180 |
Code NVARCHAR (32) NOT NULL |
| 3181 | 3181 |
UNIQUE, |
| 3182 |
Description NVARCHAR (MAX),
|
|
| 3183 |
Allowables NVARCHAR (MAX)
|
|
| 3182 |
Description NVARCHAR(MAX), |
|
| 3183 |
Allowables NVARCHAR(MAX) |
|
| 3184 | 3184 |
); |
| 3185 | 3185 |
|
| 3186 | 3186 |
CREATE TABLE TitleBlockProperties ( |
| ... | ... | |
| 3188 | 3188 |
NOT NULL, |
| 3189 | 3189 |
NAME NVARCHAR(32) NOT NULL |
| 3190 | 3190 |
UNIQUE, |
| 3191 |
AREA NVARCHAR (MAX),
|
|
| 3192 |
[TEXT] NVARCHAR (MAX)
|
|
| 3191 |
AREA NVARCHAR(MAX), |
|
| 3192 |
[TEXT] NVARCHAR(MAX) |
|
| 3193 | 3193 |
); |
| 3194 | 3194 |
|
| 3195 | 3195 |
CREATE TABLE TitleBlockValues ( |
| 3196 | 3196 |
UID NVARCHAR (37) PRIMARY KEY, |
| 3197 | 3197 |
Drawings_UID NVARCHAR (37) REFERENCES Drawings (UID), |
| 3198 | 3198 |
TitleBlockProperties_UID NVARCHAR (37) REFERENCES TitleBlockProperties (UID), |
| 3199 |
VALUE NVARCHAR (MAX)
|
|
| 3199 |
VALUE NVARCHAR(MAX) |
|
| 3200 | 3200 |
); |
| 3201 | 3201 |
|
| 3202 | 3202 |
CREATE TABLE UnitNumber ( |
| ... | ... | |
| 3204 | 3204 |
NOT NULL, |
| 3205 | 3205 |
CODE NVARCHAR (32) NOT NULL |
| 3206 | 3206 |
UNIQUE, |
| 3207 |
DESCRIPTION NVARCHAR (MAX),
|
|
| 3208 |
Allowables NVARCHAR (MAX)
|
|
| 3207 |
DESCRIPTION NVARCHAR(MAX), |
|
| 3208 |
Allowables NVARCHAR(MAX) |
|
| 3209 | 3209 |
); |
| 3210 | 3210 |
|
| 3211 | 3211 |
CREATE TABLE ValveOperCodes ( |
| ... | ... | |
| 3213 | 3213 |
NOT NULL, |
| 3214 | 3214 |
Code NVARCHAR (32) NOT NULL |
| 3215 | 3215 |
UNIQUE, |
| 3216 |
Description NVARCHAR (MAX),
|
|
| 3217 |
Allowables NVARCHAR (MAX)
|
|
| 3216 |
Description NVARCHAR(MAX), |
|
| 3217 |
Allowables NVARCHAR(MAX) |
|
| 3218 | 3218 |
); |
| 3219 | 3219 |
|
| 3220 | 3220 |
CREATE TABLE Dictionary ( |
| ... | ... | |
| 3222 | 3222 |
NOT NULL, |
| 3223 | 3223 |
Code NVARCHAR (128) NOT NULL |
| 3224 | 3224 |
UNIQUE, |
| 3225 |
Description NVARCHAR (MAX),
|
|
| 3226 |
Allowables NVARCHAR (MAX)
|
|
| 3225 |
Description NVARCHAR(MAX), |
|
| 3226 |
Allowables NVARCHAR(MAX) |
|
| 3227 | 3227 |
); |
| 3228 | 3228 |
|
| 3229 | 3229 |
CREATE TABLE SymbolAttributeCodeTable ( |
| 3230 | 3230 |
UID NVARCHAR(37) NOT NULL, |
| 3231 | 3231 |
Code NVARCHAR(128) NOT NULL, |
| 3232 |
Description NVARCHAR (MAX),
|
|
| 3233 |
Allowables NVARCHAR (MAX),
|
|
| 3232 |
Description NVARCHAR(MAX), |
|
| 3233 |
Allowables NVARCHAR(MAX), |
|
| 3234 | 3234 |
SymbolAttribute_UID NVARCHAR(37) NOT NULL, |
| 3235 | 3235 |
PRIMARY KEY(UID), |
| 3236 | 3236 |
FOREIGN KEY(SymbolAttribute_UID) REFERENCES SymbolAttribute (UID) |
| ... | ... | |
| 3241 | 3241 |
CREATE TABLE CustomTables ( |
| 3242 | 3242 |
UID NVARCHAR ( 37 ) NOT NULL, |
| 3243 | 3243 |
[Name] NVARCHAR ( 32 ) NOT NULL UNIQUE, |
| 3244 |
Description NVARCHAR (MAX),
|
|
| 3244 |
Description NVARCHAR(MAX), |
|
| 3245 | 3245 |
CONSTRAINT CustomTables_PK PRIMARY KEY(UID) |
| 3246 | 3246 |
); |
| 3247 | 3247 |
|
| ... | ... | |
| 3249 | 3249 |
UID NVARCHAR ( 37 ) NOT NULL, |
| 3250 | 3250 |
Table_UID NVARCHAR ( 37 ) NOT NULL, |
| 3251 | 3251 |
Code NVARCHAR ( 128 ) NOT NULL, |
| 3252 |
Description NVARCHAR (MAX),
|
|
| 3253 |
Allowables NVARCHAR (MAX),
|
|
| 3252 |
Description NVARCHAR(MAX), |
|
| 3253 |
Allowables NVARCHAR(MAX), |
|
| 3254 | 3254 |
CONSTRAINT CustomCodes_PK PRIMARY KEY(UID), |
| 3255 | 3255 |
FOREIGN KEY(Table_UID) REFERENCES CustomTables(UID) |
| 3256 | 3256 |
); |
| ... | ... | |
| 3282 | 3282 |
|
| 3283 | 3283 |
CREATE TABLE InstTables ( |
| 3284 | 3284 |
[UID] NVARCHAR ( 37 ) NOT NULL, |
| 3285 |
[Name] NVARCHAR (MAX) NOT NULL,
|
|
| 3286 |
Description NVARCHAR (MAX),
|
|
| 3285 |
[Name] NVARCHAR(MAX) NOT NULL, |
|
| 3286 |
Description NVARCHAR(MAX), |
|
| 3287 | 3287 |
PRIMARY KEY([UID]) |
| 3288 | 3288 |
); |
| 3289 | 3289 |
|
| DTI_PID/DTI_PID/TcpServer.py | ||
|---|---|---|
| 134 | 134 |
data_pane = mainWnd.ribbon.get_pane('Data')
|
| 135 | 135 |
data_pane.ui.toolButtonPSN.setChecked(False) |
| 136 | 136 |
''' |
| 137 |
elif jsonstr['request'] == 'ProcessEnd': |
|
| 138 |
pass |
|
| 137 | 139 |
else: |
| 138 | 140 |
pass |
| 139 | 141 |
else: |
내보내기 Unified diff
