Scribd
Upload
93 views19 pages

Festival Database Schema Guide

The document contains a table of contents listing 19 tables with their corresponding page numbers. The tables include information about agents, amenities, bands, clients, festivals, festival details, performers, types, landowners, partners, partner groups, payments, services, staff, staff roles, staff tasks, ticket sales, venues, and a relational schema.

Uploaded by

Val
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
93 views19 pages

Festival Database Schema Guide

The document contains a table of contents listing 19 tables with their corresponding page numbers. The tables include information about agents, amenities, bands, clients, festivals, festival details, performers, types, landowners, partners, partner groups, payments, services, staff, staff roles, staff tasks, ticket sales, venues, and a relational schema.

Uploaded by

Val
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

Table of contents

1 agent Page number: 2


2 amenity Page number: 3
3 band Page number: 4
4 client Page number: 5
5 festival Page number: 6
6 festival_details Page number: 7
7 festival_performers Page number: 8
8 festival_type Page number: 9
9 landowner Page number: 10
10 partner Page number: 11
11 partner_group Page number: 12
12 payment Page number: 13
13 service Page number: 14
14 staff Page number: 15
15 staff_role Page number: 16
16 staff_task Page number: 17
17 ticket_sale Page number: 18
18 venue Page number: 19
19 Relational schema Page number: 20
1 agent

Creation: Apr 05, 2018 at 08:01 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_agent int(11) No auto_increment


id_partner int(11) No -> partner.id_partner
ON UPDATE CASCADE
ON DELETE NO_ACTION
2 amenity

Creation: Apr 05, 2018 at 08:02 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_amenity int(11) No auto_increment


amnity_name varchar(100 No
)
amnity_note tinytext Yes NULL
3 band

Creation: Apr 05, 2018 at 08:03 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_band int(11) No auto_increment


id_agent int(11) Yes NULL -> agent.id_agent
ON UPDATE CASCADE
ON DELETE NO_ACTION
band_name varchar(50) No
band_genre varchar(50) Yes NULL
band_members int(2) Yes NULL
No
4 client

Creation: Apr 05, 2018 at 08:03 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_client int(11) No auto_increment


client_company varchar(100 Yes NULL
)
client_name varchar(20) No
client_surname varchar(20) No
client_address1 varchar(50) No
client_address2 varchar(50) Yes NULL
client_postcode char(8) No
client_city varchar(30) Yes NULL
client_email varchar(60) No
client_phone varchar(15) No
5 festival

Creation: Apr 05, 2018 at 03:06 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_festival int(11) No auto_increment


id_client int(11) Yes NULL -> client.id_client
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_festival_type int(11) Yes NULL ->
festival_type.id_festival_type
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_amenity int(11) Yes NULL -> amenity.id_amenity
ON UPDATE CASCADE
ON DELETE NO_ACTION
festival_name varchar(100 No
)
festival_date date No
festival_faid enum('YES', No NO
'NO')
festival_budget decimal(8,0) UNSIGNED No
6 festival_details

Creation: Apr 09, 2018 at 06:11 AM

Column Type Attributes Null Default Extra Links to Comments MIME

id_festival int(11) No -> festival.id_festival


ON UPDATE CASCADE
ON DELETE NO_ACTION
id_venue int(11) No -> venue.id_venue
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_service int(11) No -> service.id_service
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_partner int(11) No -> partner.id_partner
ON UPDATE CASCADE
ON DELETE NO_ACTION
contract_date date No
pitch_location varchar(20) Yes NULL
time_arr time No
time_dept time No
fd_note text Yes NULL
7 festival_performers

Creation: Apr 06, 2018 at 09:51 AM

Column Type Attributes Null Default Extra Links to Comments MIME

id_band int(11) No -> band.id_band


ON UPDATE CASCADE
ON DELETE NO_ACTION
id_festival int(11) No -> festival.id_festival
ON UPDATE CASCADE
ON DELETE NO_ACTION
fp_time_entry time No
fp_time_end time Yes NULL
fp_stage_time time Yes NULL
fp_note text Yes NULL
8 festival_type

