Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. --DROP TABLE Description
  2. --DROP TABLE Available_Jobs
  3. --DROP TABLE Personal_Details
  4. --DROP TABLE Job_Consultant
  5. --DROP TABLE Agency
  6. --DROP TABLE Client
  7. --DROP TABLE Resume_Details
  8.  
  9. CREATE TABLE Description (
  10. DescriptionID INTEGER IDENTITY (1,1) NOT NULL,
  11. Startdate DATETIME NOT NULL,
  12. Duration INTEGER NOT NULL,
  13. Location VARCHAR(20) NOT NULL,
  14. Salary DECIMAL(6,2),
  15. PRIMARY KEY (DescriptionID),
  16. );
  17.  
  18. CREATE TABLE Available_Jobs (
  19. JobID INTEGER IDENTITY (1,1) NOT NULL,
  20. DescriptionID INTEGER NOT NULL,
  21. Employer VARCHAR(50) NOT NULL,
  22. PRIMARY KEY (JobID),
  23. FOREIGN KEY (DescriptionID) REFERENCES Description
  24. );
  25.  
  26. CREATE TABLE Personal_Details (
  27. PersonID INTEGER IDENTITY (1,1) NOT NULL,
  28. Name VARCHAR(30) NOT NULL,
  29. Adress VARCHAR(60) NOT NULL,
  30. Date_of_birth DATETIME NOT NULL,
  31. Sex VARCHAR(6) NOT NULL,
  32. Email VARCHAR(30) NOT NULL,
  33. Phone_number VARCHAR(15) NOT NULL,
  34. PRIMARY KEY (PersonID),
  35. );
  36.  
  37. CREATE TABLE Job_Consultant (
  38. ConsultantID INTEGER IDENTITY (1,1) NOT NULL,
  39. AgencyID INTEGER NOT NULL,
  40. PersonID INTEGER NOT NULL,
  41. PRIMARY KEY (ConsultantID),
  42. --FOREIGN KEY (AgencyID) REFERENCES Agency,
  43. FOREIGN KEY (PersonID) REFERENCES Personal_Details
  44. );
  45.  
  46. CREATE TABLE Agency (
  47. AgencyID INTEGER IDENTITY (1,1) NOT NULL,
  48. ConsultantID INTEGER NOT NULL,
  49. JobID INTEGER NOT NULL,
  50. Location VARCHAR(30) NOT NULL,
  51. Phone VARCHAR(15) NOT NULL,
  52. Email VARCHAR(30) NOT NULL,
  53. PRIMARY KEY (AgencyID),
  54. FOREIGN KEY (ConsultantID) REFERENCES Job_Consultant,
  55. FOREIGN KEY (JobID) REFERENCES Available_Jobs,
  56. FOREIGN KEY (AgencyID) REFERENCES Job_Consultant
  57. );
  58.  
  59. CREATE TABLE Client (
  60. ClientID INTEGER IDENTITY (1,1) NOT NULL,
  61. PersonID INTEGER NOT NULL,
  62. ResumeID INTEGER NOT NULL,
  63. Job_type VARCHAR(1000),
  64. PRIMARY KEY (ClientID),
  65. FOREIGN KEY (PersonID) REFERENCES Personal_Details
  66. );
  67.  
  68. CREATE TABLE Resume_Details (
  69. ResumeID INTEGER IDENTITY (1,1) NOT NULL,
  70. PersonID INTEGER NOT NULL,
  71. Qualifications VARCHAR(5000),
  72. History_of_employment VARCHAR(1000),
  73. PRIMARY KEY (ResumeID),
  74. FOREIGN KEY (PersonID) REFERENCES Client,
  75. FOREIGN KEY (ResumeID) REFERENCES Client
  76. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement