6 C A 9 O 9 Server 127.0.0.1 Database landmark computers Structure Query SQL Search SQL vo landmark computers product_catagories id: bigint(20) unsigned Ⓒtitle: varchar(225) discription: text created_at: datetime updated_at: datetime Console vo o landmark_computers reviews id: bigint(20) unsigned a user_id: bigint(20) unsigned #product_id: bigint(20) unsigned rating int(11) message: text created_at: datetime updated_at: datetime Olandmark computers users id: bigint(20) unsigned avatar: blob name: varchar(50) email: varchar(50) phone: varchar(50) password: varchar(225) user_type: enum(admin" "customer) created_at: datetime updated_at: datetime Export Import Operations * Privileges landmark computers products O aid: bigint(20) unsigned title: varchar(225) featured_image: blob a description: text seo_keys: text a seo_description: text product_cat_id: bigint(20) unsigned status: enum(draft, published unpublished") is featured: tinyint(1) created_at: datetime updated_at: datetime o landmark computers favourite aid: bigint(20) unsigned product_id: bigint(20) unsigned user_id: bigint(20) unsigned created_at: datetime updated_at: datetime Routines Untitled Events Triggers O landmark computers order_items e id: bigint(20) unsigned a order_id: bigint(20) unsigned product_id: bigint(20) unsigned created_at: datetime updated_at: datetime vo landmark computers payments id: bigint(20) unsigned Oname_of_card: varchar(225) a user_id: bigint(20) unsigned @card_number: varchar(225) explary_data: varchar(225) cw: varchar(225) a total: decimal(11.2) created_at: datetime updated_at: datetime Designer landmark computers orders a id: bigint(20) unsigned ☐user_id: bigint(20) unsigned payment_id: bigint(20) unsigned a shipping_id: bigint(20) unsigned vo landmark computers faqs aid: bigint(20) unsigned questions: varchar(225) answers: varchar(225) is_active: tinyint(1) created_at: datetime updated_at: datetime status: enum(pending","on_the_way delivered "cancel) created_at: datetime updated_at: datetime o landmark computers shipping addresses aid: bigint(20) unsigned first_name: varchar(50) last_name: varchar(50) email: varchar(50) phone: varchar(50) address: varchar(225) country: varchar(50) acity: varchar(50) e postal code: varchar(50) shiping_code: varchar(50) shipping_type: enum(free","notfree) user_id: bigint(20) unsigned created_at: datetime updated_at: datetime O landmark computers queries eid: bigint(20) unsigned name: varchar(225) email: varchar(225) o subject: varchar(225) message: text user_id: bigint(20) by_user_type: enum(guest user') created_at: datetime updated_at: datetime
6 C A 9 O 9 Server 127.0.0.1 Database landmark computers Structure Query SQL Search SQL vo landmark computers product_catagories id: bigint(20) unsigned Ⓒtitle: varchar(225) discription: text created_at: datetime updated_at: datetime Console vo o landmark_computers reviews id: bigint(20) unsigned a user_id: bigint(20) unsigned #product_id: bigint(20) unsigned rating int(11) message: text created_at: datetime updated_at: datetime Olandmark computers users id: bigint(20) unsigned avatar: blob name: varchar(50) email: varchar(50) phone: varchar(50) password: varchar(225) user_type: enum(admin" "customer) created_at: datetime updated_at: datetime Export Import Operations * Privileges landmark computers products O aid: bigint(20) unsigned title: varchar(225) featured_image: blob a description: text seo_keys: text a seo_description: text product_cat_id: bigint(20) unsigned status: enum(draft, published unpublished") is featured: tinyint(1) created_at: datetime updated_at: datetime o landmark computers favourite aid: bigint(20) unsigned product_id: bigint(20) unsigned user_id: bigint(20) unsigned created_at: datetime updated_at: datetime Routines Untitled Events Triggers O landmark computers order_items e id: bigint(20) unsigned a order_id: bigint(20) unsigned product_id: bigint(20) unsigned created_at: datetime updated_at: datetime vo landmark computers payments id: bigint(20) unsigned Oname_of_card: varchar(225) a user_id: bigint(20) unsigned @card_number: varchar(225) explary_data: varchar(225) cw: varchar(225) a total: decimal(11.2) created_at: datetime updated_at: datetime Designer landmark computers orders a id: bigint(20) unsigned ☐user_id: bigint(20) unsigned payment_id: bigint(20) unsigned a shipping_id: bigint(20) unsigned vo landmark computers faqs aid: bigint(20) unsigned questions: varchar(225) answers: varchar(225) is_active: tinyint(1) created_at: datetime updated_at: datetime status: enum(pending","on_the_way delivered "cancel) created_at: datetime updated_at: datetime o landmark computers shipping addresses aid: bigint(20) unsigned first_name: varchar(50) last_name: varchar(50) email: varchar(50) phone: varchar(50) address: varchar(225) country: varchar(50) acity: varchar(50) e postal code: varchar(50) shiping_code: varchar(50) shipping_type: enum(free","notfree) user_id: bigint(20) unsigned created_at: datetime updated_at: datetime O landmark computers queries eid: bigint(20) unsigned name: varchar(225) email: varchar(225) o subject: varchar(225) message: text user_id: bigint(20) by_user_type: enum(guest user') created_at: datetime updated_at: datetime
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
can you please explain this diagram??
![Ⓡ
**
Server: 127.0.0.1 » Database: landmark computers
Structure
SQL
Query
id: bigint(20) unsigned
Ⓒtitle varchar(225)
Ⓒdiscription: text
created_at: datetime
updated_at: datetime
Console
landmark computers product_catagories
Search
v landmark computers reviews
id: bigint(20) unsigned
# user_id: bigint(20) unsigned
# product_id: bigint(20) unsigned
# rating int(11)
Ⓒmessage text
created_at: datetime
updated_at: datetime
VO
landmark computers users
id: bigint(20) unsigned
avatar blob
@name: varchar(50)
@email: varchar(50)
phone: varchar(50)
Ⓒpassword: varchar(225)
> user_type: enum('admin','customer')
created_at: datetime
updated_at: datetime
Export
Import
Operations
Privileges
0 landmark_computers products
id bigint(20) unsigned
Ⓒtitle varchar(225)
featured_image: blob
description: text
Ⓒseo_keys: text
Ⓒseo_description : text
#product_cat_id: bigint(20) unsigned
> status : enum('draft', published", unpublished")
#is_featured tinyint(1)
created_at: datetime
updated_at: datetime
v landmark computers favourite
id: bigint(20) unsigned
# product_id: bigint(20) unsigned
# user_id: bigint(20) unsigned
created_at: datetime.
updated_at: datetime
Routines
Untitled *
Events
v landmark computers order_items
id: bigint(20) unsigned
Triggers
#order_id: bigint(20) unsigned
#product_id: bigint(20) unsigned
created_at: datetime
updated_at: datetime
v landmark computers payments
id: bigint(20) unsigned
Ⓒname_of_card: varchar(225)
# user_id: bigint(20) unsigned
Ⓒ card_number: varchar(225)
expiary_data: varchar(225)
Ⓒcw: varchar(225)
# total decimal(11,2)
created_at: datetime
updated_at: datetime
VO
Designer
landmark_computers orders
id: bigint(20) unsigned
v landmark computers faqs
id: bigint(20) unsigned
Ⓒ questions : varchar(225)
Ⓒanswers varchar(225)
#is_active tinyint(1)
created_at: datetime
updated_at: datetime
# user_id: bigint(20) unsigned
#payment_id: bigint(20) unsigned
# shipping_id: bigint(20) unsigned
> status: enum('pending','on_the_way', 'delivered", 'cancel")
created_at: datetime
updated_at: datetime
◆ landmark computers shipping_addresses
id bigint(20) unsigned
first_name: varchar(50)
elast_name varchar(50)
Ⓒemail: varchar(50)
Ⓒphone : varchar(50)
Ⓒ address : varchar(225)
@country: varchar(50)
city varchar(50)
e postal code varchar(50)
@shiping_code: varchar(50)
shipping_type: enum('free', 'notfree')
# user_id: bigint(20) unsigned
created_at: datetime
updated_at: datetime
O landmark computers queries
id: bigint(20) unsigned
Ⓒ name: varchar(225)
@email: varchar(225)
subject: varchar(225)
message text
# user_id: bigint(20)
by_user_type: enum('guest', 'user')
created_at: datetime
updated_at: datetime](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4734410c-7a6a-4d30-9b44-85998945af15%2Fe3472d02-1e53-45ff-97b2-f0c7b9b990d4%2F02qimrn_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Ⓡ
**
Server: 127.0.0.1 » Database: landmark computers
Structure
SQL
Query
id: bigint(20) unsigned
Ⓒtitle varchar(225)
Ⓒdiscription: text
created_at: datetime
updated_at: datetime
Console
landmark computers product_catagories
Search
v landmark computers reviews
id: bigint(20) unsigned
# user_id: bigint(20) unsigned
# product_id: bigint(20) unsigned
# rating int(11)
Ⓒmessage text
created_at: datetime
updated_at: datetime
VO
landmark computers users
id: bigint(20) unsigned
avatar blob
@name: varchar(50)
@email: varchar(50)
phone: varchar(50)
Ⓒpassword: varchar(225)
> user_type: enum('admin','customer')
created_at: datetime
updated_at: datetime
Export
Import
Operations
Privileges
0 landmark_computers products
id bigint(20) unsigned
Ⓒtitle varchar(225)
featured_image: blob
description: text
Ⓒseo_keys: text
Ⓒseo_description : text
#product_cat_id: bigint(20) unsigned
> status : enum('draft', published", unpublished")
#is_featured tinyint(1)
created_at: datetime
updated_at: datetime
v landmark computers favourite
id: bigint(20) unsigned
# product_id: bigint(20) unsigned
# user_id: bigint(20) unsigned
created_at: datetime.
updated_at: datetime
Routines
Untitled *
Events
v landmark computers order_items
id: bigint(20) unsigned
Triggers
#order_id: bigint(20) unsigned
#product_id: bigint(20) unsigned
created_at: datetime
updated_at: datetime
v landmark computers payments
id: bigint(20) unsigned
Ⓒname_of_card: varchar(225)
# user_id: bigint(20) unsigned
Ⓒ card_number: varchar(225)
expiary_data: varchar(225)
Ⓒcw: varchar(225)
# total decimal(11,2)
created_at: datetime
updated_at: datetime
VO
Designer
landmark_computers orders
id: bigint(20) unsigned
v landmark computers faqs
id: bigint(20) unsigned
Ⓒ questions : varchar(225)
Ⓒanswers varchar(225)
#is_active tinyint(1)
created_at: datetime
updated_at: datetime
# user_id: bigint(20) unsigned
#payment_id: bigint(20) unsigned
# shipping_id: bigint(20) unsigned
> status: enum('pending','on_the_way', 'delivered", 'cancel")
created_at: datetime
updated_at: datetime
◆ landmark computers shipping_addresses
id bigint(20) unsigned
first_name: varchar(50)
elast_name varchar(50)
Ⓒemail: varchar(50)
Ⓒphone : varchar(50)
Ⓒ address : varchar(225)
@country: varchar(50)
city varchar(50)
e postal code varchar(50)
@shiping_code: varchar(50)
shipping_type: enum('free', 'notfree')
# user_id: bigint(20) unsigned
created_at: datetime
updated_at: datetime
O landmark computers queries
id: bigint(20) unsigned
Ⓒ name: varchar(225)
@email: varchar(225)
subject: varchar(225)
message text
# user_id: bigint(20)
by_user_type: enum('guest', 'user')
created_at: datetime
updated_at: datetime
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education