Advertisement
Fanadia_Friska

dri henokh

Sep 8th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. CREATE TABLE m_region_customer
  2.  
  3. (
  4. region_customer_id bigint NOT NULL DEFAULT nextval('m_region_customer_seq'::regclass),
  5. tenant_id bigint,
  6. region_id bigint,
  7. customer_id bigint,
  8. create_datetime character varying(14),
  9. create_user_id bigint,
  10. update_datetime character varying(14),
  11. update_user_id bigint,
  12. version bigint,
  13. create_datetime character varying(14),
  14. create_user_id bigint,
  15. update_datetime character varying(14),
  16. update_user_id bigint,
  17. CONSTRAINT m_region_customer_pkey PRIMARY KEY (region_customer_id)
  18.  
  19. )
  20.  
  21. WITH (
  22. OIDS=FALSE
  23. );
  24. ALTER TABLE m_region_customer
  25. OWNER TO sts;
  26.  
  27. CREATE UNIQUE INDEX idx_region_customer_01
  28. ON m_region_customer
  29. USING btree
  30. (region_id, customer_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement