I am trying to create a table for listing events in a club. Some events are three day events and others are daily events. I am struglging to work out how to differentiate between the two types and ask for your help.
here is my table so far
Code mysql:create table if not exists events ( event_id int not null , event_name varchar(32) not null , description varchar (255) not null , start_date date not null , end_date date not null , opening_time time not null , closing_time time not null , primary key (event_id) key (start_date,end_date) key (event_name) ) engine=innodb default chartset=latin1;
If I were to keep it like this, would adding a daily event which lasts for a week be quite tedious because each would have to be added as if separate events?