--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.23
-- Dumped by pg_dump version 9.6.23

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'SQL_ASCII';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: business; Type: SCHEMA; Schema: -; Owner: oequal5_mahjfit
--

CREATE SCHEMA business;


ALTER SCHEMA business OWNER TO oequal5_mahjfit;

--
-- Name: SCHEMA business; Type: COMMENT; Schema: -; Owner: oequal5_mahjfit
--

COMMENT ON SCHEMA business IS 'standard public schema';


--
-- Name: shared; Type: SCHEMA; Schema: -; Owner: oequal5_mahjfit
--

CREATE SCHEMA shared;


ALTER SCHEMA shared OWNER TO oequal5_mahjfit;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: mj_bot_level; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_bot_level (
    botlvl_id smallint NOT NULL,
    botlvl_title character varying(64) NOT NULL,
    botlvl_desc character varying(255),
    botlvl_mode smallint NOT NULL,
    botlvl_created timestamp with time zone DEFAULT now() NOT NULL,
    botlvl_updated timestamp with time zone,
    botlvl_deleted timestamp with time zone
);


ALTER TABLE business.mj_bot_level OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_bot_level.botlvl_mode; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_bot_level.botlvl_mode IS '1=> Easy, 2=> Normal, 3=> Fast';


--
-- Name: mj_bot_profile; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_bot_profile (
    botp_id bigint NOT NULL,
    botp_botlvl_id smallint NOT NULL,
    botp_title character varying(64) NOT NULL,
    botp_think_time_min_ms smallint NOT NULL,
    botp_think_time_max_ms smallint NOT NULL,
    botp_claim_aggression numeric(10,2),
    botp_defense_weight numeric(10,2),
    botp_hand_reading_weight numeric(10,2),
    botp_discard_safety_weight numeric(10,2),
    botp_joker_usage_weight numeric(10,2),
    botp_exposure_preference smallint,
    botp_error_rate numeric(10,2),
    botp_randomness numeric(10,2),
    botp_react_to_danger numeric(10,2),
    botp_charleston_quality numeric(10,2),
    botp_active timestamp with time zone,
    botp_created timestamp with time zone DEFAULT now() NOT NULL,
    botp_updated timestamp with time zone,
    botp_deleted timestamp with time zone
);


ALTER TABLE business.mj_bot_profile OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_bot_profile.botp_active; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_bot_profile.botp_active IS 'date-time => No | null => Yes';


--
-- Name: mj_digital_product; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_digital_product (
    dgp_id integer NOT NULL,
    dgp_title character varying(128) NOT NULL,
    dgp_desc character varying(255),
    dgp_dgpcat_id smallint NOT NULL,
    dgp_billing_interval_days smallint NOT NULL,
    dgp_private timestamp with time zone,
    dgp_public timestamp with time zone,
    dgp_free timestamp with time zone,
    dgp_received_points smallint,
    dgp_bonus_points smallint,
    dgp_record_position integer,
    dgp_amount smallint NOT NULL,
    dgp_code character varying(16),
    dgp_created timestamp with time zone DEFAULT now() NOT NULL,
    dgp_updated timestamp with time zone,
    dgp_deleted timestamp with time zone
);


ALTER TABLE business.mj_digital_product OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_digital_product.dgp_dgpcat_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product.dgp_dgpcat_id IS 'FK(digital_product_category = > digiprocat_id)';


--
-- Name: COLUMN mj_digital_product.dgp_private; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product.dgp_private IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_digital_product.dgp_public; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product.dgp_public IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_digital_product.dgp_free; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product.dgp_free IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_digital_product.dgp_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product.dgp_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_digital_product_category; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_digital_product_category (
    dgpcat_id smallint NOT NULL,
    dgpcat_title character varying(128) NOT NULL,
    dgpcat_desc character varying(255),
    dgpcat_active timestamp with time zone,
    dgpcat_created timestamp with time zone DEFAULT now() NOT NULL,
    dgpcat_updated timestamp with time zone,
    dgpcat_deleted timestamp with time zone
);


ALTER TABLE business.mj_digital_product_category OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_digital_product_category.dgpcat_active; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product_category.dgpcat_active IS 'date-time => No | null => Yes';


--
-- Name: COLUMN mj_digital_product_category.dgpcat_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product_category.dgpcat_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_digital_product_payment_gateway; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_digital_product_payment_gateway (
    dppg_id smallint NOT NULL,
    dppg_tppltf_id smallint NOT NULL,
    dppg_product_id smallint NOT NULL,
    dppg_created timestamp with time zone DEFAULT now() NOT NULL,
    dppg_updated timestamp with time zone,
    dppg_deleted timestamp with time zone
);


ALTER TABLE business.mj_digital_product_payment_gateway OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_digital_product_payment_gateway.dppg_tppltf_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product_payment_gateway.dppg_tppltf_id IS 'FK(mj_third_party_platform => tppltf_id)

Need to save id of payment provider';


--
-- Name: COLUMN mj_digital_product_payment_gateway.dppg_product_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product_payment_gateway.dppg_product_id IS 'Save thrid party product id when create product or plan in any third party platform you will get product or plan id';


--
-- Name: COLUMN mj_digital_product_payment_gateway.dppg_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_digital_product_payment_gateway.dppg_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game (
    game_id integer NOT NULL,
    game_owner_u_id integer NOT NULL,
    game_dealer_u_id integer NOT NULL,
    game_grule_id integer NOT NULL,
    game_tilest_id integer,
    game_allow_join smallint NOT NULL,
    game_hint timestamp with time zone,
    game_wrkstatus_id smallint NOT NULL,
    game_suspended timestamp with time zone,
    game_current_turn_u_id integer,
    game_created timestamp with time zone DEFAULT now() NOT NULL,
    game_updated timestamp with time zone,
    game_deleted timestamp with time zone
);


ALTER TABLE business.mj_game OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game.game_owner_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_owner_u_id IS 'Fk(user => u_id)';


--
-- Name: COLUMN mj_game.game_dealer_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_dealer_u_id IS 'Fk(user => u_id)';


--
-- Name: COLUMN mj_game.game_grule_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_grule_id IS 'Fk(game_rule => grule_id)';


--
-- Name: COLUMN mj_game.game_tilest_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_tilest_id IS 'Fk(tile_style => tilest_id)';


--
-- Name: COLUMN mj_game.game_allow_join; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_allow_join IS '1 => Only Bots (training mode), 2 => Only Friends (private room), 3 => public game';


--
-- Name: COLUMN mj_game.game_wrkstatus_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_wrkstatus_id IS 'Fk(work_status => wrkstatus_id)';


--
-- Name: COLUMN mj_game.game_suspended; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_suspended IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_game.game_current_turn_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_current_turn_u_id IS 'FK(user => u_id)';


