CREATE TABLE billing.bills (
    id serial NOT NULL,
    invoice VARCHAR(12) NULL,
    bill_number VARCHAR(20) NOT NULL,
    vat NUMERIC(10,2) NOT NULL DEFAULT 20,
    bill_date DATE NOT NULL,
    payment_days int4 NOT NULL DEFAULT 7,
    block bool NULL,
    sent VARCHAR(16) NOT NULL DEFAULT 'NONE'::CHARACTER VARYING,
    block_date DATE NULL,
    agr_id int4 NOT NULL,
    "timestamp" int4 NOT NULL,
    paid bool NOT NULL DEFAULT FALSE,
    commission NUMERIC(10,2) NOT NULL DEFAULT 0,
    usd_rate NUMERIC(8,4) NOT NULL,
    advance bool NULL,
    message jsonb NULL,
    diadoc_signed timestamptz NULL,
    utd bool NOT NULL DEFAULT TRUE,
    CONSTRAINT bills_definition UNIQUE (bill_number, "timestamp", agr_id),
    CONSTRAINT bills_invoice_key UNIQUE (invoice),
    CONSTRAINT bills_pkey PRIMARY KEY (id),
    CONSTRAINT bills_agr_id_fkey FOREIGN KEY (agr_id) REFERENCES agreements(id),
    CONSTRAINT bills_bill_sent_status_fk FOREIGN KEY (sent) REFERENCES aux.bill_sent_status(code) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE INDEX bills_agr_id_idx ON billing.bills USING btree (agr_id);
CREATE INDEX bills_message_idx ON billing.bills USING btree (md5((message)::text));
CREATE INDEX bills_prev_ts_idx ON billing.bills USING btree (aux.prev_ts("timestamp"));
CREATE INDEX bills_timestamp_idx ON billing.bills USING btree ("timestamp", advance);