CREATE TABLE [b2043701].[Application] (
    [ApplicationId]         INT            IDENTITY (1, 1) NOT NULL,
    [ApplicantId]           INT            NOT NULL,
    [CourseName]            NVARCHAR (50)  NOT NULL,
    [UniversityId]          INT            NOT NULL,
    [PersonalStatement]     NVARCHAR (MAX) NOT NULL,
    [TeacherReference]      NVARCHAR (MAX) NULL,
    [TeacherContactDetails] NVARCHAR (MAX) NOT NULL,
    [UniversityOffer]       NVARCHAR (10)  NULL,
    [Firm]                  BIT            NULL,
    PRIMARY KEY CLUSTERED ([ApplicationId] ASC),
    CONSTRAINT [FK_Application_Profile] FOREIGN KEY ([ApplicantId]) REFERENCES [b2043701].[Profile] ([ApplicantId]),
    CONSTRAINT [FK_Application_University] FOREIGN KEY ([UniversityId]) REFERENCES [b2043701].[University] ([UniversityId])
);


GO
EXECUTE sp_addextendedproperty @name = N'SHU Data Monitor Row Count', @value = N'6', @level0type = N'SCHEMA', @level0name = N'b2043701', @level1type = N'TABLE', @level1name = N'Application';


GO
EXECUTE sp_addextendedproperty @name = N'SHU Data Monitor Select', @value = N'2018-03-13 17:35', @level0type = N'SCHEMA', @level0name = N'b2043701', @level1type = N'TABLE', @level1name = N'Application';


GO
EXECUTE sp_addextendedproperty @name = N'SHU Data Monitor Sensitive Data Indicator', @value = N'10.100', @level0type = N'SCHEMA', @level0name = N'b2043701', @level1type = N'TABLE', @level1name = N'Application';


GO
EXECUTE sp_addextendedproperty @name = N'SHU Data Monitor Update', @value = N'2018-03-10 18:49', @level0type = N'SCHEMA', @level0name = N'b2043701', @level1type = N'TABLE', @level1name = N'Application';