PAP(Process Automation Platform)

h1. 데이타베이스 스키마

{{plantuml(svg)

@startuml

' uncomment the line below if you're using computer with a retina display

' skinparam dpi 300

!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>

' we use bold for primary key

' green color for unique

' and underscore for not_null

!define primary_key(x) <b>x</b>

!define unique(x) <color:green>x</color>

!define not_null(x) <u>x</u>

' other tags available:

' <i></i>

' <back:COLOR></color>, where color is a color name or html color code

' (#FFAACC)

' see: http://plantuml.com/classes.html#More

hide methods

hide stereotypes

' entities

rectangle Company{

Table(Dictionary, "Dictionary\nDisplay/Standard 문자열 매핑") {

primary_key(UID) TEXT[37]

unique(DisplayWords) TEXT

unique(StandardWords) TEXT

}

Table(Units, "Units(항목별 단위 모음)\n(전사 데이타베이스)") {

primary_key(UID) TEXT[37]

unique(Key) TEXT

unique(Value) TEXT

}

}

Table(Pages, "Pages") {

primary_key(UID) TEXT[37]

not_null(Projects_UID) TEXT[37]

Index INTEGER

Name TEXT[256]

}

Table(Pages, "Points") {

primary_key(UID) TEXT[37]

not_null(Components_UID) TEXT[37]

Index INTEGER

X REAL

Y REAL

Connected_Item TEXT[37]

}

Table(Projects, "Projects") {

primary_key(UID) TEXT[37]

unique(Name) TEXT

Description TEXT

}

Table(UnitRelations, "UnitRelations\n단위 연계 테이블") {

primary_key(UID) TEXT[37]

not_null(Projects_UID) TEXT[37]

not_null(ColName) TEXT[37]

not_null(Units_UID) TEXT[37]

}

Table(Configuration, "Configuration\n환경 설정 테이블") {

not_null(Projects_UID) TEXT[37]

not_null(Section) TEXT[37]

not_null(Key) TEXT[37]

Value TEXT

}

Table(HMB_condition, "HMB_condition\n(표준 HMB 구조(공정조건))") {

primary_key(StreamNumber) TEXT[256]

not_null(Projects_UID) TEXT[37]

}

Table(HMB_composition, "HMB_composition\n(표준 HMB 구조(물질))") {

primary_key(StreamNumber) TEXT[256]

not_null(Projects_UID) TEXT[37]

}

Table(Components, "Components\n(그래픽 관련 저장)") {

primary_key(UID) TEXT[37]

not_null(Projects_UID) TEXT[37]

not_null(Symbols_UID) TEXT[37]

not_null(Pages_UID) TEXT[37]

not_null(HMB_condition_StreamNumber) TEXT[256]

not_null(UnitNo) TEXT[256]

Name TEXT[256] --> 속성 이름

X REAL

Y REAL

.

.

.

}

Table(Line, "Line\n(배관 라인 리스트 및 데이터)") {

not_null(Projects_UID) TEXT[37]

primary_key(Related Stream No 1) TEXT

primary_key(Related Stream No 2) TEXT

}

Table(Instruments, "Instruments\nP&ID 기준 계기 데이터 및 리스트") {

not_null(Projects_UID) TEXT[37]

}

Table(eq_VesselDrum, "eq_VesselDrum\n기기 데이터") {

not_null(Projects_UID) TEXT[37]

}

Table(eq_TankSilo, "eq_TankSilo\n기기 데이터") {

not_null(Projects_UID) TEXT[37]

}

' relationships

UnitRelations --> Units

UnitRelations --> Projects

UnitRelations --> HMB_condition

UnitRelations --> HMB_composition

UnitRelations -> Line

Configuration -> Projects

HMB_condition -> Projects

HMB_composition -> Projects

Pages --> Projects

Components --> Projects

Components --> Pages

Points --> Components

Line --> Projects

Instruments --> Projects

eq_VesselDrum --> Projects

eq_TankSilo --> Projects

Line -> HMB_condition

Line -> HMB_composition

@enduml

}}

