An IDM-Based Approach for Information Requirement in Prefabricated Construction

Table 9

Relationship between two entities.

Each stakeholder requires one or more delivery-related files, and one delivery-related file is viewed by one or more stakeholders.	Each IFC element is required by one or more stakeholders, and one stakeholder requires the information of one or more IFC elements.	Each delivery-related files contain one or more IFC elements, and each IFC element is included in one or more delivery-related files.
Create table Stakeholder (StakeholderID char(3),; StakeholderName varchar(20),; StakeholderCI varchar(50),; Primary key (StakeholderID); Create table Delivery-related files (FileID char(11),; FileName varchar(50),; StakeholderID char(3),; CreateTime date(),; StoragePath varchar(40),; Primary key (FileID); Create table view (FileID char(11),; StakeholderID char(3),; Primary key (FileID, StakeholderID); Foreign key (FileID) references delivery-related files on delete set default on update cascade),; Foreign key (StakeholderID) references stakeholders (StakeholderID));	Create table Stakeholder (StakeholderID char(3),; StakeholderName varchar(20),; StakeholderCI varchar(50),; Primary key (StakeholderID); Create table IFC element (ComponentID varchar(100),; ComponentName varchar(20),; ComponentDetail varchar(20),; ERItemID char(7),; ERItem varchar(1000),; RequiredLevel char(1),; ChangeLog varchar(500),; Primary key (ComponentID); Create table associate1 (ComponentID varchar(100),; ERItemID char(7),; StakeholderID char(3),; Primary key (ComponentID, ERItemID, StakeholderID),; Foreign key (ComponentID, ERItemID) references IFC element on delete set default on update cascade),; Foreign key (StakeholderID) references stakeholders (StakeholderID));	Create table Delivery-related files (FileID char(11),; FileName varchar(50),; StakeholderID char(3),; CreateTime date(),; StoragePath varchar(40),; Primary key (FileID); Create table IFC element (ComponentID varchar(100),; ComponentName varchar(20),; ComponentDetail varchar(20),; ERItemID char(7),; ERItem varchar(1000),; RequiredLevel char(1),; ChangeLog varchar(500),; Primary key (ComponentID); Create table associate2 (ComponentID varchar(100),; ERItemID char(7),; FileID char(11),; Primary key (ComponentID, ERItemID, FileID),; Foreign key (ComponentID, ERItemID) references IFC element on delete set default on update cascade),; Foreign key (FileID) references delivery-related files (FileID));