Scribd
Upload
15 views2 pages

DBschema

The document outlines a database schema for an event management system, detailing various entities such as Event, User, Sponsor, Ticket, and Notification. Each entity includes attributes like IDs, timestamps, and other relevant information necessary for managing events and user interactions. Relationships between entities are also indicated, showing how they are interconnected within the system.

Uploaded by

hristinafrangova.hf
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views2 pages

DBschema

The document outlines a database schema for an event management system, detailing various entities such as Event, User, Sponsor, Ticket, and Notification. Each entity includes attributes like IDs, timestamps, and other relevant information necessary for managing events and user interactions. Relationships between entities are also indicated, showing how they are interconnected within the system.

Uploaded by

hristinafrangova.hf
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Event_Guests

Invitation
id INTEGER
id integer
*
event_id INTEGER
*
event_id integer
*
user_id INTEGER
status varchar

Event sent_at timestamp


Sponsor
Event_Sponsors 0..1
* 1
1 event_id integer
user_id integer 0..1
id INTEGER
title varchar
provided_sum integer *
event_id INTEGER
description varchar
* Media_Content
user_id INTEGER
category varchar
id integer
location varchar *
User event_id integer
0..1 Organizer
start_date timestamp
id integer 1 * 1 caption varchar
user_id integer
end_date timestamp
email varchar type varchar
rules varchar
password varchar upload_date timestamp
*
organizer_id integer
first_name varchar
Event_Followers sponsor_id integer
last_name varchar
Ticket
id INTEGER
username varchar
* id integer
event_id INTEGER
role varchar *
* event_id integer
user_id INTEGER
price integer

Notification

id integer
*
user_id integer
*
event_id integer

is_received boolean

sent_at timestamp

message_content varchar
Event_Guests
Invitation
id INTEGER
id integer
*
event_id INTEGER
*
event_id integer
*
user_id INTEGER
status varchar

Event sent_at timestamp


Sponsor
Event_Sponsors 0..1
* 1
1 event_id integer
user_id integer 0..1
id INTEGER
title varchar
provided_sum integer *
event_id INTEGER
description varchar
* Media_Content
user_id INTEGER
category varchar
id integer
location varchar *
User event_id integer
0..1 Organizer
start_date timestamp
id integer 1 * 1 caption varchar
user_id integer
end_date timestamp
email varchar type varchar
rules varchar
password varchar upload_date timestamp
*
organizer_id integer
first_name varchar
Event_Followers sponsor_id integer
last_name varchar
Ticket
id INTEGER
username varchar
* id integer
event_id INTEGER
role varchar *
* event_id integer
user_id INTEGER
price integer

Notification

id integer
*
user_id integer
*
event_id integer

is_received boolean

sent_at timestamp

message_content varchar

You might also like