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)