ERP 2.50:QA test plan 2.50/Modularity/Room tables (PostgreSQL)
/***ROOMS_ROOM TABLE******************************/
CREATE TABLE ROOMS_ROOM
(
ROOMS_ROOM_ID varchar(32) NOT NULL,
AD_CLIENT_ID varchar(32) NOT NULL,
AD_ORG_ID varchar(32) NOT NULL,
ISACTIVE character(1) NOT NULL DEFAULT 'Y'::bpchar,
CREATED timestamp without time zone NOT NULL DEFAULT now(),
CREATEDBY varchar(32) NOT NULL,
UPDATED timestamp without time zone NOT NULL DEFAULT now(),
UPDATEDBY varchar(32) NOT NULL,
NAME character varying(60) NOT NULL,
DESCRIPTION character varying(255),
ROOMTYPE character(2),
LOCATION character varying(255),
CONSTRAINT ROOMS_room_key PRIMARY KEY (ROOMS_room_id),
CONSTRAINT adclient_ROOMS_room FOREIGN KEY (ad_client_id)
REFERENCES ad_client (ad_client_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_room_org FOREIGN KEY (ad_org_id)
REFERENCES ad_org (ad_org_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_room_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE ROOMS_room OWNER TO tad;
COMMENT ON COLUMN ROOMS_room.description IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN ROOMS_room.name IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN ROOMS_room.location IS '--OBTG:NVARCHAR--';
/***ROOMS_ROOMSCHEDULE***************************/
CREATE TABLE ROOMS_ROOMSCHEDULE
(
ROOMS_ROOMSCHEDULE_ID varchar(32) NOT NULL,
AD_CLIENT_ID varchar(32) NOT NULL,
AD_ORG_ID varchar(32) NOT NULL,
ISACTIVE character(1) NOT NULL DEFAULT 'Y'::bpchar,
CREATED timestamp without time zone NOT NULL DEFAULT now(),
CREATEDBY varchar(32) NOT NULL,
UPDATED timestamp without time zone NOT NULL DEFAULT now(),
UPDATEDBY varchar(32) NOT NULL,
ROOMS_ROOM_ID varchar(32) NOT NULL,
TOPIC character varying(255),
RESERVATIONDATE timestamp without time zone NOT NULL,
STARTTIME timestamp without time zone NOT NULL,
ENDTIME timestamp without time zone NOT NULL,
AD_USER_ID varchar(32),
FREQUENCY character(2),
CONSTRAINT ROOMS_roomschedule_key PRIMARY KEY (ROOMS_roomschedule_id),
CONSTRAINT adclient_ROOMS_roomschedule FOREIGN KEY (ad_client_id)
REFERENCES ad_client (ad_client_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_roomschedule_org FOREIGN KEY (ad_org_id)
REFERENCES ad_org (ad_org_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_roomschedule_room FOREIGN KEY (ROOMS_room_id)
REFERENCES ROOMS_room (ROOMS_room_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_schedule_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE ROOMS_roomschedule OWNER TO tad;
/***ROOMS_ROOMATTEND*********************************/
CREATE TABLE ROOMS_ROOMATTEND
(
ROOMS_ROOMATTEND_ID varchar(32) NOT NULL,
AD_CLIENT_ID varchar(32) NOT NULL,
AD_ORG_ID varchar(32) NOT NULL,
ISACTIVE character(1) NOT NULL DEFAULT 'Y'::bpchar,
CREATED timestamp without time zone DEFAULT now() NOT NULL,
CREATEDBY varchar(32) NOT NULL,
UPDATED timestamp without time zone DEFAULT now() NOT NULL,
UPDATEDBY varchar(32) NOT NULL,
ROOMS_ROOMSCHEDULE_ID varchar(32) NOT NULL,
MEETINGROLE character varying(255),
TYPEATTENDER character(2),
DEPARTMENT character(2),
AD_USER_ID varchar(32),
C_BPARTNER_ID varchar(32),
CONSTRAINT ROOMS_roomattend_key PRIMARY KEY (ROOMS_roomattend_id),
CONSTRAINT adclient_ROOMS_roomattend FOREIGN KEY (ad_client_id)
REFERENCES ad_client (ad_client_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_roomattend_org FOREIGN KEY (ad_org_id)
REFERENCES ad_org (ad_org_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT auser_ROOMS_roomattend FOREIGN KEY (ad_user_id)
REFERENCES ad_user (ad_user_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT bpartner_ROOMS_roomattend FOREIGN KEY (c_bpartner_id)
REFERENCES c_bpartner (c_bpartner_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT ROOMS_attend_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE ROOMS_roomattend OWNER TO tad;
COMMENT ON COLUMN ROOMS_roomattend.typeattender IS '--OBTG:NVARCHAR--';