tag
Tables (6)
DEPARTMENTS
- DEPT_CODE — VARCHAR2(10) — Primary key — NOT NULL
- DEPT_NAME — VARCHAR2(100) — NOT NULL — 부서명
SCREEN_MASTER
- SCREEN_ID — VARCHAR2(10) — Primary key — NOT NULL
- SYSTEM_CODE — VARCHAR2(10) — NOT NULL — 시스템
- SCREEN_NAME — VARCHAR2(200) — NOT NULL — 화면명
- SCREEN_URL — VARCHAR2(500) — 화면
SCREEN_PERMISSION
- PERM_ID — NUMBER — Primary key — NOT NULL
- DEPT_CODE (DEPT_CODE2) — VARCHAR2(10) — Foreign key → DEPARTMENTS.DEPT_CODE — NOT NULL
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- SCREEN_ID — VARCHAR2(10) — Foreign key → SCREEN_MASTER.SCREEN_ID — NOT NULL
TAG_MAPPING
- MAPPING_ID — NUMBER — Primary key — NOT NULL
- TAG_ID — NUMBER — Foreign key → TAG_MASTER.TAG_ID — NOT NULL
- DEPT_CODE (DEPT_CODE2) — VARCHAR2(10) — Foreign key → DEPARTMENTS.DEPT_CODE — NOT NULL
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- SCREEN_ID — VARCHAR2(10) — Foreign key → SCREEN_MASTER.SCREEN_ID — NOT NULL
- USER_ID (USER_ID2) — VARCHAR2(20) — Foreign key → TAG_MASTER.USER_ID — NOT NULL
- TAG_TYPE — VARCHAR2(10) — NOT NULL — 태그
- REG_ID — VARCHAR2(20) — 등록자
- REG_DT — DATE — 등록일시
TAG_MASTER
- TAG_ID — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(20) — Foreign key → USERS.USER_ID — NOT NULL
- TAG_NAME — VARCHAR2(100) — NOT NULL — 태그명
- REG_DT — DATE — 등록일시
- MODI_ID — VARCHAR2(20) — 수정자
- MODI_DT — DATE — 수정일시
USERS
- USER_ID — VARCHAR2(20) — Primary key — NOT NULL
- USER_NAME — VARCHAR2(50) — NOT NULL — 사용자명
- DEPT_CODE — VARCHAR2(10) — 소속