2014年2月17日 星期一

Table: adempiere.z_pp_option

-- Table: adempiere.z_pp_option

-- DROP TABLE adempiere.z_pp_option;

CREATE TABLE adempiere.z_pp_option
(
  z_pp_option_id numeric(10,0) NOT NULL,
  ad_client_id numeric(10,0) NOT NULL,
  ad_org_id numeric(10,0) NOT NULL,
  isactive character(1) NOT NULL DEFAULT 'Y'::bpchar,
  created timestamp without time zone NOT NULL DEFAULT now(),
  createdby numeric(10,0) NOT NULL,
  updated timestamp without time zone NOT NULL DEFAULT now(),
  updatedby numeric(10,0) NOT NULL,
  value character varying(40) NOT NULL,
  name character varying(60) NOT NULL,
  description character varying(255),
  help character varying(2000),
  startdate timestamp without time zone,
  completedate timestamp without time zone,
  z_pp_option_uu character varying(36) DEFAULT NULL::character varying,
  isforward character(1) NOT NULL DEFAULT 'Y'::bpchar,
  schedulemethod character varying(40),
  CONSTRAINT z_pp_option_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (
  OIDS=FALSE
);
ALTER TABLE adempiere.z_pp_option
  OWNER TO postgres;

沒有留言:

張貼留言