CREATE TABLE hotel_guest
(
hotel_guest_id character varying(32) NOT NULL,
ad_client_id character varying(32) NOT NULL,
ad_org_id character varying(32) NOT NULL,
isactive character(1) NOT NULL DEFAULT 'Y'::bpchar,
created timestamp without time zone NOT NULL DEFAULT now(),
createdby character varying(32) NOT NULL,
updated timestamp without time zone NOT NULL DEFAULT now(),
updatedby character varying(32) NOT NULL,
documentno character varying(32) NOT NULL,
first_name character varying(100) NOT NULL,
last_name character varying(100) NOT NULL,
c_bpartner_id character varying(32) NOT NULL,
guest_rate varchar(60) NOT NULL DEFAULT 'C'::bpchar,
CONSTRAINT hotel_guest_key PRIMARY KEY (hotel_guest_id),
CONSTRAINT adclient_hotelguest FOREIGN KEY (ad_client_id)
REFERENCES ad_client (ad_client_id),
CONSTRAINT adorg_hotelguest FOREIGN KEY (ad_org_id)
REFERENCES ad_org (ad_org_id),
CONSTRAINT cbpartner_hotelguest FOREIGN KEY (c_bpartner_id)
REFERENCES c_bpartner (c_bpartner_id),
CONSTRAINT documentno_unique_hotelguest UNIQUE(ad_client_id,documentno)
);