README.md (744B)
1 # Using Database Schema 2 3 ## Installation 4 5 1) Create a new empty database: 6 7 ``` 8 CREATE DATABASE db; 9 ``` 10 11 2) Import schema 12 13 ``` 14 mysql -u username -p database_name < db.sql 15 ``` 16 17 ## Tables and Attributes 18 19 ### User 20 21 * user_id 22 * first_name 23 * middle_name 24 * last_name 25 * user_email 26 27 ### Proposal 28 29 * proposal_id 30 * proposal_parent_id 31 * proposal_name 32 * cover_sheet 33 * template 34 * library_form 35 * consult_letter 36 * author 37 * date 38 * accepted 39 * need_library_form 40 * cover_type 41 * template_type 42 43 ### Cover Sheet 44 45 * cover_id 46 * cover_file_path 47 * cover_parent_id 48 49 ### Template 50 51 * template_id 52 * template_file_path 53 54 ### Library Form 55 56 * library_form_id 57 * library_form_file_path 58 59 ### Consult Letter 60 61 * consult_letter_id 62 * consult_letter_file_path 63 * consult_letter_parent_id