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