11 lines
398 B
SQL
11 lines
398 B
SQL
-- The purpose of this table is to record rows from the schedule table that I have to edit or delete
|
|
-- usually due to an unforseen schedule change.
|
|
CREATE TABLE cancellation (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
caster_id INTEGER,
|
|
segment_id INTEGER NOT NULL,
|
|
jst DATETIME NOT NULL,
|
|
FOREIGN KEY (caster_id) REFERENCES caster (id),
|
|
FOREIGN KEY (segment_id) REFERENCES segment (id)
|
|
);
|