Creation: Apr 05, 2018 at 08:04 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_festival_type int(11) No auto_increment


ft_name varchar(100 No
)
ft_note text Yes NULL
9 landowner

Creation: Apr 05, 2018 at 08:05 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_landowner int(11) No auto_increment


id_partner int(11) No -> partner.id_partner
ON UPDATE CASCADE
ON DELETE NO_ACTION
10 partner

Creation: Apr 05, 2018 at 08:05 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_partner int(11) No auto_increment


id_partner_grou int(11) No -> partner_group.id_partner_g
p roup
ON UPDATE CASCADE
ON DELETE NO_ACTION

partner_compa varchar(100 Yes NULL


ny )
partner_name varchar(20) No
partner_surnam varchar(20) No
e
partner_addres varchar(50) No
s1
partner_addres varchar(50) Yes NULL
s2
partner_postco char(8) No
de
partner_city varchar(30) Yes NULL
partner_email varchar(60) No
partner_phone varchar(15) No
11 partner_group

Creation: Apr 05, 2018 at 08:06 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_partner_grou int(11) No auto_increment


p
partner_group_ varchar(50) No
name
12 payment

Creation: Apr 05, 2018 at 08:06 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_payment int(11) No auto_increment


id_partner int(11) No -> partner.id_partner
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_festival int(11) No -> festival.id_festival
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_staff int(11) No -> staff.id_staff
ON UPDATE CASCADE
ON DELETE NO_ACTION
pmt_date date No
pmt_amount decimal(8,2) No
pmt_type enum('Paym No
ent IN',
'Payment
OUT')
13 service

Creation: Apr 05, 2018 at 08:06 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_service int(11) No auto_increment


id_partner int(11) No -> partner.id_partner
ON UPDATE CASCADE
ON DELETE NO_ACTION
service_name varchar(50) No
service_price decimal(6,2) No
service_descript text Yes NULL
ion
14 staff

Creation: Apr 05, 2018 at 08:07 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_staff int(11) No auto_increment


id_staff_role int(11) No -> staff_role.id_staff_role
ON UPDATE CASCADE
ON DELETE NO_ACTION
staff_name varchar(20) No
staff_surname varchar(20) No
staff_address1 varchar(50) No
staff_address2 varchar(50) Yes NULL
staff_postcode char(8) No
staff_city varchar(30) Yes NULL
staff_email varchar(60) No
staff_phone varchar(15) No
15 staff_role

Creation: Apr 05, 2018 at 08:07 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_staff_role int(11) No auto_increment


staff_role_name varchar(20) No
16 staff_task

Creation: Apr 05, 2018 at 08:07 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_task int(11) No auto_increment


id_festival int(11) Yes NULL -> festival.id_festival
ON UPDATE CASCADE
ON DELETE NO_ACTION
id_staff int(11) No -> staff.id_staff
ON UPDATE CASCADE
ON DELETE NO_ACTION
task_name varchar(50) No
task_date date Yes NULL
task_time time Yes NULL
task_details text Yes NULL
task_completed enum('YES', Yes NULL
'NO')
17 ticket_sale

Creation: Apr 05, 2018 at 08:07 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_sale int(11) No auto_increment


id_festival int(11) No -> festival.id_festival
ON UPDATE CASCADE
ON DELETE NO_ACTION
ticket_series_st varchar(20) Yes NULL
art
ticket_series_en varchar(20) Yes NULL
d
ticket_sold int(10) UNSIGNED No
ticket_price decimal(5,2) UNSIGNED No
18 venue

Creation: Apr 05, 2018 at 08:08 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id_venue int(11) No auto_increment


id_landowner int(11) No -> landowner.id_landowner
ON UPDATE CASCADE
ON DELETE NO_ACTION
venue_name varchar(50) No
venue_address varchar(50) No
1
venue_address varchar(50) Yes NULL
2
venue_city varchar(30) No
venue_postcod char(8) No
e
venue_capacity smallint(11) UNSIGNED No
venue_rent_pric decimal(7,2) UNSIGNED No
e

You might also like