services

CREATE TABLE billing.services (
    id serial NOT NULL,
    bill int4 NOT NULL,
    tariff int4 NULL,
    VALUE NUMERIC(14,2) NOT NULL,
    currency VARCHAR(3) NOT NULL DEFAULT 'RUR'::CHARACTER VARYING,
    payment_terms int4 NOT NULL,
    created DATE NOT NULL DEFAULT now(),
    start_date DATE NULL,
    end_date DATE NULL,
    description VARCHAR(400) NOT NULL,
    value_rur NUMERIC(14,2) NULL,
    CONSTRAINT services_pkey PRIMARY KEY (id),
    CONSTRAINT services_bill_fkey FOREIGN KEY (bill) REFERENCES bills(id) ON DELETE CASCADE,
    CONSTRAINT services_currency_fkey FOREIGN KEY (currency) REFERENCES aux.currencies(code),
    CONSTRAINT services_payment_terms_fkey FOREIGN KEY (payment_terms) REFERENCES aux.payment_terms(id),
    CONSTRAINT services_tariff_fkey FOREIGN KEY (tariff) REFERENCES tariffs(id)
);
CREATE INDEX services_bill_idx ON billing.services USING btree (bill);
CREATE INDEX services_end_date_idx ON billing.services USING btree (end_date);
CREATE INDEX services_start_date_idx ON billing.services USING btree (start_date);