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