table_name,columns,indexes,foreign_keys

api_definitions,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('api_definitions_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""endpoint"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""method"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""base_url"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""path"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""request_headers"", ""default"": ""'[]'::jsonb"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""request_params"", ""default"": ""'[]'::jsonb"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""request_body"", ""default"": ""'{}'::jsonb"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""query_params"", ""default"": ""'[]'::jsonb"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""response_schema"", ""default"": ""'{}'::jsonb"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""response_examples"", ""default"": ""'[]'::jsonb"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""auth_type"", ""default"": ""'none'::character varying"", ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""auth_config"", ""default"": ""'{}'::jsonb"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""version"", ""default"": ""'1.0.0'::character varying"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""category"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""ARRAY"", ""column"": ""tags"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""status"", ""default"": ""true"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""idx_api_definitions_created_by"", ""definition"": ""CREATE INDEX idx_api_definitions_created_by ON public.api_definitions USING btree (created_by)""}, {""index"": ""api_definitions_pkey"", ""definition"": ""CREATE UNIQUE INDEX api_definitions_pkey ON public.api_definitions USING btree (id)""}, {""index"": ""idx_api_definitions_name"", ""definition"": ""CREATE INDEX idx_api_definitions_name ON public.api_definitions USING btree (name)""}, {""index"": ""idx_api_definitions_endpoint"", ""definition"": ""CREATE INDEX idx_api_definitions_endpoint ON public.api_definitions USING btree (endpoint)""}, {""index"": ""idx_api_definitions_status"", ""definition"": ""CREATE INDEX idx_api_definitions_status ON public.api_definitions USING btree (status)""}, {""index"": ""idx_api_definitions_category"", ""definition"": ""CREATE INDEX idx_api_definitions_category ON public.api_definitions USING btree (category)""}]","[{""column"": ""created_by"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_users"", ""constraint"": ""api_definitions_created_by_fkey"", ""ref_column"": ""id""}]"

api_integrations,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('api_integrations_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""endpoint_url"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""method"", ""default"": ""'POST'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""auth_type"", ""default"": ""'API Key'::character varying"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""api_key"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": ""'active'::character varying"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_used"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""secret_key"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""api_integrations_pkey"", ""definition"": ""CREATE UNIQUE INDEX api_integrations_pkey ON public.api_integrations USING btree (id)""}]",

bulk_coupon_codes,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('bulk_coupon_codes_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""coupon_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""bulk_coupon_codes_pkey"", ""definition"": ""CREATE UNIQUE INDEX bulk_coupon_codes_pkey ON public.bulk_coupon_codes USING btree (id)""}, {""index"": ""bulk_coupon_codes_coupon_id_index"", ""definition"": ""CREATE INDEX bulk_coupon_codes_coupon_id_index ON public.bulk_coupon_codes USING btree (coupon_id)""}, {""index"": ""bulk_coupon_codes_code_unique"", ""definition"": ""CREATE UNIQUE INDEX bulk_coupon_codes_code_unique ON public.bulk_coupon_codes USING btree (code)""}]",

business_unit_mapping,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('business_unit_mapping_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""business_unit"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""region_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""tax_group_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""tax_rate"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""date"", ""column"": ""effctive_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'1'::smallint"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""business_unit_mapping_pkey"", ""definition"": ""CREATE UNIQUE INDEX business_unit_mapping_pkey ON public.business_unit_mapping USING btree (id)""}]",

business_units,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('business_units_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""short_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": ""'USD'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""timezone"", ""default"": ""'UTC'::character varying"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""notes"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""country_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""state_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""city_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""updated_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""tax_group_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""contact_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""payment_gateway"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""region_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""include_demo_data"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""business_units_pkey"", ""definition"": ""CREATE UNIQUE INDEX business_units_pkey ON public.business_units USING btree (id)""}, {""index"": ""business_units_short_code_unique"", ""definition"": ""CREATE UNIQUE INDEX business_units_short_code_unique ON public.business_units USING btree (short_code)""}, {""index"": ""idx_created_by"", ""definition"": ""CREATE INDEX idx_created_by ON public.business_units USING btree (created_by)""}, {""index"": ""idx_updated_by"", ""definition"": ""CREATE INDEX idx_updated_by ON public.business_units USING btree (updated_by)""}, {""index"": ""business_units_tax_group_id_index"", ""definition"": ""CREATE INDEX business_units_tax_group_id_index ON public.business_units USING btree (tax_group_id)""}]","[{""column"": ""tax_group_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""tax_groups"", ""constraint"": ""business_units_tax_group_id_foreign"", ""ref_column"": ""id""}]"

cache,"[{""type"": ""character varying"", ""column"": ""key"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""value"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""expiration"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""cache_pkey"", ""definition"": ""CREATE UNIQUE INDEX cache_pkey ON public.cache USING btree (key)""}]",

cache_locks,"[{""type"": ""character varying"", ""column"": ""key"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""owner"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""expiration"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""cache_locks_pkey"", ""definition"": ""CREATE UNIQUE INDEX cache_locks_pkey ON public.cache_locks USING btree (key)""}]",

channel_availability_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('channel_availability_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""channel_availability_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX channel_availability_types_pkey ON public.channel_availability_types USING btree (id)""}, {""index"": ""channel_availability_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX channel_availability_types_code_unique ON public.channel_availability_types USING btree (code)""}]",

cities,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""state_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""country_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""cities_pkey"", ""definition"": ""CREATE UNIQUE INDEX cities_pkey ON public.cities USING btree (id)""}, {""index"": ""cities_country_id_index"", ""definition"": ""CREATE INDEX cities_country_id_index ON public.cities USING btree (country_id)""}, {""index"": ""cities_state_id_index"", ""definition"": ""CREATE INDEX cities_state_id_index ON public.cities USING btree (state_id)""}, {""index"": ""cities_status_index"", ""definition"": ""CREATE INDEX cities_status_index ON public.cities USING btree (status)""}]","[{""column"": ""country_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""countries"", ""constraint"": ""cities_country_id_foreign"", ""ref_column"": ""id""}, {""column"": ""state_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""states"", ""constraint"": ""cities_state_id_foreign"", ""ref_column"": ""id""}]"


company_settings,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('company_settings_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""company_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""website_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""website_url"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": ""'USD'::character varying"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""login_2fa_method"", ""default"": ""'none'::character varying"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""street_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""street_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""zip_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""city"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""country"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""vat_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""gst_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""pan_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""tan_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_address"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_city"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_state"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_zip"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_country"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""billing_notes"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""company_logo"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""company_settings_pkey"", ""definition"": ""CREATE UNIQUE INDEX company_settings_pkey ON public.company_settings USING btree (id)""}, {""index"": ""company_settings_user_id_key"", ""definition"": ""CREATE UNIQUE INDEX company_settings_user_id_key ON public.company_settings USING btree (user_id)""}]","[{""column"": ""user_id"", ""on_delete"": ""CASCADE"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_users"", ""constraint"": ""company_settings_user_id_fkey"", ""ref_column"": ""id""}]"

compliance_reports,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('compliance_reports_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""report_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""period"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": ""'USD'::character varying"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""filed_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""updated_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""region_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""tax_group_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""year"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}]","[{""index"": ""idx_compliance_reports_app_year_status"", ""definition"": ""CREATE INDEX idx_compliance_reports_app_year_status ON public.compliance_reports USING btree (app_id, year, status)""}, {""index"": ""compliance_reports_pkey"", ""definition"": ""CREATE UNIQUE INDEX compliance_reports_pkey ON public.compliance_reports USING btree (id)""}, {""index"": ""compliance_reports_app_id_index"", ""definition"": ""CREATE INDEX compliance_reports_app_id_index ON public.compliance_reports USING btree (app_id)""}, {""index"": ""compliance_reports_period_index"", ""definition"": ""CREATE INDEX compliance_reports_period_index ON public.compliance_reports USING btree (period)""}, {""index"": ""compliance_reports_region_id_index"", ""definition"": ""CREATE INDEX compliance_reports_region_id_index ON public.compliance_reports USING btree (region_id)""}, {""index"": ""compliance_reports_tax_group_id_index"", ""definition"": ""CREATE INDEX compliance_reports_tax_group_id_index ON public.compliance_reports USING btree (tax_group_id)""}, {""index"": ""compliance_reports_year_index"", ""definition"": ""CREATE INDEX compliance_reports_year_index ON public.compliance_reports USING btree (year)""}]","[{""column"": ""region_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""countries"", ""constraint"": ""compliance_reports_region_id_foreign"", ""ref_column"": ""id""}, {""column"": ""tax_group_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""tax_groups"", ""constraint"": ""compliance_reports_tax_group_id_foreign"", ""ref_column"": ""id""}]"

content_watched,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""content_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""profile_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": ""'Y'::character varying"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": ""'video'::character varying"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""category_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""duration"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}]","[{""index"": ""content_watched_content_id_index"", ""definition"": ""CREATE INDEX content_watched_content_id_index ON public.content_watched USING btree (content_id)""}, {""index"": ""content_watched_user_id_index"", ""definition"": ""CREATE INDEX content_watched_user_id_index ON public.content_watched USING btree (user_id)""}, {""index"": ""content_watched_app_id_index"", ""definition"": ""CREATE INDEX content_watched_app_id_index ON public.content_watched USING btree (app_id)""}, {""index"": ""content_watched_type_index"", ""definition"": ""CREATE INDEX content_watched_type_index ON public.content_watched USING btree (type)""}, {""index"": ""content_watched_category_id_index"", ""definition"": ""CREATE INDEX content_watched_category_id_index ON public.content_watched USING btree (category_id)""}, {""index"": ""content_watched_created_index"", ""definition"": ""CREATE INDEX content_watched_created_index ON public.content_watched USING btree (created)""}, {""index"": ""content_watched_profile_id_index"", ""definition"": ""CREATE INDEX content_watched_profile_id_index ON public.content_watched USING btree (profile_id)""}, {""index"": ""content_watched_pkey"", ""definition"": ""CREATE UNIQUE INDEX content_watched_pkey ON public.content_watched USING btree (id)""}]",

countries,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character"", ""column"": ""code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character"", ""column"": ""iso2"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""region"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""phone_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character"", ""column"": ""currency_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_symbol"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""flag"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""timezone"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""standard_time"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""countries_pkey"", ""definition"": ""CREATE UNIQUE INDEX countries_pkey ON public.countries USING btree (id)""}, {""index"": ""countries_status_index"", ""definition"": ""CREATE INDEX countries_status_index ON public.countries USING btree (status)""}]",

