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)