Changes between Version 20 and Version 21 of RelationalDesign2


Ignore:
Timestamp:
08/24/25 22:12:29 (20 hours ago)
Author:
175012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign2

    v20 v21  
    99
    1010----
    11 - Policy(**__p_id__**, **sdate**, **edate**)
    12 - Customer(**__c_id__** ,**e-mail**, **password**, type)
    13 - Pol_dog(**__d_embg__**, **__c_id__*** (Customer), **name**, surname, **birthdate**, kontakt)
    14 - Payment(**__payment_num__**,p_date,p_amount,visa_number)
    15 - Package(**__code__**, **title**, total, value,type_pol)
    16 - Covers(**__cov_id__**,cov_amount,cov_type)
    17 - Property_pol(**__pr_id__**,**pol_id** (Policy))
    18 - Property(**__prop_id__**, address, floor, year_build, security)
    19 - Auto_pol(**__a_id__**, **__pol_id__*** (Policy))
    20 - Vehicle(**__v_id__**, type, marka, model, **license_plate**)
    21 - Travel_pol(**__tr_id__**, **__pol_id__*** (Policy))
    22 - Pol_osi(**__o_embg__**, **name**, surname, **birthdate**, kontakt)
    23 
    24 -Customer(**__c_id__**, **name**, **e-mail**, **type**, **pass**)
    25 -Pol_dog(**__d_embg__**, **name**, **surname**, **birthdate**, kontakt, c_id* (Customer))
    26 -Package(**__code__**, **title**, **total**, **value**,**type_pol**)
    27 -Covers(**__cov_id__**,**cov_amount,cov_type**, package_code* (Package))
    28 -Policy(**__p_id__**, **sdate**, **edate**, package_code* (Package), d_embg* (Pol_dog))
    29 -Payment(**__payment_num__**, visa_number, **p_date, p_amount**, policy_id* (Policy))
    30 -Vehicle(**__v_id__**, **model, marka**, type, **license_plate**)
    31 -Property(**__prop_id__**, **address**, floor, year_build, security)
    32 -Pol_osi(**__o_embg__**, **name, surname, birthdate,** kontakt)
    33 -Auto_pol(**__a_id__**, pol_id* (Policy), v_id* (Vehicle))
    34 -Property_pol(**__pr_id__**, pol_id* (Policy), prop_id* (Property))
    35 -Travel_pol(**__tr_id__**, pol_id* (Policy), o_embg* (Pol_osi))
     11- Customer(**__c_id__**, **name**, **e-mail**, **type**, **pass**)
     12- Pol_dog(**__d_embg__**, **name**, **surname**, **birthdate**, kontakt, c_id* (Customer))
     13- Package(**__code__**, **title**, **total**, **value**,**type_pol**)
     14- Covers(**__cov_id__**,**cov_amount,cov_type**, package_code* (Package))
     15- Policy(**__p_id__**, **sdate**, **edate**, package_code* (Package), d_embg* (Pol_dog))
     16- Payment(**__payment_num__**, visa_number, **p_date, p_amount**, policy_id* (Policy))
     17- Vehicle(**__v_id__**, **model, marka**, type, **license_plate**)
     18- Property(**__prop_id__**, **address**, floor, year_build, security)
     19- Pol_osi(**__o_embg__**, **name, surname, birthdate,** kontakt)
     20- Auto_pol(**__a_id__**, pol_id* (Policy), v_id* (Vehicle))
     21- Property_pol(**__pr_id__**, pol_id* (Policy), prop_id* (Property))
     22- Travel_pol(**__tr_id__**, pol_id* (Policy), o_embg* (Pol_osi))
    3623
    3724