AWP
Tables (28)
AWP Auth User List[0424] (dbo.AWP_AUTH_USER_LIST)
- Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
- Upv/ Swp3d (TYPE) — varchar(32) — Primary key — NOT NULL
- User ID (USERID) — varchar(64) — Primary key — NOT NULL
- Authority (Auth) — varchar(64)
- Update Date (UPDATE_DT) — datetime
- Update By (UPDATE_BY) — varchar(64)
AWP System Hierarchy Set-up[0424] (dbo.AWP_ADMIN_SYSPATH)
- Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
- Category (CATEGORY) — varchar(32) — Primary key — NOT NULL
- PIPING Sample Value (PIPING_SAMPLE) — varchar(64)
- PIPING IWP Key (PIPING_KEY) — varchar(32)
- PIPING IWP SubString Digit (PIPING_SUBSTR) — varchar(64)
- CIVIL Sample Value (CIVIL_SAMPLE) — varchar(64)
- CIVIL IWP Key (CIVIL_KEY) — varchar(64)
- CIVIL IWP Substring Digit (CIVIL_SUBSTR) — varchar(64)
- Equipment Sample Value (EQUIP_SAMPLE) — varchar(64)
- Equipment IWP Key (EQUIP_KEY) — varchar(64)
- Equipment SubString Digit (EQUIP_SUBSTR) — varchar(64)
- Structure Sample Value (STRUC_SAMPLE) — varchar(64)
- Structure IWP Key (STRUC_KEY) — varchar(64)
- Structure IWP Substring Digit (STRUC_SUBSTR) — varchar(64)
AWP_FILE_PATH
- Project No (PJT_NO) — varchar(32)
- Create by (CREATEBY) — varchar(64)
- Report Path Type (PATH_TYPE) — varchar(32)
- Report Path (PATH_VALUE) — nvarchar(max)
AWP_PJTNO_MODEL_MAP
- Project No (PJT_NO) — varchar(32)
- Model Path (MODELINFO) — varchar(128)
- Create Date (CREATEDT) — datetime
- Create by (CREATEBY) — varchar(64)
- Update Date (UPDATEDT) — datetime
- Update by (UPDATEBY) — varchar(64)
AWP_PRIOR_WORK_LIST_ISO
- Project No (PJT_NO) — varchar(32) — NOT NULL
- Model Path (MODELINFO) — varchar(128) — NOT NULL
- CWP Code (CWP_CODE) — varchar(64) — NOT NULL
- ISO No (ISONO) — varchar(64) — NOT NULL
- Item Type (ITEMTYPE) — varchar(256)
- Item No (ITEMNO) — varchar(256)
- Create by (CREATEBY) — varchar(64)
- Create date (CREATEDT) — datetime
- User manual (USER_MANUAL) — int
Assgined UID in Volume Info [0427] (dbo.AWP_VOLUME_INFO_ASS_ITEM)
- Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
- Discipline (DISCIPLINE) — varchar(64)
- Item Type (ITEM_TYPE) — varchar(64)
- Item No (ITEM_NO) — varchar(256)
- Dwg No (DWG_NO) — varchar(512)
- Iso No (ISO_NO) — varchar(512)
- Block No (BLOCK_NO) — varchar(512)
- Assembly No (ASSEMBLY_NO) — varchar(512)
- Guid (GUID) — varchar(256)
- Uid (UID) — varchar(256)
Assigned Piping Item List in IWP[0424] (dbo.AWP_IWP_ASS_ITEM)
- Orginal Item No (ORG_ITEMNO) — varchar(64) — Primary key
- UID — varchar(MAX) — Primary key
- Project Code (PJT_NO) — varchar(32) — Foreign key → IWP List[0424].Project Code — NOT NULL
- IWP Code (IWP_CODE) — varchar(64) — Foreign key → IWP List[0424].IWP Code — NOT NULL
- CWP Code (CWP_CODE) — varchar(64) — Foreign key → IWP List[0424].CWP Code — NOT NULL
- Item Type (TYPE) — varchar(16)
- System Path (SYSPATH) — varchar(MAX)
- Discipline — varchar(64)
- Area (AREA) — varchar(32)
- Item No (ITEMNO) — varchar(64)
- DWG No (DWGNO) — varchar(64)
- WF — varchar(32)
- sequence (SEQNO) — int
Attachment List[0508] (dbo.AWP_ATTCHFILES)
- File Index (FILEID) — int — Primary key — NOT NULL
- IWP Code (IWP_CODE) — varchar(64) — Foreign key → IWP List[0424].IWP Code — NOT NULL
- Project Code (PJT_NO) — varchar(32) — Foreign key → IWP List[0424].Project Code — NOT NULL
- CWP Code (CWP_CODE) — varchar(64) — Foreign key → IWP List[0424].CWP Code — NOT NULL
- File Name (FILENM) — varchar(max)
- File Path (FILEPATH) — varchar(max)
- File Size (FILESIZE) — int
- UPV View Info (UPV_VIEW_INFO) — varchar(max)
- Create Date (CREATE_DT) — datetime
- Create User ID (CREATE_BY) — varchar(64)
- Update Date (UPDATE_DT) — dateTIme
- Update User ID (UPDATE_BY) — varchar(64)
- View Type (VIEW_TYPE) — varchar(32)
CWP List[0424] (dbo.CSIM_AWP_UPV_MAP)
- Project Code (PJT_NO) — varchar(100) — Primary key — NOT NULL
- CWA — varchar(100) — Primary key — NOT NULL
- CWA B (CWA_B) — varchar(100) — Primary key — NOT NULL
- CWP Code (CWP_CODE) — varchar(100) — Primary key — NOT NULL
- UPV Mapping (UPV_MAPPING) — varchar(500) — Primary key
- CWP Description (CWP_DESC) — varchar(MAX)
- CWP Start Date (CWP_START_DATE) — varchar(50)
- CWP Finish Date (CWP_FINISH_DATE) — varchar(50)
- BOQ_QTY(?) (BOQ_QTY) — numeric(38,0)
- Actural Quantity (ACTUAL_QTY) — numeric(38,0)
- Actural Start Date (ACTUAL_START_DATE) — varchar(50)
- Actural Finish Date (ACTUAL_FINISH_DATE) — varchar(50)
- ENG_PLAN_DATE(?) (ENG_PLAN_DATE) — varchar(50)
- WF_DATE(?) (WF_DATE) — varchar(50)
- UOM(?) (UOM) — varchar(50)
- Work Category (WORK_CATEGORY) — varchar(500)
- UPV Discipline (UPV_DISC) — varchar(50)
- UPV Area (UPV_AREA) — varchar(50)
- IF Date (IF_DATE) — datetime
- UPV Mapping Type (UPV_MAPPING_TYPE) — varchar(64)
- UPV 3D Where Rule (UPV_3D_WHERE_RULE) — varchar(64)
Custom Attribute[0424] (dbo.CustAttr_UPV_Extraction_Attribute)
- Project No (PJT_NO) — varchar(32) — Primary key — NOT NULL
- Category — varchar(50) — Primary key — NOT NULL
- Sequence (Seq) — int — Primary key — NOT NULL
- Attribute — varchar(50)
- Create ID (CreateId) — varchar(50)
- Create Date (CreateDt) — datetime
- Update ID (UpdateId) — varchar(50)
- Update Date (UpdateDt) — datetime
Custom Attribute Map Data[0615] (dbo.AWP_UPV_VALUE)
- Project No (PJT_NO) — varchar(64) — NOT NULL
- Model Info (ModelInfo) — varchar(64) — NOT NULL
- Discipline (DISCIPLINE) — varchar(64) — NOT NULL
- Area (AREA) — varchar(32)
- System Path (SYSPATH) — varchar(500) — NOT NULL
- Item Type (ITEMTYPE) — varchar(256) — NOT NULL
- H/E Level 1 (HE1) — varchar(256)
- H/E Level 2 (HE2) — varchar(256)
- Item No\ (ITEMNO) — varchar(256) — NOT NULL
- Iso No (ISONO) — varchar(256)
- Uid (UID) — varchar(128) — NOT NULL
- Create Date (CreateDT) — datetime — NOT NULL
- Field
Custom Attribute Value[0424] (dbo.CustAttr_UPV_Extraction_Value)
- Project No (PJT_NO) — varchar(32) — Primary key
- Category (CATEGORY) — varchar(50) — Primary key
- Model Info (MODELINFO) — varchar(500) — Primary key
- Sequence (Seq) — int — Primary key
- ATTRVALUE_1 — varchar(500)
- ATTRVALUE_2 — varchar(500)
- ATTRVALUE_3 — varchar(500)
- ATTRVALUE_4 — varchar(500)
- ATTRVALUE_5 — varchar(500)
- ATTRVALUE_6 — varchar(500)
- ATTRVALUE_7 — varchar(500)
- ATTRVALUE_8 — varchar(500)
- ATTRVALUE_9 — varchar(500)
- ATTRVALUE_10 — varchar(500)
- Create Date (CREATEDT) — datetime
Discipline For Item Tag Type [0424] (dbo.AWP_ITEMTAGTYPE_DISCIPLINE)
- Project No (PJT_NO) — varchar(64) — Primary key — NOT NULL
- Discipline (DISCIPLINE) — varchar(64) — Primary key — NOT NULL
HE For Item Tag Type [0424] (dbo.ITEMTAGTYPE_HE)
- Project No (PJT_NO) — varchar(64) — Primary key — NOT NULL
- Discipline (DISCIPLINE) — varchar(64) — Primary key — NOT NULL
- H/E Level 1 (HE_LV_1) — varchar(128) — Primary key — NOT NULL
- H/E Lebel 2 (HE_LV_2) — varchar(128) — Primary key — NOT NULL
- Template Code (TEMPLATE_CODE)
IWP Code Numbering[0427] (dbo.AWP_IWP_NUMBERING_RULE)
- Project Code (PJT_NO) — varchar(64)
- TYPE — varchar(32)
- Contents (CONTENT) — varchar(MAX)
IWP List[0424] (dbo.AWP_IWP_LIST)
- IWP Code (IWP_CODE) — varchar(64) — Primary key — NOT NULL
- Project Code (PJT_NO) — varchar(32) — Foreign key → CWP List[0424].Project Code — NOT NULL
- CWP Code (CWP_CODE) — varchar(64) — Foreign key → CWP List[0424].CWP Code — NOT NULL
- Model Path (ModelPath) — varchar(max)
- Model Cooridnate (ModelView) — varchar(max)
- Status WF — varchar(10)
- Status Cnst (StatusCnst) — varchar(10)
- Plan Start Date (PlanStartDt) — dateTime
- Plan End Date (PlanEndDt) — dateTime
- Actual Start Date (ActualStartDt) — dateTime
- Actual End Date (ActualEndDt) — dateTime
- WorkFace Planner (UserWP) — varchar(64)
- Super Intendent (UserSI) — varchar(64)
- Supervisor (UserSP) — varchar(64)
- ForeMan (UserFM) — varchar(64)
- Rev. (Rev) — int
- Remark — varchar(max)
- Image Path (ImgPath) — varchar(max)
- Sub Key (SUB_KEY) — varchar(64)
- CWA Code (CWA_Code) — varchar(64) — NOT NULL
- Seq No (SEQNO) — int
- Discipline — varchar(16)
Item Tag List (dbo.AWP_ITEMTAGLIST)
- Index (IDX) — int — Primary key — NOT NULL
- Project No (PJT_NO) — varchar(32)
- Model Path (MODELINFO) — varchar(128)
- Item Tag Type (ITEMTAGTYPE) — varchar(128)
- Area (AREA) — varchar(64)
- Item Tag No (ITEM_TAG_NO) — varchar(128)
- H/E Level 1 (HE_LV_1) — varchar(128)
- H/E Level 2 (HE_LV_2) — varchar(128)
- System Path Level 1 (SYSPATH_LV1) — varchar(64)
- System Path Level 2 (SYSPATH_LV2) — varchar(64)
- System Path Level 3 (SYSPATH_LV3) — varchar(64)
- System Path Level 4 (SYSPATH_LV4) — varchar(64)
- System Path Level 5 (SYSPATH_LV5) — varchar(64)
- System Path Level 6 (SYSPATH_LV6) — varchar(64)
- System Path Level 7 (SYSPATH_LV7) — varchar(256)
- System Path Level 8 (SYSPATH_LV8) — varchar(256)
- System Path Level 9 (SYSPATH_LV9) — varchar(256)
- System Path Level 10 (SYSPATH_LV10) — varchar(256)
- Create Date (CREATEDT) — datetime
- Create by (CREATEBY) — varchar(64)
- Update Date (UPDATEDT) — datetime
- Update by (UPDATEBY) — varchar(64)
- Discipline (DISCIPLINE) — varchar(64)
- UID — varchar(128)
- User Manual (USER_MANUAL) — bit
Item Tag Type [0424] (dbo.AWP_ITEMTAGTYPE)
- Index (IDX) — int — Primary key — NOT NULL
- Project No (PJT_NO) — varchar(32)
- Discipline (DISCIPLINE) — varchar(64)
- H/E Level 1 (HE_LV_1) — varchar(128)
- H/E Level 2 (HE_LV_2) — varchar(128)
- Item Type (ITEMTYPE) — varchar(128)
- UPV Attribute (UPV_ATT) — varchar(64)
- UPV Value (UPV_VALUE) — varchar(64)
- UPV Condition (UPV_CONDITION) — varchar(16)
- Result UPV Attribute (ITEM_ATT_VALUE) — varchar(64)
- W/F L/D Table (WF_LD_TABLE) — varchar(256)
- W/F L/D Column 1 (WF_LD_COLUMN_1) — varchar(256)
- W/F L/D Column 2 (WF_LD_COLUMN_2) — varchar(256)
- W/F L/D Column 3 (WF_LD_COLUMN_3) — varchar(256)
- W/F 3D DB 3D Key 1 (WF_3DDB_3DKEY_1) — varchar(256)
- W/F 3D DB 3D Key 2 (WF_3DDB_3DKEY_2) — varchar(256)
- W/F 3D DB 3D Key3 (WF_3DDB_3DKEY_3) — varchar(256)
- W/F/R L/D Table (WFR_LD_TABLE) — varchar(256)
- W/F/R L/D Column (WFR_LD_COLUMN) — varchar(256)
- W/F/R SQL (WFR/SQL) — varchar(Max)
- Dept Level 1 (DEPT_LV_1) — int
- Dept Level 2 (DEPT_LV_2) — int
- Dept Lebel 3 (DEPT_LV_3) — int
- Category — varchar(64)
Log TBL for development (dbo.AWP_LOG_FORDEV)
- Index (IDX) — int — Primary key — NOT NULL
- TYPE — varchar(64)
- SUB TYPE (SUB_TYPE) — varchar(64)
- Catergory (CATEGORY) — varchar(64)
- Sub Category (SUB_CATEGORY) — varchar(64)
- Contents (CONTENTS) — varchar(max)
- Create Date (CREATEDT) — datetime
- Create User ID (CREATEBY) — varchar(64)
MMS (dbo.CSIM_AWP_UPV_MAP_ME)
- Project No (PJT_NO) — varchar(20) — Primary key — NOT NULL
- CWP Code (CWP_CODE) — varchar(50)
- Const Area (CONST_AREA) — varchar(10)
- HD Element CD (HD_ELEM_CD) — varchar(10)
- Item No (ITEM_NO) — varchar(50)
- Req No (REQ_NO) — varchar(50)
- Item Name (ITEM_NM) — varchar(200)
- UOM — varchar(50)
- Item Sequence (ITEM_SEQ) — float
- Const Schedules Status (CONST_SCHEDULE_STATUS) — varchar(50)
- Field
TEMP TBL for UID[0427] (dbo.AWP_UID_TEMP)
- UPV UID (UPV_UID) — varchar(128)
- Session UID (SES_UID) — varchar(128)
- Create Date (CREATEDT) — datetime
- Confirm_Status (CONFIRM_STATUS) — tinyint
User List[04240] (dbo.AWP_USER_LIST)
- User ID (UserId) — varchar(64) — Primary key — NOT NULL
- JobType — varchar(32) — Primary key — NOT NULL
- Project Code (PJT_NO) — varchar(32) — Primary key — NOT NULL
- Discipline — varchar(64)
- Mail Address (MailAddr) — varchar(128)
- Create ID (CreateBy) — varchar(64)
- Create Date (CreateDt) — dateTime
- Update ID (UpdateBy) — varchar(64)
- Update Date (UpdateDt) — dateTime
Volume Group Info [0427] (dbo.AWP_VOLUME_GROUP)
- Volume Group Index (VG_IDX) — int — Primary key — NOT NULL
- Project No (PJT_NO) — varchar(128)
- Model Info (MODELINFO) — varchar(128)
- Volume Group Name (VOLUMNEGROUP) — varchar(128)
- Create Date (CREATEDT) — datetime
- Create by (CREATEBY) — varchar(64)
- Update Date (UPDATEDT) — datetime
- Update by (UPDATEBY) — varchar(64)
Volume Info Condition [0427] (dbo.AWP_VOLUME_INFO_CONDITION)
- Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
- Attribute Name (ATT_NAME) — varchar(128)
- Attribute Value (ATT_VALUE) — varchar(256)
- Condition(equal,like) (CONDITION) — varchar(16)
- And/Or (AND_OR) — varchar(3)
- Sequence Index (IDX) — int
Volume Info Report Condition [0427] (dbo.AWO_VOLUME_INFO_REPORT)
- Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
- Attribute Name (ATT_NAME) — varchar(128)
Volume Info Report Value (dbo.AWP_VOLUME_INFO_REPORT_VALUE)
- Volume Info Index (VI_IDX) — int — Foreign key → Volume Info [0427].Volume Info Index
- Uid (UID) — int
- Attribute Name (ATT_NAME) — varchar(128)
- Attribute Value (ATT_VALUE) — varchar(max)
Volume Info [0427] (dbo.AWP_VOLUME_INFO)
- Volume Info Index (VI_IDX) — int — Primary key
- Volume List Index (VL_IDX) — int — Foreign key → Volume List Info [0427].Volume List Index
- Volume Name (VOLUME_NAME) — varchar(128)
- Description (DESC) — varchar(max)
- Create Mode (CREATE_MODE) — varchar(2)
- Group Code (GROUP_CODE) — varchar(16)
- Select By (SELECTBY) — varchar(16)
- Create Date (CREATEDT) — datetime
- Create By (CREATEBY) — varchar(64)
- Update Date (UPDATEDT) — datetime
- Volume Color (COLOR) — varchar(32)
- Update by (UPDATEBY) — varchar(64)
- Min x (MIN_X) — float
- Min y (MIN_Y) — float
- Min z (MIN_Z) — float
- Max x (MAX_X) — float
- Max y (MAX_Y) — float
- Max z (MAX_Z) — float
- Quantity (QTY) — in
Volume List Info [0427] (dbo.AWP_VOLUME_LIST)
- Volume List Index (VL_IDX) — int — Primary key
- Volume Group Index (VG_IDX) — int — Foreign key → Volume Group Info [0427].Volume Group Index — NOT NULL
- Discipline (DISCIPLINE) — varchar(64)
- Volume List Name (VL_NAME) — varchar(128)
- Description (DESC) — varchar(max)
- Create Date (CREATDT) — datetime
- Create By (CREATEBY) — varchar(64)
- Update Date (UPDATEDT) — datetime
- Update by (UPDATEBY) — varchar(64)