소부재 db 설계

테이블 (8)

ARC of INBOUNDARY (ARC_OF_INBOUNDARY)

  • 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
  • ARC_NO — int — 기본 키 — 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

ARC of OUTBOUNDARY (ARC_OF_OUTBOUNDARY)

  • 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
  • ARC_NO — int — 기본 키 — 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

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

Bevel of INBOUNDARY (BEVEL_OF_INBOUNDARY)

  • 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
  • ARC_NO — int — 기본 키 — 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)

  • 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
  • ARC_NO — int — 기본 키 — 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

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

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 이름

Part_Mark (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
  • 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 — 부재 이름