| | |
| | | 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 |
| | | ); |
| | | |
| | | |
| | |
| | | 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)) |
| | | ); |
| | | |