Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Algus
- CREATE TABLE Film (
- id INTEGER NOT NULL,
- klass VARCHAR (30) NOT NULL,
- nimi VARCHAR(100) NOT NULL, --
- aasta INTEGER, --aasta võib ka teadmata olla.
- CONSTRAINT pk_id PRIMARY KEY (id)
- ); --
- CREATE TABLE Saal(
- id INTEGER NOT NULL, --saali number ongi saali nimi
- istekohti INTEGER NOT NULL,
- CONSTRAINT pk_id PRIMARY KEY (id)
- ); --
- CREATE TABLE Seanss (
- id INTEGER NOT NULL,
- aeg datetime NOT NULL,
- film INTEGER NOT NULL,
- saal INTEGER NOT NULL,
- CONSTRAINT pk_id PRIMARY KEY (id),
- CONSTRAINT fk_seanss_2_saal FOREIGN KEY (saal) REFERENCES saal (id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- CONSTRAINT fk_seanss_2_film FOREIGN KEY (film) REFERENCES film (id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- );
- CREATE TABLE Klient(
- id INTEGER NOT NULL,
- nimi VARCHAR (100),
- synnipaev DATE,
- sisestatud datetime NOT NULL DEFAULT CURRENT TIMESTAMP,
- CONSTRAINT pk_id PRIMARY KEY (id),
- ); --
- CREATE TABLE Pilet (
- id INTEGER NOT NULL,
- seanss INTEGER NOT NULL, --
- hind FLOAT,
- koht INTEGER NOT NULL,
- ostuhetk datetime,
- ostukanal VARCHAR (20) NOT NULL,
- myydud tinyint NOT NULL,
- klient INTEGER DEFAULT '000001', --anonüümne kasutaja
- CONSTRAINT pk_id PRIMARY KEY (id),
- CONSTRAINT fk_pilet_2_seanss FOREIGN KEY (seanss) REFERENCES seanss (id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- CONSTRAINT fk_pilet_2_klient FOREIGN KEY (klient) REFERENCES klient (id)
- ON DELETE RESTRICT ON UPDATE CASCADE,
- ); --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement