Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE doc_person
- (
- id serial NOT NULL
- constraint doc_person_pk
- primary key,
- id_request INTEGER NOT NULL // И ЗДЕСЬ NOT NULL
- constraint doc_person_doc_request_id_fk
- references doc_request
- ON DELETE cascade
- constraint fk_request
- references cls_department,
- lastname VARCHAR(100) NOT NULL,
- firstname VARCHAR(100) NOT NULL,
- patronymic VARCHAR(100),
- is_agree BOOLEAN NOT NULL
- );
- CREATE TABLE doc_address_fact
- (
- id serial NOT NULL
- constraint doc_address_fact_pk
- primary key,
- address_fact VARCHAR(255) NOT NULL,
- person_office_fact_cnt INTEGER NOT NULL,
- id_request INTEGER NOT NULL // И ЗДЕСЬ NOT NULL
- constraint fk_req_addr
- references doc_request
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement