Version 3 (modified by 9 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.