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
icon
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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education