Research Article
An IDM-Based Approach for Information Requirement in Prefabricated Construction
Table 8
Relational tables of the database.
| Name | Attribute | Data type | Constraint |
| Subtable 1: Stakeholder | StakeholderID | Reference number of stakeholders | char(3) | Primary key | StakeholderName | Stakeholder name | varchar(20) | Required | StakeholderCI | Contact information of stakeholders | varchar(50), | Required |
| Subtable 2: IFC element | ComponentID | Reference number of IFC element | varchar(100) | Composite key | ComponentName | Element name | varchar(20) | Required | ComponentDetail | Detailed description | varchar(20) | Required | ERItemID | Reference number of exchange requirement items | char(7) | Composite key | ERItem | Exchange requirement items | varchar(1000) | Required | RequiredLevel | Required level | char(1) | Required | ChangeLog | Change log | varchar(500) | Required |
| Subtable 3: Delivery-related files | FileID | Reference number of files | char(11) | Primary key | FileName | File name | varchar(50) | Required | StakeholderID | Reference number of stakeholders | char(3) | Foreign key | CreateTime | Creation date | Date() | Required | StoragePath | Storage path | varchar(40) | Required |
| Subtable 4: View | FileID | Reference number of files | char(11) | Foreign key | StakeholderID | Reference number of stakeholders | char(3) | Foreign key |
| Subtable 5: Associate | FileID | Reference number of files | char(11) | Foreign key | ComponentID | Reference number of IFC element | varchar(100) | Foreign key | ERItemID | Reference number of exchange requirement items | char(7) | Foreign key | StakeholderID | Reference number of stakeholders | char(3) | Foreign key |
|
|