소부재설계_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 — 부재 이름