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

Timestamp:

12/21/23 19:18:52 (9 months ago)

Author:

181549

Comment:

--

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

@@ +1 @@
+{{{#!html
+<h1 style="text-align: left; color: #5d5250; margin: 0; margin-top: 10px">
+ Релациска шема
+</h1>
+<hr style="margin: 0; margin-bottom:10px">
+}}}
+
+- Примарни клучеви: **__bold и underline__**.
+- Надворешни клучеви: **bold***.
+- Not-Null атрибути: **bold**.
+
+{{{#!html
+<hr style="margin: 0;">
+}}}
+
+1.Users – **__ID__** , name , email, password, location
+
+2.Business – *__ID__*, address, **user_id**
+
+3.Client – **__ID__*, date_of_birth, **user_id**
+
+4.Reservation – **__ID__**, **client_id**, **business_id**, time, date
+
+5.Competition – **__ID__**, **client_id**, **business_id**, name, eligibility 
+
+6.Subscription – **__ID__**, **client_id**, type, price, created_at, valid_by
+
+7.Guest_pay – **__ID__**, **client_id**, type, amount 
+
+8.Feedback – **__ID__**, **client_id** , comment, rating, **business_id**