transaction-service/transaction-server/target/classes/sql/ty_jycrkwt_ky.sql

-- ty_jycrkwt_ky 看样
database db_utf8 ;
CREATE TABLE db_utf8:ty_jycrkwt_ky (
	data_id varchar(100),
	locale varchar(100),
	lxr varchar(100)
) ;
comment on table db_utf8:ty_jycrkwt_ky is '委托看样' ;

-- ty_jycrkwt_hw 货物
CREATE TABLE db_utf8:ty_jycrkwt_hw (
	data_id varchar(100),
	wtbm varchar(100),
	lxr varchar(100),
    pzmc varchar(100),
    pzbm varchar(100),
    lsdj varchar(100),
    scnd varchar(20),
    lssl DECIMAL(9,3),
    jyfx INTEGER
) ;

comment on table db_utf8:ty_jycrkwt_hw is '委托货物' ;
comment on column db_utf8:ty_jycrkwt_hw.data_id is '';
comment on column db_utf8:ty_jycrkwt_hw.wtbm is '';
comment on column db_utf8:ty_jycrkwt_hw.lxr is '';
comment on column db_utf8:ty_jycrkwt_hw.pzmc is '';
comment on column db_utf8:ty_jycrkwt_hw.pzbm is '';
comment on column db_utf8:ty_jycrkwt_hw.lsdj is '';
comment on column db_utf8:ty_jycrkwt_hw.scnd is '';
comment on column db_utf8:ty_jycrkwt_hw.lssl is '粮食数量';
comment on column db_utf8:ty_jycrkwt_hw.jyfx is '交易方向<br/>  0 采购 <br/> 1 销售';

``