Advertisement
Guest User

asiu

a guest
Jan 16th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Table: t_dino_pickup_order
  2.  
  3. -- DROP TABLE t_dino_pickup_order;
  4.  
  5. CREATE TABLE t_dino_pickup_order
  6. (
  7.   pickup_order_id bigint NOT NULL,
  8.   order_no character varying(32),
  9.   order_date timestamp without time zone,
  10.   status character varying(20),
  11.   outlet_id bigint,
  12.   pic_name character varying(32),
  13.   pic_phone character varying(15),
  14.   driver_name character varying(32),
  15.   police_number character varying(10),
  16.   request_code character varying(8),
  17.   create_who character varying(32) NOT NULL,
  18.   create_date timestamp without time zone NOT NULL,
  19.   change_who character varying(32),
  20.   change_date timestamp without time zone,
  21.   delete_flag character varying(1),
  22.   CONSTRAINT t_dino_pickup_order_pk PRIMARY KEY (pickup_order_id),
  23.   CONSTRAINT t_dino_pickup_order_fk FOREIGN KEY (outlet_id)
  24.       REFERENCES m_bu (bu_id) MATCH SIMPLE
  25.       ON UPDATE NO ACTION ON DELETE NO ACTION
  26. )
  27. WITH (
  28.   OIDS=FALSE
  29. );
  30. ALTER TABLE t_dino_pickup_order
  31.   OWNER TO postgres;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement