유온
테이블 (43)
ASM_GROUP_MST
- VARCHAR2(20 — CHAR)` — NOT NULL
- IDX — NUMBER(10, 0)
- GROUP_NAME — VARCHAR2(50 CHAR)
- GROUP_MAIN_URL — VARCHAR2(100 CHAR)
- ORDERS — NUMBER(10, 0)
- NOTE — VARCHAR2(1000 CHAR)
- ACT — NUMBER(10, 0)
- REGIST_DATE — DATE
- REGIST_ID — VARCHAR2(20 CHAR)
- REGIST_NAME — VARCHAR2(30 CHAR)
- UPDATE_DATE — DATE
- UPDATE_ID — VARCHAR2(20 CHAR)
- UPDATE_NAME — VARCHAR2(30 CHAR)
- MOBILE_TYPE — CHAR(1 CHAR)
ASM_MENU_EXCEPT
- MENU_EXCEPT_IDX — NUMBER(10, 0)
- MENU_IDX — NUMBER(10, 0) — 외래 키 → ASM_MENU_MST.MENU_IDX — NOT NULL
- EXCEPT_TYPE — VARCHAR2(10 CHAR)
- EXCEPT_CODE — VARCHAR2(255 CHAR)
- PROC_TYPE — VARCHAR2(10 CHAR)
- UPDATE_DATE — DATE
- UPDATE_ID — VARCHAR2(20 CHAR)
- UPDATE_NAME — VARCHAR2(30 CHAR)
ASM_MENU_MST
- MENU_IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- URL — VARCHAR2(200 CHAR)
- TITLE — VARCHAR2(100 CHAR)
- DEPTH — NUMBER(10, 0)
- PARENT_IDX — NUMBER(10, 0)
- ACT — NUMBER(10, 0)
- ORDERS — NUMBER(10, 0)
- GROUP_CODE — VARCHAR2(20 CHAR)
- HIDDEN_YN — VARCHAR2(5 CHAR)
- PROC_TYPE — VARCHAR2(10 CHAR)
- POPUP_TYPE — VARCHAR2(10 CHAR)
- FULL_PATH — VARCHAR2(255 CHAR)
- ACCESS_LOG — VARCHAR2(5 CHAR)
- REGIST_DATE — DATE
- REGIST_ID — VARCHAR2(20 CHAR)
- REGIST_NAME — VARCHAR2(30 CHAR)
- UPDATE_DATE — DATE
- UPDATE_ID — VARCHAR2(20 CHAR)
- UPDATE_NAME — VARCHAR2(30 CHAR)
- POPUP_WIDTH — NUMBER(10, 0)
- POPUP_HEIGHT — NUMBER(10, 0)
- TREE_URL — VARCHAR2(50 CHAR)
- TMP_MENU_IDX — NUMBER(10, 0)
- TMP_PARENT_IDX — NUMBER(10, 0)
- URL2 — VARCHAR2(200 CHAR)
- TREE_URL2 — VARCHAR2(50 CHAR)
- FULL_PATH2 — VARCHAR2(255 CHAR)
- PARENT_IDX2 — NUMBER(10, 0)
- CHILD_CNT2 — NUMBER(10, 0)
- CHILD_MENU_CNT2 — NUMBER(10, 0)) — N COLUMN "ASM_MENU_MST"."MENU_IDX" IS '일련번호 ' COMMENT ON COLUMN "ASM_MENU_MST"."URL" IS '메뉴 url ' COMMENT ON COLUMN "AS…
ASM_MENU_PERM
- IDX — NUMBER(10, 0)
- URL — VARCHAR2(200 CHAR) — 외래 키 → ASM_MENU_MST.MENU_IDX — NOT NULL
- TITLE — VARCHAR2(100 CHAR)
- NOTE — VARCHAR2(512 CHAR)
- ACT — NUMBER(10, 0)
- REGIST_DATE — DATE
- REGIST_ID — VARCHAR2(30 CHAR)
- REGIST_NAME — VARCHAR2(50 CHAR)
- UPDATE_DATE — DATE
- UPDATE_ID — VARCHAR2(30 CHAR)
- UPDATE_NAME — VARCHAR2(50 CHAR)
ASM_MENU_USERS
- USER_ID — VARCHAR2(30 CHAR) — 외래 키 → SMBH_USERS.ID — NOT NULL
- VARCHAR2(20 — CHAR)` — NOT NULL
- DEFAULT_TYPE — VARCHAR2(10 CHAR)
- REGIST_DATE — DATE
- REGIST_ID — VARCHAR2(20 CHAR)
- REGIST_NAME — VARCHAR2(30 CHAR)
- UPDATE_DATE — DATE
- UPDATE_ID — VARCHAR2(20 CHAR)
- UPDATE_NAME — VARCHAR2(30 CHAR)
ASM_OUTBOX_MST
- IDX — NUMBER(10, 0)
- USERID — VARCHAR2(30 CHAR)
- ASSETNUM — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- REQNO — NUMBER(10, 0)
- REGISTDATE — DATE
- TYPE — CHAR(1 CHAR)
ASSE_MST
- IDXASSEMST — NUMBER(10, 0)
- ASSETNUM2 — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- ASSETNUM3 — VARCHAR2(30 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- TYPE1 — VARCHAR2(10 CHAR)
- REFE1 — NUMBER(10, 0)
- INFO1 — VARCHAR2(30 CHAR)
- INFO2 — NUMBER(10, 0)
- INFO3 — VARCHAR2(30 CHAR)
- INFO4 — VARCHAR2(30 CHAR)
- INFO5 — VARCHAR2(50 CHAR)
- INFO6 — VARCHAR2(30 CHAR)
- INFO7 — NUMBER(10, 0)
- INFO8 — VARCHAR2(200 CHAR)
- INFO9 — VARCHAR2(200 CHAR)
- INFO10 — NUMBER(10, 0)
- DATER — DATE
- USERIDR — VARCHAR2(30 CHAR)
- USERNMR — VARCHAR2(50 CHAR)) — N COLUMN "ASSE_MST"."IDXASSEMST" IS '일련번호 ' COMMENT ON COLUMN "ASSE_MST"."ASSETNUM" IS '자산번호 ' COMMENT ON COLUMN "ASSE_…
CODE_MST
- IDXCODEMST — NUMBER(10, 0) — 기본 키 — NOT NULL
- INFO1 — VARCHAR2(250 CHAR)
- INFO2 — VARCHAR2(50)
- INFO3 — VARCHAR2(200 CHAR)
- INFO4 — VARCHAR2(500 CHAR)
- DATER — DATE
- USERIDR — VARCHAR2(30 CHAR)
- USERNMR — VARCHAR2(50 CHAR)
- DATEU — DATE
- USERIDU — VARCHAR2(30 CHAR)
- USERNMU — VARCHAR2(50 CHAR)
- PARCODEMST — NUMBER(10, 0)
- DEPTH — CHAR(1 CHAR)
- TYPE1 — VARCHAR2(20 CHAR)
- ACT — CHAR(1 CHAR)
- INFO5 — VARCHAR2(200 CHAR)
- INFO6 — VARCHAR2(200 CHAR)
FILE_MST
- IDXFILEMST — NUMBER(10, 0) — 외래 키 → SMBH_ATTACHFILE.IDX — NOT NULL
- TYPE1 — VARCHAR2(10 CHAR)
- REFE1 — NUMBER(10, 0)
- FILE1 — VARCHAR2(200 CHAR)
- FILE2 — VARCHAR2(200 CHAR)
- FILE3 — NUMBER(10, 0)
- FILE4 — VARCHAR2(200 CHAR)
- DATER — DATE
- USERIDR — VARCHAR2(30 CHAR)
- USERNMR — VARCHAR2(50 CHAR)
INTERFACE_SCHEDULE
- IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- CONTENTS1 — NVARCHAR2(100)
- TYPE1 — NVARCHAR2(50)
- TYPE2 — NVARCHAR2(10)
- TYPE3 — NVARCHAR2(10)
- ACT — CHAR(1 CHAR)
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
INTERFACE_SCHEDULE_LOG
- IDX — NUMBER(10, 0)
- LINK_IDX — NUMBER(10, 0) — 외래 키 → INTERFACE_SCHEDULE.IDX — NOT NULL
- REGISTDATE — DATE
- RUNDATE — CHAR(19 CHAR)
- MSG — VARCHAR2(4000 CHAR)
QRCO_MST
- IDXQRCOMST — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- INFO1 — VARCHAR2(50 CHAR)
- INFO2 — NUMBER(10, 0)
- DATER — DATE
- USERIDR — VARCHAR2(30 CHAR)
- USERNMR — VARCHAR2(50 CHAR)
- DATEU — DATE
- USERIDU — VARCHAR2(30 CHAR)
- USERNMU — VARCHAR2(50 CHAR)
SMBA_ATTACHFILE
- SN — NUMBER(10, 0)
- SECTION — VARCHAR2(10 CHAR)
- MASTER_SN — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- ATTACH_TYPE — VARCHAR2(300 CHAR)
- ATTACH_NAME — VARCHAR2(300 CHAR)
- ATTACH_SIZE — NUMBER(10, 0)
- ATTACH_DATA — VARCHAR2(300 CHAR)
- UPLOAD_TIME — NUMBER(10, 0)
SMBA_CONFIG
- CONFIG_NO — NUMBER(10, 0)
- CONFIG_KEY — VARCHAR2(50 CHAR)
- CONFIG_VALUE — VARCHAR2(2000 CHAR)
SMBA_DEPRE_HIS
- IDX — NUMBER(10, 0)
- ASSETIDX — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- PRICE1 — NUMBER(19, 4)
- DATE1 — DATE
- DEPREYEARCNT — NUMBER(10, 0)
- DEPREMONTH — VARCHAR2(20 CHAR)
- DEPREVALUE1 — NUMBER(19, 4)
- DEPREVALUE2 — NUMBER(19, 4)
- DEPREVALUE3 — NUMBER(19, 4)
- DEPREVALUE4 — NUMBER(19, 4)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(20 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
SMBA_HISTORY
- SN — NUMBER(10,0)
- FIELDNAME — VARCHAR2(50 CHAR)
- BEFOREDATA — VARCHAR2(250 CHAR)
- AFTERDATA — VARCHAR2(250 CHAR)
- MASTERSN — NUMBER(10,0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- CHANGEDATE — NUMBER(10,0)
- UPDATEID — VARCHAR2(20 CHAR)
- UPDATENAME — VARCHAR2(20 CHAR)
- UPDATEDATE — DATE
SMBA_ITEMS
- IDX — NUMBER(10, 0)
- SECTION — CHAR(3 CHAR)
- CONTENTS1 — VARCHAR2(200 CHAR)
- CONTENTS2 — VARCHAR2(50 CHAR)
- ACT — CHAR(1 CHAR)
- SELECTION — CHAR(1 CHAR)
- ORDERS — NUMBER(10, 0)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- CONTENTS3 — VARCHAR2(10 CHAR)
SMBA_MANAGE_HISTORY
- IDX — NUMBER(10, 0)
- ASSETIDX — NUMBER — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- CONTENTS1 — VARCHAR2(50 CHAR)
- CONTENTS2 — VARCHAR2(50 CHAR)
- USERID — VARCHAR2(20 CHAR)
- USERNAME — VARCHAR2(20 CHAR)
- DATE1 — DATE
SMBA_MASTER
- ASSETNUM — VARCHAR2(50 CHAR) — 기본 키 — NOT NULL
- IDX — NUMBER(10, 0)
- ASSETTYPE — NUMBER(10, 0) — 외래 키 → SMBH_LAYERS.IDX — NOT NULL
- ASSETTYPE1 — NUMBER(10, 0) — 외래 키 → SMBH_LAYERS.IDX — NOT NULL
- ASSETTYPE2 — NUMBER(10, 0) — 외래 키 → SMBH_LAYERS.IDX — NOT NULL
- ASSETTYPE3 — NUMBER(10, 0) — 외래 키 → SMBH_LAYERS.IDX — NOT NULL
- ASSETTYPE4 — NUMBER(10, 0)
- ASSETNAME — VARCHAR2(50 CHAR)
- QRCODE — CHAR(15 CHAR)
- ASSETINFO1 — VARCHAR2(250 CHAR)
- ASSETINFO2 — NUMBER(10, 0)
- ASSETINFO3 — NUMBER(10, 0)
- ASSETINFO4 — VARCHAR2(50 CHAR)
- ASSETINFO5 — VARCHAR2(250 CHAR)
- ASSETINFO6 — VARCHAR2(50 CHAR)
- ASSETINFO7 — VARCHAR2(50 CHAR)
- ASSETINFO8 — NUMBER(10, 0)
- ASSETINFO9 — VARCHAR2(255 CHAR)
- ASSETINFO10 — VARCHAR2(50 CHAR)
- STATUS1 — CHAR(2 CHAR)
- STATUS2 — CHAR(2 CHAR)
- STATUS3 — CHAR(2 CHAR)
- STATUS4 — CHAR(2 CHAR)
- USERID — VARCHAR2(30 CHAR)
- USERNAME — VARCHAR2(50 CHAR)
- USERDEPART — NUMBER(10, 0)
- USERLOCATION — NUMBER(10, 0)
- USERLOCATION1 — NUMBER(10, 0)
- USERLOCATION2 — NUMBER(10, 0)
- USERLOCATION3 — NUMBER(10, 0)
- USERLOCATION4 — NUMBER(10, 0)
- USERLOCATION5 — NUMBER(10, 0)
- USERLOCATIONDETAIL — VARCHAR2(255 CHAR)
- DATE1 — DATE
- DATE2 — DATE
- DATE3 — DATE
- DATE4 — DATE
- DATE5 — DATE
- DATE6 — DATE
- SURVEYDATE — DATE
- COMPANY1 — NUMBER(10, 0)
- COMPANY2 — NUMBER(10, 0)
- COMPANY3 — NUMBER(10, 0)
- COMPANY4 — NUMBER(10, 0)
- COMPANY5 — NUMBER(10, 0)
- COMPANY6 — NUMBER(10, 0)
- COMPANY1NAME — VARCHAR2(50 CHAR)
- COMPANY3NAME — VARCHAR2(50 CHAR)
- COMPANY5NAME — VARCHAR2(50 CHAR)
- TYPE1 — CHAR(3 CHAR)
- TYPE2 — CHAR(3 CHAR)
- PRICE1 — NUMBER(19, 4)
- PRICE2 — NUMBER(19, 4)
- COUNT1 — NUMBER(10, 0)
- NOTE — VARCHAR2(4000 CHAR)
- NOTE2 — VARCHAR2(400 CHAR)
- NOTE3 — VARCHAR2(400 CHAR)
- ACT — CHAR(1 CHAR)
- NUMBERIDX — NUMBER(10, 0)
- RENTREQID — VARCHAR2(20 CHAR)
- … +45
SMBA_MASTER_DB
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- SERVICE — VARCHAR2(20)
- COMP — VARCHAR2(200)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- USERID04 — VARCHAR2(30)
- DLNK01 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK02 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK03 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK04 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK05 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK06 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK07 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK08 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DLNK09 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- DSEL01 — VARCHAR2(20)
- DSEL02 — VARCHAR2(20)
- DSEL03 — VARCHAR2(20)
- DSEL04 — VARCHAR2(20)
- DSEL05 — VARCHAR2(20)
- DSEL06 — VARCHAR2(20)
- DSEL07 — VARCHAR2(20)
- DSEL08 — VARCHAR2(20)
- DTXT01 — VARCHAR2(50)
- DTXT02 — VARCHAR2(50)
- DTXT03 — VARCHAR2(50)
- DTXT04 — VARCHAR2(50)
- DTXT05 — VARCHAR2(50)
- DTXT06 — VARCHAR2(50)
- DTXT07 — VARCHAR2(50)
- DTXT08 — VARCHAR2(50)
- DTXT09 — VARCHAR2(50)
- DTXT10 — VARCHAR2(50)
- DTXT11 — VARCHAR2(50)
- DTXT12 — VARCHAR2(50)
- ETC01 — VARCHAR2(200)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- DSEL09 — VARCHAR2(20)
- DLNK10 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SERVICE2 — VARCHAR2(20)
- SERVICE2DET — VARCHAR2(50)
- DLNK11 — NUMBER) — N COLUMN "SMBA_MASTER_DB"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_DB"."ASSETNUM" IS '자산번호' COMMENT ON COLUMN "SM…
SMBA_MASTER_HIS
- IDX — NUMBER(10, 0)
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- REGISTDATE — DATE
- ID — VARCHAR2(30 CHAR)
- NAME — VARCHAR2(50 CHAR)
- IP — VARCHAR2(50 CHAR)
- TITLE — VARCHAR2(100 CHAR)
- TITLE_CODE — VARCHAR2(10 CHAR)
SMBA_MASTER_NW
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- SERVICE — VARCHAR2(20)
- COMP — VARCHAR2(200)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- USERID04 — VARCHAR2(30)
- RACK01 — NUMBER
- RACK02 — NUMBER
- RACK03 — VARCHAR2(50)
- NTXT02 — VARCHAR2(100)
- NTXT03 — VARCHAR2(100)
- NTXT04 — VARCHAR2(50)
- NTXT05 — VARCHAR2(50)
- NTXT06 — VARCHAR2(50)
- NTXT07 — VARCHAR2(50)
- NTXT08 — VARCHAR2(50)
- NTXT09 — VARCHAR2(50)
- NTXT10 — VARCHAR2(50)
- NTXT11 — VARCHAR2(50)
- NTXT12 — VARCHAR2(50)
- NTXT13 — VARCHAR2(50)
- NTXT14 — VARCHAR2(50)
- NTXT15 — VARCHAR2(50)
- NTXT16 — VARCHAR2(50)
- NTXT17 — VARCHAR2(50)
- ETC01 — VARCHAR2(200)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- NTXT18 — NUMBER
- NTXT19 — VARCHAR2(50)
- SERVICE2 — VARCHAR2(20)
- SERVICE2DET — VARCHAR2(50)
- NTXT20 — VARCHAR2(80)
- NTXT21 — VARCHAR2(50)
- NTXT22 — VARCHAR2(50)
- NTXT23 — VARCHAR2(50)
- NTXT24 — VARCHAR2(50)
- NTXT25 — VARCHAR2(50)
- NTXT26 — VARCHAR2(50)) — N COLUMN "SMBA_MASTER_NW"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_NW"."ASSETNUM" IS '자산번호' COMMENT ON COLUMN "SM…
SMBA_MASTER_SVR
- IDX — NUMBER — 기본 키 — NOT NULL
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- COMP — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SERVICE — VARCHAR2(20)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- USERID04 — VARCHAR2(30)
- RACK01 — NUMBER
- RACK02 — NUMBER
- RACK03 — VARCHAR2(50)
- SSEL01 — VARCHAR2(30)
- SSEL02 — VARCHAR2(30)
- SSEL03 — VARCHAR2(30)
- SSEL04 — VARCHAR2(20)
- SSEL05 — VARCHAR2(20)
- SSEL06 — VARCHAR2(20)
- SSEL07 — VARCHAR2(20)
- STXT01 — VARCHAR2(100)
- STXT02 — VARCHAR2(50)
- STXT03 — VARCHAR2(50)
- STXT04 — VARCHAR2(50)
- STXT05 — VARCHAR2(50)
- STXT06 — VARCHAR2(50)
- STXT07 — VARCHAR2(50)
- STXT08 — VARCHAR2(50)
- STXT09 — VARCHAR2(50)
- STXT10 — VARCHAR2(50)
- STXT11 — VARCHAR2(50)
- STXT12 — VARCHAR2(50)
- STXT13 — VARCHAR2(50)
- STXT14 — VARCHAR2(50)
- ETC01 — VARCHAR2(200)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- STXT15 — VARCHAR2(50)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- STXT16 — VARCHAR2(50)
- SERVICE2 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SERVICE2DET — VARCHAR2(50)
- STXT17 — VARCHAR2(50)
- STXT18 — VARCHAR2(50)
- SLNK03 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SLNK04 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SLNK05 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
SMBA_MASTER_SW
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- SERVICE2 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- COMP — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SERVICE — VARCHAR2(20)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- USERID04 — VARCHAR2(30)
- OTXT01 — VARCHAR2(50)
- OTXT02 — VARCHAR2(50)
- OTXT03 — VARCHAR2(50)
- OTXT04 — VARCHAR2(50)
- OTXT05 — VARCHAR2(50)
- OTXT06 — VARCHAR2(50)
- OSEL01 — VARCHAR2(20)
- OSEL02 — VARCHAR2(20)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- SERVICE2DET — VARCHAR2(50)) — N COLUMN "SMBA_MASTER_SW"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_SW"."ASSETNUM" IS '자산번호' COMMENT ON COLUMN "SM…
SMBA_MASTER_SWDET
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- ODTXT01 — VARCHAR2(100)
- ODTXT02 — VARCHAR2(200)
- ODTXT03 — VARCHAR2(100)
- ODTXT04 — VARCHAR2(50)
- ODTXT05 — VARCHAR2(50)
- ODTXT06 — VARCHAR2(200)
SMBA_MASTER_UF
- IDX — NUMBER(10, 0)
- LINKIDX — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- CONTENTS1 — NVARCHAR2(250)
- CONTENTS2 — NVARCHAR2(250)
- CONTENTS3 — NVARCHAR2(250)
- CONTENTS4 — NVARCHAR2(250)
- CONTENTS5 — NVARCHAR2(250)
- CONTENTS6 — NVARCHAR2(250)
- CONTENTS7 — NVARCHAR2(250)
- CONTENTS8 — NVARCHAR2(250)
- CONTENTS9 — NVARCHAR2(250)
- CONTENTS10 — NVARCHAR2(250)
- CONTENTS11 — NVARCHAR2(250)
- CONTENTS12 — NVARCHAR2(250)
- CONTENTS13 — NVARCHAR2(250)
- CONTENTS14 — NVARCHAR2(250)
- CONTENTS15 — NVARCHAR2(250)
- CONTENTS16 — NVARCHAR2(250)
- CONTENTS17 — NVARCHAR2(250)
- CONTENTS18 — NVARCHAR2(250)
- CONTENTS19 — NVARCHAR2(250)
- CONTENTS20 — NVARCHAR2(250)
- CONTENTS1IDX — NUMBER(10, 0)
- CONTENTS2IDX — NUMBER(10, 0)
- CONTENTS3IDX — NUMBER(10, 0)
- CONTENTS4IDX — NUMBER(10, 0)
- CONTENTS5IDX — NUMBER(10, 0)
- CONTENTS6IDX — NUMBER(10, 0)
- CONTENTS7IDX — NUMBER(10, 0)
- CONTENTS8IDX — NUMBER(10, 0)
- CONTENTS9IDX — NUMBER(10, 0)
- CONTENTS10IDX — NUMBER(10, 0)
- CONTENTS11IDX — NUMBER(10, 0)
- CONTENTS12IDX — NUMBER(10, 0)
- CONTENTS13IDX — NUMBER(10, 0)
- CONTENTS14IDX — NUMBER(10, 0)
- CONTENTS15IDX — NUMBER(10, 0)
- CONTENTS16IDX — NUMBER(10, 0)
- CONTENTS17IDX — NUMBER(10, 0)
- CONTENTS18IDX — NUMBER(10, 0)
- CONTENTS19IDX — NUMBER(10, 0)
- CONTENTS20IDX — NUMBER(10, 0)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(20 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- IFACTION — VARCHAR2(50 CHAR)
SMBA_MASTER_VAN
- VTXT01 — VARCHAR2(10) — 기본 키 — NOT NULL
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- SERVICE — VARCHAR2(20)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- SERVICE2 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- USERID04 — VARCHAR2(30)
- COMP — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- VTXT02 — VARCHAR2(50)
- VTXT03 — VARCHAR2(50)
- VTXT04 — VARCHAR2(50)
- VTXT05 — VARCHAR2(50)
- VTXT06 — VARCHAR2(50)
- VTXT07 — VARCHAR2(50)
- VTXT08 — VARCHAR2(60)
- VTXT09 — VARCHAR2(200)
- VTXT10 — VARCHAR2(200)
- VTXT11 — VARCHAR2(50)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- VTXT12 — VARCHAR2(10)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- VTXT13 — VARCHAR2(100)
- VTXT14 — VARCHAR2(100)
- VTXT15 — VARCHAR2(50)
- VTXT16 — VARCHAR2(100)
- VTXT17 — VARCHAR2(50)
- SERVICE2DET — VARCHAR2(50)) — N COLUMN "SMBA_MASTER_VAN"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_VAN"."ASSETNUM" IS '자산번호' COMMENT ON COLUMN "…
SMBA_MASTER_WAS
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- WLNK01 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK02 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK03 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK04 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK05 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK06 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK07 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- IDXCODEMST10 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- IDXCODEMST9 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- WLNK08 — NUMBER(10, 0) — 외래 키 → CODE_MST.IDXCODEMST — NOT NULL
- SERVICE — VARCHAR2(20)
- MATYPE — VARCHAR2(10)
- USERID01 — VARCHAR2(30)
- USERID02 — VARCHAR2(30)
- USERID03 — VARCHAR2(30)
- USERID04 — VARCHAR2(30)
- WSEL01 — VARCHAR2(20)
- WTXT01 — VARCHAR2(50)
- WTXT02 — VARCHAR2(50)
- ETC01 — VARCHAR2(200)
- USERETC01 — VARCHAR2(200)
- USERETC02 — VARCHAR2(200)
- USERETC03 — VARCHAR2(200)
- USERETC04 — VARCHAR2(200)
- USERID05 — VARCHAR2(30)
- USERETC05 — VARCHAR2(200)
- WSEL02 — VARCHAR2(20)
- WSEL03 — VARCHAR2(20)
- SERVICE2DET — VARCHAR2(50)) — N COLUMN "SMBA_MASTER_WAS"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_WAS"."ASSETNUM" IS '자산번호' COMMENT ON COLUMN "…
SMBA_MASTER_WASDET
- IDX — NUMBER
- ASSETNUM2 — VARCHAR2(50 CHAR) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- WDTXT01 — VARCHAR2(50)
- WDTXT02 — VARCHAR2(50)
- WDTXT03 — VARCHAR2(500)
- WDTXT04 — VARCHAR2(500)
- WDTXT05 — VARCHAR2(50)
- WDTXT06 — VARCHAR2(50)
- WDTXT07 — VARCHAR2(50)
- WDLNK01 — VARCHAR2(20)
- WDLNK02 — VARCHAR2(20)) — N COLUMN "SMBA_MASTER_WASDET"."IDX" IS '일련번호' COMMENT ON COLUMN "SMBA_MASTER_WASDET"."ASSETNUM" IS '자산번호' COMMENT ON CO…
SMBA_RENT_HISTORY
- IDX — NUMBER(10, 0)
- ASSETIDX — NUMBER(10, 0) — 외래 키 → SMBA_MASTER.ASSETNUM — NOT NULL
- CONTENTS1 — VARCHAR2(20 CHAR)
- USERID — VARCHAR2(20 CHAR)
- USERNAME — VARCHAR2(30 CHAR)
- UPDATEUSERID — VARCHAR2(20 CHAR)
- UPDATEUSERNAME — VARCHAR2(30 CHAR)
- DATE1 — DATE
- DATE2 — DATE
- DATE3 — DATE
- IDXTASKMST — NUMBER(10, 0)
SMBA_SURVEY
- IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- CONTENTS — VARCHAR2(100 CHAR)
- STARTDATE — DATE
- ENDDATE — DATE
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- ASSETTYPE — VARCHAR2(500 CHAR)
- ASSETLOCATION — VARCHAR2(500 CHAR)
SMBA_SURVEY_TARGET
- IDX — NUMBER(10, 0)
- WORKIDX — NUMBER(10, 0) — 외래 키 → SMBA_SURVEY.IDX — NOT NULL
- IDXSMBAMASTER — NUMBER(10, 0) — 외래 키 → SMBA_MASTER_SVR.IDX — NOT NULL
- USERCHECK — CHAR(1 CHAR)
- VIEWCHECK — CHAR(1 CHAR)
- STATUS — CHAR(1 CHAR)
- SURVEY_MODE — CHAR(1 CHAR)
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- USERCHECKDATE — DATE
- USERCHECKID — VARCHAR2(30 CHAR)
- USERCHECKNAME — VARCHAR2(50 CHAR)
- UPDATEDATEVALUE — VARCHAR2(10 CHAR)
SMBH_ATTACHFILE
- IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- SECTION — VARCHAR2(2 CHAR)
- LINKIDX — NUMBER(10, 0) — 외래 키 → SMBH_BOARD.IDX — NOT NULL
- ATTACHTYPE — VARCHAR2(250 CHAR)
- ATTACHNAME — VARCHAR2(250 CHAR)
- ATTACHDATA — VARCHAR2(250 CHAR)
- ATTACHSIZE — NUMBER(10, 0)
- UPDATEDATE — DATE
- UPDATENAME — VARCHAR2(50 CHAR)
- UPDATEID — VARCHAR2(30 CHAR)
SMBH_BOARD
- IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- SECTION — CHAR(3 CHAR)
- TITLE — VARCHAR2(250 CHAR)
- CONTENTS — VARCHAR2(4000 CHAR)
- ACT — CHAR(1 CHAR)
- AUTHVIEW — CHAR(1 CHAR)
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- TYPE — VARCHAR2(60)
- PROJECTTYPE — NUMBER(10, 0)
- OPTION1 — CHAR(1 CHAR)
- OPTION2 — VARCHAR2(50 CHAR)
- DATE1 — DATE
- DATE2 — DATE
- INFO1 — CHAR(1 CHAR)
- SECTION2 — NUMBER(10, 0)
SMBH_ITEMS
- IDX — NUMBER — 기본 키 — NOT NULL
- SECTION — CHAR(3 CHAR)
- CONTENTS1 — VARCHAR2(200 CHAR)
- CONTENTS2 — VARCHAR2(250 CHAR)
- ACT — CHAR(1 CHAR)
- SELECTION — CHAR(1 CHAR)
- ORDERS — NUMBER(10, 0)
- TYPE1 — NUMBER(10, 0)
- TYPE2 — NUMBER(10, 0)
- TYPE3 — NUMBER(10, 0)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- INFO01 — VARCHAR2(200 CHAR)
- INFO02 — VARCHAR2(200 CHAR)
- INFO03 — VARCHAR2(200 CHAR)
- INFO04 — VARCHAR2(200 CHAR)
- INFO05 — VARCHAR2(200 CHAR)
SMBH_LAYERS
- IDX — NUMBER(10, 0) — 기본 키 — NOT NULL
- SECTION — CHAR(3 CHAR)
- CONTENTS1 — VARCHAR2(100 CHAR)
- CONTENTS2 — VARCHAR2(2000 CHAR)
- ACT — CHAR(1 CHAR)
- DEPTH — NUMBER(10, 0)
- PARENTIDX — NUMBER(10, 0)
- ORDERS — NUMBER(10, 0)
- CODE — VARCHAR2(30 CHAR)
- PARENTCODE — VARCHAR2(30 CHAR)
- TYPE1 — NUMBER(10, 0)
- TYPE2 — NUMBER(10, 0)
- TYPE3 — NUMBER(10, 0)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- CONTENTS3 — VARCHAR2(50 CHAR)
- CONTENTS4 — VARCHAR2(250 CHAR)
- CONTENTS5 — VARCHAR2(250 CHAR)
- CONTENTS6 — VARCHAR2(250 CHAR)
- TYPE4 — VARCHAR2(10 CHAR)
- IF_CHK — CHAR(1)
SMBH_LIST_CONFIG
- IDX — NUMBER(10, 0)
- ID — VARCHAR2(50 CHAR)
- TITLE — VARCHAR2(50 CHAR)
- FIELDIDX — VARCHAR2(30 CHAR)
- FIELD — VARCHAR2(50 CHAR)
- WIDTH — VARCHAR2(10 CHAR)
- SHOWS — VARCHAR2(10 CHAR)
- ALIGN — VARCHAR2(10 CHAR)
- TYPE1 — VARCHAR2(10 CHAR)
- ORDERS — NUMBER(10, 0)
- TYPE2 — VARCHAR2(10 CHAR)
- TYPE3 — VARCHAR2(10 CHAR)
- TYPE4 — VARCHAR2(10 CHAR)
- TYPE5 — VARCHAR2(10 CHAR)
SMBH_LOCATION_LINK
- IDX — NUMBER(10, 0)
- LINKIDX — NUMBER(10, 0) — 외래 키 → SMBH_LAYERS.IDX — NOT NULL
- ID — VARCHAR2(30 CHAR)
- SECTION — CHAR(3 CHAR)
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
SMBH_USERS
- ID — VARCHAR2(30 CHAR) — 기본 키 — NOT NULL
- IDX — NUMBER(10, 0)
- LOGONID — VARCHAR2(20 CHAR)
- NAME — VARCHAR2(50 CHAR)
- ENAME — VARCHAR2(50 CHAR)
- PASSWORD — VARCHAR2(100 CHAR)
- PERMISSION — VARCHAR2(100)
- DEPARTIDX — NUMBER(10, 0)
- DEPARTCODE — VARCHAR2(30 CHAR)
- TITLE — VARCHAR2(50 CHAR)
- TEL — VARCHAR2(50 CHAR)
- MOBILE — VARCHAR2(50 CHAR)
- EMAIL — VARCHAR2(50 CHAR)
- ACT — CHAR(1 CHAR)
- REGISTDATE — DATE
- REGISTID — VARCHAR2(30 CHAR)
- REGISTNAME — VARCHAR2(50 CHAR)
- UPDATEDATE — DATE
- UPDATEID — VARCHAR2(30 CHAR)
- UPDATENAME — VARCHAR2(50 CHAR)
- OPTION1 — CHAR(2 CHAR)
- PARTNERSCODE — VARCHAR2(20 CHAR)
- OPTION2 — CHAR(2 CHAR)
- DONG — VARCHAR2(50 CHAR)
- ROOM — VARCHAR2(50 CHAR)
- REQTYPE1 — VARCHAR2(10 CHAR)
- RANK — VARCHAR2(100 CHAR)
- STF_TY_NM — VARCHAR2(15 CHAR)
- BLNG_INST_CD — VARCHAR2(100 CHAR)
- BLNG_INST_NM — VARCHAR2(100 CHAR)
- IF_CHK — CHAR(1 CHAR)
- OPTION3 — CHAR(2 CHAR)
- USER_NO — NVARCHAR2(13)
- FAIL_COUNT — NUMBER(10, 0)
- PASSWORD_CHG_DATE — DATE
- LOGIN_IP — VARCHAR2(30 CHAR)
- PASSWORD_CHG — CHAR(1 CHAR)
- WIDTH — VARCHAR2(10 CHAR)
- HEIGHT — VARCHAR2(10 CHAR)
- DATE01 — VARCHAR2(20 CHAR)
- DATE02 — VARCHAR2(20 CHAR)
- DET_PERMISSION — VARCHAR2(20)
SMB_USER_LOG
- IDX — NUMBER(10, 0)
- ID2 — VARCHAR2(30 CHAR) — 외래 키 → SMBH_USERS.ID — NOT NULL
- NAME — VARCHAR2(50 CHAR)
- LOG_DATE — CHAR(19 CHAR)
- IP — VARCHAR2(50 CHAR)
- TITLE — VARCHAR2(100 CHAR)
- TITLE_CODE — VARCHAR2(10 CHAR)
SPCN_VAN_DASH
- IAGENCY_CODE — VARCHAR2(10)
- IAGENCY_MEMBNAM — VARCHAR2(100)
- ZIPNO1 — VARCHAR2(6)
- PRO_GRP_NAME — VARCHAR2(20)
- TRADE_CNT — NUMBER(18, 0)
- ENT_DATE — VARCHAR2(14)
SPCN_VAN_DASH_M
- WORK_DATE — VARCHAR2(8)
- CRNTNO — VARCHAR2(10)
- IAGENCY_CODE — VARCHAR2(10)
- IAGENCY_MEMBNAM — VARCHAR2(100)
- ZIPNO1 — VARCHAR2(6)
- PRO_GRP_NAME — VARCHAR2(20)
- TRADE_CNT — NUMBER(18, 0)
- ENT_DATE — VARCHAR2(14)
TASK_MST
- IDXTASKMST — NUMBER(10, 0)
- TYPE1 — VARCHAR2(10 CHAR)
- STAT — VARCHAR2(10 CHAR)
- INFO1 — VARCHAR2(200 CHAR)
- INFO2 — VARCHAR2(200 CHAR)
- INFO3 — NUMBER(10, 0)
- DATER — DATE
- USERIDR — VARCHAR2(30 CHAR)
- USERNMR — VARCHAR2(50 CHAR)
- DATEU — DATE
- USERIDU — VARCHAR2(30 CHAR)
- USERNMU — VARCHAR2(50 CHAR)