dNknZpEx

1IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'extension')
2EXEC sys.sp_executesql N'CREATE SCHEMA [extension]'
3GO
4
5
6-- Table [extension].[PromiseStudent] --
7CREATE TABLE [extension].[PromiseStudent] (
8    [StudentUSI] [INT] NOT NULL,
9    [DCCCDId] [INT] NULL,
10    [SchoolId] [INT] NULL,
11    CONSTRAINT [PromiseStudent_PK] PRIMARY KEY CLUSTERED (
12        [StudentUSI] ASC
13    ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
14) ON [PRIMARY]
15GO
16
17ALTER TABLE [extension].[PromiseStudent] WITH CHECK ADD CONSTRAINT [FK_PromiseStudent_Student] FOREIGN KEY ([StudentUSI])
18REFERENCES [edfi].[Student] ([StudentUSI])
19ON DELETE CASCADE
20GO
21
22-- Extended Properties [extension].[PromiseStudent] --
23EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.', @level0type=N'SCHEMA', @level0name=N'extension', @level1type=N'TABLE', @level1name=N'PromiseStudent'
24GO
25EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The identifier assigned to an education agency by the State Education Agency (SEA).  Also known as the State LEA ID.', @level0type=N'SCHEMA', @level0name=N'extension', @level1type=N'TABLE',@level1name=N'PromiseStudent', @level2type=N'COLUMN', @level2name=N'StudentUSI'
26GO
27EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'DCCCD Identification number.', @level0type=N'SCHEMA', @level0name=N'extension', @level1type=N'TABLE',@level1name=N'PromiseStudent', @level2type=N'COLUMN', @level2name=N'DCCCDId'
28GO