DBMS

Tables (4)

Audit_Log (변경이력)

  • Key (PK) — NUMBER — Primary key — NOT NULL
  • Field (Field1) — VARCHAR2(20)
  • Field (Field2) — CLOB(JSON)
  • Field (Field3) — CLOB(JSON)
  • Field (Field4) — TIMESTAMP
  • Key (FK1) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
  • Key (FK2) — NUMBER — Foreign key → Business_Data.Key — NOT NULL

Business_Data (실무데이터)

  • Key (PK) — NUMBER — Primary key — NOT NULL
  • Field (Field1) — VARCHAR2(30)
  • Field (Field2) — VARCHAR2(100)
  • Field (Field3) — VARCHAR2(100)
  • Key (FK) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL

Role (권한 그룹)

  • Key — VARCHAR2(10) — Primary key — NOT NULL
  • Field (Field1) — VARCHAR2(20)
  • Field (Field2) — NUMBER(1)

User (사용자)

  • Key (PK) — VARCHAR2(20) — Primary key — NOT NULL
  • Field (Field1) — VARCHAR2(256)
  • Field (Field2) — VARCHAR2(50)
  • Key (FK) — VARCHAR2(10) — Foreign key → Role.Key — NOT NULL