LS_Risk
Tables (10)
Dicipline (공정설명)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Description (Field) — varchar(200)
- Remark (Field2) — varchar(200)
Issue (이슈)
- Issue_Cd (Key) — varchar(50) — Primary key — NOT NULL
- WBS_Map_Cd (FK) — varchar(50)
- RBS_Map_Cd (Field3) — varchar(50)
- Discipline_Cd (Field4) — varchar(50)
- Title (Field) — varchar(100)
- Origin (Field2) — varchar(200
- Description (Field5) — text
- Influence (Field6) — varchar(200)
- Amount (Field7) — bigint
- ExpectationDt (Field8) — varchar(50)
- PMProcess_Cd (Field9) — varchar(50)
- WBS_Cd (Field10) — varchar(50)
- CBS_Cd (Field11) — varchar(50)
- Status (Field12) — varchar(50)
- Version (Field13) — double
- RegDt (Field14) — datetime
- UpdDt (Field15) — datetime
PMProcess (PM Process)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Name (Field) — varchar(200)
RBS_Map (Risk 종류)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Name (Field2) — varchar(200)
- Level (Field3) — int
- PCode (Field4) — varchar(50)
- Description (Field5) — varchar(200)
- Remark (Field6) — varchar(200)
- Bigo (Field7) — varchar(200)
Response_Strategy (완화 전략)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Name (Field) — varchar(100)
- Description (Field2) — varchar(200)
- Division (Field3) — varchar(50)
Responsible (Risk 담당자)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Name (Field) — varchar(100)
- Remark (Field2) — varchar(200)
- Division (Field3) — varchar(50)
Risk (리스크)
- Risk_Cd (Key) — varchar(50) — Primary key — NOT NULL
- WBS_Map_Code (Key6) — varchar(50) — Foreign key → WBS_Map.Code
- RBS_Map_Cd (Key5) — varchar(50) — Foreign key → RBS_Map.Code — NOT NULL
- Discipline_Cd (Key2) — varchar(50) — Foreign key → Dicipline.Code — NOT NULL
- PMProcess_Cd (Key3) — varchar(50) — Foreign key → PMProcess.Code — NOT NULL
- Status (Key4) — varchar(50) — Foreign key → Status.Code — NOT NULL
- Issue_Cd (Key7) — varchar(50) — Foreign key → Issue.Issue_Cd — NOT NULL
- Title (Field) — varchar(100)
- Origin (Field2) — varchar(200)
- Description (Field5) — text
- Influence (Field6) — varchar(200)
- Amount (Field7) — bigint
- ExpectationDt (Field8) — varchar(50)
- WBS_Cd (Field10) — varchar(50)
- CBS_Cd (Field11) — varchar(50)
- Version (Field13) — double
- RegDt (Field14) — datetime
- UpdDt (Field15) — datetime
Risk_Evaluation (리스크 평가)
- seq (Key) — bigint — Primary key — NOT NULL
- Risk_Cd (Key2) — varchar(50) — Primary key — NOT NULL
- Strategy_Cd (Key3) — varchar(50) — Foreign key → Response_Strategy.Code — NOT NULL
- Responsible_Cd (Key4) — varchar(50) — Foreign key → Responsible.Code — NOT NULL
- ActionPlan (Field) — text
- Department (Field2) — varchar(200)
- RegUser (Field3) — varchar(50)
- Pre_A (Field4) — smallint
- Pre_B (Field5) — smallint
- Pre_Score (Field6) — smallint
- Pre_Rank (Field7) — smallint
- After_A (Field8) — smallint
- After_B (Field9) — smallint
- After_Score (Field10) — smallint
- After_Rank (Field11) — smallint
- Feedback (Field12) — text
Status (상태)
- Code (Key) — varchar(50) — Primary key — NOT NULL
- Name (Field) — varchar(50)
WBS_Map (WBS 분류)
- Code (Field) — varchar(50) — Primary key
- Name (Field2) — varchar(200)
- Level (Field3) — int
- PCode (Field4) — varchar(50)