9 lines
301 B
SQL
9 lines
301 B
SQL
CREATE TABLE IF NOT EXISTS coach_recurring_availability (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
coach_id INT NOT NULL,
|
|
day_of_week INT NOT NULL, -- 0 for Sunday, 1 for Monday, etc.
|
|
start_time TIME NOT NULL,
|
|
end_time TIME NOT NULL,
|
|
FOREIGN KEY (coach_id) REFERENCES coaches(id)
|
|
);
|