/*創建客戶信息表 kehu */
drop table kehu
create table kehu
(
    kehu_no            varchar(6)               not null,
    kehu_name           varchar(20)              null,
    kehu_adress          varchar(30)              null,
    kehu_sh             varchar(10)              null,
    kehu_repute            varchar(10)              null,
    kehu_country            varchar(10)              null,
    kehu_province             varchar(10)              null,
 constraint PK__KEHU__NO primary key clustered (kehu_no)
)
go
/*創建訂單信息表dd*/
drop table dd
create table dd
(
    dd_no              varchar(6)              not null,
    dd_date            datetime                    null,
    kehu_no            varchar(6)             not null,
    product_no         varchar(6)             not null,
    product_number     numeric(10)            null,
    need_date          datetime                null,
    dd_manager         varchar(10)       not null,
    dd_flag      varchar(1)  default '0'     null,
 constraint PK__dd__NO primary key clustered (dd_no)
)
go
/*庫存信息表kc*/
drop table kc
create table kc
(
    product_no         varchar(6)             not null,
    product_number     numeric(10)            null,
    kc_adress          varchar(10)            not null,
 constraint PK__kc__product_no primary key clustered (product_no)
)
go
/*發貨信息表fh*/
drop table fh
create table fh
(
 dd_no varchar(6) not null,
 fh_date datetime null,
  product_no varchar(6) null,
  kehu_no varchar(6) not null,
  product_number numeric(10) null,
  product_price numeric(10) null,
  fh_manager varchar(10) not null,
 
 constraint pk_fh_dd_no primary key clustered (dd_no)
)
go
/*產品信息表product*/
drop table product
create table product
(
 product_no varchar(6) not null,
 product_name varchar(20) null,
 product_numberpermonth numeric(10) null,
 product_adress varchar(20) null,
 product_llperone numeric(6) null,
 product_price numeric(10) null,
 product_xh varchar(6) null,
 constraint pk_product_product_no primary key clustered (product_no)
)
go
/*產品生產表producting*/
drop table producting
create table producting
(
 product_no varchar(6) not null,
 product_number numeric(10) null,
 product_outdate datetime null,
 product_manager varchar(10) null,
 constraint pk_producting_product_no primary key clustered (product_no)
)
go
/*產品進庫信息表jk*/
drop table jk
create table jk
(
 jk_no varchar(6) not null,
 product_no varchar(6) not null,
 product_number numeric(10) null,
 product_indate datetime null,
 product_manager varchar(10) null,
 constraint pk_jk_jk_no primary key clustered (jk_no)
)
go