Changes between Version 20 and Version 21 of RelationalDesign


Ignore:
Timestamp:
02/08/22 20:19:52 (3 years ago)
Author:
193047
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v20 v21  
    1313----
    1414
    15 * Person: (**__id_person__**, **name**,** surname**, address, town, **phone_num**)
    16 * Employee: (**__id_person__***(Person), **id_library***(Library), **position**)
    17 * Member: (**__id_person__***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**)
    18 * Library: (**__id_library__**, **name**, **city**)
    19 * SchoolType: (**__id_school__**,** school_type_name**)
    20 * MembershipType: (**__id_membership__**, **mem_stype_name**)
    21 * PriceList: (**__id_price__**, **id_membership***(MemberShipType), **price**)
    22 * Genre: (**__id_genre__**, **name**)
    23 * Writer: (**__id_writer__**, ** name**)
    24 * Review: (**__id_review__**, **id_book***(Book), **rate**, **rent_num**)
     15* Person (**__id_person__**, **name**,** surname**, address, town, **phone_num**)
     16* Employee (**__id_person__***(Person), **id_library***(Library), **position**)
     17* Member (**__id_person__***(Person), **id_school***(SchoolType), **id_membership***(MembershipType), **id_library ***(Library), **birth**, **email**, **pass**)
     18* Library (**__id_library__**, **name**, **city**)
     19* SchoolType (**__id_school__**,** school_type_name**)
     20* MembershipType (**__id_membership__**, **mem_stype_name**)
     21* PriceList (**__id_price__**, **id_membership***(MemberShipType), **price**)
     22* Genre (**__id_genre__**, **name**)
     23* Writer (**__id_writer__**, ** name**)
     24* Review (**__id_review__**, **id_book***(Book), **rate**, **rent_num**)
    2525* Room: (**__id_room__**, **id_library***(Library), **places**, **free_places**)
    26 * OnlineDownload: (**__id_onlineDown__**, **id_book***(Book), **id_person_member***(Member))
    27 * ReservationBook: (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
     26* OnlineDownload (**__id_onlineDown__**, **id_book***(Book), **id_person_member***(Member))
     27* ReservationBook (**__id_resBook__**, **id_book***(Book), **is_person_member***(Member), **take_date**, **return_date**)
    2828* Book: (**__id_book__**, **id_writer***(Writer), **id_library***(Library), **name**, **book_num**, **if_free**, **book_price**, **book_price_late**)
    29 * ReservationPlace: (**__id_resRoom__**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**)
    30 * Membership_of_SchoolType: (**__id_membership__***(MembershipType), **id_school***(SchoolType))
     29* ReservationPlace (**__id_resRoom__**, **id_room***(Room),** id_person_member***(Member),** date**, **duration**)
     30* Membership_of_SchoolType (**__id_membership__***(MembershipType), **id_school***(SchoolType))
    3131* Who_Wrote_Book: (**__id_book__***(Book), **id_writer***(Writer))
    3232