showcase schema difference

gistfile1.txt

showcase                                                                                                                                                        production

+--------------------------+--------------------------+------------------------------------------------------------------+                                    │+--------------------------+--------------------------+------------------------------------------------------------------+
| Column                   | Type                     | Modifiers                                                        |                                    │| Column                   | Type                     | Modifiers                                                        |
|--------------------------+--------------------------+------------------------------------------------------------------|                                    │|--------------------------+--------------------------+------------------------------------------------------------------|
| id                       | integer                  |  not null default nextval('"MAT_Survey_SurveyId_seq"'::regclass) |                                    │| id                       | integer                  |  not null default nextval('"MAT_Survey_SurveyId_seq"'::regclass) |
| surveyname               | character varying(500)   |  not null                                                        |                                    │| surveyname               | character varying(500)   |  not null                                                        |
| creationdate             | timestamp with time zone |                                                                  |                                    │| creationdate             | timestamp with time zone |                                                                  |
| datesubmittedforapproval | timestamp with time zone |                                                                  |                                    │| datesubmittedforapproval | timestamp with time zone |                                                                  |
| approved                 | boolean                  |  not null                                                        |                                    │| approved                 | boolean                  |  not null                                                        |
| approveddate             | timestamp with time zone |                                                                  |                                    │| approveddate             | timestamp with time zone |                                                                  |
| read_out_date            | date                     |                                                                  |                                    │| read_out_date            | date                     |                                                                  |
| active                   | boolean                  |  not null                                                        |                                    │| active                   | boolean                  |  not null                                                        |
| approved_by_id           | integer                  |                                                                  |                                    │| approved_by_id           | integer                  |                                                                  |
| user_id                  | integer                  |  not null                                                        |                                    │| user_id                  | integer                  |  not null                                                        |
| configured               | boolean                  |                                                                  |                                    │| configured               | boolean                  |                                                                  |
| startdate                | date                     |                                                                  |                                    │| startdate                | date                     |                                                                  |
| sharereport              | boolean                  |  not null                                                        |                                    │| sharereport              | boolean                  |  not null                                                        |
| shareresponses           | boolean                  |  not null                                                        |                                    │| shareresponses           | boolean                  |  not null                                                        |
| completeddate            | timestamp with time zone |                                                                  |                                    │| completeddate            | timestamp with time zone |                                                                  |
| submitted_by_id          | integer                  |                                                                  |                                    │| submitted_by_id          | integer                  |                                                                  |
| closed_date              | timestamp with time zone |                                                                  |                                    │| closed_date              | timestamp with time zone |                                                                  |
| project_id               | integer                  |  not null                                                        |                                    │| project_id               | integer                  |  not null                                                        |
| closed_reopen            | boolean                  |  not null                                                        |                                    │| closed_reopen            | boolean                  |  not null                                                        |
| closed_by_id             | integer                  |                                                                  |                                    │| closed_by_id             | integer                  |                                                                  |
| completed_by_id          | integer                  |                                                                  |                                    │| completed_by_id          | integer                  |                                                                  |
| end_date                 | date                     |                                                                  |                                    │| end_date                 | date                     |                                                                  |
| multi_page               | boolean                  |  not null                                                        |                                    │| multi_page               | boolean                  |  not null                                                        |
| allow_correction         | boolean                  |  not null                                                        |                                    │| allow_correction         | boolean                  |  not null                                                        |
| status                   | character varying(22)    |  not null                                                        |                                    │| status                   | character varying(22)    |  not null                                                        |
| status_new               | character varying(22)    |  not null                                                        |                                    │+--------------------------+--------------------------+------------------------------------------------------------------+
+--------------------------+--------------------------+------------------------------------------------------------------+                                    │Indexes:
Indexes:                                                                                                                                                      │    "MAT_Survey_pkey" PRIMARY KEY, btree (id)
    "MAT_Survey_pkey" PRIMARY KEY, btree (id)                                                                                                                 │    "idx_mat_survey_project" UNIQUE, btree (project_id)
    "mat_survey_project_id_key" UNIQUE CONSTRAINT, btree (project_id)                                                                                         │    "mat_survey_project_id_key" UNIQUE CONSTRAINT, btree (project_id)
    "MAT_Survey_ApprovedById_c178977a" btree (approved_by_id)                                                                                                 │    "MAT_Survey_ApprovedById_c178977a" btree (approved_by_id)
    "MAT_Survey_UserId_5fc3d17e" btree (user_id)                                                                                                              │    "MAT_Survey_UserId_5fc3d17e" btree (user_id)
    "mat_survey_closed_by_id_d6b0707a" btree (closed_by_id)                                                                                                   │    "mat_survey_closed_by_id_d6b0707a" btree (closed_by_id)
    "mat_survey_completed_by_id_db2530d1" btree (completed_by_id)                                                                                             │    "mat_survey_completed_by_id_db2530d1" btree (completed_by_id)
    "mat_survey_status_7f2655a4" btree (status)                                                                                                               │    "mat_survey_status_7f2655a4" btree (status)
:                                                                                                                                                             │: