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