Changes between Version 1 and Version 2 of RelationalDesign
- Timestamp:
- 02/11/25 18:09:40 (11 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v1 v2 9 9 === Ентитети === 10 10 11 1. '''USER''' ( _user_id_, username, email, password_hash, first_name, last_name )11 1. '''USER''' ( user_id , username, email, password_hash, first_name, last_name ) 12 12 - user_id (PK, bigint) 13 13 - username (string, задолжително) … … 16 16 - first_name, last_name (опционално) 17 17 18 2. '''INSTRUCTOR''' ( _instructor_id_, first_name, last_name, biography )18 2. '''INSTRUCTOR''' ( instructor_id , first_name, last_name, biography ) 19 19 - instructor_id (PK, bigint) 20 20 - first_name (string, задолжително) … … 23 23 - (Ако сакате 1:N со CLASS, ќе имате FK во CLASS → instructor_id*) 24 24 25 3. '''TRAINING''' ( _training_id_, training_name, description, duration, intensity_level )25 3. '''TRAINING''' ( training_id , training_name, description, duration, intensity_level ) 26 26 - training_id (PK, bigint) 27 27 - training_name (string, задолжително) … … 30 30 - intensity_level (string, опционално) 31 31 32 4. '''CLASS''' ( _class_id_, date, start_time, end_time, location, capacity, seats_available, instructor_id* )32 4. '''CLASS''' ( class_id , date, start_time, end_time, location, capacity, seats_available, instructor_id* ) 33 33 - class_id (PK, bigint) 34 34 - date (date, задолжително) … … 40 40 - instructor_id* → референцира до INSTRUCTOR(instructor_id) 41 41 42 5. '''EVENT''' ( _event_id_, event_name, description, date, time, location )42 5. '''EVENT''' ( event_id , event_name, description, date, time, location ) 43 43 - event_id (PK, bigint) 44 44 - event_name (string, задолжително) … … 48 48 - location (string, задолжително) 49 49 50 6. '''PACKAGE''' ( _package_id_, package_name, price, num_classes )50 6. '''PACKAGE''' ( package_id, package_name, price, num_classes ) 51 51 - package_id (PK, bigint) 52 52 - package_name (string, задолжително) … … 54 54 - num_classes (int, задолжително) 55 55 56 7. '''MERCH_ITEMS''' ( _merch_id_, item_name, description, price, quantity_in_stock )56 7. '''MERCH_ITEMS''' ( merch_id, item_name, description, price, quantity_in_stock ) 57 57 - merch_id (PK, bigint) 58 58 - item_name (string, задолжително) … … 63 63 === Табели за M:N Релации (Bridge) === 64 64 65 1. '''USER_CLASS''' ( _user_id*_, _class_id*_)65 1. '''USER_CLASS''' ( user_id*, class_id* ) 66 66 - user_id* → референцира до USER(user_id) 67 67 - class_id* → референцира до CLASS(class_id) 68 68 - Пример за релација books (USER ↔ CLASS, M:N) 69 69 70 2. '''CLASS_TRAINING''' ( _class_id*_, _training_id*_)70 2. '''CLASS_TRAINING''' ( class_id*, training_id* ) 71 71 - class_id* → референцира до CLASS(class_id) 72 72 - training_id* → референцира до TRAINING(training_id) 73 73 - Пример за релација is_scheduled_for (M:N) 74 74 75 3. '''USER_EVENT''' ( _user_id*_, _event_id*_)75 3. '''USER_EVENT''' ( user_id*, event_id* ) 76 76 - user_id* → референцира до USER(user_id) 77 77 - event_id* → референцира до EVENT(event_id) 78 78 - Пример за релација registers (M:N) 79 79 80 4. '''USER_PACKAGE''' ( _user_id*_, _package_id*_)80 4. '''USER_PACKAGE''' ( user_id*, package_id* ) 81 81 - user_id* → референцира до USER(user_id) 82 82 - package_id* → референцира до PACKAGE(package_id) 83 83 - Пример за релација buys (M:N) 84 84 85 5. '''USER_MERCH''' ( _user_id*_, _merch_id*_)85 5. '''USER_MERCH''' ( user_id*, merch_id* ) 86 86 - user_id* → референцира до USER(user_id) 87 87 - merch_id* → референцира до MERCH_ITEMS(merch_id) 88 88 - Пример за релација purchases (M:N) 89 89 90 6. '''PACKAGE_CLASS''' ( _package_id*_, _class_id*_)90 6. '''PACKAGE_CLASS''' ( package_id*, class_id* ) 91 91 - package_id* → референцира до PACKAGE(package_id) 92 92 - class_id* → референцира до CLASS(class_id)
