Advertisement
Guest User

Untitled

a guest
Oct 15th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE outcome_ready_codes
  2. (
  3.     id             BIGSERIAL PRIMARY KEY,
  4.     invoice_number VARCHAR     NOT NULL,
  5.     invoice_date   DATE        NOT NULL,
  6.     code           VARCHAR(40) NOT NULL,
  7.     created_at     TIMESTAMP DEFAULT current_timestamp
  8. );
  9.  
  10. CREATE UNIQUE INDEX outcome_ready_codes_id_uindex ON outcome_ready_codes (id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement