Scribd
Upload
50 views6 pages

Microsoft SQL Server 2008 Table:: SR - No Column Name Data Type

The document describes the table structures for both Microsoft SQL Server 2008 and MS Access. For SQL Server, it lists 11 tables with their column names and data types for storing user, admin, discussion forum, placement, and movie review information. For Access, it lists 9 tables with their column names and data types for storing company, user, job, exam, login, and other employment related information.

Uploaded by

Andrew Martin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
50 views6 pages

Microsoft SQL Server 2008 Table:: SR - No Column Name Data Type

The document describes the table structures for both Microsoft SQL Server 2008 and MS Access. For SQL Server, it lists 11 tables with their column names and data types for storing user, admin, discussion forum, placement, and movie review information. For Access, it lists 9 tables with their column names and data types for storing company, user, job, exam, login, and other employment related information.

Uploaded by

Andrew Martin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 6

MICROSOFT SQL SERVER 2008 TABLE:

1.ADMIN TABLE
Sr.no Column Name Data Type
1. Name varchar(MAX)
2. College varchar(MAX)
3. Email varchar(MAX)
4. Password varchar(50)
5. Phone varchar(MAX)

2.USER TABLE
Sr.no Column Name Data Type
1. Name nchar(10)
2. College nchar(10)
3. Email nchar(10)
4. Password nchar(10)
5. Phone nchar(10)

3.DISSCUSSION ZONE
Sr.no Column Name Data Type Null
1. id Int No
2. Topic varchar(MAX) Yes

4.OVERALL DISCUSSION ZONE


Sr.no Column Name Data Type Null
1. Name varchar(MAX) Yes
2. Msg varchar(MAX) Yes
3. Date varchar(MAX) Yes
4. Topic varchar(MAX) Yes
5. Id Int No
5.PLACEMENT PAPER TABLE
Sr.no Column Name Data Type Null
1. Id Int No
2. Heading nvarchar(MAX) Yes
3. Definition nvarchar(MAX) Yes
4. Description nvarchar(MAX) Yes
5. Links nvarchar(MAX) Yes

6.COMMENTS TABLE
Sr.no Column Name Data Type Null
1. message nvarchar(MAX) No

7.DEMAND DETAIL TABLE


Sr.no Column Name Data Type Null
1. Id int No
2. NAME varchar(MAX) Yes
3. MSG varchar(MAX) Yes
4. DATE varchar(MAX) Yes

8.FEEDBACK TABLE
Sr.no Column Name Data Type Null
1. Id int No
2. NAME varchar(MAX) Yes
3. MSG varchar(MAX) Yes
4. DATE varchar(MAX) Yes

9.MOVIE NEWS TABLE


Sr.no Column Name Data Type Null
1. Id int No
2. News varchar(MAX) Yes
10.MOVIE REVIEW TABLE
Sr.no Column Name Data Type Null
1. Id int No
2. Name varchar(MAX) Yes
3. director varchar(MAX) Yes
4. producer varchar(MAX) Yes
5. Cast varchar(MAX) Yes
6. pbrating varchar(MAX) Yes

11.BOX OFFICE REPORT


Sr.no Column Name Data Type Null
1. Id int No
2. Box off varchar(MAX) Yes

12.BOX OFFICE REVIEW


Sr.no Column Name Data Type Null
1. Id int No
2. Name varchar(MAX) Yes
3. Verdict varchar(MAX) Yes
4. Description varchar(MAX) Yes

TABLE OF MS ACCESS:-

1.COMPANY TABLE
Sr.no Column Name Data Type
1. CName Text
2. CAddress Text
3. CPost Text
4. CCriteria Text
5. CUsername Text
6. CEmail Text
7. CContact Text
8. CCutoff Text
2.EXAM TABLE
Sr.no Column Name Data Type
1. Exam Id Text
2. Exam Name Text
3. Cutoff Text

3.USER FORM DETAIL


Sr.no Column Name Data Type
1. Name Text
2. Gender Text
3. DateOfBirth Text
4. CollegeName Text
5. CollegePhone Text
6. CollegeEmail Text
7. Branch Text
8. Mark Text
9. Degree Text
10. Email_id Text
11. Telephone Text
12 Address Text
13. State Text
14. Pincode Text
15. Category Text

4.EXAM TYPE
Sr.no Column Name Data Type
1. JobId Text
2. Post Text
3. ExamId Text
4. ExamName Text
5. Cutoff Text

5.EXPERIENCED
Sr.no Column Name Data Type
1. Username Text
2. Exp Years Text
3. Company Text
4. Desigination Text
5. Salary Text
6. ComAddress Text

6.JOB DETAILS
Sr.no Column Name Data Type
1. JobId Text
2. Post Text
3. Criteria Text
4. No. of Vacancies Text
5. Salary Text
6. LastDate Text

7.LOGIN
Sr.no Column Name Data Type
1. UserName Text
2. Password Text
3. Status Text

8.QUSETION TABLE
Sr.no Column Name Data Type
1. JobId Text
2. ExamId Text
3. QuestionNo Number
4. Question Text
5. Option1 Text
6. Option2 Text
7. Option3 Text
8. Option4 Text
9. Answer Text

9.RESULT TABLE
Sr.no Column Name Data Type
1. StudentId Text
2. examId Text
3. Jobid Text
4. Mark Number

You might also like