/magstudentportal/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/magstudentportal/trunk

« back to all changes in this revision

Viewing changes to src/main/resources/create_tables.sql

  • Committer: Gustav Hartvigsson
  • Date: 2017-08-15 07:42:18 UTC
  • Revision ID: gustav.hartvigsson@gmail.com-20170815074218-cvr745er5oc7a3yy
* forgot to add the primary-key constraint to the attandance.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/main/resources/create_tables.sql
103
103
 
104
104
  student                 BIGINT NOT NULL,
105
105
 
 
106
  late_time               TIMEZONE_MINUTE,
 
107
 
106
108
  CONSTRAINT lecture_fk   FOREIGN KEY (lecture_course,
107
109
                                      lecture_start_time,
108
110
                                      lecture_end_time)
111
113
                                              end_time),
112
114
 
113
115
  CONSTRAINT student_fk   FOREIGN KEY (student)
114
 
                          REFERENCES student (id)
 
116
                          REFERENCES student (id),
 
117
 
 
118
  CONSTRAINT student_attendance_pk PRIMARY KEY (lecture_course,
 
119
                                                lecture_start_time,
 
120
                                                lecture_end_time,
 
121
                                                student)
 
122
 
115
123
);
116
124