adm

테이블 (10)

Untitled (PAGE)

  • Key (PAGEID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (PAGENAME) — VARCHAR2(100) — NOT NULL
  • Field (URL) — VARCHAR2(500)
  • Field (USEYN) — VARCHAR2(1) — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(20) — NOT NULL
  • Field (CHGDATE) — DATE
  • Field (CHGID) — VARCHAR2(20)
  • Field (REMARK) — VARCHAR2(1000)

Untitled (MENUPAGE)

  • Key (MENUID) — VARCHAR2(50) — 외래 키 → 메뉴 그룹.Key — NOT NULL
  • Key (PAGEID) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PAGEORDER) — NUMBER(5, 0) — NOT NULL
  • Field (USEYN) — VARCHAR2(1) — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(20) — NOT NULL
  • Field (CHGDATE) — DATE
  • Field (CHGID) — VARCHAR2(20)

Untitled (ROLE)

  • Key (ROLDID) — VARCHAR2(20) — 기본 키 — NOT NULL
  • Key (ROLETYPE) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (ROLENAME) — VARCHAR2(50) — NOT NULL
  • Field (USEYN) — VARCHAR2(1) — NOT NULL

Untitled (F_USER)

  • Key (USERID) — VARCHAR2(20) — 기본 키 — NOT NULL
  • Key (COMPANYID) — VARCHAR2(20) — 기본 키 — NOT NULL

Untitled (PAGEROLE)

  • Key (ROLDID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLETYPE) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (PAGEID) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(20) — NOT NULL

Untitled (USERROLE_HIST)

  • Key (HIST_NO) — NUMBER(12, 0) — 기본 키 — NOT NULL
  • Field (SAVE_DTM) — DATE — NOT NULL
  • Key (USERID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (COMPANYID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLDID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLETYPE) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(50) — NOT NULL
  • Field (CHGDATE) — DATE
  • Field (CHGID) — VARCHAR2(50)

Untitled (USERROLE)

  • Key (USERID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (COMPANYID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLDID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLETYPE) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(50) — NOT NULL
  • Field (CHGDATE) — DATE
  • Field (CHGID) — VARCHAR2(50)

Untitled (PAGEROLE_HIST)

  • Key (HIST_NO) — NUMBER(12, 0) — 기본 키 — NOT NULL
  • Field (SAVE_DTM) — DATE — NOT NULL
  • Field (HISTTYPE) — VARCHAR2(3) — NOT NULL
  • Key (ROLDID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ROLETYPE) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Key (PAGEID) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SYSTEM_LOG)

  • Key (LOG_NO) — NUMBER(15, 0) — 기본 키 — NOT NULL
  • Field (SAVE_DTM) — DATE — NOT NULL
  • Key (USERID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (COMPANYID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (PAGEID) — VARCHAR2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (QUERYID) — VARCHAR2(50) — NOT NULL
  • Field (REMARK) — VARCHAR2(2000)

메뉴 그룹 (MENU)

  • Key (MENUID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key (PMENUID) — VARCHAR2(50) — 외래 키 → 메뉴 그룹.Key
  • Field (MENUNAME) — VARCHAR2(100) — NOT NULL
  • Field (MENUORDER) — NUMBER(5, 0) — NOT NULL
  • Field (MENULEVEL) — NUMBER(5, 0) — NOT NULL
  • Field2 (USEYN) — VARCHAR2(1) — NOT NULL
  • Field (REGDATE) — DATE — NOT NULL
  • Field (REGID) — VARCHAR2(20) — NOT NULL
  • Field (CHGDATE) — DATE
  • Field (REMARK) — VARCHAR2(1000)