INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_name','会社名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_kana','会社名（カナ）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax01','FAX番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax02','FAX番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax03','FAX番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','business_hour','店舗営業時間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_company','販売業者(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_manager','運営責任者(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip01','郵便番号1(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip02','郵便番号2(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_pref','都道府県(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr01','住所1(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr02','住所2(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel01','電話番号1(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel02','電話番号2(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel03','電話番号3(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax01','FAX番号1(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax02','FAX番号2(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax03','FAX番号3(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_email','メールアドレス(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_url','URL(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term01','商品代金以外の必要料金(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term02','注文方法(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term03','支払方法(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term04','支払期限(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term05','引き渡し時期(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term06','返品・交換について(特定商取引)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term07','予備');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term08','予備');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term09','予備');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term10','予備');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax','消費税');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax_rule','1:四捨五入　2：切捨て　3:切り上げ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email01','受注情報受付メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email02','問い合わせ受付メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email03','送信エラー受付メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email04','メール送信元メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email05','メルマガ送信元メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','free_rule','送料・手数料無料条件(円以上)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_name','店名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_kana','店名(カナ)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','point_rate','ポイント付与率');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','welcome_point','会員登録時付与ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','top_tpl','topのテンプレートファイル番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','product_tpl','商品一覧のテンプレートファイル番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','detail_tpl','商品詳細のテンプレートファイル番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','mypage_tpl','MYページのテンプレートファイル番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','deliv_id','配送業者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','name','配送業者名（ヤマト運輸）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','service_name','名称（クロネコヤマト）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','confirm_url','伝票確認URL');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','status','1:有効 2:無効');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','del_flg','0:既定 1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','creator_id','作成者の管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','配送時間ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','配送時間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee','配送料金');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_id','支払いID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_method','支払い方法');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','charge','手数料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rule','利用条件(円以上)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','deliv_id','指定無しの場合:0(配送業者）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','note','備考');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','fix','固定:1　自由設定:2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','status','1:有効 2:無効');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','del_flg','0:既定 1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_image','支払い方法表示用ロゴ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','upper_rule','利用条件(円以下)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','template_id','テンプレートID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','subject','メールタイトル');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','header','ヘッダー文書');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','footer','フッター文書');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','creator_id','作成した管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','del_flg','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','template_id','テンプレートID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','subject','件名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','charge_image','担当者の写真');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','mail_method','1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','header','ヘッダーテキスト');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','body','本文（テキスト登録用）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_title','メインのタイトル（HTMLメール専用）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_comment','メインのコメント（HTMLメール専用）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_product_id','メインの商品ID（HTMLメール専用）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_title','サブタイトル');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_comment','サブコメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id01','サブ商品ID1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id02','サブ商品ID2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id03','サブ商品ID3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id04','サブ商品ID4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id05','サブ商品ID5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id06','サブ商品ID6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id07','サブ商品ID7');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id08','サブ商品ID8');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id09','サブ商品ID9');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id10','サブ商品ID10');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id11','サブ商品ID11');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id12','サブ商品ID12');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','del_flg','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_id','配信ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','mail_method','1:テキスト 2:HTML');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','subject','メール件名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','body','メール内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_count','送信数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','complete_count','送信完了数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','start_date','送信開始');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','end_date','送信停止');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','search_data','検索条件');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','del_flg','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','customer_id','顧客ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_id','配信履歴ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','email','送信先メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','name','名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_flag','1:送信済み　2:送信失敗');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','name','商品名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_fee','商品送料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sale_limit','購入制限数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sale_unlimited','購入制限（1:購入制限無し)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','category_id','商品カテゴリー');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','rank','表示ランク');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','status','1:表示、2:非表示、3:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_flag','"1:NEW 2:お勧め 3:注目 4:限定"');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','point_rate','ポイント付与率');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment1','コメント1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment2','コメント2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment3','コメント3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment4','コメント4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment5','コメント5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment6','コメント6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file1','アップロードファイル1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file2','アップロードファイル2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file3','アップロードファイル3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file4','アップロードファイル4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file5','アップロードファイル5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file6','アップロードファイル6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_comment','メイン一覧コメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_image','メイン一覧画像');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_comment','メインコメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_image','メイン画像');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_large_image','メイン拡大画像');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title1','サブタイトル1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment1','サブコメント1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image1','サブ通常画像1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image1','サブ拡大画像1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title2','サブタイトル2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment2','サブコメント2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image2','サブ通常画像2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image2','サブ拡大画像2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title3','サブタイトル3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment3','サブコメント3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image3','サブ通常画像3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image3','サブ拡大画像3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title4','サブタイトル4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment4','サブコメント4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image4','サブ通常画像4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image4','サブ拡大画像4');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title5','サブタイトル5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment5','サブコメント5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image5','サブ通常画像5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image5','サブ拡大画像5');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title6','サブタイトル6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment6','サブコメント6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image6','サブ通常画像6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image6','サブ拡大画像6');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','del_flg','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_date_id','発送日目安(conf.php参照)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_class_id','商品規格ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id1','規格分類ID1(規格なしの場合0)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id2','規格分類ID2（規格なしの場合:0)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_code','商品コード');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock','在庫数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock_unlimited','在庫制限（1:無制限)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','sale_limit','販売制限');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price01','価格');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price02','商品価格');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','status','状態（表示:1、非表示:2）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','class_id','規格ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','name','規格名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','status','状態');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','product_id','null：マスタ登録データ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','classcategory_id','規格分類ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','name','規格分類名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','class_id','規格ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','status','状態');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_id','分類ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_name','分類名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','parent_category_id','rootの場合:0');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','level','階層');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','creator_id','作成者の管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_order','購入件数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','member','会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','nonmember','非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men','男性');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women','女性');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_member','男性会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_nonmember','男性非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_member','女性会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_nonmember','女性非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total','購入合計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_average','購入平均');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','order_date','購入日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','create_date','集計日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','year','年');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','month','月');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','day','日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','wday','曜日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_day','日別用キー');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_month','月別用キー');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_year','年別用キー');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_wday','曜日別用キー');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_order','購入件数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','member','会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','nonmember','非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men','男性');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women','女性');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_member','男性会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_nonmember','男性非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_member','女性会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_nonmember','女性非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total','購入合計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_average','購入平均');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','hour','購入時間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','order_date','購入日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','create_date','集計日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','recommend_product_id','リコメンド商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','comment','コメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','status','0:手動登録、1:自動登録');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','review_id','レビューID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_name','投稿者名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_url','投稿者URL');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','sex','男性:1、女性:2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','customer_id','会員ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','recommend_level','おすすめレベル');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','title','題名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','comment','コメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','status','1:表示 2:非表示 3:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','creator_id','作成者の管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','reading_product_id','閲覧商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','customer_id','会員ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','category_id','分類ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','product_count','商品数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','category_id','分類ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','product_count','商品数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_id','新着ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_date','表示日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_comment','コメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_url','URL');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','link_method','1:内部リンク 2:外部リンク（別ウィンドウで）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','best_id','注文ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','category_id','カテゴリID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','rank','順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','title','見出し');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','comment','コメント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','creator_id','作成者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_id','送信ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','order_id','注文ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_date','送信日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','template_id','メールテンプレートID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','creator_id','管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','subject','件名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','mail_body','本文');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','customer_id','顧客ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name01','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name02','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana01','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana02','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email','メール');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email_mobile','携帯メール');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax01','FAX1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax02','FAX2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax03','FAX3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','sex','1:男　2:女');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','job','職業');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','birth','誕生日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','password','パスワード');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder','パスワード質問');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder_answer','パスワード答え');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','secret_key','暗号化顧客ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','first_buy_date','初回購入');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','last_buy_date','最終購入');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_times','購入回数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_total','購入累計金額');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','point','ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','note','SHOPメモ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','status','1:仮登録 2:登録 3:停止 4:非会員');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell01','携帯電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell02','携帯電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell03','携帯電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','email','メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','mail_flag','1:HTML 2:TEXT 3:希望しない 4:仮登録（HTML） 5:仮登録(TEXT) 6:仮登録(希望しない)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','email','メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','mail_flag','1:HTML 2:TEXT 3:希望しない(停止)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','temp_id','一時ＩＤ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','end_flag','0:未処理 1:処理済');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','update_date','更新日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','create_data','作成日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_id','注文ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_temp_id','注文一時ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','customer_id','顧客ID(非会員の場合は、0)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','message','要望等');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name01','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name02','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana01','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana02','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_email','受注時のメールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax01','FAX1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax02','FAX2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax03','FAX3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_sex','性別(1:男性、2:女性)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax01','FAX1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax02','FAX2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax03','FAX3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','subtotal','小計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','discount','値引き');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fee','送料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','charge','手数料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','use_point','使用ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','add_point','加算ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','birth_point','お誕生日ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','tax','税金');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','total','合計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_total','お支払い合計(ポイント差し引き合計)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_id','支払い方法ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','配送時間ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','配送時間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','loan_result','ローン受付結果');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_result','クレジット受付結果');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_msg','クレジット受付メッセージ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','配達日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell02','携帯電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell03','携帯電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_temp_id','注文一時ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','customer_id','顧客ID(非会員の場合は、0)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','message','要望等');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name01','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name02','顧客名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana01','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana02','顧客名カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_email','受注時のメールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax01','FAX1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax02','FAX2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax03','FAX3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_sex','性別(1:男性、2:女性)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax01','FAX1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax02','FAX2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax03','FAX3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','subtotal','小計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','discount','値引き');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fee','送料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','charge','手数料');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','use_point','使用ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','add_point','加算ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','birth_point','お誕生日ポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','tax','税金');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','total','合計');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_total','お支払い合計(ポイント差し引き合計)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_id','支払い方法ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法（文字列）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','配送時間ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','配送時間（文字列）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','mail_flag','メルマガ希望');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_check','1:別のお届け先を指定している場合');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','point_check','1:ポイントを使用する。2:ポイントを使用しない。');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','loan_result','ローン受付結果');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_result','クレジット受付結果');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_msg','クレジット受付メッセージ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','配達日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell02','携帯電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell03','携帯電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','配送先名前');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','配送先カナ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','order_id','注文ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_id','商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id1','規格分類ID1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id2','規格分類ID2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_name','商品名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_code','商品コード');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name1','規格名1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name2','規格名2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','price','価格');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','quantity','個数');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','point_rate','ポイント付与率');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_id','都道府県ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_name','都道府県名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','rank','表示順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','member_id','管理者ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','name','管理者名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','department','部門');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_id','ログインID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','password','パスワード');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','authority','権限');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','rank','順位');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','work','稼働:1、非稼働:2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','del_flg','削除フラグ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','creator_id','作成者');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','update_date','更新日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','create_date','作成日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_date','ログイン日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_id','質問ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_name','質問名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question','質問内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','result_id','結果ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_id','質問ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_date','質問日');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_name','質問名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name01','回答者名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name02','回答者名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana01','回答者名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana02','回答者名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip01','郵便番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip02','郵便番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','pref','都道府県');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr01','住所1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr02','住所2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel01','電話番号1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel02','電話番号2');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel03','電話番号3');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','mail01','メールアドレス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question01','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question02','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question03','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question04','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question05','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question06','回答内容');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','del_flg ','0:既定、1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','product_id','この商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','relate_product_id','こんな商品ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','customer_id','顧客ID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','create_date','集計日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_id','キャンペーンID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_name','キャンペーン名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_rate','キャンペーンポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_type','キャンペーンタイプ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','start_date','キャンペーン開始期間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','end_date','キャンペーン終了期間');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','search_condition','検索条件');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','del_flg','0:既定　1:削除');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_id','キャンペーンID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','product_id','キャンペーン名');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_point_rate','キャンペーンポイント');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_id','ページID 0はプレビュー用データ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_name','ページ名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','url','ページURL PKEY1');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','php_dir','PHPファイル保存先');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','tpl_dir','テンプレートファイル保存先');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','filename','ファイル名（拡張子なし）');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','header_chk','ヘッダー使用チェック　1：使用、2：未使用');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','footer_chk','フッター使用チェック　1：使用、2：未使用');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','edit_flg','削除、ページ名称、URL等を編集可能か否かのFLG　1：編集可、2：編集不可');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','author','メタタグ(SEO管理用)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','description','メタタグ(SEO管理用)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','keyword','メタタグ(SEO管理用)');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_url','このデータに対して更新を行ったページ');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_id','ブロックID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_name','ブロック名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','tpl_path','テンプレートファイルのパス');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','filename','ファイル名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','php_path','include PHPで使用する場合にはphpのパスも保存する');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','page_id','ページID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','target_id','ターゲットID 1：レフトナビ 2：ライトナビ 3：イン画面上部 4：メイン画面下部');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_id','ブロックID');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_row','ブロックIDを配置する順番');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','no','連番');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','csv_id','CSVID　1.商品マスタ、2.顧客マスタ、3.受注');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','col','出力カラム');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','disp_name','出力名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','rank','出力順序');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','status','出力有無 1.出力、2.未出力');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','create_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','update_date','更新日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql_id','SQL番号');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','name','名称');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql','SQL文');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','update_date','作成日時');
INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','create_date','更新日時');