Changes between Version 1 and Version 2 of Логички и физички дизајн - Креирање база податоци (со SQL DDL)
- Timestamp:
- 12/21/23 19:36:35 (9 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Логички и физички дизајн - Креирање база податоци (со SQL DDL)
v1 v2 14 14 }}} 15 15 16 1.Users – **__ID__** , name , email, password, location16 1.Users – **__ID__** , **name**, **email**, **password**, **location** 17 17 18 2.Business – * __ID__*, address, **user_id**18 2.Business – **__ID__** , **address**, **user_id** 19 19 20 3.Client – **__ID__* , date_of_birth, **user_id**20 3.Client – **__ID__** , **date_of_birth** , **user_id** 21 21 22 4.Reservation – **__ID__**, **client_id**, **business_id** , time, date22 4.Reservation – **__ID__**, **client_id**, **business_id***, **time**, **date** 23 23 24 5.Competition – **__ID__**, **client_id**, **business_id**, name, eligibility24 5.Competition – **__ID__**, **client_id**, **business_id**, **name**, **eligibility** 25 25 26 6.Subscription – **__ID__**, **client_id**, type, price, created_at, valid_by26 6.Subscription – **__ID__**, **client_id**, **type**, **price**, **created_at**, **valid_by** 27 27 28 7.Guest_pay – **__ID__**, **client_id**, type, amount28 7.Guest_pay – **__ID__**, **client_id**, **type**, **amount** 29 29 30 30 8.Feedback – **__ID__**, **client_id** , comment, rating, **business_id**
