Guest User

Untitled

a guest
Aug 20th, 2019
80
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- This script only contains the table creation statements and does not fully represent the table in the database. It's still missing: indices, triggers. Do not use it as a backup.
  2.  
  3. -- Sequence and defined type
  4. CREATE SEQUENCE IF NOT EXISTS payments_id_seq;
  5.  
  6. -- Table Definition
  7. CREATE TABLE 'public'.'payments' (
  8. 'id' int4 NOT NULL DEFAULT nextval('payments_id_seq'::regclass),
  9. 'account' text,
  10. 'date' date,
  11. 'owner' text,
  12. 'amount' float8,
  13. 'pending_balance' float8,
  14. PRIMARY KEY ('id')
  15. );
RAW Paste Data