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)