Created
October 5, 2011 09:08
-
-
Save pudo/1263987 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE bund_bund ( | |
id INTEGER NOT NULL, name TEXT, label TEXT, color TEXT, pdf_url TEXT, source_url TEXT, bund_kapitel TEXT, description TEXT, bund_titel TEXT, bund_titelgruppe TEXT, | |
PRIMARY KEY (id) | |
); | |
CREATE TABLE bund_entity ( | |
id INTEGER NOT NULL, label TEXT, name TEXT, color TEXT, pdf_url TEXT, source_url TEXT, bund_ep TEXT, | |
PRIMARY KEY (id) | |
); | |
CREATE TABLE bund_entry ( | |
id INTEGER NOT NULL, hauptgruppe_id INTEGER, kapitel_id INTEGER, from_id INTEGER, titel_id INTEGER, funktion_id INTEGER, gruppe_id INTEGER, flow TEXT, data_year TEXT, financial_type TEXT, to_id INTEGER, hauptfunktion_id INTEGER, titelgruppe_id INTEGER, time TEXT, remarks TEXT, flexible TEXT, oberfunktion_id INTEGER, obergruppe_id INTEGER, amount FLOAT, | |
PRIMARY KEY (id) | |
); | |
CREATE TABLE "bund_funktionenplan-bund" ( | |
id INTEGER NOT NULL, name TEXT, label TEXT, color TEXT, description TEXT, level TEXT, | |
PRIMARY KEY (id) | |
); | |
CREATE TABLE "bund_gruppierungsplan-bund" ( | |
id INTEGER NOT NULL, name TEXT, label TEXT, color TEXT, description TEXT, level TEXT, | |
PRIMARY KEY (id) | |
); | |
CREATE INDEX from_id_index ON bund_entry (from_id); | |
CREATE INDEX funktion_id_index ON bund_entry (funktion_id); | |
CREATE INDEX gruppe_id_index ON bund_entry (gruppe_id); | |
CREATE INDEX hauptfunktion_id_index ON bund_entry (hauptfunktion_id); | |
CREATE INDEX hauptgruppe_id_index ON bund_entry (hauptgruppe_id); | |
CREATE INDEX kapitel_id_index ON bund_entry (kapitel_id); | |
CREATE INDEX oberfunktion_id_index ON bund_entry (oberfunktion_id); | |
CREATE INDEX obergruppe_id_index ON bund_entry (obergruppe_id); | |
CREATE INDEX titel_id_index ON bund_entry (titel_id); | |
CREATE INDEX titelgruppe_id_index ON bund_entry (titelgruppe_id); | |
CREATE INDEX to_id_index ON bund_entry (to_id); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment