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) — 소속