|\4=. *HMB_condition* |

|=.Field |=. Field Names |=. Data Type |=. Remarks |

|1| Stream Number| TEXT|key value: from external document or DB |

|2|Stream Description|TEXT|from external document or DB|

|3|DATA CASE|TEXT|from external document or DB|

|4|STREAMPHASE|TEXT|from external document or DB|

|5|OVERALL VAPOR FRACTION|NUMERIC|from external document or DB|

|6|OVERALL TEMPERATURE|NUMERIC|from external document or DB|

|7|OVERALL PRESSURE|NUMERIC|from external document or DB|

|8|OVERALL MOLECULAR WEIGHT|NUMERIC|from external document or DB|

|9|OVERALL MOLAR FLOW|NUMERIC|from external document or DB|

|10|OVERALL MASS FLOW|NUMERIC|from external document or DB|

|11|OVERALL ACTUAL VOLUME FLOW|NUMERIC|from external document or DB|

|12|OVERALL MASS DENSITY|NUMERIC|from external document or DB|

|13|OVERALL MASS HEAT CAPACITY|NUMERIC|from external document or DB|

|14|OVERALL HEAT FLOW|NUMERIC|from external document or DB|

|15|Overall Mass Enthalpy|NUMERIC|from external document or DB|

|16|Overall Sp. Gravity|NUMERIC|from external document or DB|

|17|Overall API Gravity|NUMERIC|from external document or DB|

|18|Overall Critical Pressure|NUMERIC|external document or DB|

|19|Overall Critical Temperature|NUMERIC|from external document or DB|

|20|Overall UOP K factor|NUMERIC|from external document or DB|

|21|LIQUID MOLE FRACTION|NUMERIC|from external document or DB|

|22|Vapor Temperature|NUMERIC|from external document or DB|

|23|Vapor Pressure|NUMERIC|from external document or DB|

|24|Vapor Pseudocritical Temperature|NUMERIC|from external document or DB|

|25|Vapor Pseudocritical Pressure|NUMERIC|from external document or DB|

|26|VAPOR MOLAR RATE|NUMERIC|from external document or DB|

|27|VAPOR MASS RATE|NUMERIC|from external document or DB|

|28|VAPOR ACTUAL VOLUME RATE|NUMERIC|from external document or DB|

|29|VAPOR STD. VOLUME RATE|NUMERIC|from external document or DB|

|30|VAPOR MOLECULAR WEIGHT|NUMERIC|from external document or DB|

|31|Vapor Heat Flow|NUMERIC|from external document or DB|

|32|VAPOR COMPRESSIBILITY|NUMERIC|from external document or DB|

|33|VAPOR SPECIFIC ENTHALPY|NUMERIC|from external document or DB|

|34|VAPOR SPECIFIC HEAT CAPACITY|NUMERIC|from external document or DB|

|35|IDEAL VAPOR SPECIFIC HEAT RATIO|NUMERIC|from external document or DB|

|36|VAPOR ACTUAL DENSITY|NUMERIC|from external document or DB|

|37|THERMAL CONDUCTIVITY|NUMERIC|from external document or DB|

|38|VAPOR VISCOSITY|NUMERIC|from external document or DB|

|39|Liquid Temperature|NUMERIC|from external document or DB|

|40|Pressure|NUMERIC|from external document or DB|

|41|Liquid Pseudocritical Temperature|NUMERIC|from external document or DB|

|42|Liquid Pseudocritical Pressure|NUMERIC|from external document or DB|

|43|LIQUID MOLAR RATE|NUMERIC|from external document or DB|

|44|LIQUID MASS RATE|NUMERIC|from external document or DB|

|45|LIQUID ACTUAL VOLUME FLOW|NUMERIC|from external document or DB|

