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--';