유온

테이블 (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)