search

jonbiemond / BCIT-Flex

A website for easily navigating BCIT courses and offerings.
https://www.bcitflex.tech
MIT License
10 stars 8 forks source link

Add surrogate key to Offering model #60

Closed jonbiemond closed 11 months ago

jonbiemond commented 11 months ago

Currently the offering table uses crn for the primary key. CRN may be duplicated between terms. Instead add a DB generated primary key.

Fall 2022
46967    Sep 12 - Dec 12    Anca Datcu-Romano
46968    Sep 13 - Dec 06    Mathew Linder
46969    Sep 15 - Dec 08    Mathew Linder
46989    Sep 10 - Dec 10    Mike Mulder
46990    Sep 15 - Dec 01    Rana Al-Sammarraie
46992    Sep 09 - Dec 09    Rana Al-Sammarraie
46994    Sep 10 - Dec 10    Jason Wilder

Fall 2023
46967    Sep 11 - Dec 11    Rana Al-Sammarraie
46968    Sep 12 - Dec 05    Mathew Linder
46969    Sep 14 - Dec 07    Mathew Linder
46988    Sep 11 - Dec 04    Mike Mulder
46989    Sep 09 - Dec 09    Mike Mulder
46990    Sep 14 - Nov 30    Rana Al-Sammarraie
46994    Sep 09 - Dec 09    Jason Wilder