CREATE TABLE chat_transcripts (
transcript_id integer PRIMARY KEY NOT NULL,
contents varchar(32000) NOT NULL,
pretty_name varchar(100) NOT NULL,
description varchar(2000),
room_id integer,
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT chat_trans_room_id_fk REFERENCES chat_rooms (),
CONSTRAINT chat_trans_transcript_id_fk REFERENCES chat_rooms (),
CONSTRAINT chat_trans_transcript_id_pk REFERENCES chat_rooms () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT chat_trans_transcript_id_pk REFERENCES acs_objects (),
CONSTRAINT chat_trans_room_id_fk REFERENCES acs_objects (),
CONSTRAINT chat_trans_transcript_id_fk REFERENCES acs_objects ()
);
CREATE INDEX chat_transcripts_room_id_idx ON chat_transcripts (room_id);
CREATE TRIGGER RI_ConstraintTrigger_c_341199 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341200 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341204 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341205 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 0 bytes
-- Table rows: 0
Tables: