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

See similar textbooks

Related questions

Question

can you please explain this diagram??

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

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.