[go: up one dir, main page]
Scribd
Upload
9 views1 page

Correction

The document outlines the structure of the 'bookings' table, which is designed to store booking details with a primary key of 'booking_id' and foreign keys 'user_id' and 'consulting_id'. It includes fields for date, booking date, status, and time, all of which are required. The table is part of a database for the Department of Computer Applications at Christ College, Puliyanmala.

Uploaded by

blessonsunil26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

Correction

The document outlines the structure of the 'bookings' table, which is designed to store booking details with a primary key of 'booking_id' and foreign keys 'user_id' and 'consulting_id'. It includes fields for date, booking date, status, and time, all of which are required. The table is part of a database for the Department of Computer Applications at Christ College, Puliyanmala.

Uploaded by

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

5.1.

2 Table
Table Name : bookings
Description : to store the booking details
Primary Key : booking _id
Foreign Key : user_id, consulting_id

Sl. Field Name Data Type Constraints Description


No
1. booking _id Int(11) Primary key Auto increment for uniquely
identifying id.

2. user_id Int(11) Not null To get student id

3. consulting_id int(10) Not null To store consulting id

4 date_time Varchar(20) Not null To set date and time


5. book_date Varchar(20) Not null To set booking date
6. status Varchar(20) Not null To set the status

7. time Varchar(20) Not null To select time stot

DEPARTMENT OF COMPUTER APPLICATION CHRIST COLLEGE, PULIYANMALA

You might also like