13 lines
258 B
SQL
13 lines
258 B
SQL
CREATE TABLE kosten
|
|
(
|
|
beschreibung CHARACTER VARYING,
|
|
projekt_id INTEGER,
|
|
betrag NUMERIC(6,2)
|
|
);
|
|
|
|
INSERT INTO kosten VALUES
|
|
('Telefon', 1, 98.5),
|
|
('Reisekosten', 1, 466.20),
|
|
('Material', 1, 235.60),
|
|
('Reisekosten', 2, 120.60),
|
|
('Material', 2, 32.20); |