create extension if not exists postgis cascade;

create extension if not exists "uuid-ossp";

create schema if not exists bs;

create table bs.simu (
  	id serial primary key,
	pid integer,
	num integer,
  	name varchar(200),
	service_name varchar(200),
	data varchar(8000),
	status smallint default 0,
	result varchar(2000),
	create_time timestamp(6) without time zone default now(),
	update_time timestamp(6) without time zone,
	sem_url varchar(2000),
	point_url varchar(2000),
	link_url varchar(2000),
	bak varchar(2000)
);

select * from bs.simu;
