SCT EDW 구축

h1. PDS 테이블 구조

{{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(111, "111\n(부서 정보를 가짐)") {

not_null(unique(DISCIPLINE_INDX_NO)) INTEGER,

not_null(unique(DISCIPLINE_NAME)) TEXT

}

Table(121, "121\n(모델 파일 정보를 가짐)") {

not_null(unique(dwg_file_spec)) TEXT

}

Table(122, "122") {

not_null(unique(dwg_view_index_no)) INTEGER

}

Table(123, "123\n(모델 Index No를 가짐)") {

not_null(unique(dwg_model_index_no)) INTEGER

not_null(unique(model_file_spec)) TEXT

}

Table(113, "113") {

not_null(discipline_indx_no) INTEGER

not_null(partition_no) INTEGER

}

Table(12_XXX, "12_XXX\n(파이프 관련 테이블)") {

}

Table(22_XXX, "22_XXX\n(Equipment 관련 테이블)") {

}

Table(24_XXX, "24_XXX\n(Nozzle 관련 테이블)") {

}

Table(80_XXX, "80_XXX\n(Support 관련 테이블)") {

}

' relationships

111 --> 113 : "dwg_view_index_no를 구함"

121 --> 122 : "dwg_view_index_no를 구함"

122 --> 123

123 --> 113

113 --> 12_XXX : "partition_no=1"

113 --> 22_XXX : "partition_no=2"

113 --> 24_XXX : "partition_no"

113 --> 80_XXX : "partition_no"

@enduml

}}