프로젝트

일반

사용자정보

개정판 e5644ccb

IDe5644ccb16e6d9bce8b0def8f56f124e14737f56
상위 38099e2f
하위 d694c9e8, e34969f1

김연진이(가) 약 5년 전에 추가함

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