Changes between Version 17 and Version 18 of RelationalDesign
- Timestamp:
- 02/15/25 10:12:55 (7 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v17 v18 15 15 * WAREHOUSE (__'''wh_id'''__, wh_adr, city_id*) 16 16 * * референцира до CITY (city_id) 17 * VEHICLE (__'''veh_id'''__, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg , wh_id*)17 * VEHICLE (__'''veh_id'''__, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id*) 18 18 * * референцира до WAREHOUSE (wh_id) 19 * USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_active, user_mobile, user_image, clazz_ city_id*)19 * USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_active, user_mobile, user_image, clazz_, user_role city_id*) 20 20 * * референцира до CITY (city_id) 21 21 * CUSTOMER (__'''user_id*'''__, cust_EDB, cust_company_name, cust_adr, cust_representative_image) … … 29 29 * !** референцира до VEHICLE (veh_id) 30 30 * MANUFACTURER (__'''man_id'''__, man_name, man_adr, man_mobile, man_email) 31 * ARTICLE (__'''art_id'''__, art_image, art_name, art_weight, ctg_id*, man r_id!**)31 * ARTICLE (__'''art_id'''__, art_image, art_name, art_weight, ctg_id*, man_id!**) 32 32 * * референцира до CATEGORY (ctg_id) 33 33 * !** референцира до MANUFACTURER (man_id) … … 53 53 * * референцира до CUSTOMER (user_id) 54 54 * !** референцира до WEEKDAY (day_id) 55 * TOKEN (__'''t_id'''__, t_value, t_date, t_type, t_expiry, t_validated_at, t_user*)55 * TOKEN_ (__'''t_id'''__, t_value, t_date, t_type, t_expiry, t_validated_at, t_user*) 56 56 * * референцира до USERS (user_id) 57 57
