HiCCS
Tables (39)
TB_CCS_AUTHORITY
- IDX — NUMBER
- AUTHORITY — NUMBER
- USER_ID — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- NOTE — VARCHAR2(500)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
TB_CCS_CHS
- IDX — NUMBER — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- SIMULATION_IDX — VARCHAR2(100) — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- TYPE — VARCHAR2(50) — NOT NULL
- INPUT_VALUE — VARCHAR2(500) — NOT NULL
- TITLE — VARCHAR2(500)
- ETC — VARCHAR2(200)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- MEMO — VARCHAR2(500)
TB_CCS_CHS_FINAL
- TYPE — VARCHAR2(50) — Primary key — NOT NULL
- CHS_IDX — NUMBER — Foreign key → TB_CCS_CHS.IDX — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- TANK_NO — VARCHAR2(20) — NOT NULL
- SIMULATION_IDX — VARCHAR2(100) — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(200)
- SIMULATION_USER — VARCHAR2(50) — NOT NULL
TB_CCS_CHS_N2_PIPE
- IDX — NUMBER — NOT NULL
- CHS_IDX — NUMBER — Foreign key → TB_CCS_CHS.IDX — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- START_POS_X — VARCHAR2(20) — NOT NULL
- START_POS_Y — VARCHAR2(20) — NOT NULL
- END_POS_X — VARCHAR2(20) — NOT NULL
- END_POS_Y — VARCHAR2(20) — NOT NULL
- START_CONNECT_TYPE — VARCHAR2(100)
- END_CONNECT_TYPE — VARCHAR2(100)
- TYPE — VARCHAR2(10) — NOT NULL
TB_CCS_CHS_N2_SUPPORT
- IDX — NUMBER
- CHS_IDX — NUMBER — Foreign key → TB_CCS_CHS.IDX
- WALL — VARCHAR2(10)
- TYPE — VARCHAR2(50)
- INSERT_POS_X — VARCHAR2(20)
- INSERT_POS_Y — VARCHAR2(20)
- ROTATE — VARCHAR2(10)
- ISFLIP — NUMBER
TB_CCS_CHS_NH3_ITEM
- IDX — NUMBER
- CHS_IDX — NUMBER — Foreign key → TB_CCS_CHS.IDX
- WALL — VARCHAR2(10)
- TYPE — VARCHAR2(50)
- INSERT_POS_X — VARCHAR2(20)
- INSERT_POS_Y — VARCHAR2(20)
- ROTATE — VARCHAR2(10)
- ISFLIP — NUMBER
TB_CCS_CHS_NH3_PIPE
- IDX — NUMBER — NOT NULL
- CHS_IDX — NUMBER — Foreign key → TB_CCS_CHS.IDX — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- START_POS_X — VARCHAR2(20) — NOT NULL
- START_POS_Y — VARCHAR2(20) — NOT NULL
- END_POS_X — VARCHAR2(20) — NOT NULL
- END_POS_Y — VARCHAR2(20) — NOT NULL
- START_CONNECT_TYPE — VARCHAR2(100)
- END_CONNECT_TYPE — VARCHAR2(100)
- TYPE — VARCHAR2(10) — NOT NULL
TB_CCS_COMMENT
- IDX — NUMBER — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- STAGE — NUMBER — NOT NULL
- PAGE — NUMBER — NOT NULL
- MEMO — VARCHAR2(1000) — NOT NULL
- ETC — VARCHAR2(500)
- IS_READ — NUMBER — NOT NULL
- READ_DATE — DATE
- INSERT_DATE — DATE
- INSERT_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- COMMENT_USER — VARCHAR2(50)
- SEND_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- RECIEVE_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
TB_CCS_FINAL
- SEQUENCE — NUMBER — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- TITLE — VARCHAR2(1000)
- NOTE — VARCHAR2(1000)
- INSPECTION — NUMBER
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(2000)
- IS_CONFIRM — NUMBER
- UPDATE_USER — VARCHAR2(50)
- UPDATE_DATE — DATE
TB_CCS_FINALDETAIL
- WALL — VARCHAR2(10) — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_FINAL.PROJECT_IDX — NOT NULL
- SEQUENCE — NUMBER — Foreign key → TB_CCS_FINAL.SEQUENCE — NOT NULL
- SIMULATION_IDX — NUMBER — NOT NULL
TB_CCS_INIT
- IDX — NUMBER — Primary key — NOT NULL
- SHIP_TYPE — VARCHAR2(200)
- TANK_TYPE — VARCHAR2(10)
- DEFAULT_TYPE — VARCHAR2(200) — NOT NULL
- DEFAULT_KEY — VARCHAR2(200)
- DEFAULT_VALUE — VARCHAR2(500) — NOT NULL
- NOTE — VARCHAR2(500)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
- PGM_MODE — VARCHAR2(10)
TB_CCS_IP
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- CODE — VARCHAR2(50) — NOT NULL
- LISTING — VARCHAR2(50) — NOT NULL
- TYPE — VARCHAR2(10)
- W — VARCHAR2(10)
- L1 — VARCHAR2(10)
- L2 — VARCHAR2(10)
- ROTATE — VARCHAR2(10)
- X1 — VARCHAR2(20)
- Y1 — VARCHAR2(20)
- Z1 — VARCHAR2(20)
- X2 — VARCHAR2(20)
- Y2 — VARCHAR2(20)
- Z2 — VARCHAR2(20)
- X3 — VARCHAR2(20)
- Y3 — VARCHAR2(20)
- Z3 — VARCHAR2(20)
- X4 — VARCHAR2(20)
- Y4 — VARCHAR2(20)
- Z4 — VARCHAR2(20)
- X5 — VARCHAR2(20)
- Y5 — VARCHAR2(20)
- Z5 — VARCHAR2(20)
- OPENING — VARCHAR2(10)
TB_CCS_ITEM_ALL_IP
- PGM_MODE — VARCHAR2(10) — NOT NULL
- SYSTEM_TYPE — VARCHAR2(10) — NOT NULL
- LISTING_CODE — VARCHAR2(50) — NOT NULL
- SHAPE_CODE — VARCHAR2(50) — NOT NULL
- SHIP_TYPE — VARCHAR2(50)
- NOTE — VARCHAR2(200)
- WALL — VARCHAR2(50) — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- CODE_AREA — VARCHAR2(100)
- FILE_NAME — VARCHAR2(1000)
- ISDWG — NUMBER
- REV — NUMBER
- WEIGHT — NUMBER
- ISDEFAULT — NUMBER
TB_CCS_ITEM_ALL_UM
- PGM_MODE — VARCHAR2(10) — NOT NULL
- SYSTEM_TYPE — VARCHAR2(10) — NOT NULL
- LISTING_CODE — VARCHAR2(50) — NOT NULL
- SHAPE_CODE — VARCHAR2(50) — NOT NULL
- SHIP_TYPE — VARCHAR2(50)
- NOTE — VARCHAR2(200)
- WALL — VARCHAR2(50) — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- CODE_AREA — VARCHAR2(100)
- FILE_NAME — VARCHAR2(1000)
- ISDWG — NUMBER
- REV — NUMBER
- ISDEFAULT — NUMBER
- WEIGHT — NUMBER
TB_CCS_ITEM_SHIP_IP
- SHAPE_CODE — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_IDX — VARCHAR2(20) — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- PGM_MODE — VARCHAR2(10) — NOT NULL
- SYSTEM_TYPE — VARCHAR2(10) — NOT NULL
- LISTING_CODE — VARCHAR2(50) — NOT NULL
- SHIP_TYPE — VARCHAR2(50)
- NOTE — VARCHAR2(200)
- WALL — VARCHAR2(50) — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- CODE_AREA — VARCHAR2(100)
- FILE_NAME — VARCHAR2(1000)
- ISDWG — NUMBER
- REV — NUMBER
- WEIGHT — NUMBER
- SHIP_NO — VARCHAR2(20)
TB_CCS_ITEM_SHIP_UM
- SHAPE_CODE — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_IDX — VARCHAR2(20) — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- PGM_MODE — VARCHAR2(10) — NOT NULL
- SYSTEM_TYPE — VARCHAR2(10) — NOT NULL
- LISTING_CODE — VARCHAR2(50) — NOT NULL
- SHIP_TYPE — VARCHAR2(50)
- NOTE — VARCHAR2(200)
- WALL — VARCHAR2(50) — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- CODE_AREA — VARCHAR2(100)
- FILE_NAME — VARCHAR2(1000)
- ISDWG — NUMBER
- REV — NUMBER
- WEIGHT — NUMBER
- SHIP_NO — VARCHAR2(20)
TB_CCS_MARKING
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- MEMBRANE_LINE — VARCHAR2(500)
- MEMBRANE_SHEET_LINE — VARCHAR2(500)
- HULL_LINE — VARCHAR2(500)
- PANEL_LINE — VARCHAR2(500)
- TITLE — VARCHAR2(1000)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
- PARAMETER — VARCHAR2(500)
TB_CCS_MARKINGLINE
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- MEMBRANE_LINE_POS — VARCHAR2(2000)
- MEMBRANE_SHEET_LINE_POS — VARCHAR2(2000)
- HULL_LINE_POS — VARCHAR2(2000)
- PANEL_LINE_POS — VARCHAR2(2000)
- PITCH_SIZE — VARCHAR2(50)
TB_CCS_OPTION
- SEQUENCE — NUMBER — Primary key — NOT NULL
- REQUISITE_ITEM — NUMBER — NOT NULL
- INITIAL_ITEM — NUMBER — NOT NULL
- SELECTED_ITEM — NUMBER — NOT NULL
- POPUP_ITEM — NUMBER
- IP — NUMBER — NOT NULL
- UM — NUMBER — NOT NULL
- OPTION_VALUE — VARCHAR2(1000)
- PRIORITY — NUMBER — NOT NULL
- FILE_PATH — VARCHAR2(1000)
- WALL — VARCHAR2(200)
- TANK_TYPE — VARCHAR2(10)
- OPTION_TYPE — VARCHAR2(10)
- CONN_TYPE — NUMBER
- ETC — VARCHAR2(500)
TB_CCS_PREFERENCE
- IDX — NUMBER
- BATCH_PATH — VARCHAR2(500)
- RECOMMEND_PATH — VARCHAR2(500)
- FEEDBACK_PATH — VARCHAR2(500)
- FEEDBACK — NUMBER
- INSERT_DATE — DATE
- INSERT_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- FEEDBACK_COMMENT — VARCHAR2(1000)
- ETC — VARCHAR2(500)
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
TB_CCS_PROJECT
- IDX — NUMBER — Primary key — NOT NULL
- SHIP_NO — VARCHAR2(50)
- SHIP_TYPE — VARCHAR2(50)
- TANK_NO — VARCHAR2(50) — NOT NULL
- INSERT_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
- NOTE — VARCHAR2(1000)
- TANK_TYPE — VARCHAR2(20) — NOT NULL
- PROJECT — VARCHAR2(500)
- UPDATE_USER — VARCHAR2(50)
- UPDATE_DATE — DATE
- SHIP_SIZE — VARCHAR2(50)
- PGM_MODE — VARCHAR2(10)
- SYSTEM_TYPE — VARCHAR2(10)
- DENSITY — VARCHAR2(10)
- INITIAL_SPECIALAREA — VARCHAR2(1000)
- TANK_CNT — VARCHAR2(20)
- MARKING_TANKDOME — VARCHAR2(500)
- SERIES_TEXT — VARCHAR2(500)
- CHS_MANAGER — VARCHAR2(50)
TB_CCS_REF_TRUSS
- IDX — NUMBER — Primary key — NOT NULL
- SHIP_NO — VARCHAR2(50)
- SHIP_TYPE — VARCHAR2(50)
- SHIP_SIZE — VARCHAR2(50)
- TANK_TYPE — VARCHAR2(20)
- TANK_NO — VARCHAR2(50)
- SYSTEM_TYPE — VARCHAR2(10)
- MEMBRANE_LINE — VARCHAR2(500)
- TRUSS_HEIGHT — VARCHAR2(200)
- NOTE — VARCHAR2(500)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
TB_CCS_REF_TRUSS_DETAIL
- LOC_ROW — NUMBER — Primary key — NOT NULL
- LOC_COL — NUMBER — Primary key — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX — NOT NULL
- LEG_NO — NUMBER
- PAN_X — VARCHAR2(20)
- PAN_Y — VARCHAR2(20)
- PAN_WIDTH — VARCHAR2(20)
- PAN_HEIGHT — VARCHAR2(20)
- LEG_X — VARCHAR2(20)
- LEG_Y — VARCHAR2(20)
- LEG_GAP — NUMBER
- ISNULL — NUMBER
- ISCENTER — NUMBER
- NO — VARCHAR2(20)
TB_CCS_SIMULATION
- IDX — NUMBER — Primary key — NOT NULL
- ETC — VARCHAR2(500)
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX
- SIMULATION — NUMBER
- OPTION_VALUE — VARCHAR2(1000)
- SPECIALAREA_VALUE — VARCHAR2(1000)
- TRUSS_VALUE — VARCHAR2(3000)
- TRUSS_HEIGHT — VARCHAR2(200)
- PIPELINE_VALUE — VARCHAR2(200)
- REINFORCEDAREA_VALUE — VARCHAR2(500)
- WALL — VARCHAR2(10) — NOT NULL
- TITLE — VARCHAR2(1000)
- INSERT_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID
- INSERT_DATE — DATE
- DWG_ROTATE — NUMBER
- ORIGIN — NUMBER
- TRUSS_LEG — VARCHAR2(3000)
- LIFT_AREA — VARCHAR2(500)
- IS_CONFIRM — NUMBER
- IS_STYPE — NUMBER
- IS_IK — NUMBER
- CHS_N2_IDX — NUMBER
- CHS_NH3_IDX — NUMBER
- UPDATE_DATE — DATE
- UPDATE_USER — VARCHAR2(50)
- PRE_SIMULATION_IDX — NUMBER
TB_CCS_SIMULATION_IB
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- CATEGORY — VARCHAR2(50) — NOT NULL
- DIRECTION — VARCHAR2(20) — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- LENGTH — VARCHAR2(20)
- QUANTITY — VARCHAR2(20)
TB_CCS_SIMULATION_TRUSS_LEG
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX — NOT NULL
- LOC_ROW — NUMBER — NOT NULL
- LOC_COL — NUMBER — NOT NULL
- X — VARCHAR2(20)
- Y — VARCHAR2(20)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ISNULL — NUMBER
TB_CCS_SIMULATION_TRUSS_PAN
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX — NOT NULL
- LOC_ROW — NUMBER — NOT NULL
- LOC_COL — NUMBER — NOT NULL
- ISNULL — NUMBER
- X — VARCHAR2(20)
- Y — VARCHAR2(20)
- W — VARCHAR2(20)
- H — VARCHAR2(20)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
TB_CCS_SI_UM
- IDX — NUMBER — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- SHIP_NO — VARCHAR2(50) — NOT NULL
- TANK_NO — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- PHASE — NUMBER — NOT NULL
- EXCEL_FILE_PATH — VARCHAR2(1000)
- DWG_FILE_PATH — VARCHAR2(1000)
TB_CCS_SI_UM_ITEM
- IDX — NUMBER — Primary key — NOT NULL
- PARENT_IDX — NUMBER — Foreign key → TB_CCS_SI_UM.IDX — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- DIRECTION — VARCHAR2(50)
- NUMBERING — VARCHAR2(100) — NOT NULL
- CODE — VARCHAR2(100) — NOT NULL
- QUANTITY — NUMBER — NOT NULL
- SIZE_X — NUMBER
- SIZE_Y — NUMBER
- SIZE_A — NUMBER
- SIZE_B — NUMBER
- TRUSS_LEVEL — NUMBER
- PHASE — NUMBER — NOT NULL
- MAX_VALUE — NUMBER
- MIN_VALUE — NUMBER
- INPUT_SIZE_X — NUMBER — NOT NULL
- INPUT_SIZE_Y — NUMBER — NOT NULL
- REMARK — VARCHAR2(500)
TB_CCS_SI_UP
- IDX — NUMBER — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- SHIP_NO — VARCHAR2(50) — NOT NULL
- TANK_NO — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- INSERT_USER — VARCHAR2(50) — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- PHASE — NUMBER — NOT NULL
- EXCEL_FILE_PATH — VARCHAR2(1000)
- DWG_FILE_PATH — VARCHAR2(1000)
TB_CCS_SI_UP_ITEM
- IDX — NUMBER — Primary key — NOT NULL
- PARENT_IDX — NUMBER — Foreign key → TB_CCS_SI_UP.IDX — NOT NULL
- WALL — VARCHAR2(10) — NOT NULL
- DIRECTION — VARCHAR2(50)
- NUMBERING — VARCHAR2(100) — NOT NULL
- CODE — VARCHAR2(100) — NOT NULL
- QUANTITY — NUMBER — NOT NULL
- LENGTH — NUMBER
- SIZE_X — NUMBER
- SIZE_Y — NUMBER
- AREA — NUMBER
- GLUE_AMOUNT — NUMBER
- TRUSS_LEVEL — NUMBER — NOT NULL
- PHASE — NUMBER — NOT NULL
- MAX_VALUE — NUMBER
- MIN_VALUE — NUMBER
- INPUT_SIZE — NUMBER — NOT NULL
- ON_SITE_VALUE — NUMBER
- DESIGN_VALUE — NUMBER
- A_VALUE — NUMBER
- REMARK — VARCHAR2(500)
TB_CCS_TEMPLATE
- IDX — NUMBER — Primary key — NOT NULL
- DWG_TYPE — NUMBER — NOT NULL
- ITEM_TYPE — NUMBER — NOT NULL
- TANK_TYPE — NUMBER — NOT NULL
- TITLE — VARCHAR2(50) — NOT NULL
- INSERT_DATE — DATE — NOT NULL
- INSERT_USER — VARCHAR2(50) — Foreign key → TB_CCS_USER.USER_ID — NOT NULL
- UPDATE_DATE — DATE — NOT NULL
- UPDATE_USER — VARCHAR2(50) — NOT NULL
- START_PAGE — NUMBER — NOT NULL
- PAPER_SIZE — VARCHAR2(10)
- FILE_PATH — VARCHAR2(1000) — NOT NULL
- ISDEFAULT — NUMBER — NOT NULL
- DETAIL_TYPE_NO — NUMBER
- ETC — VARCHAR2(500)
- GROUP_IDX — NUMBER
TB_CCS_TRUSS
- IDX — NUMBER — Primary key — NOT NULL
- PROJECT_IDX — NUMBER — Foreign key → TB_CCS_PROJECT.IDX — NOT NULL
- TITLE — VARCHAR2(500)
- LEVEL_COUNT — NUMBER
- LEGS_COUNT — NUMBER
- AMOUNT — NUMBER
- STOCK_SCORE_WEIGHT — VARCHAR2(500)
- UPPER_CHAMFER — NUMBER
- T_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- A_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- B_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- F_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- SU_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- SM_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- SL_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- PU_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- PM_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- PL_SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX
- LIQUIDDOME_VALUE — VARCHAR2(500)
- SIDEOPENING_VALUE — VARCHAR2(500)
- LIFT_VALUE — VARCHAR2(500)
- STAIR_VALUE — VARCHAR2(500)
- CP — NUMBER
- MS_WALL_1 — NUMBER
- MS_WALL_2 — NUMBER
- MS_WALL_3 — NUMBER
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)
- PDF_FILE — VARCHAR2(500)
- COMP_SCORE_WEIGHT — VARCHAR2(500)
TB_CCS_TRUSS_ITEM
- IDX — NUMBER — Primary key — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX
- X — NUMBER
- Y — NUMBER
- Z — NUMBER
- MATERIAL_CODE — VARCHAR2(100)
- SHAPE_CODE — VARCHAR2(100)
- SIZE_X — VARCHAR2(100)
- SIZE_Y — VARCHAR2(100)
- SIZE_Z — VARCHAR2(100)
- ROTATION — VARCHAR2(100)
TB_CCS_TRUSS_LEG
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX — NOT NULL
- LOC_ROW — NUMBER — NOT NULL
- LOC_COL — NUMBER — NOT NULL
- X — VARCHAR2(20)
- Y — VARCHAR2(20)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
- ISNULL — NUMBER
TB_CCS_TRUSS_PANEL
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- TRUSS_IDX — NUMBER — Foreign key → TB_CCS_TRUSS.IDX — NOT NULL
- LOC_ROW — NUMBER — NOT NULL
- LOC_COL — NUMBER — NOT NULL
- ISNULL — NUMBER
- X — VARCHAR2(20)
- Y — VARCHAR2(20)
- W — VARCHAR2(20)
- H — VARCHAR2(20)
- INSERT_USER — VARCHAR2(50)
- INSERT_DATE — DATE
TB_CCS_UM
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- CODE — VARCHAR2(50) — NOT NULL
- LISTING — VARCHAR2(50) — NOT NULL
- TYPE — VARCHAR2(10)
- W — VARCHAR2(10)
- L1 — VARCHAR2(10)
- L2 — VARCHAR2(10)
- ROTATE — VARCHAR2(10)
- X1 — VARCHAR2(20)
- Y1 — VARCHAR2(20)
- Z1 — VARCHAR2(20)
- X2 — VARCHAR2(20)
- Y2 — VARCHAR2(20)
- Z2 — VARCHAR2(20)
- X3 — VARCHAR2(20)
- Y3 — VARCHAR2(20)
- Z3 — VARCHAR2(20)
- X4 — VARCHAR2(20)
- Y4 — VARCHAR2(20)
- Z4 — VARCHAR2(20)
- X5 — VARCHAR2(20)
- Y5 — VARCHAR2(20)
- Z5 — VARCHAR2(20)
- CLOSING_SHEET — VARCHAR2(10)
- OPENING — VARCHAR2(10)
TB_CCS_UP
- SIMULATION_IDX — NUMBER — Foreign key → TB_CCS_SIMULATION.IDX — NOT NULL
- CODE — VARCHAR2(50) — NOT NULL
- LISTING — VARCHAR2(50) — NOT NULL
- TYPE — VARCHAR2(10)
- W — VARCHAR2(10)
- L1 — VARCHAR2(10)
- L2 — VARCHAR2(10)
- ROTATE — VARCHAR2(10)
- X1 — VARCHAR2(20)
- Y1 — VARCHAR2(20)
- Z1 — VARCHAR2(20)
- X2 — VARCHAR2(20)
- Y2 — VARCHAR2(20)
- Z2 — VARCHAR2(20)
- X3 — VARCHAR2(20)
- Y3 — VARCHAR2(20)
- Z3 — VARCHAR2(20)
- X4 — VARCHAR2(20)
- Y4 — VARCHAR2(20)
- Z4 — VARCHAR2(20)
- X5 — VARCHAR2(20)
- Y5 — VARCHAR2(20)
- Z5 — VARCHAR2(20)
- OPENING — VARCHAR2(10)
TB_CCS_USER
- USER_ID — VARCHAR2(50) — Primary key — NOT NULL
- USER_NAME — VARCHAR2(50) — NOT NULL
- USER_POS — VARCHAR2(50)
- USER_SECT — VARCHAR2(200)
- USER_DEPT — VARCHAR2(200)
- INSERT_DATE — DATE
- ETC — VARCHAR2(500)