日期:2014-05-16 浏览次数:21027 次
表结构如下:
-- Create table
create table CSS_SUPPLY
(
supply_id VARCHAR2(20) not null,
user_id VARCHAR2(16) not null,
cont_no VARCHAR2(10),
reg_date VARCHAR2(20),
product_id VARCHAR2(20),
product_name VARCHAR2(200),
uom VARCHAR2(10),
trademark VARCHAR2(30),
origin VARCHAR2(30),
category VARCHAR2(10),
quantity NUMBER(10),
deliver_days NUMBER(10),
deadline VARCHAR2(20),
img_uri VARCHAR2(600),
status VARCHAR2(2),
product_name_en VARCHAR2(200),
trademark_en VARCHAR2(30),
origin_en VARCHAR2(30),
category_en VARCHAR2(10),
uom_en VARCHAR2(10),
remark_en VARCHAR2(4000),
visit_count NUMBER(16),
stock_number NUMBER(16),
enquiry_count NUMBER(16),
price NUMBER(20,2),
product_code VARCHAR2(20),
standard VARCHAR2(150),
standard_en VARCHAR2(150),
model VARCHAR2(150),
model_en VARCHAR2(150),
cont_name VARCHAR2(30),
cont_name_en VARCHAR2(30),
cont_email VARCHAR2(60),
cont_phone VARCHAR2(50),
cont_mobile VARCHAR2(50),
cont_fax VARCHAR2(50),