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)