SQL

create table [dbo].[aaa_through_log] (
  kno varchar(50) not null
  , dt datetime default getdate() not null
  , test int default 0
  , primary key (kno,dt)
);








create table [dbo].[address] (
  ind varchar(18) not null
  , yuubin varchar(300) not null
  , prefecture varchar(300) not null
  , jyuusyo1 varchar(300) not null
  , jyuusyo2 varchar(300) not null
  , primary key (ind,yuubin,jyuusyo1,jyuusyo2)
);






create table [dbo].[adplan_origin] (
  id int not null
  , banner_id varchar(150) not null
  , media_name varchar(150) not null
  , menu_name varchar(150) not null
  , link_name varchar(150) not null
  , submit_name varchar(150) not null
  , entry_date varchar(150) not null
  , user_id int not null
  , product_name varchar(150) not null
  , result_price varchar(150) not null
  , order_id varchar(150) not null
  , pc varchar(15) not null
  , ad_type varchar(60) not null
  , primary key (id)
);










create table [dbo].[alert] (
  barno int not null
  , mannum int not null
  , rakusatu_alert_flg int not null
  , rakusatu_date varchar(36) not null
  , haiso_alert_flg int not null
  , haiso_date varchar(36) not null
  , touroku_date varchar(36) not null
  , kubun varchar(30) not null
  , price int not null
  , yobi varchar(36) not null
  , primary key (barno)
);










create table [dbo].[alert] (
  barno int not null
  , mannum int not null
  , rakusatu_alert_flg int not null
  , rakusatu_date varchar(36) not null
  , haiso_alert_flg int not null
  , haiso_date varchar(36) not null
  , touroku_date varchar(36) not null
  , kubun varchar(30) not null
  , price int not null
  , yobi varchar(36) not null
  , primary key (barno)
);










create table [dbo].[all_product_status] (
  barno int not null
  , kaitori_category int not null
  , sex int not null
  , oya_cate int not null
  , cate int not null
  , brand_cd int not null
  , brand_name varchar(90) not null
  , season_cd int not null
  , kikaku_cd int not null
  , barno_order_date varchar(36) not null
  , barno_set_date varchar(36) not null
  , daityou_date varchar(36) not null
  , satuei_date varchar(36) not null
  , stock_date varchar(36) not null
  , kakou_date varchar(36) not null
  , syupin_date varchar(36) not null
  , uriage_date varchar(36) not null
  , kaitori_price int not null
  , uriage_price int not null
  , base_id int not null
  , shop_cd int not null
  , product_status int not null
  , list_output_flg int not null
  , syupin_price int not null
  , tantou_name varchar(60) not null
  , z_cate int not null
  , z_product_type_id int not null
  , mannum int not null
  , primary key (barno)
);






create table [dbo].[all_product_status_kai] (
  barno int not null
  , kaitori_category int not null
  , sex int not null
  , oya_cate int not null
  , cate int not null
  , brand_cd int not null
  , brand_name varchar(90) not null
  , season_cd int not null
  , kikaku_cd int not null
  , barno_order_date varchar(36) not null
  , barno_set_date varchar(36) not null
  , daityou_date varchar(36) not null
  , satuei_date varchar(36) not null
  , stock_date varchar(36) not null
  , kakou_date varchar(36) not null
  , syupin_date varchar(36) not null
  , uriage_date varchar(36) not null
  , kaitori_price int not null
  , uriage_price int not null
  , base_id int not null
  , shop_cd int not null
  , product_status int not null
  , list_output_flg int not null
  , syupin_price int not null
  , tantou_name varchar(60) not null
  , z_cate int not null
  , z_product_type_id int not null
  , mannum int not null
  , niuke_date varchar(36) not null
  , niuke_location_no varchar(30) not null
  , draft_date varchar(36) not null
  , draft_location_no varchar(30) not null
  , satei_date varchar(36) not null
  , satei_location_no varchar(30) not null
  , pick_date varchar(36) not null
  , assort_location_no varchar(36) not null
  , daityou_location_no varchar(36) not null
  , satuei_location_no varchar(36) not null
  , inventory_date varchar(36) not null
  , inventory_base_id int not null
  , inventory_user_id int not null
  , yobi1 varchar(36) not null
  , yobi2 varchar(36) not null
  , yobi3 varchar(36) not null
  , primary key (barno)
);






create table [dbo].[arrival_kanri_list] (
  status varchar(60) not null
  , no bigint not null
  , kaitori_no varchar(120) not null
  , touroku_date varchar(72) not null
  , name varchar(60) not null
  , kisai_yiyu varchar(300) not null
  , kisaisya varchar(60) not null
  , arrival_date varchar(72) not null
  , bikou varchar(300) not null
  , comp_user_name varchar(300) not null
  , comp_date varchar(120) not null
  , contact_date varchar(72) not null
  , contact_user_name varchar(300) not null
  , last_update_dt datetime default NULL
  , primary key (no)
);






create table [dbo].[arrival_kanri_list_comment] (
  no bigint not null
  , no2 int not null
  , comment varchar(300) not null
  , user_id int not null
  , dt datetime
);














create table [dbo].[assort_furiwake] (
  cate_cd int not null
  , cate_name varchar(60) not null
  , category4 varchar(30) not null
  , sex varchar(15) not null
  , primary key (cate_cd,cate_name)
);








create table [dbo].[assort_memo] (
  status varchar(60) not null
  , no bigint not null
  , kaitori_no varchar(120) not null
  , work_date varchar(36) not null
  , seiritu_date varchar(36) not null
  , name varchar(60) not null
  , kisairiyu varchar(300) not null
  , irai_detail varchar(450) not null
  , kisaisya varchar(60) not null
  , upd_date varchar(36) not null
  , kakuninsya varchar(30) not null
  , primary key (no)
);