Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Table: t_dino_pickup_order
- -- DROP TABLE t_dino_pickup_order;
- CREATE TABLE t_dino_pickup_order
- (
- pickup_order_id bigint NOT NULL,
- order_no character varying(32),
- order_date timestamp without time zone,
- status character varying(20),
- outlet_id bigint,
- pic_name character varying(32),
- pic_phone character varying(15),
- driver_name character varying(32),
- police_number character varying(10),
- request_code character varying(8),
- create_who character varying(32) NOT NULL,
- create_date timestamp without time zone NOT NULL,
- change_who character varying(32),
- change_date timestamp without time zone,
- delete_flag character varying(1),
- CONSTRAINT t_dino_pickup_order_pk PRIMARY KEY (pickup_order_id),
- CONSTRAINT t_dino_pickup_order_fk FOREIGN KEY (outlet_id)
- REFERENCES m_bu (bu_id) MATCH SIMPLE
- ON UPDATE NO ACTION ON DELETE NO ACTION
- )
- WITH (
- OIDS=FALSE
- );
- ALTER TABLE t_dino_pickup_order
- OWNER TO postgres;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement