USER_ROLE

Tables (3)

USER_INFO

  • USER_ID (PK) — VARCHAR2(50 CHAR) — Primary key — NOT NULL
  • USER_NM (Field) — VARCHAR2(100 CHAR) — NOT NULL
  • DEPT_CD (Field2) — VARCHAR2(50 CHAR)
  • USE_YN (Field3) — CHAR(1 CHAR) — NOT NULL
  • REG_DT (Field4) — TIMESTAMP(6) — NOT NULL
  • REG_USER (Field5) — VARCHAR2(50 CHAR) — NOT NULL
  • UPD_DT (Field6) — TIMESTAMP(6)
  • UPD_USER (Field7) — VARCHAR2(50 CHAR)
  • POSITION_CD (Field8) — VARCHAR2(50 CHAR)
  • role_seq (FK) — BIGINT — Foreign key → USER_ROLE.role_seq — NOT NULL

USER_ROLE (유저_권한)

  • role_seq (PK) — BIGINT — Primary key — NOT NULL
  • role_name (Field) — VARCHAR(50)
  • upd_dt (Field2) — TIMESTAMP(6)
  • reg_dt (Field3) — TIMESTAMP(6)
  • parent_role_seq (Field4) — BIGINT

USER_ROLE_CHANGE_HIST (Untitled)

  • hist_seq (PK) — BIGINT — Primary key — NOT NULL
  • USER_ID (FK) — VARCHAR2(50 CHAR) — Foreign key → USER_INFO.USER_ID — NOT NULL
  • REG_DT (Field) — TIMESTAMP(6)
  • UPD_DT (Field2) — TIMESTAMP(6)
  • ORIGIN_ROLE_SEQ (FK2) — BIGINT — Foreign key → USER_ROLE.role_seq — NOT NULL
  • REQEUST_ROLE_SEQ (FK3) — BIGINT — Foreign key → USER_ROLE.role_seq — NOT NULL
  • STATUS (Field3) — ENUM(REQ, APPROVAL, REJECT)