Sure,
The script for the table and foreign keys follow below.
The foreign key field that is not handled by .netTiers is the one on the field UserID with fieldtype UniqueIdentifier that references the AspNet_Users table. (The AspNet tables have been automatically created in the same database, but I include here the create script)
CREATE TABLE dbo.Contactpersoon(
ContactpersoonID Int IDENTITY NOT NULL,
Achternaam VarChar(32) NOT NULL,
Voornaam VarChar(32) NOT NULL,
BedrijfID Int NOT NULL,
UserID UniqueIdentifier NOT NULL,
Titel VarChar(8) NULL,
Functie VarChar(32) NOT NULL,
Afdeling VarChar(32) NOT NULL,
Telefoonnr VarChar(16) NOT NULL,
Mobielnr VarChar(16) NULL,
Faxnr VarChar(16) NULL,
CONSTRAINT P_Contactpersoon PRIMARY KEY CLUSTERED (
ContactpersoonID
),
CONSTRAINT U_Contactpersoon UNIQUE NONCLUSTERED (
UserID
)
) ON "PRIMARY"
GO
ALTER TABLE dbo.ContactPersoon WITH NOCHECK ADD CONSTRAINT F_ContactPersoon_UserID FOREIGN KEY (UserID)
REFERENCES dbo.ASPNET_USERS (UserID)
ON DELETE CASCADE
ON UPDATE CASCADE
GO
ALTER TABLE dbo.ContactPersoon WITH NOCHECK ADD CONSTRAINT F_ContactPersoon_BedrijfID FOREIGN KEY (BedrijfID)
REFERENCES dbo.Bedrijf (BedrijfID)
ON DELETE CASCADE
ON UPDATE CASCADE
GO
CREATE TABLE dbo.Bedrijf (
BedrijfID Int IDENTITY NOT NULL,
BedrijfsNaam VarChar(32) NOT NULL,
KVK_nr VarChar(16) NOT NULL,
BTW_nr VarChar(16) NOT NULL,
Subnaam VarChar(32),
Telefoonnr VarChar(16) NOT NULL,
Faxnummer VarChar(16),
CONSTRAINT P_Bedrijf PRIMARY KEY CLUSTERED (
BedrijfID
),
CONSTRAINT U_Bedrijf1 UNIQUE NONCLUSTERED (
KVK_nr
),
CONSTRAINT U_Bedrijf2 UNIQUE NONCLUSTERED (
Btw_nr
)
) ON "PRIMARY"
GO
CREATE TABLE dbo.aspnet_Users (
ApplicationId Uniqueidentifier NOT NULL,
UserId Uniqueidentifier DEFAULT newid() NOT NULL,
UserName NVarChar(256) NOT NULL,
LoweredUserName NVarChar(256) NOT NULL,
MobileAlias NVarChar(16) DEFAULT NULL,
IsAnonymous Bit DEFAULT (0) NOT NULL,
LastActivityDate DateTime NOT NULL,
CONSTRAINT PK__aspnet_Users__03317E3D PRIMARY KEY NONCLUSTERED (
UserId
)
) ON "PRIMARY"
GO