Scribd
Upload
109 views4 pages

Database Table Structures Overview

The document describes the structure of 4 database tables: LOGINS, Book Register, User Register, and Order. The LOGINS table stores user login information with fields for id, username, password, and user type. The Book Register table tracks book information like name, publication, edition, ISBN, author, number of copies, and section. The User Register table contains user details including id, name, student id, gender, date of birth, class, username, and password. The Order table manages order records with fields for order id, ordered book, author, ISBN, number of copies needed, received date, and status.

Uploaded by

kavya
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
109 views4 pages

Database Table Structures Overview

The document describes the structure of 4 database tables: LOGINS, Book Register, User Register, and Order. The LOGINS table stores user login information with fields for id, username, password, and user type. The Book Register table tracks book information like name, publication, edition, ISBN, author, number of copies, and section. The User Register table contains user details including id, name, student id, gender, date of birth, class, username, and password. The Order table manages order records with fields for order id, ordered book, author, ISBN, number of copies needed, received date, and status.

Uploaded by

kavya
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/ 4

LOGINS TABLE

PRIMARY KEY : Id

ATTRIBUTE DATATYPE LENGTH DESCRIPTION


id Int Primary Login Id
username Varchar 20 Username
password Varchar 20 Password
type Varchar 20 User type
Book Register Table

Primary key : Id

ATTRIBUTE DATATYPE LENGTH DESCRIPTION


id Int primary id
bookname Varchar 20 bookname
publication Varchar 20 publication
edition Varchar 20 Book edition
isbn Varchar 20 Book isbn
author Varchar 20 author
copy Varchar 20 copy
section Varchar 20 Book section
User Register Table

Primary key : id

ATTRIBUTE DATATYPE LENGTH DESCRIPTION


id Int primary User id
name Varchar 20 name
uniqueid Varchar 20 Students id
gender Varchar 20 gender
dob Varchar 20 dob
class Varchar 20 User class
username Varchar 20 username
password Varchar 20 Password
Order Table

Primary key : id

ATTRIBUTE DATATYPE LENGTH DESCRIPTION


id int primary Order id
book varchar 20 Ordered book
author varchar 20 author
isbn varchar 20 Book isbn
Need varchar 20 Needed copies
received varchar 20 Received date
status varchar 20 status

You might also like