SIOS ERD

Tables (15)

SIOSC0010 (레이어 관리)

  • LAY_CD (1) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • LAY_NM (2) — VARCHAR2(30 Char)
  • LAY_TYPE (3) — VARCHAR2(10 Char)
  • REMARK (4) — VARCHAR2(200 Char)
  • USE_YN (5) — VARCHAR2(1 Char)
  • DEFAULT_YN (6) — VARCHAR2(1 Char)
  • REG_USER (7) — VARCHAR2(20 Char)
  • REG_DATE (8) — DATE
  • UPD_USER (9) — VARCHAR2(20 Char)
  • UPD_DATE (10) — DATE

SIOSC0020 (레이어별 Feature 관리)

  • LAY_CD (1) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • FT_CD (2) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • FT_NM (3) — VARCHAR2(20 Char)
  • FT_DESC (4) — VARCHAR2(50 Char)
  • FT_MGMT (5) — VARCHAR2(20 Char)
  • FT_COORD (6) — VARCHAR2(50 Char)
  • FT_ANGLE (7) — NUMBER
  • BG_COLOR (8) — VARCHAR2(20 Char)
  • LN_COLOR (9) — VARCHAR2(20 Char)
  • FR_COLOR (10) — VARCHAR2(20 Char)
  • FT_KIND (11) — VARCHAR2(10 Char)
  • FT_TYPE (12) — VARCHAR2(10 Char)
  • ETC_INFO (13) — VARCHAR2(50 Char)
  • USE_YN (14) — VARCHAR2(1 Char)
  • REG_USER (15) — VARCHAR2(20 Char)
  • REG_DATE (16) — DATE
  • UPD_USER (17) — VARCHAR2(20 Char)
  • UPD_DATE (18) — DATE

SIOSC9010 (DOCK 관리)

  • DOCK_CODE (1) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • POS_SEQ (2) — NUMBER — Primary key — NOT NULL
  • DOCK_NAME (3) — VARCHAR2(50 Char)
  • DOCK_TYPE (4) — VARCHAR2(20 Char)
  • DOCK_DESC (5) — VARCHAR2(200 Char)
  • DOCK_LEN (6) — NUMBER
  • DOCK_WID (7) — NUMBER
  • DOCK_DIR (8) — VARCHAR2(1 Char)
  • POS_LON (9) — VARCHAR2(15 Char)
  • POS_LAN (10) — VARCHAR2(15 Char)
  • ROT_ANG (11) — NUMBER
  • DEP_MIN (12) — NUMBER
  • DEP_MAX (13) — NUMBER
  • SHP_KND (14) — VARCHAR2(10 Char)
  • REG_USER (15) — VARCHAR2(20 Char)
  • REG_DATE (16) — DATE
  • UPD_USER (17) — VARCHAR2(20 Char)
  • UPD_DATE (18) — DATE

SIOSC9020 (안벽 관리)

  • QUAY_CODE (1) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • POS_SEQ (2) — NUMBER — Primary key — NOT NULL
  • QUAY_NAME (3) — VARCHAR2(50 Char)
  • QUAY_TYPE (4) — VARCHAR2(20 Char)
  • QUAY_DESC (5) — VARCHAR2(200 Char)
  • QUAY_LEN (6) — NUMBER
  • QUAY_WID (7) — NUMBER
  • QUAY_DIR (8) — VARCHAR2(1 Char)
  • POS_LON (9) — VARCHAR2(15 Char)
  • POS_LAN (10) — VARCHAR2(15 Char)
  • ROT_ANG (11) — NUMBER
  • DEP_MIN (12) — NUMBER
  • DEP_MAX (13) — NUMBER
  • SHP_KND (14) — VARCHAR2(10 Char)
  • REMAKR (15) — VARCHAR2(200 Char)
  • REG_USER (16) — VARCHAR2(20 Char)
  • REG_DATE (17) — DATE
  • UPD_USER (18) — VARCHAR2(20 Char)
  • UPD_DATE (19) — DATE

