Changes between Version 2 and Version 3 of RelationalDesign
- Timestamp:
- 02/11/25 18:11:46 (11 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v2 v3 3 3 == Ознаки == 4 4 - Со * се означени надворешни клучеви (FK). 5 - Примарните клучеви (PK) се подвлечени болдирани.5 - Примарните клучеви (PK) се подвлечени и.Bold 6 6 7 7 == Табели == … … 9 9 === Ентитети === 10 10 11 1. '''USER''' ( user_id, username, email, password_hash, first_name, last_name )12 - user_id(PK, bigint)11 1. '''USER''' ( **user_id** , username, email, password_hash, first_name, last_name ) 12 - **user_id** (PK, bigint) 13 13 - username (string, задолжително) 14 14 - email (string, задолжително) … … 16 16 - first_name, last_name (опционално) 17 17 18 2. '''INSTRUCTOR''' ( instructor_id, first_name, last_name, biography )19 - instructor_id(PK, bigint)18 2. '''INSTRUCTOR''' ( **instructor_id** , first_name, last_name, biography ) 19 - **instructor_id** (PK, bigint) 20 20 - first_name (string, задолжително) 21 21 - last_name (string, задолжително) … … 23 23 - (Ако сакате 1:N со CLASS, ќе имате FK во CLASS → instructor_id*) 24 24 25 3. '''TRAINING''' ( training_id, training_name, description, duration, intensity_level )26 - training_id(PK, bigint)25 3. '''TRAINING''' ( **training_id** , training_name, description, duration, intensity_level ) 26 - **training_id** (PK, bigint) 27 27 - training_name (string, задолжително) 28 28 - description (text, опционално) … … 30 30 - intensity_level (string, опционално) 31 31 32 4. '''CLASS''' ( class_id, date, start_time, end_time, location, capacity, seats_available, instructor_id* )33 - class_id(PK, bigint)32 4. '''CLASS''' ( **class_id** , date, start_time, end_time, location, capacity, seats_available, instructor_id* ) 33 - **class_id** (PK, bigint) 34 34 - date (date, задолжително) 35 35 - start_time (time, задолжително) … … 40 40 - instructor_id* → референцира до INSTRUCTOR(instructor_id) 41 41 42 5. '''EVENT''' ( event_id, event_name, description, date, time, location )43 - event_id(PK, bigint)42 5. '''EVENT''' ( **event_id** , event_name, description, date, time, location ) 43 - **event_id** (PK, bigint) 44 44 - event_name (string, задолжително) 45 45 - description (text, опционално) … … 48 48 - location (string, задолжително) 49 49 50 6. '''PACKAGE''' ( package_id, package_name, price, num_classes )51 - package_id(PK, bigint)50 6. '''PACKAGE''' ( **package_id**, package_name, price, num_classes ) 51 - **package_id** (PK, bigint) 52 52 - package_name (string, задолжително) 53 53 - price (decimal, задолжително) 54 54 - num_classes (int, задолжително) 55 55 56 7. '''MERCH_ITEMS''' ( merch_id, item_name, description, price, quantity_in_stock )57 - merch_id(PK, bigint)56 7. '''MERCH_ITEMS''' ( **merch_id**, item_name, description, price, quantity_in_stock ) 57 - **merch_id** (PK, bigint) 58 58 - item_name (string, задолжително) 59 59 - description (text, опционално) … … 103 103 == Дијаграм на табелите (DBeaver) == 104 104 [[Image(BlissCore_Tables_DBeaver.png, 600px)]] 105
