dataWarehouse_sql_ssis/employment_create_libraries.sql at main · ksproska/dataWarehouse_sql_ssis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
DROP TABLE IF EXISTS LibraryAcademicTitle;
DROP TABLE IF EXISTS LibraryCompanyType;
DROP TABLE IF EXISTS LibraryCoreProgrammingLanguage;
DROP TABLE IF EXISTS LibraryCountryName;
DROP TABLE IF EXISTS LibrarySex;
DROP TABLE IF EXISTS LibraryFirstLanguage;
DROP TABLE IF EXISTS LibraryWorkForm;
DROP TABLE IF EXISTS LibrarySpeciality;
DROP TABLE IF EXISTS LibraryTeamType;
DROP TABLE IF EXISTS LibraryFormOfEmployment;

CREATE TABLE [LibraryAcademicTitle] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryCompanyType] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryCoreProgrammingLanguage] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryCountryName] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibrarySex] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryFirstLanguage] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryWorkForm] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibrarySpeciality] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryTeamType] (
    [Name] VARCHAR(50)
)
CREATE TABLE [LibraryFormOfEmployment] (
    [Name] VARCHAR(50)
)
INSERT INTO [dbo].[LibraryAcademicTitle] VALUES (NULL);
INSERT INTO [dbo].[LibraryCompanyType] VALUES (NULL);
INSERT INTO [dbo].[LibraryCoreProgrammingLanguage] VALUES (NULL);
INSERT INTO [dbo].[LibraryCountryName] VALUES (NULL);
INSERT INTO [dbo].[LibraryFirstLanguage] VALUES (NULL);
INSERT INTO [dbo].[LibraryFormOfEmployment] VALUES (NULL);
INSERT INTO [dbo].[LibrarySex] VALUES (NULL);
INSERT INTO [dbo].[LibrarySpeciality] VALUES (NULL);
INSERT INTO [dbo].[LibraryTeamType] VALUES (NULL);
INSERT INTO [dbo].[LibraryWorkForm] VALUES (NULL);