coupon,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_text1"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_text2"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_text3"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_banner1"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_banner2"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_banner3"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""client_presence_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""coupon_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""discount_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""reedemed_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""reedmed_reward"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""jsonb"", ""column"": ""bulk_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""reedmed_cap"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""reedmed_cap_per_user"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""updated_by"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""json"", ""column"": ""content"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""coupon_pkey"", ""definition"": ""CREATE UNIQUE INDEX coupon_pkey ON public.coupon USING btree (id)""}, {""index"": ""coupon_client_id_index"", ""definition"": ""CREATE INDEX coupon_client_id_index ON public.coupon USING btree (app_id)""}, {""index"": ""coupon_code_index"", ""definition"": ""CREATE INDEX coupon_code_index ON public.coupon USING btree (code)""}, {""index"": ""coupon_client_presence_id_index"", ""definition"": ""CREATE INDEX coupon_client_presence_id_index ON public.coupon USING btree (client_presence_id)""}, {""index"": ""coupon_coupon_type_index"", ""definition"": ""CREATE INDEX coupon_coupon_type_index ON public.coupon USING btree (coupon_type)""}, {""index"": ""coupon_created_at_index"", ""definition"": ""CREATE INDEX coupon_created_at_index ON public.coupon USING btree (created_at)""}, {""index"": ""coupon_created_by_index"", ""definition"": ""CREATE INDEX coupon_created_by_index ON public.coupon USING btree (created_by)""}, {""index"": ""coupon_discount_type_index"", ""definition"": ""CREATE INDEX coupon_discount_type_index ON public.coupon USING btree (discount_type)""}, {""index"": ""coupon_end_date_index"", ""definition"": ""CREATE INDEX coupon_end_date_index ON public.coupon USING btree (end_date)""}, {""index"": ""coupon_start_date_index"", ""definition"": ""CREATE INDEX coupon_start_date_index ON public.coupon USING btree (start_date)""}]",

currency,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('currency_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_symbal"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""json"", ""column"": ""country_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""region"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""currency_symbol"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""icon_path"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""symbol_position"", ""default"": ""'before'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""decimal_separator"", ""default"": ""'.'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""thousands_separator"", ""default"": ""','::character varying"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""currency_pkey"", ""definition"": ""CREATE UNIQUE INDEX currency_pkey ON public.currency USING btree (id)""}, {""index"": ""currency_app_id_index"", ""definition"": ""CREATE INDEX currency_app_id_index ON public.currency USING btree (app_id)""}]",

customer_detail,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""customer_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""first_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""middle_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""last_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""birth_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""age_grouo"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""marital_status"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""gender"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""address"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""streat"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""city"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""country"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""country_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""pincode"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_address"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_street"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_city"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_country"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_country_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""billing_pincode"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""referral_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""referred_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""referred_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""employment_profession"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""is_email_verified"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""is_phone_verified"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""sync_status"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""enable_notification"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""notification_from"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""notification_till"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""enable_sms_promo"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""sms_from"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""sms_till"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""enable_whatsapp_promo"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""whatsapp_from"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""whatsapp_till"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""enable_email_promo"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""email_from"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""email_till"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""is_wallet"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character"", ""column"": ""currency"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""wallet_balance"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""wallet_modifed_on"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""additional_data"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""customer_detail_pkey"", ""definition"": ""CREATE UNIQUE INDEX customer_detail_pkey ON public.customer_detail USING btree (id)""}, {""index"": ""customer_detail_age_grouo_index"", ""definition"": ""CREATE INDEX customer_detail_age_grouo_index ON public.customer_detail USING btree (age_grouo)""}, {""index"": ""customer_detail_billing_city_index"", ""definition"": ""CREATE INDEX customer_detail_billing_city_index ON public.customer_detail USING btree (billing_city)""}, {""index"": ""customer_detail_billing_country_code_index"", ""definition"": ""CREATE INDEX customer_detail_billing_country_code_index ON public.customer_detail USING btree (billing_country_code)""}, {""index"": ""customer_detail_billing_country_index"", ""definition"": ""CREATE INDEX customer_detail_billing_country_index ON public.customer_detail USING btree (billing_country)""}, {""index"": ""customer_detail_billing_pincode_index"", ""definition"": ""CREATE INDEX customer_detail_billing_pincode_index ON public.customer_detail USING btree (billing_pincode)""}, {""index"": ""customer_detail_city_index"", ""definition"": ""CREATE INDEX customer_detail_city_index ON public.customer_detail USING btree (city)""}, {""index"": ""customer_detail_country_code_index"", ""definition"": ""CREATE INDEX customer_detail_country_code_index ON public.customer_detail USING btree (country_code)""}, {""index"": ""customer_detail_country_index"", ""definition"": ""CREATE INDEX customer_detail_country_index ON public.customer_detail USING btree (country)""}, {""index"": ""customer_detail_created_at_index"", ""definition"": ""CREATE INDEX customer_detail_created_at_index ON public.customer_detail USING btree (created_at)""}, {""index"": ""customer_detail_customer_id_index"", ""definition"": ""CREATE INDEX customer_detail_customer_id_index ON public.customer_detail USING btree (customer_id)""}, {""index"": ""customer_detail_email_from_index"", ""definition"": ""CREATE INDEX customer_detail_email_from_index ON public.customer_detail USING btree (email_from)""}, {""index"": ""customer_detail_email_till_index"", ""definition"": ""CREATE INDEX customer_detail_email_till_index ON public.customer_detail USING btree (email_till)""}, {""index"": ""customer_detail_first_name_index"", ""definition"": ""CREATE INDEX customer_detail_first_name_index ON public.customer_detail USING btree (first_name)""}, {""index"": ""customer_detail_gender_index"", ""definition"": ""CREATE INDEX customer_detail_gender_index ON public.customer_detail USING btree (gender)""}, {""index"": ""customer_detail_is_email_verified_index"", ""definition"": ""CREATE INDEX customer_detail_is_email_verified_index ON public.customer_detail USING btree (is_email_verified)""}, {""index"": ""customer_detail_is_phone_verified_index"", ""definition"": ""CREATE INDEX customer_detail_is_phone_verified_index ON public.customer_detail USING btree (is_phone_verified)""}, {""index"": ""customer_detail_last_name_index"", ""definition"": ""CREATE INDEX customer_detail_last_name_index ON public.customer_detail USING btree (last_name)""}, {""index"": ""customer_detail_marital_status_index"", ""definition"": ""CREATE INDEX customer_detail_marital_status_index ON public.customer_detail USING btree (marital_status)""}, {""index"": ""customer_detail_middle_name_index"", ""definition"": ""CREATE INDEX customer_detail_middle_name_index ON public.customer_detail USING btree (middle_name)""}, {""index"": ""customer_detail_notification_from_index"", ""definition"": ""CREATE INDEX customer_detail_notification_from_index ON public.customer_detail USING btree (notification_from)""}, {""index"": ""customer_detail_notification_till_index"", ""definition"": ""CREATE INDEX customer_detail_notification_till_index ON public.customer_detail USING btree (notification_till)""}, {""index"": ""customer_detail_pincode_index"", ""definition"": ""CREATE INDEX customer_detail_pincode_index ON public.customer_detail USING btree (pincode)""}, {""index"": ""customer_detail_sms_from_index"", ""definition"": ""CREATE INDEX customer_detail_sms_from_index ON public.customer_detail USING btree (sms_from)""}, {""index"": ""customer_detail_sms_till_index"", ""definition"": ""CREATE INDEX customer_detail_sms_till_index ON public.customer_detail USING btree (sms_till)""}, {""index"": ""customer_detail_sync_status_index"", ""definition"": ""CREATE INDEX customer_detail_sync_status_index ON public.customer_detail USING btree (sync_status)""}, {""index"": ""customer_detail_updated_at_index"", ""definition"": ""CREATE INDEX customer_detail_updated_at_index ON public.customer_detail USING btree (updated_at)""}, {""index"": ""customer_detail_whatsapp_from_index"", ""definition"": ""CREATE INDEX customer_detail_whatsapp_from_index ON public.customer_detail USING btree (whatsapp_from)""}, {""index"": ""customer_detail_whatsapp_till_index"", ""definition"": ""CREATE INDEX customer_detail_whatsapp_till_index ON public.customer_detail USING btree (whatsapp_till)""}]",

