개정판 e5644ccb
issue #1046 : 시스템 분석/설계 : PressureVariation 테이블 추가
Change-Id: I664a3901adfba129fec597de251fa9c2a074d86f
HYTOS/HYTOS/Scripts/CreateTables.sql | ||
---|---|---|
314 | 314 |
REFERENCES Components (UID) ON DELETE CASCADE |
315 | 315 |
); |
316 | 316 | |
317 | ||
318 | 317 |
CREATE TABLE IF NOT EXISTS SheetHistory ( |
319 | 318 |
UID INTEGER PRIMARY KEY AUTOINCREMENT, |
320 | 319 |
Activity TEXT NOT NULL, |
... | ... | |
322 | 321 |
User TEXT NOT NULL, |
323 | 322 |
IP TEXT NOT NULL |
324 | 323 |
); |
324 | ||
325 |
CREATE TABLE IF NOT EXISTS PressureVariation ( |
|
326 |
UID TEXT NOT NULL, |
|
327 |
Components_UID TEXT NOT NULL, |
|
328 |
Element TEXT NOT NULL, |
|
329 |
Inside_Pipe_Size REAL, |
|
330 |
Length REAL, |
|
331 |
Angle REAL, |
|
332 |
K REAL, |
|
333 |
Pressure REAL, |
|
334 |
Void REAL, |
|
335 |
Quality REAL, |
|
336 |
Density REAL, |
|
337 |
V_Den REAL, |
|
338 |
Mean_Vel REAL, |
|
339 |
Max_Vel REAL, |
|
340 |
Ero_Vel REAL, |
|
341 |
Pattern_X REAL, |
|
342 |
Pattern_Y REAL, |
|
343 |
Regime TEXT, |
|
344 |
Friction REAL, |
|
345 |
Gravity REAL, |
|
346 |
Momentum REAL, |
|
347 |
Total REAL, |
|
348 |
CONSTRAINT PK_PressureVariation PRIMARY KEY ( |
|
349 |
UID |
|
350 |
), |
|
351 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
352 |
Components_UID |
|
353 |
) |
|
354 |
REFERENCES Components (UID) ON DELETE CASCADE |
|
355 |
); |
내보내기 Unified diff