Changes between Version 3 and Version 4 of Логички и физички дизајн - Креирање база податоци (со SQL DDL)


Ignore:
Timestamp:
12/21/23 20:54:54 (9 months ago)
Author:
181549
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Логички и физички дизајн - Креирање база податоци (со SQL DDL)

    v3 v4  
    16161.Users – **__ID__** , **name**, **email**, **password**, **location**
    1717
    18 2.Business – **__ID__** , **address**, **user_id**
     182.Business – **__ID__** , **address**, **user_id* **
    1919
    20 3.Client – **__ID__** , **date_of_birth** , **user_id**
     203.Client – **__ID__** , **date_of_birth** , **user_id* **
    2121
    22 4.Reservation – **__ID__**, **client_id**, **business_id***, **time**, **date**
     224.Reservation – **__ID__**, **client_id* **, **business_id* **, **time**, **date**
    2323
    24 5.Competition – **__ID__**, **client_id**, **business_id**, **name**, **eligibility**
     245.Competition – **__ID__**, **client_id* **, **business_id* **, **name**, **eligibility**
    2525
    26 6.Subscription – **__ID__**, **client_id**, **type**, **price**, **created_at**, **valid_by**
     266.Subscription – **__ID__**, **client_id* **, **type**, **price**, **created_at**, **valid_by**
    2727
    28 7.Guest_pay – **__ID__**, **client_id**, **type**, **amount**
     287.Guest_pay – **__ID__**, **client_id* **, **type**, **amount**
    2929
    30 8.Feedback – **__ID__**, **client_id** , comment, rating, **business_id**
     308.Feedback – **__ID__**, **client_id* ** , comment, rating, **business_id* **
    3131
    3232=== DDL скрипта за бришење на табелите и креирање на табелите