Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Ergo (
- id INTEGER,
- akronimio CHAR(150),
- title CHAR(150) NOT NULL,
- hmerominiaEn DATE,
- hmerominiaLik DATE,
- PRIMARY KEY(id)
- );
- CREATE TABLE Organismos (
- id INTEGER,
- name CHAR(150) NOT NULL,
- city CHAR(150),
- country CHAR(150),
- PRIMARY KEY (id)
- );
- CREATE TABLE Dhmosieush (
- id INTEGER,
- title CHAR(150) NOT NULL,
- periodiko CHAR(150),
- etos INTEGER,
- PRIMARY KEY(id)
- );
- CREATE TABLE Paradoteo (
- id INTEGER,
- title CHAR(150),
- tupos CHAR(150) NOT NULL,
- PRIMARY KEY(id)
- );
- CREATE TABLE ExeiOne(
- idParadoteo INTEGER,
- idErgo INTEGER,
- FOREIGN KEY(idParadoteo) REFERENCE Paradoteo(id),
- FOREIGN KEY(idErgo) REFERENCE Ergo(id)
- );
- CREATE TABLE ExeiOne(
- idDhmosieush INTEGER,
- idErgo INTEGER,
- FOREIGN KEY(idDhmosieush) REFERENCE Dhmosieush(id),
- FOREIGN KEY(idErgo) REFERENCE Ergo(id)
- );
- CREATE TABLE ErgOrg (
- idErgo INTEGER,
- idOrganismos INTEGER,
- rolos CHAR(150),
- poso FLOAT,
- FOREIGN KEY(idErgo) REFERENCE Ergo(id),
- FOREIGN KEY(idOrganimsos) REFERENCE Organimos (id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement