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