.idea/dataSources.ids
<?xml version="1.0" encoding="UTF-8"?>
<component name="dataSourceStorage">
<data-source name="Rails hermoine: development" uuid="80136a92-346f-4ac3-bb00-d7aa943ddb08">
<database-info product="SQLite" version="3.8.9" jdbc-version="2.1" driver-name="SQLiteJDBC" driver-version="native"/>
<case-sensitivity plain-identifiers="mixed" quoted-identifiers="mixed"/>
<schema name="" catalog=""/>
<table name="assignments" schema="" catalog="" type="TABLE">
<column name="professor_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="course_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<index name="index_assignments_on_course_id" unique="true" columns="course_id"/>
<index name="index_assignments_on_professor_id" unique="true" columns="professor_id"/>
</table>
<table name="courses" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="ccn" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="title" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="abbreviation" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="location" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="days" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="start_time" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="end_time" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="professors" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="name" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="department" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="email" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="request_copy" sqlType="BOOLEAN" precision="0" scale="-1" nullable="true" jdbcType="4" def="J2Yn"/>
<column name="notification" sqlType="BOOLEAN" precision="0" scale="-1" nullable="true" jdbcType="4" def="J2Yn"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="requests" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="comments" sqlType="TEXT" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="status" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4" def="MA=="/>
<column name="format" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="course_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
<index name="index_requests_on_course_id" unique="true" columns="course_id"/>
</table>
<table name="schema_migrations" schema="" catalog="" type="TABLE">
<column name="version" sqlType="VARCHAR" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<index name="unique_schema_migrations" unique="true" columns="version"/>
</table>
<table name="sqlite_sequence" schema="" catalog="" type="TABLE">
<column name="name" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="seq" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
</table>
</data-source>
<data-source name="Rails hermoine: test" uuid="174009cf-a66d-40ed-898e-fd6a3a23795e">
<database-info product="SQLite" version="3.8.9" jdbc-version="2.1" driver-name="SQLiteJDBC" driver-version="native"/>
<case-sensitivity plain-identifiers="mixed" quoted-identifiers="mixed"/>
<schema name="" catalog=""/>
<table name="assignments" schema="" catalog="" type="TABLE">
<column name="professor_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="course_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<index name="index_assignments_on_professor_id" unique="true" columns="professor_id"/>
<index name="index_assignments_on_course_id" unique="true" columns="course_id"/>
</table>
<table name="courses" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="ccn" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="title" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="location" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="days" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="time" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="request_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
<index name="index_courses_on_request_id" unique="true" columns="request_id"/>
</table>
<table name="professors" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="name" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="department" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="requests" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="comments" sqlType="TEXT" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="status" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="schema_migrations" schema="" catalog="" type="TABLE">
<column name="version" sqlType="VARCHAR" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<index name="unique_schema_migrations" unique="true" columns="version"/>
</table>
<table name="sqlite_sequence" schema="" catalog="" type="TABLE">
<column name="name" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="seq" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
</table>
</data-source>
<data-source name="Rails hermoine: cucumber" uuid="fc1b8715-663f-4cc7-bbcf-011792bf3fcd">
<database-info product="SQLite" version="3.8.9" jdbc-version="2.1" driver-name="SQLiteJDBC" driver-version="native"/>
<case-sensitivity plain-identifiers="mixed" quoted-identifiers="mixed"/>
<schema name="" catalog=""/>
<table name="assignments" schema="" catalog="" type="TABLE">
<column name="professor_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="course_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<index name="index_assignments_on_professor_id" unique="true" columns="professor_id"/>
<index name="index_assignments_on_course_id" unique="true" columns="course_id"/>
</table>
<table name="courses" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="ccn" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="title" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="location" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="days" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="time" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="request_id" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
<index name="index_courses_on_request_id" unique="true" columns="request_id"/>
</table>
<table name="professors" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="name" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="department" sqlType="VARCHAR" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="requests" schema="" catalog="" type="TABLE">
<column name="id" sqlType="INTEGER" precision="0" scale="-1" nullable="false" jdbcType="4"/>
<column name="comments" sqlType="TEXT" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="status" sqlType="INTEGER" precision="0" scale="-1" nullable="true" jdbcType="4"/>
<column name="created_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<column name="updated_at" sqlType="DATETIME" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<primary-key columns="id"/>
</table>
<table name="schema_migrations" schema="" catalog="" type="TABLE">
<column name="version" sqlType="VARCHAR" precision="0" scale="-1" nullable="false" jdbcType="12"/>
<index name="unique_schema_migrations" unique="true" columns="version"/>
</table>
<table name="sqlite_sequence" schema="" catalog="" type="TABLE">
<column name="name" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
<column name="seq" sqlType="" precision="0" scale="-1" nullable="true" jdbcType="12"/>
</table>
</data-source>
</component>