fembod

Database Name: fembod Tables: Category Content of the extract/topic of the quote Genre Literary genre of the text S_Keyword Keyword used to find that piece of text Search Keyword è Name changed into s.keyword = search keyword Source Author name + title + century (- = BC ǀ empty = AD) Texts It includes all the quotations. Details: Keyword (connect to Table keyword and the ids DONE) + Source (connect with Source table) + Chapter + Paragraph + Verse + Greek + English + Category (connect to category table) + Notes Plutarch Moralia  specific book specified in Chapter Plutarch Lives  specific book specified in Chapter Links Link to LOEB Classical Library or Perseus Scaife Viewer Images How can I insert image files? Link? Id + source + image + category (connect with category table) + notes ID numbers? 2.22.24 I transferred the database from my computer to a server at the Faculty of Arts so that it has a daily backup, is accessible to me from any computer, is more secure, and allows more people to work on it—making collaboration easier. Popular Commands: - Temporary table created called temporanea in which IDs of sources match. Next move: substitute in the general table texts the sources column with their IDs. -- questo e’ un commento /*questo e’un commento*/ - ON = matchs, couples, e.g. select*from texts t left join category c on c.category = t.category - How to substitute a column with proper values with a column with IDs: UPDATE texts SET category_id = (SELECT id FROM category c WHERE c.category = texts.category); - UPDATE texts SET section = ‘’ WHERE section is null - Create authors table: Creare tabella autori: CREATE TABLE SELECT DISTINCT author from source; = only once, do not repeat the same author more than once. - Fill in the table: comando INSERT INSERT INTO author (author, date1, date2) SELECT (distinct author, date1, date2 FROM source; JOIN TABLE SELECT * FROM texts t left join source s on t.source_id left join genre g on g genre = s.genre left join category c on t.category_id = c.id; 26.2: update - Link Table created – Substituted column with Greek quote + link with 2 separate columns: Greek quote / Link ID: SELECT a.author, s.title, t.greek_quote FROM texts t LEFT JOIN source s ON t.source_id = s.id LEFT JOIN genre g ON g.id = s.genre_id LEFT JOIN category c ON t.category_id = c.id LEFT JOIN s_keyword sk ON sk.id = t.s_keyword_id LEFT JOIN author a ON a.id = s.author_id LEFT JOIN link l ON l.text_id = t.id WHERE sk.keyword = 'Woman';