KEMBAR78
Data Dictionary | PDF | Information Technology | Computer Programming
Scribd
Upload
14 views5 pages

Data Dictionary

The document provides a detailed schema of the 'boutiqa' database, including tables such as 'address', 'admin', 'bulkemail', 'buyercart', 'login', 'product', 'register', 'storeproduct', 'storeratingreview', 'storesalesrevenue', and their respective columns, types, nullability, and indexes. Each table has a primary key and some have additional indexes defined. Views are also mentioned for certain tables, indicating their structure without defined indexes.

Uploaded by

Faiq Dzihnan
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
14 views5 pages

Data Dictionary

The document provides a detailed schema of the 'boutiqa' database, including tables such as 'address', 'admin', 'bulkemail', 'buyercart', 'login', 'product', 'register', 'storeproduct', 'storeratingreview', 'storesalesrevenue', and their respective columns, types, nullability, and indexes. Each table has a primary key and some have additional indexes defined. Views are also mentioned for certain tables, indicating their structure without defined indexes.

Uploaded by

Faiq Dzihnan
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/ 5

3/16/23, 4:00 localhost / 127.0.0.

1 / boutiqa |
PM phpMyAdmin 5.2.0
boutiqa

address

Column Type Null Default Comments

RegisterID (Primary) int(11) No

Address (Primary) varchar(256) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

RegisterID 6 A No
PRIMARY BTREE Yes No
Address 6 A No

addressview
Table comments: VIEW

Column Type Null Default Comments

FirstName varchar(256) No

LastName varchar(256) No

Address varchar(256) No

No index defined!

admin

Column Type Null Default Comments

AdminID (Primary) int(11) No

AdminEmailAddress varchar(256) No

AdminPassword varchar(256) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No AdminID 3 A No

bulkemail

localhost/phpmyadmin/index.php?route=/database/data-dictionary&db=boutiqa&goto=index.php%3Froute%3D 1
3/16/23, 4:00 localhost / 127.0.0.1 / boutiqa |
PM phpMyAdmin 5.2.0
Column Type Null Default Comments

AdminID (Primary) int(11) No

BulkEmailID (Primary) int(11) No

Receiver varchar(256) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

AdminID 4 A No
PRIMARY BTREE Yes No
BulkEmailID 4 A No

bulkemailview
Table comments: VIEW

Column Type Null Default Comments

AdminEmailAddress varchar(256) No

BulkEmailID int(11) No

Receiver varchar(256) No

No index defined!

buyercart

Column Type Null Default Comments

BuyerID (Primary) int(11) No

CartID (Primary) int(11) No

CartItem (Primary) varchar(256) No

Quantity int(11) No

Price decimal(19,2) No

TotalPrice decimal(19,2) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No BuyerID 6 A No

CartID 6 A No

localhost/phpmyadmin/index.php?route=/database/data-dictionary&db=boutiqa&goto=index.php%3Froute%3D 2
3/16/23, 4:00 localhost / 127.0.0.1 / boutiqa |
PM phpMyAdmin 5.2.0
Keyname Type Unique Packed Column Cardinality Collation Null Comment

CartItem 6 A No

login

Column Type Null Default Comments

LoginID (Primary) int(11) No

Email varchar(256) No

Password varchar(256) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No LoginID 5 A No

product
Table comments: VIEW

Column Type Null Default Comments

ProductName varchar(256) No

Price decimal(19,2) No

No index defined!

register

Column Type Null Default Comments

RegisterID (Primary) int(11) No

FirstName varchar(256) No

LastName varchar(256) No

Username varchar(256) No

BirthDate date No

Gender varchar(256) No

Email varchar(256) No

Password varchar(256) No

localhost/phpmyadmin/index.php?route=/database/data-dictionary&db=boutiqa&goto=index.php%3Froute%3D 3
3/16/23, 4:00 localhost / 127.0.0.1 / boutiqa |
PM phpMyAdmin 5.2.0
Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No RegisterID 7 A No

storeproduct

Column Type Null Default Comments

SellerID int(11) No

StoreID int(11) No

ProductName varchar(256) No

Price decimal(19,2) No

ProductRating int(11) No

ProductReview int(11) No

Stock int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

idx_product BTREE No No ProductName 8 A No

storeratingreview

Column Type Null Default Comments

SellerID (Primary) int(11) No

StoreID (Primary) int(11) No

StoreName varchar(256) No

StoreRating int(11) No

StoreReview int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

SellerID 6 A No
PRIMARY BTREE Yes No
StoreID 6 A No

localhost/phpmyadmin/index.php?route=/database/data-dictionary&db=boutiqa&goto=index.php%3Froute%3D 4
3/16/23, 4:00 localhost / 127.0.0.1 / boutiqa |
PM phpMyAdmin 5.2.0

storerevenueview
Table comments: VIEW

Column Type Null Default Comments

StoreName varchar(256) No

StoreSales int(11) No

StoreRevenue decimal(19,2) No

No index defined!

storesalesrevenue

Column Type Null Default Comments

StoreID (Primary) int(11) No

StoreSales int(11) No

StoreRevenue decimal(19,2) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No StoreID 6 A No

storeview
Table comments: VIEW

Column Type Null Default Comments

StoreName varchar(256) No

ProductName varchar(256) No

No index defined!

localhost/phpmyadmin/index.php?route=/database/data-dictionary&db=boutiqa&goto=index.php%3Froute%3D 5

You might also like