public override ISqlExpression GetIdentityExpression(SqlTable table, SqlField identityField, bool forReturning)
		{
			if (table.SequenceAttributes != null)
				return new SqlExpression("GEN_ID(" + table.SequenceAttributes[0].SequenceName + ", 1)", Precedence.Primary);

			return base.GetIdentityExpression(table, identityField, forReturning);
		}

		public override ISqlExpression GetIdentityExpression(SqlTable table, SqlField identityField, bool forReturning)
		{
			if (table.SequenceAttributes != null)
			{
				var attr = GetSequenceNameAttribute(table, false);

				if (attr != null)
					return new SqlExpression(attr.SequenceName + ".nextval", Precedence.Primary);
			}

			return base.GetIdentityExpression(table, identityField, forReturning);
		}

 public Address()
 {
     party_id = new SqlField("party_id", SqlDbType.BigInt);
     address_format_type_cd_id = new SqlField("address_format_type_cd_id", SqlDbType.BigInt, isNullable: true);
     address_type_cd_id = new SqlField("address_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ADDRESS_TYPE);
     attention = new SqlField("attention", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     city = new SqlField("city", SqlDbType.VarChar, isNullable: true, maxLength: 30);
     country = new SqlField("country", SqlDbType.VarChar, isNullable: true, maxLength: 30);
     county = new SqlField("county", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     postal_code = new SqlField("postal_code", SqlDbType.VarChar, isNullable: true, maxLength: 10);
     state = new SqlField("state", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     street_3 = new SqlField("street_3", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     street_aux = new SqlField("street_aux", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     street_main = new SqlField("street_main", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     usage_cd_id = new SqlField("usage_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ADDRESS_USAGE);
 }

        protected override void BuildCreateTableFieldType(SqlField field)
        {
            if (field.IsIdentity)
            {
                if (field.DataType == DataType.Int32)
                {
                    StringBuilder.Append("SERIAL");
                    return;
                }

                if (field.DataType == DataType.Int64)
                {
                    StringBuilder.Append("SERIAL8");
                    return;
                }
            }

            base.BuildCreateTableFieldType(field);
        }

 public Rule_assignment()
 {
     attached_to_id = new SqlField("attached_to_id", SqlDbType.BigInt);
     attached_to_type_cd_id = new SqlField("attached_to_type_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.SYSTEM_OBJECT_TYPE);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
     rule_id = new SqlField("rule_id", SqlDbType.BigInt, isNullable: true);
     rule_id_old = new SqlField("rule_id_old", SqlDbType.VarChar, isNullable: true, maxLength: 100);
 }

        static SelectQuery.TableSource FindField(SqlField field, SelectQuery.TableSource table)
        {
            if (field.Table == table.Source)
                return table;

            foreach (var @join in table.Joins)
            {
                var t = FindField(field, @join.Table);

                if (t != null)
                    return @join.Table;
            }

            return null;
        }

 public Template()
 {
     name = new SqlField("name", SqlDbType.VarChar, maxLength: 250);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     template_category_cd_id = new SqlField("template_category_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.TEMPLATE_CATEGORY);
     template_text = new SqlField("template_text", SqlDbType.Text);
     description = new SqlField("description", SqlDbType.VarChar, isNullable: true, maxLength: 250);
     end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
     template_type_cd_id = new SqlField("template_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.TEMPLATE_TYPE);
 }

 public Settlement_config()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     check_group_id = new SqlField("check_group_id", SqlDbType.SmallInt);
     settlement_method_cd_id = new SqlField("settlement_method_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.SETTLEMENT_METHOD);
     attached_to_id = new SqlField("attached_to_id", SqlDbType.BigInt, isNullable: true);
     attached_to_type_cd_id = new SqlField("attached_to_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.SYSTEM_OBJECT_TYPE);
     auto_close_criteria = new SqlField("auto_close_criteria", SqlDbType.VarChar, isNullable: true, maxLength: 500);
     auto_closeout_time = new SqlField("auto_closeout_time", SqlDbType.VarChar, isNullable: true, maxLength: 30);
     bank_number = new SqlField("bank_number", SqlDbType.VarChar, isNullable: true, maxLength: 44);
     check_pay_to_name = new SqlField("check_pay_to_name", SqlDbType.VarChar, isNullable: true, maxLength: 250);
     checking_account_number = new SqlField("checking_account_number", SqlDbType.VarChar, isNullable: true, maxLength: 54);
     is_auto_closeout = new SqlField("is_auto_closeout", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     is_check_per_order = new SqlField("is_check_per_order", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     is_check_per_order_pos = new SqlField("is_check_per_order_pos", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     is_close_children_on_auto_closeout = new SqlField("is_close_children_on_auto_closeout", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     is_close_prior_business_day = new SqlField("is_close_prior_business_day", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     no_closeout_dates = new SqlField("no_closeout_dates", SqlDbType.VarChar, isNullable: true, maxLength: 100);
     prior_day_time_offset_minutes = new SqlField("prior_day_time_offset_minutes", SqlDbType.Int, isNullable: true);
     report_group_id = new SqlField("report_group_id", SqlDbType.SmallInt, isNullable: true);
     report_template_id = new SqlField("report_template_id", SqlDbType.BigInt, isNullable: true);
     settlement_report_cd_id = new SqlField("settlement_report_cd_id", SqlDbType.BigInt, isNullable: true);
 }

 public Rule()
 {
     rule_name = new SqlField("rule_name", SqlDbType.VarChar, maxLength: 100);
     rule_type_cd_id = new SqlField("rule_type_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.RULE_TYPE);
     run_location_cd_id = new SqlField("run_location_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.RULE_RUN_LOCATION);
     is_exclude_from_cache = new SqlField("is_exclude_from_cache", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     rule_class = new SqlField("rule_class", SqlDbType.VarChar, isNullable: true, maxLength: 255);
     rule_display_name = new SqlField("rule_display_name", SqlDbType.VarChar, isNullable: true, maxLength: 256);
     trigger_cd_id = new SqlField("trigger_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.RULE_TYPE);
 }

 public Business_unit_batch_receipt_config()
 {
     name = new SqlField("name", SqlDbType.VarChar, maxLength: 50);
     party_id = new SqlField("party_id", SqlDbType.BigInt);
     seq_no = new SqlField("seq_no", SqlDbType.SmallInt);
     config = new SqlField("config", SqlDbType.Image, isNullable: true);
 }

		protected override void BuildCreateTableIdentityAttribute1(SqlField field)
		{
			StringBuilder.Append("GENERATED BY DEFAULT AS IDENTITY");
		}

 protected override void BuildCreateTableIdentityAttribute1(SqlField field)
 {
     StringBuilder.Append("AUTO_INCREMENT");
 }

 public Business_unit_merchant_number()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     is_card_present = new SqlField("is_card_present", SqlDbType.Char, maxLength: 1, isFlag: true);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     visa_mastercard_id = new SqlField("visa_mastercard_id", SqlDbType.VarChar, maxLength: 20);
     amex_id = new SqlField("amex_id", SqlDbType.VarChar, isNullable: true, maxLength: 20);
     discover_id = new SqlField("discover_id", SqlDbType.VarChar, isNullable: true, maxLength: 20);
     end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
     is_tax_number = new SqlField("is_tax_number", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     is_vcfee_tax_number = new SqlField("is_vcfee_tax_number", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     provider_id = new SqlField("provider_id", SqlDbType.VarChar, isNullable: true, maxLength: 5);
 }

 public Business_unit_order_comment()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     comment_cd_id = new SqlField("comment_cd_id", SqlDbType.BigInt);
     end_date = new SqlField("end_date", SqlDbType.DateTime);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     display_order = new SqlField("display_order", SqlDbType.SmallInt, isNullable: true);
     order_processing_location_cd_id = new SqlField("order_processing_location_cd_id", SqlDbType.BigInt, isNullable: true);
     override_template_id = new SqlField("override_template_id", SqlDbType.BigInt, isNullable: true);
 }

 public Business_unit_correspondence_reason()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     correspondence_reason_cd_id = new SqlField("correspondence_reason_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.CORRESPONDENCE_REASON);
     end_date = new SqlField("end_date", SqlDbType.DateTime);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     display_order = new SqlField("display_order", SqlDbType.SmallInt, isNullable: true);
     order_processing_location_cd_id = new SqlField("order_processing_location_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ORDER_PLACEMENT_LOCATION);
     override_template_id = new SqlField("override_template_id", SqlDbType.BigInt, isNullable: true);
 }

 public Business_unit_connect_info()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     ftp_folder = new SqlField("ftp_folder", SqlDbType.VarChar, isNullable: true, maxLength: 100);
     ftp_password = new SqlField("ftp_password", SqlDbType.VarChar, isNullable: true, maxLength: 128);
     ftp_user = new SqlField("ftp_user", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     gpg_options = new SqlField("gpg_options", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     gpgp_key_name = new SqlField("gpgp_key_name", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     is_ftp_s = new SqlField("is_ftp_s", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
     postback_password = new SqlField("postback_password", SqlDbType.VarChar, isNullable: true, maxLength: 128);
     postback_url = new SqlField("postback_url", SqlDbType.VarChar, isNullable: true, maxLength: 1000);
     postback_user = new SqlField("postback_user", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     server_name = new SqlField("server_name", SqlDbType.VarChar, isNullable: true, maxLength: 50);
     share_name = new SqlField("share_name", SqlDbType.VarChar, isNullable: true, maxLength: 100);
 }

 public Business_unit_close_method()
 {
     business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
     close_method_cd_id = new SqlField("close_method_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.EOD_CLOSE_METHOD);
     display_index = new SqlField("display_index", SqlDbType.SmallInt, isNullable: true);
 }

        static ISqlExpression GetColumn(QueryData data, SqlField field)
        {
            foreach (var query in data.Queries)
            {
                var q = query.Query;

                foreach (var table in q.From.Tables)
                {
                    var t = FindField(field, table);

                    if (t != null)
                    {
                        var n   = q.Select.Columns.Count;
                        var idx = q.Select.Add(field);

                        if (n != q.Select.Columns.Count)
                            if (!q.GroupBy.IsEmpty || q.Select.Columns.Any(c => IsAggregationFunction(c.Expression)))
                                q.GroupBy.Items.Add(field);

                        return q.Select.Columns[idx];
                    }
                }
            }

            return null;
        }

 public Terminal_id()
 {
     business_unit_merchant_number_id = new SqlField("business_unit_merchant_number_id", SqlDbType.BigInt);
     start_date = new SqlField("start_date", SqlDbType.DateTime);
     terminal_id = new SqlField("terminal_id", SqlDbType.VarChar, maxLength: 20);
     business_unit_pos_terminal_id = new SqlField("business_unit_pos_terminal_id", SqlDbType.BigInt, isNullable: true);
     end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
 }

            protected override SqlExpression VisitField(SqlField expr)
            {
                // нужно вытащить имя источника поля
                string sourceName = null;
                if (!_nameMap.TryGetValue(expr.Source, out sourceName))
                {
                    sourceName = "T" + _nameMap.Count;
                    _nameMap[expr.Source] = sourceName;
                }

                if (!String.IsNullOrEmpty(sourceName))
                {
                    WriteName(sourceName);
                    _builder.Append('.');
                }
                WriteName(expr.Name);                    
                return expr;
            }