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