1 CREATE TABLE xonstat.map_game_types
3 map_id integer NOT NULL,
4 game_type_cd character varying(10) NOT NULL,
5 CONSTRAINT map_game_types_pk PRIMARY KEY (map_id, game_type_cd),
6 CONSTRAINT map_game_types_fk001 FOREIGN KEY (map_id)
7 REFERENCES xonstat.maps (map_id) MATCH SIMPLE
8 ON UPDATE NO ACTION ON DELETE NO ACTION,
9 CONSTRAINT map_game_types_fk002 FOREIGN KEY (game_type_cd)
10 REFERENCES xonstat.cd_game_type (game_type_cd) MATCH SIMPLE
11 ON UPDATE NO ACTION ON DELETE NO ACTION
16 ALTER TABLE xonstat.map_game_types OWNER TO xonstat;