Spalten technical_contact, business_contact

Peter Hormanns

2014-05-17 c3f5a5b24843b960955dc4e5d092736b1de705fd

 hsarback/database/schema.sql

@@ -14,7 +14,11 @@
    bank_name character varying(50),
    bank_iban character varying(30),
    bank_bic character varying(15),
    mandat_ref character varying(10)
    mandat_ref character varying(10) NOT NULL,
    mandat_signed date,
    mandat_since date,
    mandat_until date,
    mandat_used date
);


@@ -169,6 +173,8 @@
    phone_mobile character varying(30),
    fax character varying(30),
    email character varying(100) NOT NULL,
    business_contact boolean DEFAULT TRUE,
    technical_contact boolean DEFAULT TRUE,
    CONSTRAINT ckc_email_contact CHECK (((email)::text ~~ '%@%.%'::text))
);