Version 6 (modified by 8 months ago) ( diff ) | ,
---|
Релациска шема
- Примарни клучеви: bold и underline.
- Надворешни клучеви: bold*.
- Not-Null атрибути: bold.
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*
DDL скрипта за бришење на табелите и креирање на табелите
DML скрипта за полнење на табелите со податоци
Релациски дијаграм изваден од DBeaver
Attachments (5)
-
Kreiranje.sql
(2.1 KB
) - added by 9 months ago.
KREIRANJE TABELI
- diagramDB.png (40.8 KB ) - added by 9 months ago.
- Kreiranje2.sql (2.2 KB ) - added by 8 months ago.
- Polnenje2.sql (3.7 KB ) - added by 8 months ago.
- diagramdbeaver2.png (40.9 KB ) - added by 8 months ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.