CREATE TABLE dbo.main_gr (
    iGr                            smallint                                not  null 
  , Name                           varchar                        ( 100 )    not  null 
  , s_Kod                          varchar                        ( 10 )      null 
  , stored                          char                            ( 1 )       null 
  , hlev                           smallint                                 null 
  , is_filial                       char                            ( 1 )       null 
  , is_ru                           char                            ( 1 )       null 
  , is_nbu                          char                            ( 1 )       null 
  , Bizn                           smallint                                 null 
  , Bizn_iGr_Par                   smallint                                 null 
  , bizn_ns                         char                            ( 1 )       null 
  , gr                              char                            ( 2 )       null 
  , ru                              char                            ( 1 )       null 
  , Is_Otd                          char                            ( 1 )       null 
  , Is_TOBO                         char                            ( 1 )       null 
  , is_ukr                          char                            ( 1 )       null 
  , ibank                          smallint                                not  null 
  , BBN_BNMN                        char                            ( 2 )      not  null 
  , BFL_CNA                         char                            ( 2 )      not  null 
  )

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping  PUBLIC  "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping  package ="test_app">
  < class  name="Main_gr" table="main_gr">
<id name="id" column="iGr">
<generator  class ="native"/>
</id>
<property name="name" type="java.lang.String">
			<column name="name" not- null ="true" sql-type="VARCHAR" />
</property>
<property name="hlev" type="smallint" column="hlev"/>
<property name="s_kod" type="java.lang.String">
			<column name="s_kod" not- null ="true" sql-type="VARCHAR" />
</property>
</ class >
</hibernate-mapping>