|46|LIQUID STD. VOLUME FLOW|NUMERIC|from external document or DB|

|47|LIQUID MOLECULAR WEIGHT|NUMERIC|from external document or DB|

|48|Liquid Heat Flow|NUMERIC|from external document or DB|

|49|LIQUID SPECIFIC ENTHALPY|NUMERIC|from external document or DB|

|50|LIQUID Boiling Point Pressure at Stream T|NUMERIC|from external document or DB|

|51|LIQUID SPECIFIC HEAT CAPACITY|NUMERIC|from external document or DB|

|52|LIQUID ACTUAL DENSITY|NUMERIC|from external document or DB|

|53|Liquid Std Density|NUMERIC|from external document or DB|

|54|Liquid Specific Gravity @ 15°C|NUMERIC|from external document or DB|

|55|LIQUID SURFACE TENSION|NUMERIC|from external document or DB|

|56|LIQUID THERMAL CONDUCTIVITY|NUMERIC|from external document or DB|

|57|LIQUID VISCOSITY|NUMERIC|from external document or DB|

|58|AQUEOUS Pseudocritical Temperature|NUMERIC|from external document or DB|

|59|AQUEOUS Pseudocritical Pressure|NUMERIC|from external document or DB|

|60|AQUEOUS MOLAR RATE|NUMERIC|from external document or DB|

|61|AQUEOUS MASS RATE|NUMERIC|from external document or DB|

|62|AQUEOUS ACTUAL VOLUME FLOW|NUMERIC|from external document or DB|

|63|AQUEOUS STD. LIQUID FLOW|NUMERIC|from external document or DB|

|64|Molecular Weight|NUMERIC|from external document or DB|

|65|AQUEOUS Heat Flow|NUMERIC|from external document or DB|

|66|AQUEOUS SPECIFIC ENTHALPY|NUMERIC|from external document or DB|

|67|AQUEOUS  Boiling Point Pressure at Stream T|NUMERIC|from external document or DB|

|68|AQUEOUS SPECIFIC HEAT CAPACITY|NUMERIC|from external document or DB|

|69|AQUEOUS ACTUAL DENSITY|NUMERIC|from external document or DB|

|70|AQUEOUS Std Density|NUMERIC|from external document or DB|

|71|AQUEOUS Specific Gravity @ 15°C|NUMERIC|from external document or DB|

|72|AQUEOUS SURFACE TENSION|NUMERIC|from external document or DB|

|73|AQUEOUS THERMAL CONDUCTIVITY|NUMERIC|from external document or DB|

|74|AQUEOUS VISCOSITY|NUMERIC|from external document or DB|

|75|Data Source|TEXT|import 시 user selection|

|\4=. *HMB_composition* |

|=.Field |=. Field Names |=. Data Type |=. Remarks |

|=.1|Stream Number|TEXT|key value: from external document or DB|

|=.2|DATA CASE|TEXT|from external document or DB|

|=.3|COMP1|TEXT|from external document or DB|

|=.4|COMP2|TEXT|from external document or DB|

|=.5|COMP3|TEXT|from external document or DB|

|=.6|COMP4|TEXT|from external document or DB|

|=.7|COMP5|TEXT|external document or DB|

|=.8|COMP6|TEXT|from external document or DB|

|=.9|COMP7|TEXT|from external document or DB|

|=.10|COMP8|TEXT|from external document or DB|

|=.11|COMP9|TEXT|from external document or DB|

|=.12|COMP10|TEXT|from external document or DB|

|=.13|COMP11|TEXT|from external document or DB|

|=.14|COMP12|TEXT|from external document or DB|

|=.15|COMP13|TEXT|from external document or DB|

|=.16|COMP14|TEXT|from external document or DB|

|=.17|COMP15|TEXT|from external document or DB|

|=.18|COMP16|TEXT|from external document or DB|

|=.19|COMP17|TEXT|from external document or DB|

