소부재설계_20230913
테이블 (11)
ARC INBOUNDARY of Part_Stiff (ARC_INBOUNDARY_of_Part_Stiff)
- MARK NAME (STIFF_NAME) — varchar2 — 기본 키 — NOT NULL
- SHIP NO (SHIP) — varchar2 — 기본 키 — NOT NULL
- BLOCK NO (BLOCK) — varchar2 — 기본 키 — NOT NULL
- PANEL NAME (P_NAME) — varchar2 — 기본 키 — NOT NULL
- MARK NAME (NAME2) — varchar2 — 외래 키 → Part_Mark.MARK NAME — NOT NULL
- TYPE OF ARC (CWCCW) — INT — NOT NULL
- X of Start Point (SX) — Double — NOT NULL
- Y of Start Point (SY) — Double — NOT NULL
- X of End Point (EX) — Double — NOT NULL
- Y of Center Point (EY) — Double — NOT NULL
- X of Center Point (CX) — Double — NOT NULL
- Y of Center Point (CY) — Double — NOT NULL
- Local X of Start Point (LSX) — Double — NOT NULL
- Local Y of Start Point (LSY) — Double — NOT NULL
- Local X of End Point (LEX) — Double — NOT NULL
- Local Y of End Point (LEY) — Double — NOT NULL
- Local X of Center Point (LCX) — Double — NOT NULL
- Local Y of Center Point (LCY) — Double — NOT NULL
- Angle of Rotation (R) — Double — NOT NULL
ARC OUTBOUNDARY of Part_Stiff (ARC_OUTBOUNDARY_of_Part_Stiff)
- MARK NAME (STIFF_NAME) — varchar2 — 기본 키 — NOT NULL
- SHIP NO (SHIP) — varchar2 — 기본 키 — NOT NULL
- BLOCK NO (BLOCK) — varchar2 — 기본 키 — NOT NULL
- PANEL NAME (P_NAME) — varchar2 — 기본 키 — NOT NULL
- MARK NAME (NAME2) — varchar2 — 외래 키 → Part_Mark.MARK NAME — NOT NULL
- TYPE OF ARC (CWCCW) — INT — NOT NULL
- X of Start Point (SX) — Double — NOT NULL
- Y of Start Point (SY) — Double — NOT NULL
- X of End Point (EX) — Double — NOT NULL
- Y of Center Point (EY) — Double — NOT NULL
- X of Center Point (CX) — Double — NOT NULL
- Y of Center Point (CY) — Double — NOT NULL
- Local X of Start Point (LSX) — Double — NOT NULL
- Local Y of Start Point (LSY) — Double — NOT NULL
- Local X of End Point (LEX) — Double — NOT NULL
- Local Y of End Point (LEY) — Double — NOT NULL
- Local X of Center Point (LCX) — Double — NOT NULL
- Local Y of Center Point (LCY) — Double — NOT NULL
- Angle of Rotation (R) — Double — NOT NULL
ARC of INBOUNDARY (ARC_OF_INBOUNDARY)
- ARC_NO — int — 기본 키 — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → Part_Info.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → Part_Info.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → Part_Info.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → Part_Info.PART NAME — NOT NULL — 부재 이름
- TYPE OF ARC (CWCCW) — int — NOT NULL — Line : 1, 시계방향 ARC : 2, 반시계 방향 ARC: 3
- X of Start Point (SX) — Double — NOT NULL
- Y of Start Point (SY) — Double — NOT NULL
- X of End Point (EX) — Double — NOT NULL
- Y of End Point (EY) — Double — NOT NULL
- X of Center Point (CX) — Double — NOT NULL
- Y of Center Point (CY) — Double — NOT NULL
- Angle of Rotation (R) — Double — NOT NULL
- Local X of Start Point (LSX) — Double — NOT NULL
- Local Y of Start Point (LSY) — Double — NOT NULL
- Local X of End Point (LEX) — Double — NOT NULL
- Local Y of End Point (LEY) — Double — NOT NULL
- Local X of Center Point (LCX) — Double — NOT NULL
- Local Y of Center Point (LCY) — Double — NOT NULL
ARC of OUTBOUNDARY (ARC_OF_OUTBOUNDARY)
- ARC_NO — int — 기본 키 — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → Part_Info.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → Part_Info.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → Part_Info.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → Part_Info.PART NAME — NOT NULL — 부재 이름
- TYPE OF ARC (CWCCW) — int — NOT NULL — Line : 1, 시계방향 ARC : 2, 반시계 방향 ARC: 3
- X of Start Point (SX) — Double — NOT NULL
- Y of Start Point (SY) — Double — NOT NULL
- X of End Point (EX) — Double — NOT NULL
- Y of End Point (EY) — Double — NOT NULL
- X of Center Point (CX) — Double — NOT NULL
- Y of Center Point (CY) — Double — NOT NULL
- Angle of Rotation (R) — Double — NOT NULL
- Local X of Start Point (LSX) — Double — NOT NULL
- Local Y of Start Point (LSY) — Double — NOT NULL
- Local X of End Point (LEX) — Double — NOT NULL
- Local Y of End Point (LEY) — Double — NOT NULL
- Local X of Center Point (LCX) — Double — NOT NULL
- Local Y of Center Point (LCY) — Double — NOT NULL
Arc of Part_Mark (ARC_of_MARK)
- MARK NAME (NAME) — varchar2 — 기본 키 — NOT NULL
- SHIP NAME (SHIP_NO) — varchar2 — 기본 키 — NOT NULL
- BLOCK NAME (BLOCK_NO) — varchar2 — 기본 키 — NOT NULL
- PANEL NAME (PANEL_NAME) — varchar2 — 기본 키 — NOT NULL
- PART NAME (PART_NAME) — varchar2 — 기본 키 — NOT NULL
- MARK NAME (NAME2) — varchar2 — 외래 키 → Part_Mark.MARK NAME — NOT NULL
- TYPE OF ARC (CWCCW) — int — NOT NULL — Line : 1, 시계방향 ARC : 2, 반시계 방향 ARC: 3
- X of Start Point (SX) — Double — NOT NULL
- Y of Start Point (SY) — Double — NOT NULL
- X of End Point (EX) — Double — NOT NULL
- Y of End Point (EY) — Double — NOT NULL
- X of Center Point (CX) — Double — NOT NULL
- Y of Center Point (CY) — Double — NOT NULL
- Angle of Rotation (R) — Double — NOT NULL
- Local X of Start Point (LSX) — Double — NOT NULL
- Local Y of Start Point (LSY) — Double — NOT NULL
- Local X of End Point (LEX) — Double — NOT NULL
- Local Y of End Point (LEY) — Double — NOT NULL
- Local X of Center Point (LCX) — Double — NOT NULL
- Local Y of Center Point (LCY) — Double — NOT NULL
Bevel of INBOUNDARY (BEVEL_OF_INBOUNDARY)
- ARC_NO (ARC_NO2) — int — 외래 키 → ARC of INBOUNDARY.ARC_NO — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → ARC of INBOUNDARY.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → ARC of INBOUNDARY.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → ARC of INBOUNDARY.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → ARC of INBOUNDARY.PART NAME — NOT NULL — 부재 이름
- CODE OF BEVEL (CODE) — varchar2 — NOT NULL
- SIDE OF BEVEL (SIDE) — varchar2 — NOT NULL
- Angle OF BEVEL1 (ANGLE1) — Double — NOT NULL
- Angle OF BEVEL2 (ANGLE2) — Double — NOT NULL
- CHAMFER OF ARC (CHAMFER) — Double — NOT NULL
Bevel of OUTBOUNDARY (BEVEL_OF_OUTBOUNDARY)
- ARC_NO (ARC_NO2) — int — 외래 키 → ARC of OUTBOUNDARY.ARC_NO — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → ARC of OUTBOUNDARY.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → ARC of OUTBOUNDARY.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → ARC of OUTBOUNDARY.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → ARC of OUTBOUNDARY.PART NAME — NOT NULL — 부재 이름
- CODE OF BEVEL (CODE) — varchar2 — NOT NULL
- SIDE OF BEVEL (SIDE) — varchar2 — NOT NULL
- Angle OF BEVEL1 (ANGLE1) — Double — NOT NULL
- Angle OF BEVEL2 (ANGLE2) — Double — NOT NULL
- CHAMFER OF ARC (CHAMFER) — Double — NOT NULL
- Field
Label of Part (Label_of_Part)
- MARK NAME (NAME) — varchar2 — 기본 키 — NOT NULL
- SHIP NAME (SHIP_NO) — varchar2 — 기본 키 — NOT NULL
- BLOCK NAME (BLOCK_NO) — varchar2 — 기본 키 — NOT NULL
- PANEL NAME (PANEL_NAME) — varchar2 — 기본 키 — NOT NULL
- PART NAME (PART_NAME) — varchar2 — 기본 키 — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → Part_Info.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → Part_Info.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → Part_Info.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → Part_Info.PART NAME — NOT NULL — 부재 이름
- Text of Part (STR) — varchar2 — NOT NULL
- X of the text starting point (X) — Double — NOT NULL
- Y of the text starting point (Y) — Double — NOT NULL
- W of the text starting point (W) — Double — NOT NULL
- H of the text starting point (H) — Double — NOT NULL
- Angle of Rotation (ANGLE) — Double — NOT NULL
NEST OF PART (Nest_Of_Part)
- SHIP NO (SHIP) — varchar2 — 기본 키 — NOT NULL
- NEST NAME (NEST_NAME) — varchar2 — 기본 키 — NOT NULL
- PART_1 NAME (PART_1) — varchar2 — NOT NULL
- Strar Point(x)of Part_1 (SX_PART_1) — Double — NOT NULL
- Strar Point(y)of Part_1 (SY_PART_1) — Double — NOT NULL
- MARK_1 NAME (MARK_1) — varchar2
- Start Point(x)of Mark_1 (SX_MARK_1) — Double
- Start Point(y)of Mark_1 (SY_MARK_1) — Double
- MARK_2 NAME (MARK_2) — varchar2
- Start Point(x)of Mark_2 (SX_MARK_2) — Double
- Start Point(y)of Mark_2 (SY_MARK_2) — Double
- MARK_3 NAME (MARK_3) — varchar2
- Start Point(x)of Mark_3 (SX_MARK_3) — Double
- Start Point(y)of Mark_3 (SY_MARK_3) — Double
- MARK_4 NAME (MARK_4) — varchar2
- Start Point(x)of Mark_4 (SX_MARK_4) — Double
- Start Point(y)of Mark_4 (SY_MARK_4) — Double
- MARK_5 NAME (MARK_5) — varchar2
- Start Point(x)of Mark_5 (SX_MARK_5) — Double
- Start Point(5)of Mark_5 (SY_MARK_5) — Double
Part_Info
- SHIP NO (SHIP) — varchar2 — 기본 키 — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK) — varchar2 — 기본 키 — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 기본 키 — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME) — varchar2 — 기본 키 — NOT NULL — 부재 이름
- WORK TYPE (W_TYPE) — varchar2 — 작업 구분(Frame, Girder, Bracket)
- REVISION (REV) — INT — NOT NULL — 부재의 revision 번호
- PART TYPE (P_TYPE) — INT — NOT NULL — 부재 타입 구분(PLATE, STIFFENER, ANGLE, T-BAR)
- STAGE (SONGSUN) — varchar2 — 작업 송선
- PART THICKNESS (THICK) — Double — NOT NULL — 부재 두께
- PART GRADE (GRADE) — varchar2 — NOT NULL — 부재 Quality
- PART AREA (AREA) — Double — NOT NULL — 부재 면적
- PART WIDTH (WIDTH) — Double — 부재 너비 값
- PART LENGTH (LENGTH) — Double — 부재 길이 값
- PART WIDTH2 (WIDTH2) — Double — 부재2의 너비 값(Profile 종류에 따라 값 존재)
- PART LENGTH2 (LENGTH2) — Double — 부재2의 길이 값(Profile 종류에 따라 값 존재)
- PART THICK2 (THICK2) — Double — 부재2의 두께 값(Profile 종류에 따라 값 존재)
- PART COG_U (COG_U) — Double — 부재 COG U 값
- PART COG_V (COG_V) — Double — 부재 COG V 값
- PART WEIGHT (WEIGHT) — Double — 부재 무게 값
- ASSEMBLY (ASSY) — varchar2 — 부재가 속한 Assembly 이름
- SHIP NO (SHIP2) — varchar2 — 외래 키 → NEST OF PART.SHIP NO — NOT NULL
- NEST NAME (NEST_NAME) — varchar2 — 외래 키 → NEST OF PART.NEST NAME — NOT NULL
Part_Mark (MARK)
- MARK NAME (NAME) — varchar2 — 기본 키 — NOT NULL
- MARKING SIDE (SIDE) — varchar2 — NOT NULL
- MARKING TYPE (TYPE) — varchar2 — NOT NULL
- MARKING PROFILE THICKNESS (M_PR_THICKNESS) — Double — NOT NULL
- SHIP NO (SHIP2) — varchar2 — 외래 키 → Part_Info.SHIP NO — NOT NULL — 소부재 작업 선박명
- BLOCK NO (BLOCK2) — varchar2 — 외래 키 → Part_Info.BLOCK NO — NOT NULL — 소부재 작업 블록명
- PANEL NAME (P_NAME) — varchar2 — 외래 키 → Part_Info.PANEL NAME — NOT NULL — 소부재 작업 판넬 이름
- PART NAME (NAME2) — varchar2 — 외래 키 → Part_Info.PART NAME — NOT NULL — 부재 이름