customer_device,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('customer_device_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""customer_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""platfrom"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""make_model"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""os_version"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""screen_resolution"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""device_unique_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""device_ip"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""additional_data"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""device_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""push_device_token"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""onesignal_device_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""country"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""state"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""city"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""created"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp with time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""network_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""network_provider"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""browser"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""os"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""customer_device_pkey"", ""definition"": ""CREATE UNIQUE INDEX customer_device_pkey ON public.customer_device USING btree (id)""}, {""index"": ""customer_device_customer_id_index"", ""definition"": ""CREATE INDEX customer_device_customer_id_index ON public.customer_device USING btree (customer_id)""}, {""index"": ""customer_device_platfrom_index"", ""definition"": ""CREATE INDEX customer_device_platfrom_index ON public.customer_device USING btree (platfrom)""}]",

customers,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('customers_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""user_name"", ""default"": ""''::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""email_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""phone_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""country_code"", ""default"": ""'IN'::character varying"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""country_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""state_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""city_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""client_cust_id"", ""default"": ""'0'::bigint"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""country"", ""default"": ""'N/A'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""state"", ""default"": ""'N/A'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""city"", ""default"": ""'N/A'::character varying"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_login"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""device_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""push_token"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""browser"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""device_unique_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""ip"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""app_version"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""platform"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""gender"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""dob"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""lat"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""long"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""password"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""first_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""last_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""is_mail_verify"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_phone_verify"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""owner_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""about_me"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""idx_customers_phone_number"", ""definition"": ""CREATE INDEX idx_customers_phone_number ON public.customers USING btree (phone_number)""}, {""index"": ""idx_customers_device_unique_id"", ""definition"": ""CREATE INDEX idx_customers_device_unique_id ON public.customers USING btree (device_unique_id)""}, {""index"": ""idx_customers_last_login"", ""definition"": ""CREATE INDEX idx_customers_last_login ON public.customers USING btree (last_login)""}, {""index"": ""idx_customers_country_id"", ""definition"": ""CREATE INDEX idx_customers_country_id ON public.customers USING btree (country_id)""}, {""index"": ""idx_customers_state_id"", ""definition"": ""CREATE INDEX idx_customers_state_id ON public.customers USING btree (state_id)""}, {""index"": ""idx_customers_city_id"", ""definition"": ""CREATE INDEX idx_customers_city_id ON public.customers USING btree (city_id)""}, {""index"": ""customers_created_at"", ""definition"": ""CREATE INDEX customers_created_at ON public.customers USING btree (created_at)""}, {""index"": ""customers_client_cust_id"", ""definition"": ""CREATE INDEX customers_client_cust_id ON public.customers USING btree (client_cust_id)""}, {""index"": ""customers_app_id"", ""definition"": ""CREATE INDEX customers_app_id ON public.customers USING btree (app_id)""}, {""index"": ""customers_email_id"", ""definition"": ""CREATE INDEX customers_email_id ON public.customers USING btree (email_id)""}, {""index"": ""customers_status"", ""definition"": ""CREATE INDEX customers_status ON public.customers USING btree (status)""}]",

dunning_campaign_templates,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('dunning_campaign_templates_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""dunning_campaign_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""template_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""stage"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""delay_days"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""dunning_campaign_templates_pkey"", ""definition"": ""CREATE UNIQUE INDEX dunning_campaign_templates_pkey ON public.dunning_campaign_templates USING btree (id)""}, {""index"": ""dunning_campaign_templates_dunning_campaign_id_stage_index"", ""definition"": ""CREATE INDEX dunning_campaign_templates_dunning_campaign_id_stage_index ON public.dunning_campaign_templates USING btree (dunning_campaign_id, stage)""}, {""index"": ""dunning_campaign_templates_template_id_index"", ""definition"": ""CREATE INDEX dunning_campaign_templates_template_id_index ON public.dunning_campaign_templates USING btree (template_id)""}]","[{""column"": ""dunning_campaign_id"", ""on_delete"": ""CASCADE"", ""on_update"": ""NO ACTION"", ""ref_table"": ""dunning_campaigns"", ""constraint"": ""dunning_campaign_templates_dunning_campaign_id_foreign"", ""ref_column"": ""id""}]"

dunning_campaigns,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('dunning_campaigns_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": ""'payment_failure'::character varying"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""3"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""grace_period_days"", ""default"": ""7"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""retry_attempts"", ""default"": ""5"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""notification_channel"", ""default"": ""'email'::character varying"", ""nullable"": ""NO""}, {""type"": ""date"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""date"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""target_segments"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""retry_schedule"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""notification_rules"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""customers_affected"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""recovery_rate"", ""default"": ""'0'::numeric"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""total_notifications_sent"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""total_payments_recovered"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""recovered_amount"", ""default"": ""'0'::numeric"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""first_email_timing"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""first_email_delay_hours"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""send_immediate_non_retriable"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""subscription_action"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""invoice_action"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""final_email_delay_days"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""final_email_template_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""enable_3ds_handling"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""three_ds_template_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""total_timeline_days"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""idx_dunning_campaigns_final_email_template_id"", ""definition"": ""CREATE INDEX idx_dunning_campaigns_final_email_template_id ON public.dunning_campaigns USING btree (final_email_template_id)""}, {""index"": ""idx_dunning_campaigns_three_ds_template_id"", ""definition"": ""CREATE INDEX idx_dunning_campaigns_three_ds_template_id ON public.dunning_campaigns USING btree (three_ds_template_id)""}, {""index"": ""dunning_campaigns_pkey"", ""definition"": ""CREATE UNIQUE INDEX dunning_campaigns_pkey ON public.dunning_campaigns USING btree (id)""}, {""index"": ""dunning_campaigns_type_index"", ""definition"": ""CREATE INDEX dunning_campaigns_type_index ON public.dunning_campaigns USING btree (type)""}, {""index"": ""dunning_campaigns_start_date_index"", ""definition"": ""CREATE INDEX dunning_campaigns_start_date_index ON public.dunning_campaigns USING btree (start_date)""}, {""index"": ""dunning_campaigns_end_date_index"", ""definition"": ""CREATE INDEX dunning_campaigns_end_date_index ON public.dunning_campaigns USING btree (end_date)""}, {""index"": ""dunning_campaigns_created_by_index"", ""definition"": ""CREATE INDEX dunning_campaigns_created_by_index ON public.dunning_campaigns USING btree (created_by)""}, {""index"": ""dunning_campaigns_status_index"", ""definition"": ""CREATE INDEX dunning_campaigns_status_index ON public.dunning_campaigns USING btree (status)""}]","[{""column"": ""final_email_template_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""email_sms_templates"", ""constraint"": ""dunning_campaigns_final_email_template_id_foreign"", ""ref_column"": ""id""}, {""column"": ""three_ds_template_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""email_sms_templates"", ""constraint"": ""dunning_campaigns_three_ds_template_id_foreign"", ""ref_column"": ""id""}]"

eligible_customer_segments,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('eligible_customer_segments_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""eligible_customer_segments_pkey"", ""definition"": ""CREATE UNIQUE INDEX eligible_customer_segments_pkey ON public.eligible_customer_segments USING btree (id)""}, {""index"": ""eligible_customer_segments_code_unique"", ""definition"": ""CREATE UNIQUE INDEX eligible_customer_segments_code_unique ON public.eligible_customer_segments USING btree (code)""}]",

email_sms_templates,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('email_templates_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""template_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""subject"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""event_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""category"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""admin_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""cc_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""bcc_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""external_template"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""content"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""trigger_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""frequency"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""delay_time"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""auto_resend"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""track_open"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""track_click"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""trigger_status"", ""default"": ""'0'::smallint"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""email_templates_pkey"", ""definition"": ""CREATE UNIQUE INDEX email_templates_pkey ON public.email_sms_templates USING btree (id)""}]",

failed_jobs,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('failed_jobs_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""uuid"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""connection"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""queue"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""payload"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""exception"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""failed_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}]","[{""index"": ""failed_jobs_pkey"", ""definition"": ""CREATE UNIQUE INDEX failed_jobs_pkey ON public.failed_jobs USING btree (id)""}, {""index"": ""failed_jobs_uuid_unique"", ""definition"": ""CREATE UNIQUE INDEX failed_jobs_uuid_unique ON public.failed_jobs USING btree (uuid)""}]",

feedback,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('feedback_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""email"", ""default"": ""''::character varying"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""contact_no"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": ""''::character varying"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": ""''::text"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""subject"", ""default"": ""''::character varying"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""app_version"", ""default"": ""''::text"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""model"", ""default"": ""''::text"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""device_type"", ""default"": ""''::character varying"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_dt"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": ""'open'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""priority"", ""default"": ""'low'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""category_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""response_count"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""resolved_in_first_response"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_escalate"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""feedback_pkey"", ""definition"": ""CREATE UNIQUE INDEX feedback_pkey ON public.feedback USING btree (id)""}, {""index"": ""idx_feedback_app_id"", ""definition"": ""CREATE INDEX idx_feedback_app_id ON public.feedback USING btree (app_id)""}, {""index"": ""idx_feedback_user_id"", ""definition"": ""CREATE INDEX idx_feedback_user_id ON public.feedback USING btree (user_id)""}, {""index"": ""idx_feedback_created_dt"", ""definition"": ""CREATE INDEX idx_feedback_created_dt ON public.feedback USING btree (created_dt)""}, {""index"": ""idx_feedback_duplicate_check"", ""definition"": ""CREATE INDEX idx_feedback_duplicate_check ON public.feedback USING btree (app_id, user_id, email, subject, date(created_dt))""}]",

gateway_configuration,"[{""type"": ""integer"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""client_presence_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""gateway_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""merchent_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""secret_key"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""api_key"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""webhook_url"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""time_out"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_sync"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""callback"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""webhook_retry_count"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""icon"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""gateway_configuration_pkey"", ""definition"": ""CREATE UNIQUE INDEX gateway_configuration_pkey ON public.gateway_configuration USING btree (id)""}, {""index"": ""gateway_configuration_client_presence_id_index"", ""definition"": ""CREATE INDEX gateway_configuration_client_presence_id_index ON public.gateway_configuration USING btree (client_presence_id)""}, {""index"": ""gateway_configuration_gateway_id_index"", ""definition"": ""CREATE INDEX gateway_configuration_gateway_id_index ON public.gateway_configuration USING btree (gateway_id)""}]","[{""column"": ""client_presence_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_presence"", ""constraint"": ""gateway_configuration_client_presence_id_foreign"", ""ref_column"": ""id""}, {""column"": ""gateway_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""payment_gateway_master"", ""constraint"": ""gateway_configuration_gateway_id_foreign"", ""ref_column"": ""id""}]"

installment_frequency_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('installment_frequency_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""days"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""installment_frequency_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX installment_frequency_types_pkey ON public.installment_frequency_types USING btree (id)""}, {""index"": ""installment_frequency_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX installment_frequency_types_code_unique ON public.installment_frequency_types USING btree (code)""}]",

job_batches,"[{""type"": ""character varying"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""total_jobs"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""pending_jobs"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""failed_jobs"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""failed_job_ids"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""options"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""cancelled_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""finished_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""job_batches_pkey"", ""definition"": ""CREATE UNIQUE INDEX job_batches_pkey ON public.job_batches USING btree (id)""}]",

jobs,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('jobs_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""queue"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""payload"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""attempts"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""reserved_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""available_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""jobs_pkey"", ""definition"": ""CREATE UNIQUE INDEX jobs_pkey ON public.jobs USING btree (id)""}, {""index"": ""jobs_queue_index"", ""definition"": ""CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue)""}]",

loyalty_points,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('loyalty_points_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""customer_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""current_balance"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""total_earned"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""total_redeemed"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""tier"", ""default"": ""'Bronze'::character varying"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""points_to_next_tier"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""loyalty_points_pkey"", ""definition"": ""CREATE UNIQUE INDEX loyalty_points_pkey ON public.loyalty_points USING btree (id)""}, {""index"": ""loyalty_points_customer_id_index"", ""definition"": ""CREATE INDEX loyalty_points_customer_id_index ON public.loyalty_points USING btree (customer_id)""}, {""index"": ""loyalty_points_tier_index"", ""definition"": ""CREATE INDEX loyalty_points_tier_index ON public.loyalty_points USING btree (tier)""}, {""index"": ""loyalty_points_status_index"", ""definition"": ""CREATE INDEX loyalty_points_status_index ON public.loyalty_points USING btree (status)""}]",

migrations,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('migrations_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""migration"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""batch"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""migrations_pkey"", ""definition"": ""CREATE UNIQUE INDEX migrations_pkey ON public.migrations USING btree (id)""}]",

modules,"[{""type"": ""integer"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""menu_type"", ""default"": ""'main'::character varying"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""parent_id"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""path"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""icon"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""navigation_group"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""modified"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""modules_pkey"", ""definition"": ""CREATE UNIQUE INDEX modules_pkey ON public.modules USING btree (id)""}, {""index"": ""idx_modules_parent_id"", ""definition"": ""CREATE INDEX idx_modules_parent_id ON public.modules USING btree (parent_id)""}, {""index"": ""idx_modules_menu_type"", ""definition"": ""CREATE INDEX idx_modules_menu_type ON public.modules USING btree (menu_type)""}, {""index"": ""idx_modules_status"", ""definition"": ""CREATE INDEX idx_modules_status ON public.modules USING btree (status)""}]","[{""column"": ""parent_id"", ""on_delete"": ""CASCADE"", ""on_update"": ""NO ACTION"", ""ref_table"": ""modules"", ""constraint"": ""modules_parent_id_fkey"", ""ref_column"": ""id""}]"

package_mode_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('package_mode_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""package_mode_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX package_mode_types_pkey ON public.package_mode_types USING btree (id)""}, {""index"": ""package_mode_types_code_index"", ""definition"": ""CREATE INDEX package_mode_types_code_index ON public.package_mode_types USING btree (code)""}, {""index"": ""package_mode_types_sort_order_index"", ""definition"": ""CREATE INDEX package_mode_types_sort_order_index ON public.package_mode_types USING btree (sort_order)""}, {""index"": ""package_mode_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX package_mode_types_code_unique ON public.package_mode_types USING btree (code)""}, {""index"": ""package_mode_types_is_active_index"", ""definition"": ""CREATE INDEX package_mode_types_is_active_index ON public.package_mode_types USING btree (is_active)""}]",

package_products,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('package_products_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""package_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""product_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""client_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""package_products_pkey"", ""definition"": ""CREATE UNIQUE INDEX package_products_pkey ON public.package_products USING btree (id)""}, {""index"": ""package_products_package_id_product_id_unique"", ""definition"": ""CREATE UNIQUE INDEX package_products_package_id_product_id_unique ON public.package_products USING btree (package_id, product_id)""}]","[{""column"": ""product_id"", ""on_delete"": ""CASCADE"", ""on_update"": ""NO ACTION"", ""ref_table"": ""products"", ""constraint"": ""package_products_product_id_foreign"", ""ref_column"": ""id""}, {""column"": ""package_id"", ""on_delete"": ""CASCADE"", ""on_update"": ""NO ACTION"", ""ref_table"": ""tbl_packages"", ""constraint"": ""package_products_package_id_foreign"", ""ref_column"": ""id""}]"

package_user_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('package_user_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""package_user_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX package_user_types_pkey ON public.package_user_types USING btree (id)""}, {""index"": ""package_user_types_code_index"", ""definition"": ""CREATE INDEX package_user_types_code_index ON public.package_user_types USING btree (code)""}, {""index"": ""package_user_types_sort_order_index"", ""definition"": ""CREATE INDEX package_user_types_sort_order_index ON public.package_user_types USING btree (sort_order)""}, {""index"": ""package_user_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX package_user_types_code_unique ON public.package_user_types USING btree (code)""}, {""index"": ""package_user_types_is_active_index"", ""definition"": ""CREATE INDEX package_user_types_is_active_index ON public.package_user_types USING btree (is_active)""}]",

password_reset_tokens,"[{""type"": ""character varying"", ""column"": ""email"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""token"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""password_reset_tokens_pkey"", ""definition"": ""CREATE UNIQUE INDEX password_reset_tokens_pkey ON public.password_reset_tokens USING btree (email)""}]",

payment_gateway_master,"[{""type"": ""integer"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""logo"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""payment_gateway_master_pkey"", ""definition"": ""CREATE UNIQUE INDEX payment_gateway_master_pkey ON public.payment_gateway_master USING btree (id)""}]",

payment_method_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('payment_method_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""icon"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""payment_method_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX payment_method_types_pkey ON public.payment_method_types USING btree (id)""}, {""index"": ""payment_method_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX payment_method_types_code_unique ON public.payment_method_types USING btree (code)""}]",

payment_mode_saved,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""source_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""json"", ""column"": ""source_detail"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_default"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""payment_mode_saved_pkey"", ""definition"": ""CREATE UNIQUE INDEX payment_mode_saved_pkey ON public.payment_mode_saved USING btree (id)""}, {""index"": ""payment_mode_saved_source_type_index"", ""definition"": ""CREATE INDEX payment_mode_saved_source_type_index ON public.payment_mode_saved USING btree (source_type)""}, {""index"": ""payment_mode_saved_user_id_index"", ""definition"": ""CREATE INDEX payment_mode_saved_user_id_index ON public.payment_mode_saved USING btree (user_id)""}, {""index"": ""payment_mode_saved_status_index"", ""definition"": ""CREATE INDEX payment_mode_saved_status_index ON public.payment_mode_saved USING btree (status)""}]",

period_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('period_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""period_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX period_types_pkey ON public.period_types USING btree (id)""}, {""index"": ""period_types_code_index"", ""definition"": ""CREATE INDEX period_types_code_index ON public.period_types USING btree (code)""}, {""index"": ""period_types_sort_order_index"", ""definition"": ""CREATE INDEX period_types_sort_order_index ON public.period_types USING btree (sort_order)""}, {""index"": ""period_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX period_types_code_unique ON public.period_types USING btree (code)""}, {""index"": ""period_types_is_active_index"", ""definition"": ""CREATE INDEX period_types_is_active_index ON public.period_types USING btree (is_active)""}]",

personal_access_tokens,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('personal_access_tokens_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""tokenable_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""tokenable_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""token"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""abilities"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""last_used_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""expires_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""personal_access_tokens_pkey"", ""definition"": ""CREATE UNIQUE INDEX personal_access_tokens_pkey ON public.personal_access_tokens USING btree (id)""}, {""index"": ""personal_access_tokens_tokenable_type_tokenable_id_index"", ""definition"": ""CREATE INDEX personal_access_tokens_tokenable_type_tokenable_id_index ON public.personal_access_tokens USING btree (tokenable_type, tokenable_id)""}, {""index"": ""personal_access_tokens_token_unique"", ""definition"": ""CREATE UNIQUE INDEX personal_access_tokens_token_unique ON public.personal_access_tokens USING btree (token)""}, {""index"": ""personal_access_tokens_expires_at_index"", ""definition"": ""CREATE INDEX personal_access_tokens_expires_at_index ON public.personal_access_tokens USING btree (expires_at)""}]",

price_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('price_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""price_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX price_types_pkey ON public.price_types USING btree (id)""}, {""index"": ""price_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX price_types_code_unique ON public.price_types USING btree (code)""}]",

product_category_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('product_category_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""product_category_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX product_category_types_pkey ON public.product_category_types USING btree (id)""}, {""index"": ""product_category_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX product_category_types_code_unique ON public.product_category_types USING btree (code)""}]",

product_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('product_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""product_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX product_types_pkey ON public.product_types USING btree (id)""}, {""index"": ""product_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX product_types_code_unique ON public.product_types USING btree (code)""}]",

products,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('products_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""service_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""sku"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""product_category"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""display_order"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""product_image"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""is_active"", ""default"": ""1"", ""nullable"": ""NO""}]","[{""index"": ""products_pkey"", ""definition"": ""CREATE UNIQUE INDEX products_pkey ON public.products USING btree (id)""}, {""index"": ""products_service_type_index"", ""definition"": ""CREATE INDEX products_service_type_index ON public.products USING btree (service_type)""}, {""index"": ""products_sku_unique"", ""definition"": ""CREATE UNIQUE INDEX products_sku_unique ON public.products USING btree (sku)""}, {""index"": ""products_product_category_index"", ""definition"": ""CREATE INDEX products_product_category_index ON public.products USING btree (product_category)""}]",

promotion_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('promotion_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""promotion_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX promotion_types_pkey ON public.promotion_types USING btree (id)""}, {""index"": ""promotion_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX promotion_types_code_unique ON public.promotion_types USING btree (code)""}]",

promotional_tags,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('promotional_tags_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""color"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""promotional_tags_pkey"", ""definition"": ""CREATE UNIQUE INDEX promotional_tags_pkey ON public.promotional_tags USING btree (id)""}, {""index"": ""promotional_tags_name_unique"", ""definition"": ""CREATE UNIQUE INDEX promotional_tags_name_unique ON public.promotional_tags USING btree (name)""}]",

promotions,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('promotions_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""promotion_type_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""discount_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""discount_value"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""date"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""date"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""eligible_segment_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""max_usage_per_customer"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""auto_apply"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotable_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""promotable_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""idx_promotions_promotion_type_id"", ""definition"": ""CREATE INDEX idx_promotions_promotion_type_id ON public.promotions USING btree (promotion_type_id)""}, {""index"": ""idx_promotions_eligible_segment_id"", ""definition"": ""CREATE INDEX idx_promotions_eligible_segment_id ON public.promotions USING btree (eligible_segment_id)""}, {""index"": ""promotions_pkey"", ""definition"": ""CREATE UNIQUE INDEX promotions_pkey ON public.promotions USING btree (id)""}, {""index"": ""promotions_promotable_type_promotable_id_index"", ""definition"": ""CREATE INDEX promotions_promotable_type_promotable_id_index ON public.promotions USING btree (promotable_type, promotable_id)""}, {""index"": ""promotions_code_unique"", ""definition"": ""CREATE UNIQUE INDEX promotions_code_unique ON public.promotions USING btree (code)""}]","[{""column"": ""promotion_type_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""promotion_types"", ""constraint"": ""promotions_promotion_type_id_foreign"", ""ref_column"": ""id""}, {""column"": ""eligible_segment_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""eligible_customer_segments"", ""constraint"": ""promotions_eligible_segment_id_foreign"", ""ref_column"": ""id""}]"

reason_code_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('reason_code_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""reason_code_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX reason_code_types_pkey ON public.reason_code_types USING btree (id)""}, {""index"": ""reason_code_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX reason_code_types_code_unique ON public.reason_code_types USING btree (code)""}]",

regions,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('regions_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""YES""}]","[{""index"": ""regions_pkey"", ""definition"": ""CREATE UNIQUE INDEX regions_pkey ON public.regions USING btree (id)""}, {""index"": ""regions_name_key"", ""definition"": ""CREATE UNIQUE INDEX regions_name_key ON public.regions USING btree (name)""}, {""index"": ""idx_regions_name_unique"", ""definition"": ""CREATE UNIQUE INDEX idx_regions_name_unique ON public.regions USING btree (name)""}]",

role_mngt,"[{""type"": ""integer"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""created_by_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""json"", ""column"": ""access_control"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""json"", ""column"": ""last_access_control"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""role_mngt_pkey"", ""definition"": ""CREATE UNIQUE INDEX role_mngt_pkey ON public.role_mngt USING btree (id)""}, {""index"": ""role_mngt_created_at_index"", ""definition"": ""CREATE INDEX role_mngt_created_at_index ON public.role_mngt USING btree (created_at)""}, {""index"": ""role_mngt_created_by_id_index"", ""definition"": ""CREATE INDEX role_mngt_created_by_id_index ON public.role_mngt USING btree (created_by_id)""}, {""index"": ""role_mngt_status_index"", ""definition"": ""CREATE INDEX role_mngt_status_index ON public.role_mngt USING btree (status)""}, {""index"": ""role_mngt_updated_at_index"", ""definition"": ""CREATE INDEX role_mngt_updated_at_index ON public.role_mngt USING btree (updated_at)""}]",

saved_dashboards,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('saved_dashboards_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""title"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": ""'dashboard'::character varying"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""source"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""dashboard_config"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""preview_image"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""created_by_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""created_by_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""is_shared"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_favorite"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""file_path"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""file_format"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""saved_dashboards_pkey"", ""definition"": ""CREATE UNIQUE INDEX saved_dashboards_pkey ON public.saved_dashboards USING btree (id)""}]",

season_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('season_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""season_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX season_types_pkey ON public.season_types USING btree (id)""}, {""index"": ""season_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX season_types_code_unique ON public.season_types USING btree (code)""}]",

service_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('service_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""service_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX service_types_pkey ON public.service_types USING btree (id)""}, {""index"": ""service_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX service_types_code_unique ON public.service_types USING btree (code)""}]",

sessions,"[{""type"": ""character varying"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""ip_address"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""user_agent"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""payload"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""last_activity"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""sessions_pkey"", ""definition"": ""CREATE UNIQUE INDEX sessions_pkey ON public.sessions USING btree (id)""}, {""index"": ""sessions_user_id_index"", ""definition"": ""CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id)""}, {""index"": ""sessions_last_activity_index"", ""definition"": ""CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity)""}]",

social_connects,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('social_connects_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""social_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""provider"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""info"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp with time zone"", ""column"": ""created_at"", ""default"": ""now()"", ""nullable"": ""NO""}, {""type"": ""timestamp with time zone"", ""column"": ""updated_at"", ""default"": ""now()"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""from"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""social_connects_pkey"", ""definition"": ""CREATE UNIQUE INDEX social_connects_pkey ON public.social_connects USING btree (id)""}]",

states,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""state_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""country_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""states_pkey"", ""definition"": ""CREATE UNIQUE INDEX states_pkey ON public.states USING btree (id)""}, {""index"": ""states_country_id_index"", ""definition"": ""CREATE INDEX states_country_id_index ON public.states USING btree (country_id)""}, {""index"": ""states_status_index"", ""definition"": ""CREATE INDEX states_status_index ON public.states USING btree (status)""}]","[{""column"": ""country_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""countries"", ""constraint"": ""states_country_id_foreign"", ""ref_column"": ""id""}]"

subscription_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('subscription_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""subscription_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX subscription_types_pkey ON public.subscription_types USING btree (id)""}, {""index"": ""subscription_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX subscription_types_code_unique ON public.subscription_types USING btree (code)""}]",

superadmins,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('superadmins_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""email"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""password"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""mobile"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""remember_token"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""superadmins_pkey"", ""definition"": ""CREATE UNIQUE INDEX superadmins_pkey ON public.superadmins USING btree (id)""}, {""index"": ""superadmins_email_unique"", ""definition"": ""CREATE UNIQUE INDEX superadmins_email_unique ON public.superadmins USING btree (email)""}]",

target_segment_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('target_segment_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""target_segment_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX target_segment_types_pkey ON public.target_segment_types USING btree (id)""}, {""index"": ""target_segment_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX target_segment_types_code_unique ON public.target_segment_types USING btree (code)""}]",

tax_group_types,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('tax_group_types_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""tax_group_types_pkey"", ""definition"": ""CREATE UNIQUE INDEX tax_group_types_pkey ON public.tax_group_types USING btree (id)""}, {""index"": ""tax_group_types_code_unique"", ""definition"": ""CREATE UNIQUE INDEX tax_group_types_code_unique ON public.tax_group_types USING btree (code)""}]",

tax_groups,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('tax_groups_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""region_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""tax_rate"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""tax_group_type_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""sort_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'1'::smallint"", ""nullable"": ""NO""}]","[{""index"": ""idx_tax_groups_region_id"", ""definition"": ""CREATE INDEX idx_tax_groups_region_id ON public.tax_groups USING btree (region_id)""}, {""index"": ""idx_tax_groups_tax_group_type_id"", ""definition"": ""CREATE INDEX idx_tax_groups_tax_group_type_id ON public.tax_groups USING btree (tax_group_type_id)""}, {""index"": ""tax_groups_pkey"", ""definition"": ""CREATE UNIQUE INDEX tax_groups_pkey ON public.tax_groups USING btree (id)""}, {""index"": ""tax_groups_code_unique"", ""definition"": ""CREATE UNIQUE INDEX tax_groups_code_unique ON public.tax_groups USING btree (code)""}, {""index"": ""tax_groups_app_id_index"", ""definition"": ""CREATE INDEX tax_groups_app_id_index ON public.tax_groups USING btree (app_id)""}]","[{""column"": ""region_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""countries"", ""constraint"": ""tax_groups_region_id_foreign"", ""ref_column"": ""id""}, {""column"": ""tax_group_type_id"", ""on_delete"": ""SET NULL"", ""on_update"": ""NO ACTION"", ""ref_table"": ""tax_group_types"", ""constraint"": ""tax_groups_tax_group_type_id_foreign"", ""ref_column"": ""id""}]"

taxation,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""tax_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""tax_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""tax_rate"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""country_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""state_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""city_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""client_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""client_presence_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""boolean"", ""column"": ""is_applicable"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""effective_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""updated_by"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""taxation_pkey"", ""definition"": ""CREATE UNIQUE INDEX taxation_pkey ON public.taxation USING btree (id)""}, {""index"": ""idx_taxation_created_by"", ""definition"": ""CREATE INDEX idx_taxation_created_by ON public.taxation USING btree (created_by)""}, {""index"": ""idx_taxation_updated_by"", ""definition"": ""CREATE INDEX idx_taxation_updated_by ON public.taxation USING btree (updated_by)""}, {""index"": ""taxation_city_id_index"", ""definition"": ""CREATE INDEX taxation_city_id_index ON public.taxation USING btree (city_id)""}, {""index"": ""taxation_client_id_index"", ""definition"": ""CREATE INDEX taxation_client_id_index ON public.taxation USING btree (client_id)""}, {""index"": ""taxation_client_presence_id_index"", ""definition"": ""CREATE INDEX taxation_client_presence_id_index ON public.taxation USING btree (client_presence_id)""}, {""index"": ""taxation_country_id_index"", ""definition"": ""CREATE INDEX taxation_country_id_index ON public.taxation USING btree (country_id)""}, {""index"": ""taxation_created_at_index"", ""definition"": ""CREATE INDEX taxation_created_at_index ON public.taxation USING btree (created_at)""}, {""index"": ""taxation_state_id_index"", ""definition"": ""CREATE INDEX taxation_state_id_index ON public.taxation USING btree (state_id)""}, {""index"": ""taxation_tax_type_index"", ""definition"": ""CREATE INDEX taxation_tax_type_index ON public.taxation USING btree (tax_type)""}, {""index"": ""taxation_updated_at_index"", ""definition"": ""CREATE INDEX taxation_updated_at_index ON public.taxation USING btree (updated_at)""}]","[{""column"": ""city_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""cities"", ""constraint"": ""taxation_city_id_foreign"", ""ref_column"": ""id""}, {""column"": ""client_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client"", ""constraint"": ""taxation_client_id_foreign"", ""ref_column"": ""id""}, {""column"": ""client_presence_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_presence"", ""constraint"": ""taxation_client_presence_id_foreign"", ""ref_column"": ""id""}, {""column"": ""country_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""countries"", ""constraint"": ""taxation_country_id_foreign"", ""ref_column"": ""id""}, {""column"": ""created_by"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_user_mngt"", ""constraint"": ""taxation_created_by_foreign"", ""ref_column"": ""id""}, {""column"": ""state_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""states"", ""constraint"": ""taxation_state_id_foreign"", ""ref_column"": ""id""}, {""column"": ""updated_by"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""client_user_mngt"", ""constraint"": ""taxation_updated_by_foreign"", ""ref_column"": ""id""}]"

tbl_customer_subscriptions,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('tbl_customer_subscriptions_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""order_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""transaction_id"", ""default"": ""' '::character varying"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""package_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""package_title"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""subscriber_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""pg_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""start_date"", ""default"": ""'1970-01-01 00:00:00'::timestamp without time zone"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""end_date"", ""default"": ""'1970-01-01 00:00:00'::timestamp without time zone"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""grace"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_cancelled"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""cancelled_at"", ""default"": ""'1970-01-01 00:00:00'::timestamp without time zone"", ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""back_dated"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""is_duplicate_order"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""order_platform"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""purchase_type"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""price"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""autorenew"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}]","[{""index"": ""tbl_customer_subscriptions_pkey"", ""definition"": ""CREATE UNIQUE INDEX tbl_customer_subscriptions_pkey ON public.tbl_customer_subscriptions USING btree (id)""}, {""index"": ""tbl_customer_subscriptions_app_id"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_app_id ON public.tbl_customer_subscriptions USING btree (app_id)""}, {""index"": ""tbl_customer_subscriptions_created_at"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_created_at ON public.tbl_customer_subscriptions USING btree (created_at)""}, {""index"": ""tbl_customer_subscriptions_pg_name"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_pg_name ON public.tbl_customer_subscriptions USING btree (pg_name)""}, {""index"": ""idx_subs_app_subscriber_status"", ""definition"": ""CREATE INDEX idx_subs_app_subscriber_status ON public.tbl_customer_subscriptions USING btree (app_id, subscriber_id, status)""}, {""index"": ""idx_subs_status_end_date"", ""definition"": ""CREATE INDEX idx_subs_status_end_date ON public.tbl_customer_subscriptions USING btree (status, end_date)""}, {""index"": ""idx_subs_transaction_id"", ""definition"": ""CREATE INDEX idx_subs_transaction_id ON public.tbl_customer_subscriptions USING btree (transaction_id)""}, {""index"": ""tbl_customer_subscriptions_status"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_status ON public.tbl_customer_subscriptions USING btree (status)""}, {""index"": ""idx_subs_package_id"", ""definition"": ""CREATE INDEX idx_subs_package_id ON public.tbl_customer_subscriptions USING btree (package_id)""}, {""index"": ""tbl_customer_subscriptions_start_date"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_start_date ON public.tbl_customer_subscriptions USING btree (start_date)""}, {""index"": ""tbl_customer_subscriptions_end_date"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_end_date ON public.tbl_customer_subscriptions USING btree (end_date)""}, {""index"": ""tbl_customer_subscriptions_autorenew"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_autorenew ON public.tbl_customer_subscriptions USING btree (autorenew)""}, {""index"": ""tbl_customer_subscriptions_package_title"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_package_title ON public.tbl_customer_subscriptions USING btree (package_title)""}, {""index"": ""tbl_customer_subscriptions_subscriber_id"", ""definition"": ""CREATE INDEX tbl_customer_subscriptions_subscriber_id ON public.tbl_customer_subscriptions USING btree (subscriber_id)""}, {""index"": ""idx_customer_subscriptions_order_id"", ""definition"": ""CREATE INDEX idx_customer_subscriptions_order_id ON public.tbl_customer_subscriptions USING btree (order_id)""}]","[{""column"": ""order_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""tbl_order"", ""constraint"": ""fk_customer_subscriptions_order"", ""ref_column"": ""id""}]"

tbl_delete_account,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('tbl_delete_account_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""ref_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""request_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""subject"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""reason"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""status"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp with time zone"", ""column"": ""created_at"", ""default"": ""now()"", ""nullable"": ""YES""}]","[{""index"": ""tbl_delete_account_pkey"", ""definition"": ""CREATE UNIQUE INDEX tbl_delete_account_pkey ON public.tbl_delete_account USING btree (id)""}]",

tbl_order,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('tbl_order_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""transaction_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""subscriber_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""gateway_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""gateway_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""package_price"", ""default"": ""'0'::numeric"", ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""sgst"", ""default"": ""0.00"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""cgst"", ""default"": ""0.00"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""total"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""'0'::smallint"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""currency_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""coupon_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""coupon_amount"", ""default"": ""'0'::numeric"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""coupon_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""triggered_content_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""sync"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""client_order_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""package_id"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""smallint"", ""column"": ""auto_renew"", ""default"": ""0"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""package_name"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""tbl_order_pkey"", ""definition"": ""CREATE UNIQUE INDEX tbl_order_pkey ON public.tbl_order USING btree (id)""}, {""index"": ""tbl_order_app_id"", ""definition"": ""CREATE INDEX tbl_order_app_id ON public.tbl_order USING btree (app_id)""}, {""index"": ""tbl_order_coupon_code"", ""definition"": ""CREATE INDEX tbl_order_coupon_code ON public.tbl_order USING btree (coupon_code)""}, {""index"": ""tbl_order_coupon_id"", ""definition"": ""CREATE INDEX tbl_order_coupon_id ON public.tbl_order USING btree (coupon_id)""}, {""index"": ""tbl_order_subscriber_id"", ""definition"": ""CREATE INDEX tbl_order_subscriber_id ON public.tbl_order USING btree (subscriber_id)""}, {""index"": ""tbl_order_start_date"", ""definition"": ""CREATE INDEX tbl_order_start_date ON public.tbl_order USING btree (start_date)""}, {""index"": ""tbl_order_end_date"", ""definition"": ""CREATE INDEX tbl_order_end_date ON public.tbl_order USING btree (end_date)""}, {""index"": ""tbl_order_created_at"", ""definition"": ""CREATE INDEX tbl_order_created_at ON public.tbl_order USING btree (created_at)""}, {""index"": ""tbl_order_gateway_id"", ""definition"": ""CREATE INDEX tbl_order_gateway_id ON public.tbl_order USING btree (gateway_id)""}, {""index"": ""tbl_order_package_id"", ""definition"": ""CREATE INDEX tbl_order_package_id ON public.tbl_order USING btree (package_id)""}, {""index"": ""idx_tbl_order_transaction_id"", ""definition"": ""CREATE INDEX idx_tbl_order_transaction_id ON public.tbl_order USING btree (transaction_id)""}, {""index"": ""idx_tbl_order_app_subscriber_status"", ""definition"": ""CREATE INDEX idx_tbl_order_app_subscriber_status ON public.tbl_order USING btree (app_id, subscriber_id, status)""}, {""index"": ""idx_tbl_order_app_subscriber"", ""definition"": ""CREATE INDEX idx_tbl_order_app_subscriber ON public.tbl_order USING btree (app_id, subscriber_id)""}, {""index"": ""tbl_order_currency"", ""definition"": ""CREATE INDEX tbl_order_currency ON public.tbl_order USING btree (currency)""}, {""index"": ""tbl_order_status"", ""definition"": ""CREATE INDEX tbl_order_status ON public.tbl_order USING btree (status)""}, {""index"": ""tbl_order_auto_renewal"", ""definition"": ""CREATE INDEX tbl_order_auto_renewal ON public.tbl_order USING btree (auto_renew)""}]",

tbl_packages,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('tbl_packages_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""title"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""auto_renew"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""order_index"", ""default"": ""999"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""package_mode"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""razorpay_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""google_inapp_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""google_inapp_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""apple_inapp_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""apple_inapp_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""paytm_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""paytm_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""amazonpay_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""currency_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""currency_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""amazonpay_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""country_code"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""stripe_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""stripe_recurring_plan_id"", ""default"": ""'0'::character varying"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""roku_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""roku_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""price"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""download_expiry"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""pkg_platform_avl"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""jiotv_plan_id"", ""default"": ""'1'::character varying"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""jiotv_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""period"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""period_interval"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""plan_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""trial_period"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""trial_length"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""package_type"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""date"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""date"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""publish"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""strikout_price"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""device_restriction"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""modified_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""package_category_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""has_grace"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""has_suspension"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""is_downloadable"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""has_free_trial"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""razorpay_recurring_plan_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""idx_packages_app_id"", ""definition"": ""CREATE INDEX idx_packages_app_id ON public.tbl_packages USING btree (app_id)""}, {""index"": ""idx_packages_app_status"", ""definition"": ""CREATE INDEX idx_packages_app_status ON public.tbl_packages USING btree (app_id, status)""}, {""index"": ""idx_packages_app_order_index"", ""definition"": ""CREATE INDEX idx_packages_app_order_index ON public.tbl_packages USING btree (app_id, order_index)""}, {""index"": ""idx_packages_google_plan"", ""definition"": ""CREATE INDEX idx_packages_google_plan ON public.tbl_packages USING btree (google_inapp_plan_id)""}, {""index"": ""idx_packages_apple_plan"", ""definition"": ""CREATE INDEX idx_packages_apple_plan ON public.tbl_packages USING btree (apple_inapp_plan_id)""}, {""index"": ""idx_packages_razorpay_plan"", ""definition"": ""CREATE INDEX idx_packages_razorpay_plan ON public.tbl_packages USING btree (razorpay_plan_id)""}, {""index"": ""tbl_package_pkey"", ""definition"": ""CREATE UNIQUE INDEX tbl_package_pkey ON public.tbl_packages USING btree (id)""}]",

temp,"[{""type"": ""integer"", ""column"": ""id"", ""default"": ""nextval('temp_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""email"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""temp_pkey"", ""definition"": ""CREATE UNIQUE INDEX temp_pkey ON public.temp USING btree (id)""}]",

ticket_categories,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('ticket_categories_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""category"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""smallint"", ""column"": ""status"", ""default"": ""1"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}]","[{""index"": ""ticket_categories_pkey"", ""definition"": ""CREATE UNIQUE INDEX ticket_categories_pkey ON public.ticket_categories USING btree (id)""}]",

user_segments,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('user_segments_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""segment_name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""segment_description"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""segment_config"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""json"", ""column"": ""customer_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""created_by"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""is_active"", ""default"": ""true"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""estimated_size"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""in_cohort"", ""default"": ""false"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""user_segments_app_id_index"", ""definition"": ""CREATE INDEX user_segments_app_id_index ON public.user_segments USING btree (app_id)""}, {""index"": ""user_segments_pkey"", ""definition"": ""CREATE UNIQUE INDEX user_segments_pkey ON public.user_segments USING btree (id)""}, {""index"": ""user_segments_segment_name_index"", ""definition"": ""CREATE INDEX user_segments_segment_name_index ON public.user_segments USING btree (segment_name)""}, {""index"": ""user_segments_created_by_index"", ""definition"": ""CREATE INDEX user_segments_created_by_index ON public.user_segments USING btree (created_by)""}, {""index"": ""user_segments_is_active_index"", ""definition"": ""CREATE INDEX user_segments_is_active_index ON public.user_segments USING btree (is_active)""}]",

user_verification_otp,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('user_verification_otp_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""expiry_time"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""contact_no"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""otp"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}]","[{""index"": ""user_verification_otp_pkey"", ""definition"": ""CREATE UNIQUE INDEX user_verification_otp_pkey ON public.user_verification_otp USING btree (id)""}]",

user_wallet,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""current_balance"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""previous_balance"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_added"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_spent"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""payment_source"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character"", ""column"": ""currency"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""user_wallet_pkey"", ""definition"": ""CREATE UNIQUE INDEX user_wallet_pkey ON public.user_wallet USING btree (id)""}, {""index"": ""user_wallet_currency_index"", ""definition"": ""CREATE INDEX user_wallet_currency_index ON public.user_wallet USING btree (currency)""}, {""index"": ""user_wallet_status_index"", ""definition"": ""CREATE INDEX user_wallet_status_index ON public.user_wallet USING btree (status)""}, {""index"": ""user_wallet_user_id_index"", ""definition"": ""CREATE INDEX user_wallet_user_id_index ON public.user_wallet USING btree (user_id)""}]",

client_users,"[{""type"": ""integer"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""name"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""email"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""password"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""mobile"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""integer"", ""column"": ""parent_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""USER-DEFINED"", ""column"": ""permission_type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""organisation"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""token"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""USER-DEFINED"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created"", ""default"": ""CURRENT_TIMESTAMP"", ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""modified"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""user_access"", ""default"": ""'{}'::jsonb"", ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""business_unit"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""business_unit_ids"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""org_address"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""org_logo"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""contact_email"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""contact_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""website_name"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""gst_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""pan_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""vat_number"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""jsonb"", ""column"": ""payment_gateways"", ""default"": ""'[]'::jsonb"", ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""api_key"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""remember_token"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""timezone"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""client_users_pkey"", ""definition"": ""CREATE UNIQUE INDEX client_users_pkey ON public.client_users USING btree (id)""}, {""index"": ""idx_client_users_id_app"", ""definition"": ""CREATE INDEX idx_client_users_id_app ON public.client_users USING btree (id, app_id)""}, {""index"": ""idx_client_users_user_access"", ""definition"": ""CREATE INDEX idx_client_users_user_access ON public.client_users USING gin (user_access)""}]",

voucher_usage_logs,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('voucher_usage_logs_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""voucher_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""order_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""deducted_amount"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""remaining_balance"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""redeemed_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""idx_voucher_usage_logs_voucher_id"", ""definition"": ""CREATE INDEX idx_voucher_usage_logs_voucher_id ON public.voucher_usage_logs USING btree (voucher_id)""}, {""index"": ""voucher_usage_logs_pkey"", ""definition"": ""CREATE UNIQUE INDEX voucher_usage_logs_pkey ON public.voucher_usage_logs USING btree (id)""}]","[{""column"": ""voucher_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""vouchers"", ""constraint"": ""voucher_usage_logs_voucher_id_foreign"", ""ref_column"": ""id""}]"

vouchers,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": ""nextval('vouchers_id_seq'::regclass)"", ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""voucher_code"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""voucher_type"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""amount"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""numeric"", ""column"": ""balance_amount"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""currency"", ""default"": ""'INR'::character varying"", ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""issued_to_user_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""issued_by_admin_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""bigint"", ""column"": ""order_id_source"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""boolean"", ""column"": ""is_redeemable_once"", ""default"": ""false"", ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""valid_from"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""valid_until"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": ""'active'::character varying"", ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""usage_count"", ""default"": ""0"", ""nullable"": ""YES""}, {""type"": ""text"", ""column"": ""notes"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""integer"", ""column"": ""app_id"", ""default"": null, ""nullable"": ""YES""}, {""type"": ""timestamp without time zone"", ""column"": ""redeemed_at"", ""default"": null, ""nullable"": ""YES""}]","[{""index"": ""vouchers_voucher_code_unique"", ""definition"": ""CREATE UNIQUE INDEX vouchers_voucher_code_unique ON public.vouchers USING btree (voucher_code)""}, {""index"": ""vouchers_app_id_index"", ""definition"": ""CREATE INDEX vouchers_app_id_index ON public.vouchers USING btree (app_id)""}, {""index"": ""vouchers_pkey"", ""definition"": ""CREATE UNIQUE INDEX vouchers_pkey ON public.vouchers USING btree (id)""}]",

wallet_history,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""user_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""wallet_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""bigint"", ""column"": ""offer_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""double precision"", ""column"": ""current_balance"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""double precision"", ""column"": ""previous_balance"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""double precision"", ""column"": ""amount"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""type"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""source"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""refernce_id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character"", ""column"": ""currency"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""transaction _detail"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""initiated_by"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""last_modified"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""wallet_history_pkey"", ""definition"": ""CREATE UNIQUE INDEX wallet_history_pkey ON public.wallet_history USING btree (id)""}, {""index"": ""wallet_history_currency_index"", ""definition"": ""CREATE INDEX wallet_history_currency_index ON public.wallet_history USING btree (currency)""}, {""index"": ""wallet_history_initiated_by_index"", ""definition"": ""CREATE INDEX wallet_history_initiated_by_index ON public.wallet_history USING btree (initiated_by)""}, {""index"": ""wallet_history_last_modified_index"", ""definition"": ""CREATE INDEX wallet_history_last_modified_index ON public.wallet_history USING btree (last_modified)""}, {""index"": ""wallet_history_offer_id_index"", ""definition"": ""CREATE INDEX wallet_history_offer_id_index ON public.wallet_history USING btree (offer_id)""}, {""index"": ""wallet_history_source_index"", ""definition"": ""CREATE INDEX wallet_history_source_index ON public.wallet_history USING btree (source)""}, {""index"": ""wallet_history_status_index"", ""definition"": ""CREATE INDEX wallet_history_status_index ON public.wallet_history USING btree (status)""}, {""index"": ""wallet_history_type_index"", ""definition"": ""CREATE INDEX wallet_history_type_index ON public.wallet_history USING btree (type)""}, {""index"": ""wallet_history_user_id_index"", ""definition"": ""CREATE INDEX wallet_history_user_id_index ON public.wallet_history USING btree (user_id)""}, {""index"": ""wallet_history_wallet_id_index"", ""definition"": ""CREATE INDEX wallet_history_wallet_id_index ON public.wallet_history USING btree (wallet_id)""}]","[{""column"": ""offer_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""wallet_offer"", ""constraint"": ""wallet_history_offer_id_foreign"", ""ref_column"": ""id""}, {""column"": ""wallet_id"", ""on_delete"": ""NO ACTION"", ""on_update"": ""NO ACTION"", ""ref_table"": ""user_wallet"", ""constraint"": ""wallet_history_wallet_id_foreign"", ""ref_column"": ""id""}]"

wallet_offer,"[{""type"": ""bigint"", ""column"": ""id"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""title"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""description"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""promotional_text1"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""text"", ""column"": ""promotional_text2"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_banner1"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""promotional_banner2"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character"", ""column"": ""currency"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""amount"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""bonus_amount"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""numeric"", ""column"": ""max_bonus"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""character varying"", ""column"": ""status"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""start_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""end_date"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""created_at"", ""default"": null, ""nullable"": ""NO""}, {""type"": ""timestamp without time zone"", ""column"": ""updated_at"", ""default"": null, ""nullable"": ""NO""}]","[{""index"": ""wallet_offer_pkey"", ""definition"": ""CREATE UNIQUE INDEX wallet_offer_pkey ON public.wallet_offer USING btree (id)""}, {""index"": ""wallet_offer_created_at_index"", ""definition"": ""CREATE INDEX wallet_offer_created_at_index ON public.wallet_offer USING btree (created_at)""}, {""index"": ""wallet_offer_currency_index"", ""definition"": ""CREATE INDEX wallet_offer_currency_index ON public.wallet_offer USING btree (currency)""}, {""index"": ""wallet_offer_status_index"", ""definition"": ""CREATE INDEX wallet_offer_status_index ON public.wallet_offer USING btree (status)""}, {""index"": ""wallet_offer_updated_at_index"", ""definition"": ""CREATE INDEX wallet_offer_updated_at_index ON public.wallet_offer USING btree (updated_at)""}]",