--
-- Name: COLUMN mj_game.game_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game.game_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_play; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_play (
    gplay_id integer NOT NULL,
    gplay_tile_ids smallint[] NOT NULL,
    gplay_from_gseat_id integer,
    gplay_to_gseat_id integer,
    gplay_gpaction_id smallint NOT NULL,
    gplay_created timestamp with time zone DEFAULT now() NOT NULL,
    gplay_updated timestamp with time zone,
    gplay_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_play OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_play.gplay_from_gseat_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_play.gplay_from_gseat_id IS 'FK(game_seat => gseat_id)';


--
-- Name: COLUMN mj_game_play.gplay_to_gseat_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_play.gplay_to_gseat_id IS 'Fk(game_seat => gseat_id)';


--
-- Name: COLUMN mj_game_play.gplay_gpaction_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_play.gplay_gpaction_id IS 'Fk(game_play_action => gpaction_id)';


--
-- Name: COLUMN mj_game_play.gplay_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_play.gplay_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_play_action; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_play_action (
    gpaction_id integer NOT NULL,
    gpaction_title character varying(64) NOT NULL,
    gpaction_desc character varying(255),
    gpaction_audio_file character varying(128),
    gpaction_created timestamp with time zone DEFAULT now() NOT NULL,
    gpaction_updated timestamp with time zone,
    gpaction_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_play_action OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_play_action.gpaction_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_play_action.gpaction_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_rule; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_rule (
    grule_id integer NOT NULL,
    grule_year smallint NOT NULL,
    grule_json_file character varying(255),
    grule_schema_version character varying(32),
    grule_revision integer DEFAULT 1,
    grule_title character varying(150),
    grule_active timestamp with time zone,
    grule_default timestamp with time zone,
    grule_created timestamp with time zone DEFAULT now() NOT NULL,
    grule_updated timestamp with time zone,
    grule_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_rule OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_rule.grule_active; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_rule.grule_active IS 'date-time => No | null => Yes';


--
-- Name: COLUMN mj_game_rule.grule_default; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_rule.grule_default IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_game_rule.grule_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_rule.grule_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_rule_hand; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_rule_hand (
    grh_id integer NOT NULL,
    grh_grule_id integer NOT NULL,
    grh_hand_title character varying(255) NOT NULL,
    grh_label character varying(255) NOT NULL,
    grh_tiles_total smallint NOT NULL,
    grh_value_kind smallint NOT NULL,
    grh_value_mult numeric(10,2),
    grh_hand_json jsonb NOT NULL,
    grh_created timestamp with time zone DEFAULT now() NOT NULL,
    grh_updated timestamp with time zone,
    grh_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_rule_hand OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_rule_hand.grh_grule_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_rule_hand.grh_grule_id IS 'FK(game_rule => grule_id)';


--
-- Name: COLUMN mj_game_rule_hand.grh_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_rule_hand.grh_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_seat; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_seat (
    gseat_id integer NOT NULL,
    gseat_game_id integer NOT NULL,
    gseat_gseattype_id smallint NOT NULL,
    gseat_tilest_id integer,
    gseat_u_id integer,
    gseat_user_status smallint,
    gseat_player_type smallint NOT NULL,
    gseat_sound_off timestamp with time zone,
    gseat_auto_pick timestamp with time zone,
    gseat_created timestamp with time zone DEFAULT now() NOT NULL,
    gseat_updated timestamp with time zone,
    gseat_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_seat OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_seat.gseat_game_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_game_id IS 'Fk(game => game_id)';


--
-- Name: COLUMN mj_game_seat.gseat_gseattype_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_gseattype_id IS 'Fk(game_seat_type => gseattype_id)';


--
-- Name: COLUMN mj_game_seat.gseat_tilest_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_tilest_id IS 'FK(tile_style => tilest_id)';


--
-- Name: COLUMN mj_game_seat.gseat_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_u_id IS 'FK(user => u_id)';


--
-- Name: COLUMN mj_game_seat.gseat_sound_off; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_sound_off IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_game_seat.gseat_auto_pick; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_auto_pick IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_game_seat.gseat_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat.gseat_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_seat_type; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_seat_type (
    gseattype_id smallint NOT NULL,
    gseattype_title character varying(50) NOT NULL,
    gseattype_code character varying(10) NOT NULL,
    gseattype_created timestamp with time zone DEFAULT now() NOT NULL,
    gseattype_updated timestamp with time zone,
    gseattype_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_seat_type OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_seat_type.gseattype_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_seat_type.gseattype_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_game_tile; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_game_tile (
    gtile_id integer NOT NULL,
    gtile_tile_id integer NOT NULL,
    gtile_gseat_id integer NOT NULL,
    gtile_in_exposer_one timestamp with time zone,
    gtile_in_rack_one timestamp with time zone,
    gtile_sort_exposer_one integer,
    gtile_sort_rack_one integer,
    gtile_in_exposer_two timestamp with time zone,
    gtile_in_rack_two timestamp with time zone,
    gtile_sort_exposer_two integer,
    gtile_sort_rack_two integer,
    gtile_created timestamp with time zone DEFAULT now() NOT NULL,
    gtile_updated timestamp with time zone,
    gtile_deleted timestamp with time zone
);


ALTER TABLE business.mj_game_tile OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_game_tile.gtile_tile_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_tile.gtile_tile_id IS 'FK(tile => tile_id)';


--
-- Name: COLUMN mj_game_tile.gtile_gseat_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_tile.gtile_gseat_id IS 'FK(game_seat => gseat_id)';


--
-- Name: COLUMN mj_game_tile.gtile_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_game_tile.gtile_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_tile; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_tile (
    tile_id integer NOT NULL,
    tile_code character varying(16) NOT NULL,
    tile_display_name character varying(64) NOT NULL,
    tile_display_short_name character varying(16) NOT NULL,
    tile_category smallint NOT NULL,
    tile_type smallint NOT NULL,
    tile_set smallint NOT NULL,
    tile_rank smallint NOT NULL,
    tile_honor timestamp with time zone,
    tile_audio_file character varying(128),
    tile_created timestamp with time zone DEFAULT now() NOT NULL,
    tile_updated timestamp with time zone,
    tile_deleted timestamp with time zone,
    CONSTRAINT chk_tile_rank CHECK (((tile_rank >= 1) AND (tile_rank <= 9)))
);


ALTER TABLE business.mj_tile OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_tile.tile_category; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile.tile_category IS '1 => SUITED, 2 => WIND, 3 => DRAGON, 4 => FLOWER, 5 => JOKER [ST]';


--
-- Name: COLUMN mj_tile.tile_type; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile.tile_type IS 'S1 => BAM, S2 => DOT, S3 => CRAK,  W4 => EAST, W5 => SOUTH, W6 => WEST, W7 => NORTH, D8 => RED, D9 => GREEN, D3 => WHITE [ST] ';


--
-- Name: COLUMN mj_tile.tile_honor; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile.tile_honor IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_tile.tile_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile.tile_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_tile_image; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_tile_image (
    tileimg_id integer NOT NULL,
    tileimg_tilest_id integer NOT NULL,
    tileimg_tile_id integer NOT NULL,
    tileimg_face_frame_file character varying(255),
    tileimg_back_frame_file character varying(255),
    tileimg_scale numeric(10,4),
    tileimg_offset_x numeric(10,4) DEFAULT 0,
    tileimg_offset_y numeric(10,4) DEFAULT 0,
    tileimg_anchor_x numeric(10,4) DEFAULT 0,
    tileimg_anchor_y numeric(10,4) DEFAULT 0,
    tileimg_meta jsonb,
    tileimg_created timestamp with time zone DEFAULT now() NOT NULL,
    tileimg_updated timestamp with time zone,
    tileimg_deleted timestamp with time zone
);


ALTER TABLE business.mj_tile_image OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_tile_image.tileimg_tilest_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile_image.tileimg_tilest_id IS 'FK(tile_style => tilest_id)';


--
-- Name: COLUMN mj_tile_image.tileimg_tile_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile_image.tileimg_tile_id IS 'FK(tile => tile_id)';


--
-- Name: COLUMN mj_tile_image.tileimg_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile_image.tileimg_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_tile_style; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_tile_style (
    tilest_id integer NOT NULL,
    tilest_title character varying(64) NOT NULL,
    tilest_desc character varying(255),
    tilest_file character varying(255) NOT NULL,
    tilest_default_width smallint NOT NULL,
    tilest_default_height smallint NOT NULL,
    tilest_active timestamp with time zone,
    tilest_created timestamp with time zone DEFAULT now() NOT NULL,
    tilest_updated timestamp with time zone,
    tilest_deleted timestamp with time zone
);


ALTER TABLE business.mj_tile_style OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_tile_style.tilest_active; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile_style.tilest_active IS 'datetime => Yes | null => No	';


--
-- Name: COLUMN mj_tile_style.tilest_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_tile_style.tilest_deleted IS 'datetime => Yes | null => No	';


--
-- Name: mj_user_digital_purchase; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_user_digital_purchase (
    udgpur_id bigint NOT NULL,
    udgpur_u_id integer NOT NULL,
    udgpur_bill_fname character varying(32),
    udgpur_bill_lname character varying(32),
    udgpur_bill_company character varying(32),
    udgpur_mobile character varying(16),
    udgpur_mobile_cc character varying(8),
    udgpur_address character varying(255),
    udgpur_from_region_name character varying(128),
    udgpur_from_city_name character varying(128),
    udgpur_from_state_name character varying(128),
    udgpur_from_country_id integer,
    udgpur_from_zipcode character varying(20),
    udgpur_from_email character varying(128),
    udgpur_from_tin_no character varying(50),
    udgpur_tax_amount numeric(12,2) DEFAULT 0,
    udgpur_currency_conversion_rate numeric(12,6) DEFAULT 1,
    udgpur_additional_tax_amount numeric(12,2) DEFAULT 0,
    udgpur_offer_discount_amount numeric(12,2) DEFAULT 0,
    udgpur_subtotal_amount numeric(12,2) DEFAULT 0,
    udgpur_total_amount numeric(12,2) DEFAULT 0,
    udgpur_office_note character varying(255),
    udgpur_dppg_id smallint,
    udgpur_transaction_id character varying(255),
    udgpur_charge_fee smallint,
    udgpur_payment_wrkstatus_id smallint,
    udppur_completed timestamp with time zone,
    udppur_created timestamp with time zone DEFAULT now() NOT NULL,
    udppur_updated timestamp with time zone,
    udppur_deleted timestamp with time zone,
    udgpur_payment_tppltf_id smallint,
    udgpur_payment_response jsonb
);


ALTER TABLE business.mj_user_digital_purchase OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_digital_purchase.udgpur_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase.udgpur_u_id IS 'FK(user => u_id)';


--
-- Name: COLUMN mj_user_digital_purchase.udgpur_dppg_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase.udgpur_dppg_id IS 'FK(digital_product_payment_gateway => dppg_id)';


--
-- Name: COLUMN mj_user_digital_purchase.udgpur_payment_wrkstatus_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase.udgpur_payment_wrkstatus_id IS 'FK(work_status => wrkstatus_id ) payment status ';


--
-- Name: COLUMN mj_user_digital_purchase.udppur_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase.udppur_deleted IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_digital_purchase.udgpur_payment_tppltf_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase.udgpur_payment_tppltf_id IS 'FK(third_party_platform => tppltf_id)

Add Id of using which payment gateway product purchase';


--
-- Name: mj_user_digital_purchase_items; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_user_digital_purchase_items (
    udgpuritm_id bigint NOT NULL,
    udgpuritm_udgpur_id bigint NOT NULL,
    udgpuritm_qty smallint NOT NULL,
    udgpuritm_discount_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_tax_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_additional_tax_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_subtotal_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_total_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_billing_interval_days smallint NOT NULL,
    udgpuritm_comment character varying(255),
    udgpuritm_amount smallint DEFAULT 0 NOT NULL,
    udgpuritm_tax_percentage smallint,
    udgpuritm_additional_tax_percentage smallint,
    udgpuritm_private timestamp with time zone,
    udgpuritm_public timestamp with time zone,
    udgpuritm_free timestamp with time zone,
    udgpuritm_dgp_id integer,
    ugppuritm_created timestamp with time zone DEFAULT now() NOT NULL,
    ugppuritm_updated timestamp with time zone,
    ugppuritm_deleted timestamp with time zone
);


ALTER TABLE business.mj_user_digital_purchase_items OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_digital_purchase_items.udgpuritm_udgpur_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.udgpuritm_udgpur_id IS 'FK(user_digital_purchase => udgpur_id)';


--
-- Name: COLUMN mj_user_digital_purchase_items.udgpuritm_private; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.udgpuritm_private IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_digital_purchase_items.udgpuritm_public; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.udgpuritm_public IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_digital_purchase_items.udgpuritm_free; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.udgpuritm_free IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_digital_purchase_items.udgpuritm_dgp_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.udgpuritm_dgp_id IS 'FK(digital_product => udgpuritm_dgp_id)';


--
-- Name: COLUMN mj_user_digital_purchase_items.ugppuritm_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_digital_purchase_items.ugppuritm_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_user_friends; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_user_friends (
    ufrnd_id integer NOT NULL,
    ufrnd_from_u_id integer NOT NULL,
    ufrnd_to_u_id integer NOT NULL,
    ufrnd_wrkstatus_id smallint NOT NULL,
    ufrnd_accpeted timestamp with time zone,
    ufrnd_from_favorite timestamp with time zone,
    ufrnd_to_favorite timestamp with time zone,
    ufrnd_created timestamp with time zone DEFAULT now() NOT NULL,
    ufrnd_updated timestamp with time zone,
    ufrnd_deleted timestamp with time zone
);


ALTER TABLE business.mj_user_friends OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_friends.ufrnd_from_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_friends.ufrnd_from_u_id IS 'FK(user => u_id)';


--
-- Name: COLUMN mj_user_friends.ufrnd_to_u_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_friends.ufrnd_to_u_id IS 'FK(user => u_id';


--
-- Name: COLUMN mj_user_friends.ufrnd_wrkstatus_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_friends.ufrnd_wrkstatus_id IS 'FK(work_status => wrkstatus_id ) ADD PENDING, ACCEPTED, BLOCKED';


--
-- Name: COLUMN mj_user_friends.ufrnd_accpeted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_friends.ufrnd_accpeted IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_friends.ufrnd_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_friends.ufrnd_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_user_membership; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_user_membership (
    umbr_id integer NOT NULL,
    umbr_dgp_id integer NOT NULL,
    umbr_start date NOT NULL,
    umbr_end date NOT NULL,
    umbr_auto_renew timestamp with time zone,
    umbr_udgpur_id bigint,
    umbr_created timestamp with time zone DEFAULT now() NOT NULL,
    umbr_updated timestamp with time zone,
    umbr_deleted timestamp with time zone,
    CONSTRAINT chk_umbr_start_end CHECK ((umbr_start < umbr_end))
);


ALTER TABLE business.mj_user_membership OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_membership.umbr_dgp_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_membership.umbr_dgp_id IS 'FK(digital_product => dgp_id)';


--
-- Name: COLUMN mj_user_membership.umbr_udgpur_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_membership.umbr_udgpur_id IS 'FK(user_digital_purchase => udgpur_id)';


--
-- Name: COLUMN mj_user_membership.umbr_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_membership.umbr_deleted IS 'date-time => Yes | null => No	';


--
-- Name: mj_user_wallet_transaction; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_user_wallet_transaction (
    uwtrans_id bigint NOT NULL,
    uwtrans_from_ref_id integer NOT NULL,
    uwtrans_from_ref_type character varying(255) NOT NULL,
    uwtrans_to_ref_id integer NOT NULL,
    uwtrans_to_ref_type character varying(255) NOT NULL,
    uwtrans_points integer NOT NULL,
    uwtrans_private_notes character varying(255),
    uwtrans_notes character varying(255),
    uwtrans_suspicious timestamp with time zone,
    uwtrans_blocked timestamp with time zone,
    uwtrans_created timestamp with time zone DEFAULT now() NOT NULL,
    uwtrans_updated timestamp with time zone,
    uwtrans_deleted timestamp with time zone
);


ALTER TABLE business.mj_user_wallet_transaction OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_from_ref_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_from_ref_id IS 'Reference table record id';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_from_ref_type; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_from_ref_type IS 'Reference table name';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_to_ref_id; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_to_ref_id IS 'Reference table record id';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_to_ref_type; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_to_ref_type IS 'Reference table name';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_suspicious; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_suspicious IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_blocked; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_blocked IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_wallet_transaction.uwtrans_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_user_wallet_transaction.uwtrans_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_wallet_transaction_ref_type; Type: TABLE; Schema: business; Owner: oequal5_mahjfit
--

CREATE TABLE business.mj_wallet_transaction_ref_type (
    wtranreftype_id smallint NOT NULL,
    wtranreftype_title character varying(128) NOT NULL,
    wtranreftype_desc character varying(255),
    wtranreftype_created timestamp with time zone DEFAULT now() NOT NULL,
    wtranreftype_updated timestamp with time zone,
    wtranreftype_deleted timestamp with time zone
);


ALTER TABLE business.mj_wallet_transaction_ref_type OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_wallet_transaction_ref_type.wtranreftype_deleted; Type: COMMENT; Schema: business; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN business.mj_wallet_transaction_ref_type.wtranreftype_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_alert_duration; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_alert_duration (
    alertdur_id smallint NOT NULL,
    alertdur_title character varying(16) NOT NULL,
    alertdur_created timestamp with time zone DEFAULT now() NOT NULL,
    alertdur_updated timestamp with time zone,
    alertdur_deleted timestamp with time zone
);


ALTER TABLE shared.mj_alert_duration OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_alert_duration.alertdur_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_alert_duration.alertdur_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_api_endpoint_auth; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_api_endpoint_auth (
    aepu_id smallint NOT NULL,
    aepu_role_id smallint DEFAULT 0 NOT NULL,
    aepu_username character varying(128) NOT NULL,
    aepu_email character varying(128) NOT NULL,
    aepu_identify text NOT NULL,
    aepu_jwt_access_token text,
    aepu_jwt_refresh_token text,
    aepu_suspended timestamp with time zone,
    aepu_created timestamp with time zone DEFAULT now() NOT NULL,
    aepu_updated timestamp with time zone,
    aepu_deleted timestamp with time zone
);


ALTER TABLE shared.mj_api_endpoint_auth OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_api_endpoint_auth.aepu_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_api_endpoint_auth.aepu_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_connection_source; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_connection_source (
    connsrc_id smallint NOT NULL,
    connsrc_connsrccat_id smallint NOT NULL,
    connsrc_title character varying(64) NOT NULL,
    connsrc_desc character varying(255),
    connsrc_created timestamp with time zone DEFAULT now() NOT NULL,
    connsrc_updated timestamp with time zone,
    connsrc_deleted timestamp with time zone
);


ALTER TABLE shared.mj_connection_source OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_connection_source.connsrc_connsrccat_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_connection_source.connsrc_connsrccat_id IS 'FK( connection_source_category => connsrccat_id)';


--
-- Name: COLUMN mj_connection_source.connsrc_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_connection_source.connsrc_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_connection_source_category; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_connection_source_category (
    connsrccat_id smallint NOT NULL,
    connsrccat_title character varying(128) NOT NULL,
    connsrccat_desc character varying(255),
    connsrccat_active timestamp with time zone,
    connsrccat_created timestamp with time zone DEFAULT now() NOT NULL,
    connsrccat_updated timestamp with time zone,
    connsrccat_deleted timestamp with time zone
);


ALTER TABLE shared.mj_connection_source_category OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_connection_source_category.connsrccat_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_connection_source_category.connsrccat_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_device; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_device (
    device_id smallint NOT NULL,
    device_user_agent text NOT NULL,
    device_name character varying(128) NOT NULL,
    device_os character varying(128) NOT NULL,
    device_interface character varying(64) NOT NULL,
    device_approved timestamp with time zone,
    device_created timestamp with time zone DEFAULT now() NOT NULL,
    device_updated timestamp with time zone,
    device_deleted timestamp with time zone
);


ALTER TABLE shared.mj_device OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_device.device_user_agent; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_user_agent IS 'RAW string of device which is sent from client side this is the main source to identify device';


--
-- Name: COLUMN mj_device.device_name; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_name IS 'Will be generated or will be set by human';


--
-- Name: COLUMN mj_device.device_os; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_os IS 'OS platform - MAC, WIN, LINUX, IOS, ANDROID, WINDOWS MOBILE. (Will be sent from client side by valid process)	';


--
-- Name: COLUMN mj_device.device_interface; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_interface IS 'Mobile APP, Desktop APP, Google Chrome, FireFox, Safari, Opera... etc Browsers (Will be sent from client side by valid process)	';


--
-- Name: COLUMN mj_device.device_approved; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_approved IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_device.device_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_device.device_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_faq; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_faq (
    faq_id integer NOT NULL,
    faq_faqcat_id smallint NOT NULL,
    faq_url_slug character varying(255) NOT NULL,
    faq_question text NOT NULL,
    faq_answer text NOT NULL,
    faq_active timestamp with time zone,
    faq_created timestamp with time zone DEFAULT now() NOT NULL,
    faq_updated timestamp with time zone,
    faq_deleted timestamp with time zone
);


ALTER TABLE shared.mj_faq OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_faq.faq_faqcat_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_faq.faq_faqcat_id IS 'FK(faq_category => faqcat_id)';


--
-- Name: COLUMN mj_faq.faq_active; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_faq.faq_active IS 'date-time => No | null => Yes';


--
-- Name: COLUMN mj_faq.faq_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_faq.faq_deleted IS 'date-time => No | null => Yes';


--
-- Name: mj_faq_category; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_faq_category (
    faqcat_id smallint NOT NULL,
    faqcat_title character varying(64) NOT NULL,
    faqcat_desc character varying(255),
    faqcat_active timestamp with time zone,
    faqcat_created timestamp with time zone DEFAULT now() NOT NULL,
    faqcat_updated timestamp with time zone,
    faqcat_deleted timestamp with time zone
);


ALTER TABLE shared.mj_faq_category OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_faq_category.faqcat_active; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_faq_category.faqcat_active IS 'date-time => No | null => Yes';


--
-- Name: COLUMN mj_faq_category.faqcat_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_faq_category.faqcat_deleted IS 'date-time => No | null => Yes';


--
-- Name: mj_geo_country; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_geo_country (
    country_id smallint NOT NULL,
    country_name character varying(64) NOT NULL,
    country_numeric_code character(3),
    country_iso_iii character(3),
    country_capital character varying(64),
    country_currency character(3),
    country_currency_name character varying(64),
    country_currency_symbol character varying(16),
    country_emoji character varying(128),
    country_iso_ii character(2),
    country_created timestamp with time zone DEFAULT now() NOT NULL,
    country_updated timestamp without time zone,
    country_deleted timestamp without time zone
);


ALTER TABLE shared.mj_geo_country OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_geo_country.country_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_geo_country.country_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_geo_country_phone_code; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_geo_country_phone_code (
    cntryphcd_id smallint NOT NULL,
    cntryphcd_country_id smallint NOT NULL,
    cntryphcd_created timestamp with time zone DEFAULT now() NOT NULL,
    cntryphcd_updated timestamp with time zone,
    cntryphcd_deleted timestamp with time zone,
    cntryphcd_phone_code character varying(16) NOT NULL
);


ALTER TABLE shared.mj_geo_country_phone_code OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_geo_country_phone_code.cntryphcd_country_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_geo_country_phone_code.cntryphcd_country_id IS 'FK(mj_gelo_country => country_id)';


--
-- Name: COLUMN mj_geo_country_phone_code.cntryphcd_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_geo_country_phone_code.cntryphcd_deleted IS 'date-time => Yes | null => No	';


--
-- Name: mj_lead; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_lead (
    lead_id integer NOT NULL,
    lead_from_uar_id integer NOT NULL,
    lead_to_uar_id integer NOT NULL,
    lead_ref_id character varying(128),
    lead_ref_type character varying(128),
    lead_concern_issue character varying(255),
    lead_preferred_contact_method character varying(16),
    lead_subject character varying(128) NOT NULL,
    lead_comment text,
    lead_created timestamp with time zone DEFAULT now() NOT NULL,
    lead_updated timestamp with time zone,
    lead_deleted timestamp with time zone,
    CONSTRAINT chk_lead_from_uar_id CHECK ((lead_from_uar_id > 0)),
    CONSTRAINT chk_lead_to_uar_id CHECK ((lead_to_uar_id > 0))
);


ALTER TABLE shared.mj_lead OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_lead.lead_from_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_lead.lead_from_uar_id IS 'FK (user_authorisation => uar_id) person who contacted';


--
-- Name: COLUMN mj_lead.lead_to_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_lead.lead_to_uar_id IS 'FK (user_authorisation => uar_id) person who manage/answer request';


--
-- Name: COLUMN mj_lead.lead_ref_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_lead.lead_ref_id IS 'FK (relevant table primary key)';


--
-- Name: COLUMN mj_lead.lead_ref_type; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_lead.lead_ref_type IS 'FK (relevant table name )';


--
-- Name: COLUMN mj_lead.lead_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_lead.lead_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_queue_email; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_queue_email (
    queemail_id integer NOT NULL,
    queemail_wrkstatus_id smallint NOT NULL,
    queemail_from_uar_id bigint NOT NULL,
    queemail_to_uar_id bigint,
    queemail_ref_id character varying(128),
    queemail_ref_type character varying(128),
    queemail_created_uar_id bigint,
    queemail_from_email character varying(128) NOT NULL,
    queemail_to_email character varying(128),
    queemail_cc text,
    queemail_ccother text,
    queemail_bcc text,
    queemail_subject character varying(64),
    queemail_body text NOT NULL,
    queemail_raw_data jsonb,
    queemail_sent timestamp with time zone DEFAULT now(),
    queemail_created timestamp with time zone DEFAULT now() NOT NULL,
    queemail_updated timestamp with time zone,
    queemail_deleted timestamp with time zone
);


ALTER TABLE shared.mj_queue_email OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_queue_email.queemail_wrkstatus_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_wrkstatus_id IS 'FK (work_status => wrkstatus_id)';


--
-- Name: COLUMN mj_queue_email.queemail_from_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_from_uar_id IS 'FK( user_authorisation => uar_id)';


--
-- Name: COLUMN mj_queue_email.queemail_to_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_to_uar_id IS 'FK( user_authorisation => uar_id)';


--
-- Name: COLUMN mj_queue_email.queemail_ref_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_ref_id IS 'FK (relevant table primary key)';


--
-- Name: COLUMN mj_queue_email.queemail_ref_type; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_ref_type IS 'FK (relevant table name)';


--
-- Name: COLUMN mj_queue_email.queemail_created_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_created_uar_id IS 'FK(user_authorisation => uar_id)';


--
-- Name: COLUMN mj_queue_email.queemail_sent; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_sent IS 'date-time => No | null => Yes';


--
-- Name: COLUMN mj_queue_email.queemail_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_queue_email.queemail_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_session; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_session (
    sess_id integer NOT NULL,
    sess_auth_id integer NOT NULL,
    sess_uar_id integer,
    sess_device_id smallint NOT NULL,
    sess_logged_in character(1) DEFAULT false NOT NULL,
    sess_keep_logged character(1) DEFAULT false NOT NULL,
    sess_jwt text,
    sess_data text,
    sess_created timestamp with time zone DEFAULT now() NOT NULL,
    sess_updated timestamp with time zone,
    sess_deleted timestamp with time zone
);


ALTER TABLE shared.mj_session OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_session.sess_auth_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_auth_id IS 'FK to authentication table or any unique id to confirm (this project has => user_authentication => au_id) | 1 user can have multiple but sessions are device based and when any functionality will be accessed by user role and permission will be checked';


--
-- Name: COLUMN mj_session.sess_uar_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_uar_id IS 'FK(user_authorisation => uar_id)';


--
-- Name: COLUMN mj_session.sess_device_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_device_id IS 'FK(device => device_id)';


--
-- Name: COLUMN mj_session.sess_logged_in; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_logged_in IS '1 => Yes | 0 => No (user is logged in or anonymous user)';


--
-- Name: COLUMN mj_session.sess_keep_logged; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_keep_logged IS '1 => Yes | 0 => No';


--
-- Name: COLUMN mj_session.sess_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_session.sess_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_third_party_platform; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_third_party_platform (
    tppltf_id smallint NOT NULL,
    tppltf_slug character varying(255) NOT NULL,
    tppltf_name character varying(128) NOT NULL,
    tppltf_created timestamp with time zone DEFAULT now() NOT NULL,
    tppltf_updated timestamp with time zone,
    tppltf_deleted timestamp with time zone
);


ALTER TABLE shared.mj_third_party_platform OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_third_party_platform.tppltf_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_third_party_platform.tppltf_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_user; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_user (
    u_id integer NOT NULL,
    u_username character varying(128),
    u_url_slug character varying(255),
    u_connsrc_id smallint,
    u_fname character varying(32),
    u_lname character varying(32),
    u_mname character varying(32),
    u_primary_email character varying(128),
    u_primary_mobile character varying(16),
    u_primary_mobile_cc character varying(8),
    u_recovery_email character varying(128),
    u_recovery_mobile character varying(16),
    u_recovery_mobile_cc character varying(8),
    u_file_profile_photo character varying(255),
    u_pemail_verified timestamp with time zone,
    u_pmobile_verified timestamp with time zone,
    u_verified timestamp with time zone,
    u_suspended timestamp with time zone,
    u_created timestamp with time zone DEFAULT now() NOT NULL,
    u_updated timestamp with time zone,
    u_deleted timestamp with time zone,
    u_has_two_factor_auth smallint DEFAULT 0
);


ALTER TABLE shared.mj_user OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user.u_connsrc_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user.u_connsrc_id IS 'FK (connection_source => connsrc_id) From where user came and get registered';


--
-- Name: COLUMN mj_user.u_primary_mobile_cc; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user.u_primary_mobile_cc IS 'FK(geo_country_phone_code => cntryphcd_phone_code)';


--
-- Name: COLUMN mj_user.u_recovery_mobile_cc; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user.u_recovery_mobile_cc IS 'FK(geo_country_phone_code => cntryphcd_phone_code)';


--
-- Name: COLUMN mj_user.u_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user.u_deleted IS 'date-time => No | null => Yes';


--
-- Name: mj_user_authentication; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_user_authentication (
    uau_id integer NOT NULL,
    uau_identify text,
    uau_identify_last text,
    uau_last_changed timestamp with time zone,
    uau_force_reset timestamp with time zone,
    uau_otp character varying(255),
    uau_otp_expiry timestamp with time zone,
    uau_twofa_secret text,
    uau_created timestamp with time zone DEFAULT now() NOT NULL,
    uau_updated timestamp with time zone DEFAULT now() NOT NULL,
    uau_deleted timestamp with time zone
);


ALTER TABLE shared.mj_user_authentication OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_authentication.uau_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_id IS 'FK(user => u_id)';


--
-- Name: COLUMN mj_user_authentication.uau_identify; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_identify IS 'If null, user is not allowed to logged in	';


--
-- Name: COLUMN mj_user_authentication.uau_identify_last; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_identify_last IS 'save previous auth identification';


--
-- Name: COLUMN mj_user_authentication.uau_force_reset; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_force_reset IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_authentication.uau_otp; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_otp IS 'used for signin using opt';


--
-- Name: COLUMN mj_user_authentication.uau_otp_expiry; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_otp_expiry IS 'Expiry date of OTP';


--
-- Name: COLUMN mj_user_authentication.uau_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authentication.uau_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_user_authorisation; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_user_authorisation (
    uar_id integer NOT NULL,
    uar_u_id integer NOT NULL,
    uar_uau_id integer,
    uar_arole_id smallint NOT NULL,
    uar_created timestamp with time zone DEFAULT now() NOT NULL,
    uar_updated timestamp with time zone,
    uar_deleted timestamp with time zone
);


ALTER TABLE shared.mj_user_authorisation OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_authorisation.uar_u_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authorisation.uar_u_id IS 'FK(user=>u_id)';


--
-- Name: COLUMN mj_user_authorisation.uar_uau_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authorisation.uar_uau_id IS 'FK(user_authentication => uau_id)	';


--
-- Name: COLUMN mj_user_authorisation.uar_arole_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authorisation.uar_arole_id IS 'FK(authorisation_role => arole_id)	';


--
-- Name: COLUMN mj_user_authorisation.uar_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_authorisation.uar_deleted IS 'date-time => Yes | null => No';


--
-- Name: mj_user_device; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_user_device (
    udvc_id integer NOT NULL,
    udvc_u_id integer NOT NULL,
    udvc_device_id smallint NOT NULL,
    udvc_from_ip_address character varying(32) NOT NULL,
    udvc_mac_address character varying(128),
    udvc_system_id character varying(128),
    udvc_name character varying(64),
    udvc_suspended timestamp with time zone,
    udvc_created timestamp with time zone DEFAULT now() NOT NULL,
    udvc_updated timestamp with time zone,
    udvc_deleted timestamp with time zone,
    udvc_device_token character varying(255) NOT NULL,
    udvc_uuid character varying(128) NOT NULL,
    udvc_provider_id text,
    udvc_file_avatar text,
    udvc_useragent text NOT NULL,
    udvc_platform character varying(128) NOT NULL,
    udvc_language character varying(16) NOT NULL,
    udvc_timezone character varying(32) NOT NULL,
    udvc_screen_width smallint NOT NULL,
    udvc_screen_height smallint NOT NULL,
    udvc_device_pixel_ratio smallint NOT NULL,
    udvc_hardware_concurrency character varying(8) NOT NULL,
    udvc_max_touch_points character varying(8) NOT NULL,
    udvc_device_memory character varying(8) NOT NULL
);


ALTER TABLE shared.mj_user_device OWNER TO oequal5_mahjfit;

--
-- Name: COLUMN mj_user_device.udvc_u_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_u_id IS 'FK (user => u_id)';


--
-- Name: COLUMN mj_user_device.udvc_device_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_device_id IS 'FK (device => device_id)';


--
-- Name: COLUMN mj_user_device.udvc_system_id; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_system_id IS 'Device ID set by user/system';


--
-- Name: COLUMN mj_user_device.udvc_suspended; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_suspended IS 'date-time => Yes | null => No (device access suspended)';


--
-- Name: COLUMN mj_user_device.udvc_deleted; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_deleted IS 'date-time => Yes | null => No';


--
-- Name: COLUMN mj_user_device.udvc_device_token; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_user_device.udvc_device_token IS 'unique for all devices';


--
-- Name: mj_work_status; Type: TABLE; Schema: shared; Owner: oequal5_mahjfit
--

CREATE TABLE shared.mj_work_status (
    wrkstatus_id smallint NOT NULL,
    wrkstatus_title character varying(16) NOT NULL,
    wrkstatus_created timestamp without time zone DEFAULT now() NOT NULL,
    wrkstatus_updated timestamp without time zone,
    wrkstatus_deleted timestamp without time zone
);


ALTER TABLE shared.mj_work_status OWNER TO oequal5_mahjfit;

--
-- Name: TABLE mj_work_status; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON TABLE shared.mj_work_status IS 'This is universal table to use any kind of status for any work like newsletter sent status, followup status etc';


--
-- Name: COLUMN mj_work_status.wrkstatus_title; Type: COMMENT; Schema: shared; Owner: oequal5_mahjfit
--

COMMENT ON COLUMN shared.mj_work_status.wrkstatus_title IS '(1 => Pending, 2 => Success, 3 => Failed , Rejected, Sent, Draft, Review ) etc';


--
-- Data for Name: mj_bot_level; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_bot_level (botlvl_id, botlvl_title, botlvl_desc, botlvl_mode, botlvl_created, botlvl_updated, botlvl_deleted) FROM stdin;
\.


--
-- Data for Name: mj_bot_profile; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_bot_profile (botp_id, botp_botlvl_id, botp_title, botp_think_time_min_ms, botp_think_time_max_ms, botp_claim_aggression, botp_defense_weight, botp_hand_reading_weight, botp_discard_safety_weight, botp_joker_usage_weight, botp_exposure_preference, botp_error_rate, botp_randomness, botp_react_to_danger, botp_charleston_quality, botp_active, botp_created, botp_updated, botp_deleted) FROM stdin;
\.


--
-- Data for Name: mj_digital_product; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_digital_product (dgp_id, dgp_title, dgp_desc, dgp_dgpcat_id, dgp_billing_interval_days, dgp_private, dgp_public, dgp_free, dgp_received_points, dgp_bonus_points, dgp_record_position, dgp_amount, dgp_code, dgp_created, dgp_updated, dgp_deleted) FROM stdin;
\.


--
-- Data for Name: mj_digital_product_category; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_digital_product_category (dgpcat_id, dgpcat_title, dgpcat_desc, dgpcat_active, dgpcat_created, dgpcat_updated, dgpcat_deleted) FROM stdin;
\.


--
-- Data for Name: mj_digital_product_payment_gateway; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_digital_product_payment_gateway (dppg_id, dppg_tppltf_id, dppg_product_id, dppg_created, dppg_updated, dppg_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game (game_id, game_owner_u_id, game_dealer_u_id, game_grule_id, game_tilest_id, game_allow_join, game_hint, game_wrkstatus_id, game_suspended, game_current_turn_u_id, game_created, game_updated, game_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_play; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_play (gplay_id, gplay_tile_ids, gplay_from_gseat_id, gplay_to_gseat_id, gplay_gpaction_id, gplay_created, gplay_updated, gplay_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_play_action; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_play_action (gpaction_id, gpaction_title, gpaction_desc, gpaction_audio_file, gpaction_created, gpaction_updated, gpaction_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_rule; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_rule (grule_id, grule_year, grule_json_file, grule_schema_version, grule_revision, grule_title, grule_active, grule_default, grule_created, grule_updated, grule_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_rule_hand; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_rule_hand (grh_id, grh_grule_id, grh_hand_title, grh_label, grh_tiles_total, grh_value_kind, grh_value_mult, grh_hand_json, grh_created, grh_updated, grh_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_seat; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_seat (gseat_id, gseat_game_id, gseat_gseattype_id, gseat_tilest_id, gseat_u_id, gseat_user_status, gseat_player_type, gseat_sound_off, gseat_auto_pick, gseat_created, gseat_updated, gseat_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_seat_type; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_seat_type (gseattype_id, gseattype_title, gseattype_code, gseattype_created, gseattype_updated, gseattype_deleted) FROM stdin;
\.


--
-- Data for Name: mj_game_tile; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_game_tile (gtile_id, gtile_tile_id, gtile_gseat_id, gtile_in_exposer_one, gtile_in_rack_one, gtile_sort_exposer_one, gtile_sort_rack_one, gtile_in_exposer_two, gtile_in_rack_two, gtile_sort_exposer_two, gtile_sort_rack_two, gtile_created, gtile_updated, gtile_deleted) FROM stdin;
\.


--
-- Data for Name: mj_tile; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_tile (tile_id, tile_code, tile_display_name, tile_display_short_name, tile_category, tile_type, tile_set, tile_rank, tile_honor, tile_audio_file, tile_created, tile_updated, tile_deleted) FROM stdin;
\.


--
-- Data for Name: mj_tile_image; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_tile_image (tileimg_id, tileimg_tilest_id, tileimg_tile_id, tileimg_face_frame_file, tileimg_back_frame_file, tileimg_scale, tileimg_offset_x, tileimg_offset_y, tileimg_anchor_x, tileimg_anchor_y, tileimg_meta, tileimg_created, tileimg_updated, tileimg_deleted) FROM stdin;
\.


--
-- Data for Name: mj_tile_style; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_tile_style (tilest_id, tilest_title, tilest_desc, tilest_file, tilest_default_width, tilest_default_height, tilest_active, tilest_created, tilest_updated, tilest_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_digital_purchase; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_user_digital_purchase (udgpur_id, udgpur_u_id, udgpur_bill_fname, udgpur_bill_lname, udgpur_bill_company, udgpur_mobile, udgpur_mobile_cc, udgpur_address, udgpur_from_region_name, udgpur_from_city_name, udgpur_from_state_name, udgpur_from_country_id, udgpur_from_zipcode, udgpur_from_email, udgpur_from_tin_no, udgpur_tax_amount, udgpur_currency_conversion_rate, udgpur_additional_tax_amount, udgpur_offer_discount_amount, udgpur_subtotal_amount, udgpur_total_amount, udgpur_office_note, udgpur_dppg_id, udgpur_transaction_id, udgpur_charge_fee, udgpur_payment_wrkstatus_id, udppur_completed, udppur_created, udppur_updated, udppur_deleted, udgpur_payment_tppltf_id, udgpur_payment_response) FROM stdin;
\.


--
-- Data for Name: mj_user_digital_purchase_items; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_user_digital_purchase_items (udgpuritm_id, udgpuritm_udgpur_id, udgpuritm_qty, udgpuritm_discount_amount, udgpuritm_tax_amount, udgpuritm_additional_tax_amount, udgpuritm_subtotal_amount, udgpuritm_total_amount, udgpuritm_billing_interval_days, udgpuritm_comment, udgpuritm_amount, udgpuritm_tax_percentage, udgpuritm_additional_tax_percentage, udgpuritm_private, udgpuritm_public, udgpuritm_free, udgpuritm_dgp_id, ugppuritm_created, ugppuritm_updated, ugppuritm_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_friends; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_user_friends (ufrnd_id, ufrnd_from_u_id, ufrnd_to_u_id, ufrnd_wrkstatus_id, ufrnd_accpeted, ufrnd_from_favorite, ufrnd_to_favorite, ufrnd_created, ufrnd_updated, ufrnd_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_membership; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_user_membership (umbr_id, umbr_dgp_id, umbr_start, umbr_end, umbr_auto_renew, umbr_udgpur_id, umbr_created, umbr_updated, umbr_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_wallet_transaction; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_user_wallet_transaction (uwtrans_id, uwtrans_from_ref_id, uwtrans_from_ref_type, uwtrans_to_ref_id, uwtrans_to_ref_type, uwtrans_points, uwtrans_private_notes, uwtrans_notes, uwtrans_suspicious, uwtrans_blocked, uwtrans_created, uwtrans_updated, uwtrans_deleted) FROM stdin;
\.


--
-- Data for Name: mj_wallet_transaction_ref_type; Type: TABLE DATA; Schema: business; Owner: oequal5_mahjfit
--

COPY business.mj_wallet_transaction_ref_type (wtranreftype_id, wtranreftype_title, wtranreftype_desc, wtranreftype_created, wtranreftype_updated, wtranreftype_deleted) FROM stdin;
\.


--
-- Data for Name: mj_alert_duration; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_alert_duration (alertdur_id, alertdur_title, alertdur_created, alertdur_updated, alertdur_deleted) FROM stdin;
\.


--
-- Data for Name: mj_api_endpoint_auth; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_api_endpoint_auth (aepu_id, aepu_role_id, aepu_username, aepu_email, aepu_identify, aepu_jwt_access_token, aepu_jwt_refresh_token, aepu_suspended, aepu_created, aepu_updated, aepu_deleted) FROM stdin;
\.


--
-- Data for Name: mj_connection_source; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_connection_source (connsrc_id, connsrc_connsrccat_id, connsrc_title, connsrc_desc, connsrc_created, connsrc_updated, connsrc_deleted) FROM stdin;
\.


--
-- Data for Name: mj_connection_source_category; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_connection_source_category (connsrccat_id, connsrccat_title, connsrccat_desc, connsrccat_active, connsrccat_created, connsrccat_updated, connsrccat_deleted) FROM stdin;
\.


--
-- Data for Name: mj_device; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_device (device_id, device_user_agent, device_name, device_os, device_interface, device_approved, device_created, device_updated, device_deleted) FROM stdin;
\.


--
-- Data for Name: mj_faq; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_faq (faq_id, faq_faqcat_id, faq_url_slug, faq_question, faq_answer, faq_active, faq_created, faq_updated, faq_deleted) FROM stdin;
\.


--
-- Data for Name: mj_faq_category; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_faq_category (faqcat_id, faqcat_title, faqcat_desc, faqcat_active, faqcat_created, faqcat_updated, faqcat_deleted) FROM stdin;
\.


--
-- Data for Name: mj_geo_country; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_geo_country (country_id, country_name, country_numeric_code, country_iso_iii, country_capital, country_currency, country_currency_name, country_currency_symbol, country_emoji, country_iso_ii, country_created, country_updated, country_deleted) FROM stdin;
\.


--
-- Data for Name: mj_geo_country_phone_code; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_geo_country_phone_code (cntryphcd_id, cntryphcd_country_id, cntryphcd_created, cntryphcd_updated, cntryphcd_deleted, cntryphcd_phone_code) FROM stdin;
\.


--
-- Data for Name: mj_lead; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_lead (lead_id, lead_from_uar_id, lead_to_uar_id, lead_ref_id, lead_ref_type, lead_concern_issue, lead_preferred_contact_method, lead_subject, lead_comment, lead_created, lead_updated, lead_deleted) FROM stdin;
\.


--
-- Data for Name: mj_queue_email; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_queue_email (queemail_id, queemail_wrkstatus_id, queemail_from_uar_id, queemail_to_uar_id, queemail_ref_id, queemail_ref_type, queemail_created_uar_id, queemail_from_email, queemail_to_email, queemail_cc, queemail_ccother, queemail_bcc, queemail_subject, queemail_body, queemail_raw_data, queemail_sent, queemail_created, queemail_updated, queemail_deleted) FROM stdin;
\.


--
-- Data for Name: mj_session; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_session (sess_id, sess_auth_id, sess_uar_id, sess_device_id, sess_logged_in, sess_keep_logged, sess_jwt, sess_data, sess_created, sess_updated, sess_deleted) FROM stdin;
\.


--
-- Data for Name: mj_third_party_platform; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_third_party_platform (tppltf_id, tppltf_slug, tppltf_name, tppltf_created, tppltf_updated, tppltf_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_user (u_id, u_username, u_url_slug, u_connsrc_id, u_fname, u_lname, u_mname, u_primary_email, u_primary_mobile, u_primary_mobile_cc, u_recovery_email, u_recovery_mobile, u_recovery_mobile_cc, u_file_profile_photo, u_pemail_verified, u_pmobile_verified, u_verified, u_suspended, u_created, u_updated, u_deleted, u_has_two_factor_auth) FROM stdin;
\.


--
-- Data for Name: mj_user_authentication; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_user_authentication (uau_id, uau_identify, uau_identify_last, uau_last_changed, uau_force_reset, uau_otp, uau_otp_expiry, uau_twofa_secret, uau_created, uau_updated, uau_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_authorisation; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_user_authorisation (uar_id, uar_u_id, uar_uau_id, uar_arole_id, uar_created, uar_updated, uar_deleted) FROM stdin;
\.


--
-- Data for Name: mj_user_device; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_user_device (udvc_id, udvc_u_id, udvc_device_id, udvc_from_ip_address, udvc_mac_address, udvc_system_id, udvc_name, udvc_suspended, udvc_created, udvc_updated, udvc_deleted, udvc_device_token, udvc_uuid, udvc_provider_id, udvc_file_avatar, udvc_useragent, udvc_platform, udvc_language, udvc_timezone, udvc_screen_width, udvc_screen_height, udvc_device_pixel_ratio, udvc_hardware_concurrency, udvc_max_touch_points, udvc_device_memory) FROM stdin;
\.


--
-- Data for Name: mj_work_status; Type: TABLE DATA; Schema: shared; Owner: oequal5_mahjfit
--

COPY shared.mj_work_status (wrkstatus_id, wrkstatus_title, wrkstatus_created, wrkstatus_updated, wrkstatus_deleted) FROM stdin;
\.


--
-- Name: mj_bot_level pk_botlvl_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_bot_level
    ADD CONSTRAINT pk_botlvl_id PRIMARY KEY (botlvl_id);


--
-- Name: mj_bot_profile pk_botp_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_bot_profile
    ADD CONSTRAINT pk_botp_id PRIMARY KEY (botp_id);


--
-- Name: mj_digital_product pk_dgp_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_digital_product
    ADD CONSTRAINT pk_dgp_id PRIMARY KEY (dgp_id);


--
-- Name: mj_digital_product_category pk_dgpcat_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_digital_product_category
    ADD CONSTRAINT pk_dgpcat_id PRIMARY KEY (dgpcat_id);


--
-- Name: mj_digital_product_payment_gateway pk_dppg_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_digital_product_payment_gateway
    ADD CONSTRAINT pk_dppg_id PRIMARY KEY (dppg_id);


--
-- Name: mj_game pk_game_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game
    ADD CONSTRAINT pk_game_id PRIMARY KEY (game_id);


--
-- Name: mj_game_play_action pk_gpaction_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_play_action
    ADD CONSTRAINT pk_gpaction_id PRIMARY KEY (gpaction_id);


--
-- Name: mj_game_play pk_gplay_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_play
    ADD CONSTRAINT pk_gplay_id PRIMARY KEY (gplay_id);


--
-- Name: mj_game_rule_hand pk_grh_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_rule_hand
    ADD CONSTRAINT pk_grh_id PRIMARY KEY (grh_id);


--
-- Name: mj_game_rule pk_grule_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_rule
    ADD CONSTRAINT pk_grule_id PRIMARY KEY (grule_id);


--
-- Name: mj_game_seat pk_gseat_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_seat
    ADD CONSTRAINT pk_gseat_id PRIMARY KEY (gseat_id);


--
-- Name: mj_game_seat_type pk_gseattype_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_seat_type
    ADD CONSTRAINT pk_gseattype_id PRIMARY KEY (gseattype_id);


--
-- Name: mj_game_tile pk_gtile_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_tile
    ADD CONSTRAINT pk_gtile_id PRIMARY KEY (gtile_id);


--
-- Name: mj_tile pk_tile_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_tile
    ADD CONSTRAINT pk_tile_id PRIMARY KEY (tile_id);


--
-- Name: mj_tile_image pk_tileimg_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_tile_image
    ADD CONSTRAINT pk_tileimg_id PRIMARY KEY (tileimg_id);


--
-- Name: mj_tile_style pk_tilest_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_tile_style
    ADD CONSTRAINT pk_tilest_id PRIMARY KEY (tilest_id);


--
-- Name: mj_user_digital_purchase pk_udgpur_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_user_digital_purchase
    ADD CONSTRAINT pk_udgpur_id PRIMARY KEY (udgpur_id);


--
-- Name: mj_user_digital_purchase_items pk_udgpuritm_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_user_digital_purchase_items
    ADD CONSTRAINT pk_udgpuritm_id PRIMARY KEY (udgpuritm_id);


--
-- Name: mj_user_friends pk_ufrnd_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_user_friends
    ADD CONSTRAINT pk_ufrnd_id PRIMARY KEY (ufrnd_id);


--
-- Name: mj_user_membership pk_umbr_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_user_membership
    ADD CONSTRAINT pk_umbr_id PRIMARY KEY (umbr_id);


--
-- Name: mj_user_wallet_transaction pk_uwtrans_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_user_wallet_transaction
    ADD CONSTRAINT pk_uwtrans_id PRIMARY KEY (uwtrans_id);


--
-- Name: mj_wallet_transaction_ref_type pk_wtranreftype_id; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_wallet_transaction_ref_type
    ADD CONSTRAINT pk_wtranreftype_id PRIMARY KEY (wtranreftype_id);


--
-- Name: mj_game_seat_type un_gseattype_title_code; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_game_seat_type
    ADD CONSTRAINT un_gseattype_title_code UNIQUE (gseattype_title, gseattype_code);


--
-- Name: mj_tile un_tile_code; Type: CONSTRAINT; Schema: business; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY business.mj_tile
    ADD CONSTRAINT un_tile_code UNIQUE (tile_code);


--
-- Name: mj_work_status mj_work_status_pkey; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_work_status
    ADD CONSTRAINT mj_work_status_pkey PRIMARY KEY (wrkstatus_id);


--
-- Name: mj_api_endpoint_auth pk_aepu_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_api_endpoint_auth
    ADD CONSTRAINT pk_aepu_id PRIMARY KEY (aepu_id);


--
-- Name: mj_alert_duration pk_alertdur_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_alert_duration
    ADD CONSTRAINT pk_alertdur_id PRIMARY KEY (alertdur_id);


--
-- Name: mj_geo_country_phone_code pk_cntryphcd_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_geo_country_phone_code
    ADD CONSTRAINT pk_cntryphcd_id PRIMARY KEY (cntryphcd_id);


--
-- Name: mj_connection_source pk_connsrc_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_connection_source
    ADD CONSTRAINT pk_connsrc_id PRIMARY KEY (connsrc_id);


--
-- Name: mj_connection_source_category pk_connsrccat_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_connection_source_category
    ADD CONSTRAINT pk_connsrccat_id PRIMARY KEY (connsrccat_id);


--
-- Name: mj_geo_country pk_country_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_geo_country
    ADD CONSTRAINT pk_country_id PRIMARY KEY (country_id);


--
-- Name: mj_device pk_device_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_device
    ADD CONSTRAINT pk_device_id PRIMARY KEY (device_id);


--
-- Name: mj_faq pk_faq_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_faq
    ADD CONSTRAINT pk_faq_id PRIMARY KEY (faq_id);


--
-- Name: mj_faq_category pk_faqcat_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_faq_category
    ADD CONSTRAINT pk_faqcat_id PRIMARY KEY (faqcat_id);


--
-- Name: mj_lead pk_lead_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_lead
    ADD CONSTRAINT pk_lead_id PRIMARY KEY (lead_id);


--
-- Name: mj_queue_email pk_queemail_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_queue_email
    ADD CONSTRAINT pk_queemail_id PRIMARY KEY (queemail_id);


--
-- Name: mj_session pk_session_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_session
    ADD CONSTRAINT pk_session_id PRIMARY KEY (sess_id);


--
-- Name: mj_third_party_platform pk_tppltf_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_third_party_platform
    ADD CONSTRAINT pk_tppltf_id PRIMARY KEY (tppltf_id);


--
-- Name: mj_user pk_u_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user
    ADD CONSTRAINT pk_u_id PRIMARY KEY (u_id);


--
-- Name: mj_user_authorisation pk_uar_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_authorisation
    ADD CONSTRAINT pk_uar_id PRIMARY KEY (uar_id);


--
-- Name: mj_user_authentication pk_uau_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_authentication
    ADD CONSTRAINT pk_uau_id PRIMARY KEY (uau_id);


--
-- Name: mj_user_device pk_udvc_id; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_device
    ADD CONSTRAINT pk_udvc_id PRIMARY KEY (udvc_id);


--
-- Name: mj_api_endpoint_auth un_aepu_username; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_api_endpoint_auth
    ADD CONSTRAINT un_aepu_username UNIQUE (aepu_username);


--
-- Name: mj_geo_country un_country_name; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_geo_country
    ADD CONSTRAINT un_country_name UNIQUE (country_name);


--
-- Name: mj_device un_device_name; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_device
    ADD CONSTRAINT un_device_name UNIQUE (device_name, device_os, device_interface);


--
-- Name: mj_faq un_faq_url_slug; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_faq
    ADD CONSTRAINT un_faq_url_slug UNIQUE (faq_url_slug);


--
-- Name: mj_session un_sess_auth_uar_device; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_session
    ADD CONSTRAINT un_sess_auth_uar_device UNIQUE (sess_auth_id, sess_uar_id, sess_device_id);


--
-- Name: mj_third_party_platform un_tppltf_slug; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_third_party_platform
    ADD CONSTRAINT un_tppltf_slug UNIQUE (tppltf_slug);


--
-- Name: mj_user un_u_primary_email; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user
    ADD CONSTRAINT un_u_primary_email UNIQUE (u_primary_email);


--
-- Name: mj_user un_u_primary_mobile; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user
    ADD CONSTRAINT un_u_primary_mobile UNIQUE (u_primary_mobile, u_primary_mobile_cc);


--
-- Name: mj_user un_u_url_slug; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user
    ADD CONSTRAINT un_u_url_slug UNIQUE (u_url_slug);


--
-- Name: mj_user un_u_username; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user
    ADD CONSTRAINT un_u_username UNIQUE (u_username);


--
-- Name: mj_user_authorisation un_uar_u_au_arole; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_authorisation
    ADD CONSTRAINT un_uar_u_au_arole UNIQUE (uar_u_id, uar_uau_id, uar_arole_id);


--
-- Name: mj_user_device un_udvc_u_id_device_id_device_token; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_device
    ADD CONSTRAINT un_udvc_u_id_device_id_device_token UNIQUE (udvc_u_id, udvc_device_id, udvc_device_token);


--
-- Name: mj_user_device un_udvc_uuid; Type: CONSTRAINT; Schema: shared; Owner: oequal5_mahjfit
--

ALTER TABLE ONLY shared.mj_user_device
    ADD CONSTRAINT un_udvc_uuid UNIQUE (udvc_uuid);


--
-- Name: gplay_tile_ids; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX gplay_tile_ids ON business.mj_game_play USING gin (gplay_tile_ids) WITH (fastupdate='true');


--
-- Name: in_game_allow_join; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_allow_join ON business.mj_game USING btree (game_allow_join);


--
-- Name: in_game_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_created ON business.mj_game USING btree (game_created);


--
-- Name: in_game_current_turn_u_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_current_turn_u_id ON business.mj_game USING btree (game_current_turn_u_id);


--
-- Name: in_game_dealer_u_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_dealer_u_id ON business.mj_game USING btree (game_dealer_u_id);


--
-- Name: in_game_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_deleted ON business.mj_game USING btree (game_deleted);


--
-- Name: in_game_grule_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_grule_id ON business.mj_game USING btree (game_grule_id);


--
-- Name: in_game_owner_u_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_owner_u_id ON business.mj_game USING btree (game_owner_u_id);


--
-- Name: in_game_suspended; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_suspended ON business.mj_game USING btree (game_suspended);


--
-- Name: in_game_tilest_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_tilest_id ON business.mj_game USING btree (game_tilest_id);


--
-- Name: in_game_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_game_updated ON business.mj_game USING btree (game_updated);


--
-- Name: in_gplay_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gplay_deleted ON business.mj_game_play USING btree (gplay_deleted);


--
-- Name: in_grh_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_created ON business.mj_game_rule_hand USING btree (grh_created);


--
-- Name: in_grh_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_deleted ON business.mj_game_rule_hand USING btree (grh_deleted);


--
-- Name: in_grh_grule_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_grule_id ON business.mj_game_rule_hand USING btree (grh_grule_id);


--
-- Name: in_grh_hand_title; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_hand_title ON business.mj_game_rule_hand USING btree (grh_hand_title);


--
-- Name: in_grh_label; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_label ON business.mj_game_rule_hand USING btree (grh_label);


--
-- Name: in_grh_tiles_total; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_tiles_total ON business.mj_game_rule_hand USING btree (grh_tiles_total);


--
-- Name: in_grh_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_updated ON business.mj_game_rule_hand USING btree (grh_updated);


--
-- Name: in_grh_value_kind; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_value_kind ON business.mj_game_rule_hand USING btree (grh_value_kind);


--
-- Name: in_grh_value_mult; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_value_mult ON business.mj_game_rule_hand USING btree (grh_value_mult);


--
-- Name: in_grh_wrkstatus_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grh_wrkstatus_id ON business.mj_game USING btree (game_wrkstatus_id);


--
-- Name: in_grule_active; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_active ON business.mj_game_rule USING btree (grule_active);


--
-- Name: in_grule_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_created ON business.mj_game_rule USING btree (grule_created);


--
-- Name: in_grule_default; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_default ON business.mj_game_rule USING btree (grule_default);


--
-- Name: in_grule_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_deleted ON business.mj_game_rule USING btree (grule_deleted);


--
-- Name: in_grule_revision; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_revision ON business.mj_game_rule USING btree (grule_revision);


--
-- Name: in_grule_schema_version; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_schema_version ON business.mj_game_rule USING btree (grule_schema_version);


--
-- Name: in_grule_title; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_title ON business.mj_game_rule USING btree (grule_title);


--
-- Name: in_grule_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_updated ON business.mj_game_rule USING btree (grule_updated);


--
-- Name: in_grule_year; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_grule_year ON business.mj_game_rule USING btree (grule_year);


--
-- Name: in_gseat_auto_pick; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_auto_pick ON business.mj_game_seat USING btree (gseat_auto_pick);


--
-- Name: in_gseat_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_created ON business.mj_game_seat USING btree (gseat_created);


--
-- Name: in_gseat_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_deleted ON business.mj_game_seat USING btree (gseat_deleted);


--
-- Name: in_gseat_game_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_game_id ON business.mj_game_seat USING btree (gseat_game_id);


--
-- Name: in_gseat_gseattype_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_gseattype_id ON business.mj_game_seat USING btree (gseat_gseattype_id);


--
-- Name: in_gseat_player_type; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_player_type ON business.mj_game_seat USING btree (gseat_player_type);


--
-- Name: in_gseat_sound_off; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_sound_off ON business.mj_game_seat USING btree (gseat_sound_off);


--
-- Name: in_gseat_tilest_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_tilest_id ON business.mj_game_seat USING btree (gseat_tilest_id);


--
-- Name: in_gseat_u_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_u_id ON business.mj_game_seat USING btree (gseat_u_id);


--
-- Name: in_gseat_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_updated ON business.mj_game_seat USING btree (gseat_updated);


--
-- Name: in_gseat_user_status; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseat_user_status ON business.mj_game_seat USING btree (gseat_user_status);


--
-- Name: in_gseattype_code; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseattype_code ON business.mj_game_seat_type USING btree (gseattype_code);


--
-- Name: in_gseattype_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseattype_created ON business.mj_game_seat_type USING btree (gseattype_created);


--
-- Name: in_gseattype_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseattype_deleted ON business.mj_game_seat_type USING btree (gseattype_deleted);


--
-- Name: in_gseattype_title; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseattype_title ON business.mj_game_seat_type USING btree (gseattype_title);


--
-- Name: in_gseattype_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gseattype_updated ON business.mj_game_seat_type USING btree (gseattype_updated);


--
-- Name: in_gtile_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_created ON business.mj_game_tile USING btree (gtile_created);


--
-- Name: in_gtile_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_deleted ON business.mj_game_tile USING btree (gtile_deleted);


--
-- Name: in_gtile_gseat_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_gseat_id ON business.mj_game_tile USING btree (gtile_gseat_id);


--
-- Name: in_gtile_in_exposer_one; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_in_exposer_one ON business.mj_game_tile USING btree (gtile_in_exposer_one);


--
-- Name: in_gtile_in_exposer_two; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_in_exposer_two ON business.mj_game_tile USING btree (gtile_in_exposer_two);


--
-- Name: in_gtile_in_rack_one; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_in_rack_one ON business.mj_game_tile USING btree (gtile_in_rack_one);


--
-- Name: in_gtile_in_rack_two; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_in_rack_two ON business.mj_game_tile USING btree (gtile_in_exposer_two);


--
-- Name: in_gtile_sort_exposer_one; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_sort_exposer_one ON business.mj_game_tile USING btree (gtile_sort_exposer_one);


--
-- Name: in_gtile_sort_exposer_two; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_sort_exposer_two ON business.mj_game_tile USING btree (gtile_sort_exposer_two);


--
-- Name: in_gtile_sort_rack_one; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_sort_rack_one ON business.mj_game_tile USING btree (gtile_sort_rack_one);


--
-- Name: in_gtile_sort_rack_two; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_sort_rack_two ON business.mj_game_tile USING btree (gtile_sort_rack_two);


--
-- Name: in_gtile_tile_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_tile_id ON business.mj_game_tile USING btree (gtile_tile_id);


--
-- Name: in_gtile_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_gtile_updated ON business.mj_game_tile USING btree (gtile_updated);


--
-- Name: in_tileimg_anchor_x; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_anchor_x ON business.mj_tile_image USING btree (tileimg_anchor_x);


--
-- Name: in_tileimg_anchor_y; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_anchor_y ON business.mj_tile_image USING btree (tileimg_anchor_y);


--
-- Name: in_tileimg_created; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_created ON business.mj_tile_image USING btree (tileimg_created);


--
-- Name: in_tileimg_deleted; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_deleted ON business.mj_tile_image USING btree (tileimg_deleted);


--
-- Name: in_tileimg_offset_x; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_offset_x ON business.mj_tile_image USING btree (tileimg_offset_x);


--
-- Name: in_tileimg_offset_y; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_offset_y ON business.mj_tile_image USING btree (tileimg_offset_y);


--
-- Name: in_tileimg_scale; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_scale ON business.mj_tile_image USING btree (tileimg_scale);


--
-- Name: in_tileimg_tilest_id; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_tilest_id ON business.mj_tile_image USING btree (tileimg_tilest_id);


--
-- Name: in_tileimg_updated; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_tileimg_updated ON business.mj_tile_image USING btree (tileimg_updated);


--
-- Name: in_udgpur_payment_response; Type: INDEX; Schema: business; Owner: oequal5_mahjfit
--

CREATE INDEX in_udgpur_payment_response ON business.mj_user_digital_purchase USING gin (udgpur_payment_response) WITH (fastupdate='true');


--
-- Name: in_alertdur_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_alertdur_created ON shared.mj_alert_duration USING btree (alertdur_created);


--
-- Name: in_alertdur_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_alertdur_deleted ON shared.mj_alert_duration USING btree (alertdur_deleted);


--
-- Name: in_alertdur_title; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_alertdur_title ON shared.mj_alert_duration USING btree (alertdur_title);


--
-- Name: in_alertdur_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_alertdur_updated ON shared.mj_alert_duration USING btree (alertdur_updated);


--
-- Name: in_connsrccat_active; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_connsrccat_active ON shared.mj_connection_source_category USING btree (connsrccat_active);


--
-- Name: in_connsrccat_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_connsrccat_created ON shared.mj_connection_source_category USING btree (connsrccat_created);


--
-- Name: in_connsrccat_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_connsrccat_deleted ON shared.mj_connection_source_category USING btree (connsrccat_deleted);


--
-- Name: in_connsrccat_title; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_connsrccat_title ON shared.mj_connection_source_category USING btree (connsrccat_title);


--
-- Name: in_connsrccat_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_connsrccat_updated ON shared.mj_connection_source_category USING btree (connsrccat_updated);


--
-- Name: in_device_approved; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_approved ON shared.mj_device USING btree (device_approved);


--
-- Name: in_device_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_created ON shared.mj_device USING btree (device_created);


--
-- Name: in_device_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_deleted ON shared.mj_device USING btree (device_deleted);


--
-- Name: in_device_interface; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_interface ON shared.mj_device USING btree (device_interface);


--
-- Name: in_device_os; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_os ON shared.mj_device USING btree (device_os);


--
-- Name: in_device_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_device_updated ON shared.mj_device USING btree (device_updated);


--
-- Name: in_faqcat_active; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_faqcat_active ON shared.mj_faq_category USING btree (faqcat_active);


--
-- Name: in_faqcat_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_faqcat_created ON shared.mj_faq_category USING btree (faqcat_created);


--
-- Name: in_faqcat_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_faqcat_deleted ON shared.mj_faq_category USING btree (faqcat_deleted);


--
-- Name: in_faqcat_title; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_faqcat_title ON shared.mj_faq_category USING btree (faqcat_title);


--
-- Name: in_faqcat_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_faqcat_updated ON shared.mj_faq_category USING btree (faqcat_updated);


--
-- Name: in_queemail_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_created ON shared.mj_queue_email USING btree (queemail_created);


--
-- Name: in_queemail_created_uar_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_created_uar_id ON shared.mj_queue_email USING btree (queemail_created_uar_id);


--
-- Name: in_queemail_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_deleted ON shared.mj_queue_email USING btree (queemail_deleted);


--
-- Name: in_queemail_from_email; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_from_email ON shared.mj_queue_email USING btree (queemail_from_email);


--
-- Name: in_queemail_from_uar_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_from_uar_id ON shared.mj_queue_email USING btree (queemail_from_uar_id);


--
-- Name: in_queemail_ref_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_ref_id ON shared.mj_queue_email USING btree (queemail_ref_id);


--
-- Name: in_queemail_ref_type; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_ref_type ON shared.mj_queue_email USING btree (queemail_ref_type);


--
-- Name: in_queemail_sent; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_sent ON shared.mj_queue_email USING btree (queemail_sent);


--
-- Name: in_queemail_subject; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_subject ON shared.mj_queue_email USING btree (queemail_subject);


--
-- Name: in_queemail_to_email; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_to_email ON shared.mj_queue_email USING btree (queemail_to_email);


--
-- Name: in_queemail_to_uar_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_to_uar_id ON shared.mj_queue_email USING btree (queemail_to_uar_id);


--
-- Name: in_queemail_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_updated ON shared.mj_queue_email USING btree (queemail_updated);


--
-- Name: in_queemail_wrkstatus_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_queemail_wrkstatus_id ON shared.mj_queue_email USING btree (queemail_wrkstatus_id);


--
-- Name: in_sess_auth_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_auth_id ON shared.mj_session USING btree (sess_auth_id);


--
-- Name: in_sess_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_created ON shared.mj_session USING btree (sess_created);


--
-- Name: in_sess_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_deleted ON shared.mj_session USING btree (sess_deleted);


--
-- Name: in_sess_device_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_device_id ON shared.mj_session USING btree (sess_device_id);


--
-- Name: in_sess_keep_logged; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_keep_logged ON shared.mj_session USING btree (sess_keep_logged);


--
-- Name: in_sess_logged_in; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_logged_in ON shared.mj_session USING btree (sess_logged_in);


--
-- Name: in_sess_uar_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_uar_id ON shared.mj_session USING btree (sess_uar_id);


--
-- Name: in_sess_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_sess_updated ON shared.mj_session USING btree (sess_updated);


--
-- Name: in_u_connsrc_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_connsrc_id ON shared.mj_user USING btree (u_connsrc_id);


--
-- Name: in_u_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_created ON shared.mj_user USING btree (u_created);


--
-- Name: in_u_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_deleted ON shared.mj_user USING btree (u_deleted);


--
-- Name: in_u_fname; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_fname ON shared.mj_user USING btree (u_fname);


--
-- Name: in_u_has_two_factor_auth; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_has_two_factor_auth ON shared.mj_user USING btree (u_has_two_factor_auth);


--
-- Name: in_u_lname; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_lname ON shared.mj_user USING btree (u_lname);


--
-- Name: in_u_mname; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_mname ON shared.mj_user USING btree (u_mname);


--
-- Name: in_u_pemail_verified; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_pemail_verified ON shared.mj_user USING btree (u_pemail_verified);


--
-- Name: in_u_pmobile_verified; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_pmobile_verified ON shared.mj_user USING btree (u_pmobile_verified);


--
-- Name: in_u_primary_mobile_cc; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_primary_mobile_cc ON shared.mj_user USING btree (u_primary_mobile_cc);


--
-- Name: in_u_recovery_email; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_recovery_email ON shared.mj_user USING btree (u_recovery_email);


--
-- Name: in_u_recovery_mobile; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_recovery_mobile ON shared.mj_user USING btree (u_recovery_mobile);


--
-- Name: in_u_recovery_mobile_cc; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_recovery_mobile_cc ON shared.mj_user USING btree (u_recovery_mobile_cc);


--
-- Name: in_u_suspended; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_suspended ON shared.mj_user USING btree (u_suspended);


--
-- Name: in_u_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_updated ON shared.mj_user USING btree (u_updated);


--
-- Name: in_u_verified; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_u_verified ON shared.mj_user USING btree (u_verified);


--
-- Name: in_uar_arole_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_arole_id ON shared.mj_user_authorisation USING btree (uar_arole_id);


--
-- Name: in_uar_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_created ON shared.mj_user_authorisation USING btree (uar_created);


--
-- Name: in_uar_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_deleted ON shared.mj_user_authorisation USING btree (uar_deleted);


--
-- Name: in_uar_u_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_u_id ON shared.mj_user_authorisation USING btree (uar_u_id);


--
-- Name: in_uar_uau_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_uau_id ON shared.mj_user_authorisation USING btree (uar_uau_id);


--
-- Name: in_uar_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uar_updated ON shared.mj_user_authorisation USING btree (uar_updated);


--
-- Name: in_uau_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uau_created ON shared.mj_user_authentication USING btree (uau_created);


--
-- Name: in_uau_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uau_deleted ON shared.mj_user_authentication USING btree (uau_deleted);


--
-- Name: in_uau_force_reset; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uau_force_reset ON shared.mj_user_authentication USING btree (uau_force_reset);


--
-- Name: in_uau_last_changed; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uau_last_changed ON shared.mj_user_authentication USING btree (uau_last_changed);


--
-- Name: in_uau_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_uau_updated ON shared.mj_user_authentication USING btree (uau_updated);


--
-- Name: in_udvc_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_created ON shared.mj_user_device USING btree (udvc_created);


--
-- Name: in_udvc_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_deleted ON shared.mj_user_device USING btree (udvc_deleted);


--
-- Name: in_udvc_device_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_device_id ON shared.mj_user_device USING btree (udvc_device_id);


--
-- Name: in_udvc_from_ip_address; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_from_ip_address ON shared.mj_user_device USING btree (udvc_from_ip_address);


--
-- Name: in_udvc_mac_address; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_mac_address ON shared.mj_user_device USING btree (udvc_mac_address);


--
-- Name: in_udvc_name; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_name ON shared.mj_user_device USING btree (udvc_name);


--
-- Name: in_udvc_suspended; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_suspended ON shared.mj_user_device USING btree (udvc_suspended);


--
-- Name: in_udvc_system_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_system_id ON shared.mj_user_device USING btree (udvc_system_id);


--
-- Name: in_udvc_u_id; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_u_id ON shared.mj_user_device USING btree (udvc_u_id);


--
-- Name: in_udvc_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_udvc_updated ON shared.mj_user_device USING btree (udvc_updated);


--
-- Name: in_wrkstatus_created; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_wrkstatus_created ON shared.mj_work_status USING btree (wrkstatus_created);


--
-- Name: in_wrkstatus_deleted; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_wrkstatus_deleted ON shared.mj_work_status USING btree (wrkstatus_deleted);


--
-- Name: in_wrkstatus_title; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_wrkstatus_title ON shared.mj_work_status USING btree (wrkstatus_title);


--
-- Name: in_wrkstatus_updated; Type: INDEX; Schema: shared; Owner: oequal5_mahjfit
--

CREATE INDEX in_wrkstatus_updated ON shared.mj_work_status USING btree (wrkstatus_updated);


--
-- PostgreSQL database dump complete
--