|=.20|COMP18|TEXT|from external document or DB|

|=.21|COMP19|TEXT|from external document or DB|

|=.22|COMP20|TEXT|from external document or DB|

|=.23|Data Source|TEXT|import 시 user selection|

|\4=. *Line* |

|=.Field |=. Field Names |=. Data Type |=. Remarks |

|=.1|Related Stream No 1|TEXT|key value: from auto mapping using SPPID and PAP|

|=.2|Related Stream No 2|TEXT|dummy|

|=.3|SPID|TEXT|from SPPID|

|=.4|Unit no|TEXT|from SPPID|

|=.5|Fluid code|TEXT|from SPPID|

|=.6|Sequence no|TEXT|from SPPID|

|=.7|Material class|TEXT|from SPPID|

|=.8|Schedule|TEXT|later|

|=.9|size|NUMERIC|from SPPID or line sizing calculation (별도 계산 모듈)|

|=.10|Insulation type|TEXT|from SPPID|

|=.11|From|TEXT|from SPPID / drawing of PAP / Roby F-T / PSN|

|=.12|To|TEXT|from SPPID / drawing of PAP / Roby F-T / PSN|

|=.13|&ID number|TEXT|from SPPID |

|=.14|Phase|TEXT|from HMB|

|=.15|Normal OP|NUMERIC|from HMB|

|=.16|Normal OT|NUMERIC|from HMB|

|=.17|Max OP|NUMERIC|later|

|=.18|Max OT|NUMERIC|later|

|=.19|Min temp|NUMERIC|later|

|=.20|Vacuum Temp|NUMERIC|later|

|=.21|Density / Specific Gravity|NUMERIC|from HMB|

|=.22|Viscosity|NUMERIC|from HMB|

|=.23|Mass flow|UMERIC|from HMB|

|=.24|Vol. flow|NUMERIC|from HMB|

|=.25|Velocity|NUMERIC|from line sizing calculation (별도 계산 모듈)|

|=.25|Pressure Drop|NUMERIC|from line sizing calculation (별도 계산 모듈)|

|=.26|Length|NUMERIC|later|

|=.27|Total Equivalent Length|NUMERIC|later|

|=.28|Design Pressure|NUMERIC|from calculation (별도 계산 모듈)|

|=.29|Design Temperature|NUMERIC|from calculation (별도 계산 모듈)|

|=.30|Process Remark|TEXT|from E/L and SPPID|

|=.31|Steam Out Chk.|TEXT|later|

|=.32|Steam Out Temp|NUMERIC|later|

|=.33|Heat Tracing Temp|NUMERIC|later|

|=.34|Flex Temp|NUMERIC|later|

|=.35|Hydro Test Press|NUMERIC|later|

|=.36|Pneu Test Press|NUMERIC|later|

|=.37|Special Service|TEXT|from calculation (별도 계산 모듈)|

|=.38|Insul Matl|TEXT|later|

|=.39|Insulation thickness|NUMERIC|later|

|=.40|Paint Code|TEXT|later|

|=.41|NDE (%)|NUMERIC|later|

|=.42|SR|TEXT|later|

|=.43|SC|TEXT|later|

|=.44|System Priority|TEXT|later|

|=.45|Critical Rating|NUMERIC|later|

|=.46|NDE Class|TEXT|later|

|=.47|Stress Temp.|NUMERIC|later|

|=.48|AG/UG|TEXT|later|

|=.49|P Fluid for Band|TEXT|later|

|=.50|Data Source|TEXT|import 시 user selection|

|=.-|HT type|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|HT maintain temp|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Inspection class|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|RT%|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|DP%|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|MP%|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Stress relief|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Fluid service code (K/M/N/D)|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Explosive or flammable|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Sys ID(1)|-|설계정보 리스트 생성 template 에만 쓰임|

|=.-|Sys ID(2)|-|설계정보 리스트 생성 template 에만 쓰임|