Research Article
Developing an IFC-Based Database for Construction Quality Evaluation
Table 13
Relational tables of the database.
| | Relational tables | | Name | Attribute | Data type | Constraint |
| | Subtable 1—fractional project | | F_BranchWorkID | Reference number | Char(2) | Primary key | | F_BranchWorkName | Name | Varchar(12) | Required | | F_ConstructionU | Construction units | Varchar(40) | Required | | F_ConstructureQS | Construction quality score | Decimal(4,2) | Required |
| | Subtable 2—constituent project | | F_ConstituentPID | Reference number | Char(2) | Primary key | | F_ConstituentPName | Name | Varchar(12) | Required | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_ConstituentPIR | Inspection result | Varchar(100) | Optional | | F_ConstituentPAD | Acceptance decisions | Varchar(100) | Required | | F_ConstituentPTD | Professional technical director | Varchar(10) | Required | | F_ConstituentPSE | Supervision engineer | Varchar(10) | Required |
| | Subtable 3—inspection lot | | F_InspectionLotID | Reference number | Char (14) | Primary key | | F_InspectionLotName | Name | Varchar(50) | Required | | F_ConstituentPID | Reference number | Char(2) | Foreign key | | F_InspectionLotDate | Inspection date | Date() | Required | | F_InspectionLotAD | Acceptance date | Date() | Optional | | F_InspectionLotS | Construction standard and specification | Varchar(50) | Required | | F_InspectionLotIR | Inspection results of construction units | Varchar(100) | Required | | F_InspectionLot SU | Acceptance decision from supervision unit | Varchar(100) | Required |
| | Subtable 4–files | | F_DocumentID | Reference number | Char(7) | Primary key | | F_DocumentName | File names | Varchar(40) | Required | | F_CreateTime | Creation date | Date() | Optional | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_StoragePath | Storage path | Varchar(40) | Required |
| | Subtable 5—evaluate | | F_InspectionLotID | Reference number | Char (14) | Foreign key | | F_ComponentID | Reference number of element | Varchar(100) | Foreign key | | F_IndicatorID | Reference number of evaluation indicator | Char(6)) | Foreign key |
| | Subtable 6—include | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_ComponentID | Reference number of element | Varchar(100) | Foreign key | | F_IndicatorID | Reference number of evaluation indicator | Char(6)) | Foreign key |
| | Subtable 7—divide | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_ConstituentPID | Reference number | Char(2) | Foreign key |
| | Subtable 8—associate | | F_DocumentID | Reference number | Char(7) | Primary key | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_ConstituentPID | Reference number | Char(2) | Foreign key | | F_InspectionLotID | Reference number | Char (14) | Foreign key | | F_ComponentID | Reference number of element | Varchar(100) | Foreign key | | F_IndicatorID | Reference number of evaluation indicator | Char(6)) | Foreign key |
| | Subtable 9—inspect | | F_ConstituentPID | Reference number | Char(2) | Foreign key | | F_InspectionLotID | Reference number | Char (14) | Foreign key |
| | Subtable 10—IFC element | | F_ComponentID | Reference number/GUID in IfcBuildingElement | Varchar(100) | Composite key | | F_ComponentName | Ifc element name | Varchar(20) | Required | | F_ComponentDetail | Detailed description | Varchar(20) | Required | | F_BranchWorkID | Reference number | Char(2) | Foreign key | | F_IndicatorID | Reference number of evaluation indicator | Char(6) | Composite key | | F_IndicatorName | Indicator name | Varchar(20) | Required | | F_EvaluationSR | Evaluation standards and requirements | Varchar(200) | Required | | F_EvaluationResult | IfcPropertySet on Wall/Column/Slab/Beam | Varchar(5) | Required |
|
|
