SWP3D_PnIDQCS

Tables (4)

Common AttachFile (dbo.AttachFiles)

  • FileID (FileID2) — int — Foreign key → PnID Note View/Att Information.FileID — NOT NULL — Attachment 유일 키값
  • FileNm — varchar(max) — File Name
  • FilePath — varchar(MAX) — File Path
  • RealFileNm — varchar(MAX) — Real File Name
  • FileSize — int — File Size
  • CreateId — varchar(20) — Create ID
  • CreateDt — dateTime — Create Date
  • UpdateId — varchar(20) — Update ID
  • UpdateDt — dateTime — Update Date

PnID Note Based QCS Option (PnID_Option)

  • Projcd — varchar(6) — Primary key — NOT NULL — 키값
  • Stage — varchar(max) — Stage Option값
  • Discipline — varchar(max) — Discipline Option값
  • Category — varchar(max) — Category Option값

PnID Note View/Att Information (dbo.PnID_AttachInfo)

  • FileID — int — Primary key — NOT NULL — Attachment 유일 키값
  • PnIDNoteId — varchar(50) — Foreign key → PnIDNoteQCSInfo.PnIDNoteId — NOT NULL — P&ID Note 유일 키값
  • AppliedView — varchar(200) — Upv View Position
  • CreateId — varchar(32) — Create ID
  • CreateDt — dateTime — Create Date
  • UpdateId — varchar(32) — Update ID
  • UpdateDt — dateTime — Update Date

PnIDNoteQCSInfo (dbo.PnID_NoteInfo)

  • PnIDNoteId — varchar(50) — Primary key — NOT NULL — P&ID Note 유일 키값
  • PnIDNo — varchar(32) — NOT NULL — P&ID No
  • NoteNo — int — NOT NULL — Note No
  • Stage — varchar(32) — NOT NULL — Stage
  • Description — varchar(max) — Description
  • Discipline — varchar(32) — Discipline
  • Category — varchar(32) — For Check_Category
  • DueDt (DuDt) — dateTime — For Check_Due Date
  • TargetStage — varchar(32) — For Check_Target Stage
  • CheckedYN — tinyInt — For Check_Checked Y/N
  • AppliedDt — dateTime — Applied_Applied Date
  • AppliedBy — varchar(64) — Applied_Applied By
  • AppliedYN — tinyInt — Applied_Applied Y/N
  • ClosedDt — dateTime — For Close_Closed Date
  • ClosedBy — varchar(64) — For Close_Closed by
  • Status — tinyInt — For Close_Status
  • ModelInfo — varchar(100) — 3D Model No
  • Unit — varchar(32) — Unit
  • CreatedDt (CreateDt) — dateTime — Note Created Date
  • CreateBy — varchar(64) — Note Created by
  • ModifiedDt — dateTime — Note Last Modified Date
  • ModifiedBy — varchar(64) — Note Last Modified by
  • CheckedDt — dateTime — Checked Date
  • CheckedBy — varchar(64) — Checked by
  • Remarks — varchat(Max) — Remarks
  • Source — tinyInt — P&ID note Source
  • Projcd (Projcdv) — varchar(6) — NOT NULL — Project ID