Scribd
Upload
18 views2 pages

Database Table

The document outlines the structure of four database tables: User/client, Manager, Server, and Codespeech, detailing fields, data types, constraints, and descriptions. Each table contains essential information such as user names, contact details, manager IDs, server configurations, and codespeech identifiers. The constraints include primary keys and not null requirements to ensure data integrity.

Uploaded by

AvDesh Vats
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
18 views2 pages

Database Table

The document outlines the structure of four database tables: User/client, Manager, Server, and Codespeech, detailing fields, data types, constraints, and descriptions. Each table contains essential information such as user names, contact details, manager IDs, server configurations, and codespeech identifiers. The constraints include primary keys and not null requirements to ensure data integrity.

Uploaded by

AvDesh Vats
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/ 2

1.

User/client database table


S no. field datatype constraint description
1 Name Char(10) Primary key User_name

2 address Varchar(25) Not null User_address


3 Contact no. Varhcar(10) Not null Contact number

4 Cust. id Varchar(20) Not null Cust_id

5 Office address Varchar(20) Not null Office address

2. Manager database

S no. field datatype constraint descriptio


n
1 M_id Varchar(1 Not null Manager
0) ID
2 M_phone Varchar(1 Not null Manager
no. 0) phone no.
3 M_addres Varchar(1 Not null Manager
s 0) address
4 M_email Varchar(1 Not null Manager
0) mail
3.server databse

Serial no. field datatype constraint descriptio


n
1 Serv_nam Varchar(1 Not null Server
e 0) name
2 Ser_ID Varchar(2 Not null Server id
0)
3 Ser_confi Varchar(1 Not null Server
g 5) configurat
ion
4 devices Varchar(1 Not null Devices
0) connected

4. Codespeech

Serial no. field datatype contraint devices


1 CS_id Char(20) Not null Codespee
ch ID
2 CS_no. Char(20) Not null Codepeec
h number
3 CS_type Char(20) Foreign Codespee
key ch type

You might also like