HYTOS

h1. 데이타베이스

h2. 테이블 정의 규칙
# *약어는 대문자로 표기한다*
# *칼럼 이름은 카멜 표기법으로 표기한다*
# *참조 칼럼 이름은 "참조 테이블 이름_참조 칼럼 이름"으로 표기한다*

{{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

Table(Drawings, "Drawings\n(도면 정보를 가짐)") {
primary_key(UID) TEXT,
not_null(Name) TEXT,
not_null(DateTime) TEXT
}

Table(HMB, "HMB\n(물성치 테이블)") {
primary_key(UID) TEXT
not_null(Drawings_UID) TEXT
not_null(StreamNo) TEXT
...
}

Table(Reports, "Reports\n(계산 결과 테이블)") {
primary_key(UID) TEXT
not_null(Drawings_UID) TEXT
...
}

Table(Ports, "Ports\n(연결점 테이블)") {
primary_key(UID) TEXT,
not_null(Components_UID) TEXT
not_null(X) REAL
not_null(Y) REAL
not_null(Connected_UID) TEXT
}

Table(Attributes, "Attributes\n(컴포넌트 속성 테이블)") {
primary_key(Components_UID) TEXT,
not_null(SymbolAttribute_UID) TEXT
Value TEXT
}

Table(SymbolAttributes, "SymbolAttributes\n(심볼 속성 정의 테이블)") {
primary_key(UID) TEXT,
not_null(Symbols_UID) INTEGER,
not_null(Attribute) TEXT,
not_null(DisplayAttribute) TEXT,
not_null(AttributeType) TEXT,
AttrAt INTEGER,
Expression TEXT,
not_null(Index) INTEGER <i>심볼 속성 순서 정의</i>
}

Table(Symbols, "Symbols\n(심볼 정의 테이블)") {
primary_key(UID) INTEGER
not_null(unique(Name)) TEXT,
not_null(SymbolType_ID) INTEGER <i>삭제 예정</i>,
not_null(SymbolName_ID) INTEGER,
not_null(Threshold) NUMERIC,
not_null(MinMatchPoint) INTEGER,
not_null(IsDetectOrigin) INTEGER,
not_null(RotationCount) INTEGER,
not_null(OCROption) INTEGER,
not_null(IsContainChild) INTEGER,
not_null(OriginalPoint) TEXT,
not_null(ConnectionPoint) TEXT,
not_null(AdditionalSymbol) TEXT,
not_null(IsExceptDetect) INTEGER,
not_null(HasInstrumentLabel) INTEGER
}

Table(Components, "Components\n(컴포넌트 테이블)") {
primary_key(UID) TEXT,
not_null(Drawings_UID) TEXT
not_null(Symbol_UID) TEXT
not_null(X) REAL
not_null(Y) REAL
not_null(Width) REAL
not_null(Height) REAL
not_null(Rotation) REAL
}

Table(Configuration, "Configuration\n(설정을 저장하는 테이블)") {
not_null(unique(Section)) TEXT
not_null(unique(Key)) TEXT
Value TEXT
}

' relationships
Components --> Drawings
HMB --> Drawings
Reports --> Drawings
Components --> Symbols
SymbolAttributes --> Symbols
Attributes --> Components
Attributes --> SymbolAttributes
Ports --> Components
@enduml
}}