SIOSC9030 (SHIP 관리)

  • SHIP_NO (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • SHIP_KIND (2) — VARCHAR2(10 Char)
  • SHIP_NAME (3) — VARCHAR2(50 Char)
  • SHIP_DESC (4) — VARCHAR2(200 Char)
  • DOCK_CODE (5) — VARCHAR2(20 Char)
  • QUAY_CODE (6) — VARCHAR2(20 Char)
  • CURR_LOC (7) — VARCHAR2(10 Char)
  • PROJ_TYPE (8) — VARCHAR2(10 Char)
  • SC_DATE (9) — VARCHAR2(10 Char)
  • KL_DATE (10) — VARCHAR2(10 Char)
  • FT_DATE (11) — VARCHAR2(10 Char)
  • LC_DATE (12) — VARCHAR2(10 Char)
  • CL_DATE (13) — VARCHAR2(10 Char)
  • DL_DATE (14) — VARCHAR2(10 Char)
  • COORD_XY (15) — VARCHAR2(4000 Char)
  • LOA (16) — NUMBER
  • LBP (17) — NUMBER
  • BEAM (18) — NUMBER
  • DEPTH (19) — NUMBER
  • TOT_TON (20) — NUMBER
  • CG_TON (21) — NUMBER
  • ODER_OWN_NM (22) — VARCHAR2(20 Char)
  • REC_OWN_NM (23) — VARCHAR2(20 Char)
  • PLAN_ST_DATE (24) — VARCHAR2(10 Char)
  • PLAN_FI_DATE (25) — VARCHAR2(10 Char)
  • REG_USER (26) — VARCHAR2(20 Char)
  • REG_DATE (27) — DATE
  • UPD_USER (28) — VARCHAR2(20 Char)
  • UPD_DATE (29) — DATE
  • Field

SIOSC9040 (BLOCK 관리)

  • SHIP_NO (1) — VARCHAR2(10 Char)
  • BLK_NO (2) — VARCHAR2(10 Char)
  • BLK_TYPE (3) — VARCHAR2(1 Char)
  • PE_STATUS (4) — VARCHAR2(10 Char)
  • BLK_LEN (5) — NUMBER
  • BLK_WID (6) — NUMBER
  • BLK_MES (7) — VARCHAR2(1 Char)
  • COORD_XY (8) — VARCHAR2(999 Char)
  • CENTER_X (9) — VARCHAR2(50 Char)
  • CENTER_Y (10) — VARCHAR2(50 Char)
  • STOCK_DTE (11) — VARCHAR2(10 Char)
  • CUR_PRO (12) — VARCHAR2(10 Char)
  • LOT_NUM (13) — VARCHAR2(10 Char)
  • TP_CODE (14) — VARCHAR2(10 Char)
  • TP_ORD_CD (15) — VARCHAR2(10 Char)
  • DESI_CODE (16) — VARCHAR2(10 Char)
  • DESI_SEQ (17) — VARCHAR2(10 Char)
  • REG_USER (18) — VARCHAR2(20 Char)
  • REG_DATE (19) — DATE
  • UPD_USER (20) — VARCHAR2(20 Char)
  • UPD_DATE (21) — DATE

SIOSC9050 (BLOCK PLAN)

  • SHIP_NO (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • BLK_NO (2) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • SUB_ASSEM_PLN (3) — VARCHAR2(10 Char)
  • SUB_ASSEM_ACT (4) — VARCHAR2(10 Char)
  • MAIN_ASSEM_PLN (5) — VARCHAR2(10 Char)
  • MAIN_ASSEM_ACT (6) — VARCHAR2(10 Char)
  • PRE_OFIT_PLN (7) — VARCHAR2(10 Char)
  • PRE_OFIT_ACT (8) — VARCHAR2(10 Char)
  • PRE_PE_PLN (9) — VARCHAR2(10 Char)
  • PRE_PE_ACT (10) — VARCHAR2(10 Char)
  • PRE_PNT_PLN (11) — VARCHAR2(10 Char)
  • PRE_PNT_ACT (12) — VARCHAR2(10 Char)
  • POS_PE1_PLN (13) — VARCHAR2(10 Char)
  • POS_PE1_ACT (14) — VARCHAR2(10 Char)
  • POS_PE2_PLN (15) — VARCHAR2(10 Char)
  • POS_PE2_ACT (16) — VARCHAR2(10 Char)
  • BLK_EREC_PLN (17) — VARCHAR2(10 Char)
  • BLK_EREC_ACT (18) — VARCHAR2(10 Char)
  • REG_USER (19) — VARCHAR2(20 Char)
  • REG_DATE (20) — DATE
  • UPD_USER (21) — VARCHAR2(20 Char)
  • UPD_DATE (22) — DATE

SIOSZ0010 (공통코드 관리 (HEADER))

  • CODE_DVN (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • CODE_DVN_NAME (2) — VARCHAR2(30 Char)
  • USE_YN (3) — VARCHAR2(1 Char)
  • REG_USER (4) — VARCHAR2(20 Char)
  • REG_DATE (5) — DATE
  • UPD_USER (6) — VARCHAR2(20 Char)
  • UPD_DATE (7) — DATE

SIOSZ0011 (공통코드 관리(DETAIL))

  • CODE_DVN (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • CODE_NO (2) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • CODE_NAME (3) — VARCHAR2(30 Char)
  • SORT_NUM (4) — NUMBER
  • USE_YN (5) — VARCHAR2(1 Char)
  • TEMP1 (6) — VARCHAR2(30 Char)
  • TEMP2 (7) — VARCHAR2(30 Char)
  • TEMP3 (8) — VARCHAR2(30 Char)
  • TEMP4 (9) — VARCHAR2(30 Char)
  • TEMP5 (10) — VARCHAR2(30 Char)
  • REMARK (11) — VARCHAR2(200 Char)
  • REG_USER (12) — VARCHAR2(20 Char)
  • REG_DATE (13) — DATE
  • UPD_USER (14) — VARCHAR2(20 Char)
  • UPD_DATE (15) — DATE

SIOSZ0020 (부서관리)

  • DEPT_CODE (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • DEPT_NAME (2) — VARCHAR2(30 Char)
  • USE_YN (3) — VARCHAR2(1 Char)
  • REG_USER (4) — VARCHAR2(20 Char)
  • REG_DATE (5) — DATE
  • UPD_USER (6) — VARCHAR2(20 Char)
  • UPD_DATE (7) — DATE
  • DEPT_FULL_CODE (8) — VARCHAR2(100 Char)
  • PARENT_CODE (9) — VARCHAR2(10 Char)
  • SORT_NUM (10) — NUMBER

SIOSZ0030 (사용자 관리)

  • USER_ID (1) — VARCHAR2(20 Char) — Primary key — NOT NULL
  • USER_NAME (2) — VARCHAR2(10 Char) — NOT NULL
  • DEPT_CODE (3) — VARCHAR2(10 Char)
  • OFFICE_TEL (4) — VARCHAR2(10 Char)
  • USER_PHONE (5) — VARCHAR2(15 Char)
  • POSITION1 (6) — VARCHAR2(10Char)
  • POSITION2 (7) — VARCHAR2(10 Char)
  • ADMIN_YN (8) — VARCHAR2(1 Char)
  • REG_USER (9) — VARCHAR2(20 Char)
  • REG_DATE (10) — DATE
  • UPD_USER (11) — VARCHAR2(20 Char)
  • UPD_DATE (12) — DATE
  • RETIRE_YN (13) — VARCHAR2(1 Char)

SIOSZ0040 (메뉴리스트)

  • MENU_CODE (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • MENU_FULL_CD (2) — VARCHAR2(50 Char) — NOT NULL
  • MENU_NAME (3) — VARCHAR2(30 Char)
  • MENU_PATH (4) — VARCHAR2(50 Char)
  • SORT_NO (5) — NUMBER
  • PARENT_MENU_CD (6) — VARCHAR2(10Char)
  • DEVICE_TYPE (7) — VARCHAR2(1 Char)
  • REMARK (8) — VARCHAR2(300 Char)
  • USE_YN (9) — VARCHAR2(1 Char)
  • REG_USER (10) — VARCHAR2(20 Char)
  • REG_DATE (11) — DATE
  • UPD_USER (12) — VARCHAR2(20 Char)
  • UPD_DATE (13) — DATE

SIOSZ0050 (권한 리스트)

  • AUTH_CD (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • AUTH_NAME (2) — VARCHAR2(50 Char)
  • REG_USER (3) — VARCHAR2(20 Char)
  • REG_DATE (4) — DATE
  • UPD_USER (5) — VARCHAR2(20 Char)
  • UPD_DATE (6) — DATE

SIOSZ0051 (권한 세부정보)

  • AUTH_CD (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • MENU_CD (2) — VARCHAR2(10 Char) — Primary key
  • USE_YN (3) — VARCHAR2(1 Char)
  • SEARCH_YN (4) — VARCHAR2(1 Char)
  • SASVE_YN (5) — VARCHAR2(1 Char)
  • DELETE_YN (6) — VARCHAR2(1 Char)
  • REG_USER (7) — VARCHAR2(20 Char)
  • REG_DATE (8) — DATE
  • UPD_USER (9) — VARCHAR2(20 Char)
  • UPD_DATE (10) — DATE

SIOZ0060 (CopyOf권한 리스트)

  • AUTH_CD (1) — VARCHAR2(10 Char) — Primary key — NOT NULL
  • AUTH_NAME (2) — VARCHAR2(50 Char)
  • REG_USER (3) — VARCHAR2(20 Char)
  • REG_DATE (4) — DATE
  • UPD_USER (5) — VARCHAR2(20 Char)
  • UPD_DATE (6) — DATE