Scribd
Upload
15 views4 pages

Database Schema for Sales Management

The document describes the structure of 6 database tables - sales, tbl_admin, tbl_inventory, tbl_ordering, tbl_product, and tbl_users. Each table definition includes the table columns, column types, whether columns can be null, default values, indexes, and other properties. Primary keys are defined for each table.

Uploaded by

nico
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
15 views4 pages

Database Schema for Sales Management

The document describes the structure of 6 database tables - sales, tbl_admin, tbl_inventory, tbl_ordering, tbl_product, and tbl_users. Each table definition includes the table columns, column types, whether columns can be null, default values, indexes, and other properties. Primary keys are defined for each table.

Uploaded by

nico
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

sales

Column Type Null Default Links to Comments MIME


sales_id (Primary
int(11) No
)
daily_sales double No
weekly_sales double No
monthly_sales double No
annual_sales double No
total_sales double No

Indexes

Colum Nul
Keyname Type Unique Packed Cardinality Collation Comment
n l
PRIMAR
BTREE Yes No sales_id 0 A No
Y

tbl_admin
Column Type Null Default Links to Comments MIME
id (Primary
int(15) No
)
varchar(15
username No
)
varchar(15
password No
)

Indexes

Colum Nul
Keyname Type Unique Packed Cardinality Collation Comment
n l
PRIMAR
BTREE Yes No id 0 A No
Y

tbl_inventory
Column Type Null Default Links to Comments MIME
invent_ID (Primary
int(20) No
)
prod_ID int(20) No
invent_quantity int(20) No
varchar(20
invent_date No
)

Indexes

Uniqu Nul
Keyname Type Packed Column Cardinality Collation Comment
e l
PRIMAR invent_I
BTREE Yes No 0 A No
Y D

tbl_ordering
Column Type Null Default Links to Comments MIME
order_ID (Primary
int(20) No
)
prod_ID int(20) No
order_quantity int(20) No
user_ID int(20) No
varchar(20
order_date No
)

Indexes

Collatio
Keyname Type Unique Packed Column Cardinality Null Comment
n
PRIMAR order_I
BTREE Yes No 0 A No
Y D

tbl_product
Column Type Null Default Links to Comments MIME
prod_ID (Primary int(20) No
)
varchar(20
prod_name No
)
varchar(20
prod_description No
)
varchar(20
prod_image No
)

Indexes

Colum Nul
Keyname Type Unique Packed Cardinality Collation Comment
n l
PRIMAR
BTREE Yes No prod_ID 2 A No
Y

tbl_users
Column Type Null Default Links to Comments MIME
user_ID (Primary
int(20) No
)
users_fname varchar(50) No
users_mname varchar(50) No
users_lname varchar(50) No
users_address varchar(50) No
users_cn varchar(50) No
varchar(200
users_image No
)

Indexes

Colum Nul
Keyname Type Unique Packed Cardinality Collation Comment
n l
PRIMAR BTREE Yes No user_ID 0 A No
Colum Nul
Keyname Type Unique Packed Cardinality Collation Comment
n l
Y

You might also like