Home › Forums › [Internship Web Application] Internship Database: So we aren't actually using the google form at all? › [Internship Web Application] Internship Database: No. It’s just being used to help create the database schem… › [Internship Web Application] Internship Database: Here's what the database table schema generated from the CSV file …
-
Here's what the database table schema generated from the CSV file looks like:
+—————————————-+————–+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+—————————————-+————–+——+—–+———+—————-+
| __ds_rec_id | int(11) | NO | PRI | NULL | auto_increment |
| timestamp_0 | varchar(64) | YES | | NULL | |
| title_of_the_internship_1 | varchar(64) | YES | | NULL | |
| organization_name_2 | varchar(64) | YES | | NULL | |
| organization_type_3 | varchar(64) | YES | | NULL | |
| description_of_the_internship_4 | text | YES | | NULL | |
| contact_number_5 | varchar(64) | YES | | NULL | |
| contact_email_6 | varchar(256) | YES | | NULL | |
| website_7 | varchar(64) | YES | | NULL | |
| attachment_8 | text | YES | | NULL | |
| street_9 | varchar(64) | YES | | NULL | |
| city_10 | varchar(64) | YES | | NULL | |
| state_11 | varchar(64) | YES | | NULL | |
| zip_code_12 | bigint(20) | YES | | NULL | |
| start_date_13 | varchar(64) | YES | | NULL | |
| end_date_14 | varchar(64) | YES | | NULL | |
| related_field_of_study_15 | varchar(64) | YES | | NULL | |
| class_16 | varchar(64) | YES | | NULL | |
| stipend_17 | varchar(64) | YES | | NULL | |
| per_18 | varchar(64) | YES | | NULL | |
| hours_of_commitment_19 | bigint(20) | YES | | NULL | |
| per_20 | varchar(64) | YES | | NULL | |
| other_assistance_21 | varchar(64) | YES | | NULL | |
| other_requirements_22 | text | YES | | NULL | |
| describe_other_requirements_23 | text | YES | | NULL | |
| submitter_name__if_not_the_contact__24 | varchar(64) | YES | | NULL | |
| submitter_email_25 | varchar(256) | YES | | NULL | |
+—————————————-+————–+——+—–+———+—————-+