describe Donors; +----------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+----------------+ | donor_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | donor_uname | varchar(255) | YES | | NULL | | | donor_email | varchar(255) | YES | | NULL | | | donor_password | varchar(255) | YES | | NULL | | | donor_fname | varchar(255) | YES | | NULL | | | donor_lname | varchar(255) | YES | | NULL | | | donor_type | varchar(255) | YES | | NULL | | +----------------+------------------+------+-----+---------+----------------+ SELECT * FROM Donors; +----------+--------------+---------------------+--------------------------------------------------------------+-------------+-------------+------------+ | donor_id | donor_uname | donor_email | donor_password | donor_fname | donor_lname | donor_type | +----------+--------------+---------------------+--------------------------------------------------------------+-------------+-------------+------------+ | 1 | test | test@test.com | $2y$10$uaZ0BT7V0zUtxEplzdW0H.nUSpf4YCxgqLAhzpUSTAtI2asyeBo8O | John | Smith | Faculty | | 2 | acoleman13 | acoleman13@csub.edu | $2y$10$iHGZuREzfTDOYHqiKieZ0.K4zQspDEF9sIvanMI.L73AdnNi7Jzra | Allison | Coleman | Staff | | 8 | testusername | test@email.com | $2y$10$YKlXmi.mwFNxFRhCqMpbxuq7HiDs4mtihbLok5zaAAKu0L0VHU3kK | Billy | Bob | Student | | 9 | pigoa2 | pigoa2@csub.edu | $2y$10$t1aVYIWiT4fSXUlnri33NeH5eIrfH4dfA5ykwj0OCNP1ohlIWj76. | Pierre | Igoa | Staff | | 10 | bboop | bboop@gmail.com | $2y$10$VfUIhO3KutK6GNjN./RDduIXZTcZ11T2DClAItDutgenaa6R8lGeG | Betty | Boop | Student | +----------+--------------+---------------------+--------------------------------------------------------------+-------------+-------------+------------+ describe Funds; +------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+----------------+ | fund_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fund_name | varchar(255) | YES | | NULL | | | fund_img | varchar(127) | YES | | NULL | | | fund_description | varchar(511) | YES | | NULL | | +------------------+------------------+------+-----+---------+----------------+ SELECT * FROM Funds; +---------+----------------------------------------------------------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | fund_id | fund_name | fund_img | fund_description | +---------+----------------------------------------------------------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | Stiern Library | stiern-library.jpg | Supports the library's collections and programs | | 2 | School of Arts and Humanities | ah.jpg | Supports the School of Arts and Humanities | | 3 | School of Business and Public Administration | bpa.jpg | Prepares graduates to make knowledge-based decisions to address challenging issues facing organizational leaders in our region | | 4 | School of Natural Sciences, Mathematics, and Engineering | nsme.jpg | Supports the seven departments within the School of Natural Sciences, Mathematics, and Engineering | | 5 | School of Social Sciences and Education | sse.jpg | Prepares students to become skilled professional practitioners in counseling specialties, educational leadership, teacher education, special education, and social work | | 6 | Roadrunner Athletic Scholarship Fund | roadrunner-athletic.jpg | Provides aid to student-athletes who are up to the challenge of Division I competition AND the rigors of college life | | 7 | Alumni Scholarship Fund for Graduate Students | alumni-scholarship.jpg | Helps CSUB alumni receive scholarship money toward their graduate degrees at CSU Bakersfield | | 8 | University Counselor Training Clinic | university-counselor.jpg | Provides reduced-cost counseling services to low income and under-insured Kern area residents | +---------+----------------------------------------------------------+--------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ describe Pledge_Details; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | pledge_line_number | int(10) unsigned | NO | PRI | NULL | auto_increment | | pledge_amount | decimal(13,4) | YES | | NULL | | | pledge_fund_name | varchar(255) | YES | | NULL | | | pledge_id | int(10) unsigned | YES | | NULL | | | pledge_donor_type | varchar(255) | YES | | NULL | | | pledge_fund_img | varchar(127) | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ SELECT * FROM Pledge_Details; +--------------------+---------------+----------------------------------------------------------+-----------+-------------------+--------------------------+ | pledge_line_number | pledge_amount | pledge_fund_name | pledge_id | pledge_donor_type | pledge_fund_img | +--------------------+---------------+----------------------------------------------------------+-----------+-------------------+--------------------------+ | 1 | 100.0000 | School of Social Sciences and Education | 11 | Staff | sse.jpg | | 2 | 25.0000 | Alumni Scholarship Fund for Graduate Students | 12 | Staff | alumni-scholarship.jpg | | 3 | 50.0000 | Stiern Library | 12 | Staff | stiern-library.jpg | | 4 | 30.0000 | University Counselor Training Clinic | 12 | Staff | university-counselor.jpg | | 6 | 50.0000 | Roadrunner Athletic Scholarship Fund | 14 | Student | roadrunner-athletic.jpg | | 7 | 25.0000 | School of Arts and Humanities | 15 | Faculty | ah.jpg | | 8 | 25.0000 | School of Business and Public Administration | 15 | Faculty | bpa.jpg | | 9 | 25.0000 | School of Natural Sciences, Mathematics, and Engineering | 15 | Faculty | nsme.jpg | | 10 | 25.0000 | School of Social Sciences and Education | 15 | Faculty | sse.jpg | | 11 | 100.0000 | School of Arts and Humanities | 16 | Staff | ah.jpg | | 12 | 0.0000 | School of Social Sciences and Education | 16 | Staff | sse.jpg | | 13 | 50.0000 | Alumni Scholarship Fund for Graduate Students | 16 | Staff | alumni-scholarship.jpg | | 14 | 1000.0000 | Stiern Library | 17 | Staff | stiern-library.jpg | | 15 | 3000.0000 | School of Natural Sciences, Mathematics, and Engineering | 17 | Staff | nsme.jpg | | 16 | 1500.0000 | School of Business and Public Administration | 17 | Staff | bpa.jpg | | 17 | 101.0200 | University Counselor Training Clinic | 18 | Staff | university-counselor.jpg | | 18 | 101.3500 | Stiern Library | 18 | Staff | stiern-library.jpg | | 19 | 500.0000 | School of Natural Sciences, Mathematics, and Engineering | 18 | Staff | nsme.jpg | | 20 | 100.0000 | Stiern Library | 19 | Staff | stiern-library.jpg | | 21 | 200.0000 | School of Arts and Humanities | 19 | Staff | ah.jpg | | 22 | 700.0000 | School of Business and Public Administration | 19 | Staff | bpa.jpg | | 23 | 150.5000 | Alumni Scholarship Fund for Graduate Students | 20 | Staff | alumni-scholarship.jpg | | 27 | 100.0000 | Alumni Scholarship Fund for Graduate Students | 24 | Faculty | alumni-scholarship.jpg | +--------------------+---------------+----------------------------------------------------------+-----------+-------------------+--------------------------+ describe Pledges; +--------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------------+------+-----+---------+----------------+ | pledge_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | pledge_date | date | YES | | NULL | | | pledge_donor_fname | varchar(255) | YES | | NULL | | | pledge_donor_lname | varchar(255) | YES | | NULL | | | pledge_donor_type | varchar(255) | YES | | NULL | | | pledge_donor_id | int(10) unsigned | YES | | NULL | | +--------------------+------------------+------+-----+---------+----------------+ SELECT * FROM Pledges; +-----------+-------------+--------------------+--------------------+-------------------+-----------------+ | pledge_id | pledge_date | pledge_donor_fname | pledge_donor_lname | pledge_donor_type | pledge_donor_id | +-----------+-------------+--------------------+--------------------+-------------------+-----------------+ | 11 | 2018-04-28 | Allison | Coleman | Staff | 2 | | 12 | 2018-04-28 | Allison | Coleman | Staff | 2 | | 14 | 2018-05-06 | Billy | Bob | Student | 8 | | 15 | 2018-05-06 | John | Smith | Faculty | 1 | | 16 | 2018-05-08 | Allison | Coleman | Staff | 2 | | 17 | 2018-05-08 | Pierre | Igoa | Staff | 9 | | 18 | 2018-05-08 | Pierre | Igoa | Staff | 9 | | 19 | 2018-05-08 | Pierre | Igoa | Staff | 9 | | 20 | 2018-05-08 | Pierre | Igoa | Staff | 9 | | 24 | 2018-05-09 | John | Smith | Faculty | 1 | +-----------+-------------+--------------------+--------------------+-------------------+-----------------+