Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.71 KB | None | 0 0
  1. CREATE TABLE doc_person
  2. (
  3.     id serial NOT NULL
  4.         constraint doc_person_pk
  5.             primary key,
  6.     id_request INTEGER NOT NULL // И ЗДЕСЬ NOT NULL
  7.         constraint doc_person_doc_request_id_fk
  8.             references doc_request
  9.                 ON DELETE cascade
  10.         constraint fk_request
  11.             references cls_department,
  12.     lastname VARCHAR(100) NOT NULL,
  13.     firstname VARCHAR(100) NOT NULL,
  14.     patronymic VARCHAR(100),
  15.     is_agree BOOLEAN NOT NULL
  16. );
  17.  
  18. CREATE TABLE doc_address_fact
  19. (
  20.     id serial NOT NULL
  21.         constraint doc_address_fact_pk
  22.             primary key,
  23.     address_fact VARCHAR(255) NOT NULL,
  24.     person_office_fact_cnt INTEGER NOT NULL,
  25.     id_request INTEGER NOT NULL // И ЗДЕСЬ NOT NULL
  26.         constraint fk_req_addr
  27.             references doc_request
  28. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement