source: branches/version-2_4/html/install/sql/column_comment.sql @ 17818

Revision 17818, 80.8 KB checked in by kishida, 17 years ago (diff)

商品テーブルの備考欄(SHOP専用)を追加
  • Property svn:mime-type set to application/x-httpd-php; charset=UTF-8
Line 
1INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_name','会社名');
2INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_kana','会社名（カナ）');
3INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip01','郵便番号1');
4INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip02','郵便番号2');
5INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','pref','都道府県');
6INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr01','住所1');
7INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr02','住所2');
8INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel01','電話番号1');
9INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel02','電話番号2');
10INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel03','電話番号3');
11INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax01','FAX番号1');
12INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax02','FAX番号2');
13INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax03','FAX番号3');
14INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','business_hour','店舗営業時間');
15INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_company','販売業者(特定商取引)');
16INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_manager','運営責任者(特定商取引)');
17INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip01','郵便番号1(特定商取引)');
18INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip02','郵便番号2(特定商取引)');
19INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_pref','都道府県(特定商取引)');
20INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr01','住所1(特定商取引)');
21INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr02','住所2(特定商取引)');
22INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel01','電話番号1(特定商取引)');
23INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel02','電話番号2(特定商取引)');
24INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel03','電話番号3(特定商取引)');
25INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax01','FAX番号1(特定商取引)');
26INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax02','FAX番号2(特定商取引)');
27INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax03','FAX番号3(特定商取引)');
28INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_email','メールアドレス(特定商取引)');
29INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_url','URL(特定商取引)');
30INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term01','商品代金以外の必要料金(特定商取引)');
31INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term02','注文方法(特定商取引)');
32INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term03','支払方法(特定商取引)');
33INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term04','支払期限(特定商取引)');
34INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term05','引き渡し時期(特定商取引)');
35INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term06','返品・交換について(特定商取引)');
36INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term07','予備');
37INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term08','予備');
38INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term09','予備');
39INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term10','予備');
40INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax','消費税');
41INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax_rule','1:四捨五入　2：切捨て　3:切り上げ');
42INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email01','受注情報受付メールアドレス');
43INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email02','問い合わせ受付メールアドレス');
44INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email03','送信エラー受付メールアドレス');
45INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email04','メール送信元メールアドレス');
46INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email05','メルマガ送信元メールアドレス');
47INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','free_rule','送料・手数料無料条件(円以上)');
48INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_name','店名');
49INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_kana','店名(カナ)');
50INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','point_rate','ポイント付与率');
51INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','welcome_point','会員登録時付与ポイント');
52INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','update_date','更新日時');
53INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','top_tpl','topのテンプレートファイル番号');
54INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','product_tpl','商品一覧のテンプレートファイル番号');
55INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','detail_tpl','商品詳細のテンプレートファイル番号');
56INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','mypage_tpl','MYページのテンプレートファイル番号');
57INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','deliv_id','配送業者ID');
58INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','name','配送業者名（ヤマト運輸）');
59INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','service_name','名称（クロネコヤマト）');
60INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','confirm_url','伝票確認URL');
61INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','rank','表示順位');
62INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','status','1:有効 2:無効');
63INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','del_flg','0:既定 1:削除');
64INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','creator_id','作成者の管理者ID');
65INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','create_date','作成日時');
66INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時');
67INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID');
68INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','配送時間ID');
69INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','配送時間');
70INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID');
71INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID');
72INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee','配送料金');
73INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_id','支払いID');
74INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_method','支払い方法');
75INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','charge','手数料');
76INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rule','利用条件(円以上)');
77INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','deliv_id','指定無しの場合:0(配送業者）');
78INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rank','表示順位');
79INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','note','備考');
80INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','fix','固定:1　自由設定:2');
81INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','status','1:有効 2:無効');
82INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','del_flg','0:既定 1:削除');
83INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','creator_id','作成者ID');
84INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','create_date','作成日時');
85INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','update_date','更新日時');
86INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_image','支払い方法表示用ロゴ');
87INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','upper_rule','利用条件(円以下)');
88INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','template_id','テンプレートID');
89INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','subject','メールタイトル');
90INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','header','ヘッダー文書');
91INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','footer','フッター文書');
92INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','creator_id','作成した管理者ID');
93INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','del_flg','0:既定、1:削除');
94INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','create_date','作成日時');
95INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','update_date','更新日時');
96INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','template_id','テンプレートID');
97INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','subject','件名');
98INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','charge_image','担当者の写真');
99INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','mail_method','1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE');
100INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','header','ヘッダーテキスト');
101INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','body','本文（テキスト登録用）');
102INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_title','メインのタイトル（HTMLメール専用）');
103INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_comment','メインのコメント（HTMLメール専用）');
104INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_product_id','メインの商品ID（HTMLメール専用）');
105INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_title','サブタイトル');
106INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_comment','サブコメント');
107INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id01','サブ商品ID1');
108INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id02','サブ商品ID2');
109INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id03','サブ商品ID3');
110INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id04','サブ商品ID4');
111INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id05','サブ商品ID5');
112INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id06','サブ商品ID6');
113INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id07','サブ商品ID7');
114INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id08','サブ商品ID8');
115INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id09','サブ商品ID9');
116INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id10','サブ商品ID10');
117INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id11','サブ商品ID11');
118INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id12','サブ商品ID12');
119INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','del_flg','0:既定、1:削除');
120INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','creator_id','作成者ID');
121INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','create_date','作成日時');
122INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','update_date','更新日時');
123INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_id','配信ID');
124INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','mail_method','1:テキスト 2:HTML');
125INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','subject','メール件名');
126INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','body','メール内容');
127INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_count','送信数');
128INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','complete_count','送信完了数');
129INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','start_date','送信開始');
130INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','end_date','送信停止');
131INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','search_data','検索条件');
132INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','del_flg','0:既定、1:削除');
133INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','creator_id','作成者ID');
134INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','create_date','作成日時');
135INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','update_date','更新日時');
136INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','customer_id','顧客ID');
137INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_id','配信履歴ID');
138INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','email','送信先メールアドレス');
139INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','name','名前');
140INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_flag','1:送信済み　2:送信失敗');
141INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_id','商品ID');
142INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','name','商品名');
143INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_fee','商品送料');
144INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sale_limit','購入制限数');
145INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sale_unlimited','購入制限（1:購入制限無し)');
146INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','category_id','商品カテゴリー');
147INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','rank','表示ランク');
148INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','status','1:表示、2:非表示、3:削除');
149INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_flag','"1:NEW 2:お勧め 3:注目 4:限定"');
150INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','point_rate','ポイント付与率');
151INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment1','コメント1');
152INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment2','コメント2');
153INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment3','コメント3');
154INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment4','コメント4');
155INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment5','コメント5');
156INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment6','コメント6');
157INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','note','備考欄(SHOP専用)');
158INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file1','アップロードファイル1');
159INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file2','アップロードファイル2');
160INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file3','アップロードファイル3');
161INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file4','アップロードファイル4');
162INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file5','アップロードファイル5');
163INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file6','アップロードファイル6');
164INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_comment','メイン一覧コメント');
165INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_image','メイン一覧画像');
166INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_comment','メインコメント');
167INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_image','メイン画像');
168INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_large_image','メイン拡大画像');
169INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title1','サブタイトル1');
170INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment1','サブコメント1');
171INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image1','サブ通常画像1');
172INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image1','サブ拡大画像1');
173INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title2','サブタイトル2');
174INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment2','サブコメント2');
175INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image2','サブ通常画像2');
176INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image2','サブ拡大画像2');
177INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title3','サブタイトル3');
178INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment3','サブコメント3');
179INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image3','サブ通常画像3');
180INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image3','サブ拡大画像3');
181INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title4','サブタイトル4');
182INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment4','サブコメント4');
183INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image4','サブ通常画像4');
184INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image4','サブ拡大画像4');
185INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title5','サブタイトル5');
186INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment5','サブコメント5');
187INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image5','サブ通常画像5');
188INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image5','サブ拡大画像5');
189INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title6','サブタイトル6');
190INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment6','サブコメント6');
191INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image6','サブ通常画像6');
192INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image6','サブ拡大画像6');
193INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','del_flg','0:既定、1:削除');
194INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','creator_id','作成者ID');
195INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','create_date','作成日時');
196INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','update_date','更新日時');
197INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_date_id','発送日目安(conf.php参照)');
198INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_class_id','商品規格ID');
199INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_id','商品ID');
200INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id1','規格分類ID1(規格なしの場合0)');
201INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id2','規格分類ID2（規格なしの場合:0)');
202INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_code','商品コード');
203INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock','在庫数');
204INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock_unlimited','在庫制限（1:無制限)');
205INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','sale_limit','販売制限');
206INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price01','価格');
207INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price02','商品価格');
208INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','status','状態（表示:1、非表示:2）');
209INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','creator_id','作成者ID');
210INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','create_date','作成日時');
211INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','update_date','更新日時');
212INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','class_id','規格ID');
213INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','name','規格名');
214INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','status','状態');
215INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','rank','表示順位');
216INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','creator_id','作成者ID');
217INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','create_date','作成日時');
218INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','update_date','更新日時');
219INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','del_flg ','0:既定、1:削除');
220INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','product_id','null：マスタ登録データ');
221INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','classcategory_id','規格分類ID');
222INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','name','規格分類名');
223INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','class_id','規格ID');
224INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','status','状態');
225INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','rank','表示順位');
226INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','creator_id','作成者ID');
227INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','create_date','作成日時');
228INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','update_date','更新日時');
229INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','del_flg ','0:既定、1:削除');
230INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_id','分類ID');
231INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_name','分類名');
232INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','parent_category_id','rootの場合:0');
233INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','level','階層');
234INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','rank','表示順位');
235INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','creator_id','作成者の管理者ID');
236INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','create_date','作成日時');
237INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','update_date','更新日時');
238INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','del_flg ','0:既定、1:削除');
239INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_order','購入件数');
240INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','member','会員');
241INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','nonmember','非会員');
242INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men','男性');
243INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women','女性');
244INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_member','男性会員');
245INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_nonmember','男性非会員');
246INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_member','女性会員');
247INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_nonmember','女性非会員');
248INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total','購入合計');
249INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_average','購入平均');
250INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','order_date','購入日');
251INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','create_date','集計日');
252INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','year','年');
253INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','month','月');
254INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','day','日');
255INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','wday','曜日');
256INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_day','日別用キー');
257INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_month','月別用キー');
258INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_year','年別用キー');
259INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_wday','曜日別用キー');
260INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_order','購入件数');
261INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','member','会員');
262INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','nonmember','非会員');
263INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men','男性');
264INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women','女性');
265INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_member','男性会員');
266INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_nonmember','男性非会員');
267INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_member','女性会員');
268INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_nonmember','女性非会員');
269INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total','購入合計');
270INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_average','購入平均');
271INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','hour','購入時間');
272INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','order_date','購入日');
273INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','create_date','集計日');
274INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','product_id','商品ID');
275INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','recommend_product_id','リコメンド商品ID');
276INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','rank','表示順位');
277INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','comment','コメント');
278INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','status','0:手動登録、1:自動登録');
279INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','creator_id','作成者ID');
280INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','create_date','作成日時');
281INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','update_date','更新日時');
282INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','review_id','レビューID');
283INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','product_id','商品ID');
284INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_name','投稿者名');
285INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_url','投稿者URL');
286INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','sex','男性:1、女性:2');
287INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','customer_id','会員ID');
288INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','recommend_level','おすすめレベル');
289INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','title','題名');
290INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','comment','コメント');
291INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','status','1:表示 2:非表示 3:削除');
292INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','creator_id','作成者の管理者ID');
293INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','create_date','作成日時');
294INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','update_date','更新日時');
295INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','del_flg ','0:既定、1:削除');
296INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','reading_product_id','閲覧商品ID');
297INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','customer_id','会員ID');
298INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','create_date','作成日時');
299INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','update_date','更新日時');
300INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','category_id','分類ID');
301INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','product_count','商品数');
302INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','create_date','作成日時');
303INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','category_id','分類ID');
304INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','product_count','商品数');
305INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','create_date','作成日時');
306INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_id','新着ID');
307INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_date','表示日');
308INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','rank','表示順位');
309INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_comment','コメント');
310INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_url','URL');
311INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','link_method','1:内部リンク 2:外部リンク（別ウィンドウで）');
312INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','creator_id','作成者ID');
313INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','create_date','作成日時');
314INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','update_date','更新日時');
315INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','del_flg ','0:既定、1:削除');
316INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','best_id','注文ID');
317INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','category_id','カテゴリID');
318INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','rank','順位');
319INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','product_id','商品ID');
320INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','title','見出し');
321INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','comment','コメント');
322INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','creator_id','作成者ID');
323INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','create_date','作成日時');
324INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','update_date','更新日時');
325INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','del_flg ','0:既定、1:削除');
326INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_id','送信ID');
327INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','order_id','注文ID');
328INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_date','送信日時');
329INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','template_id','メールテンプレートID');
330INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','creator_id','管理者ID');
331INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','subject','件名');
332INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','mail_body','本文');
333INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','customer_id','顧客ID');
334INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name01','顧客名');
335INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name02','顧客名');
336INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana01','顧客名カナ');
337INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana02','顧客名カナ');
338INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip01','郵便番号1');
339INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip02','郵便番号2');
340INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','pref','都道府県');
341INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr01','住所1');
342INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr02','住所2');
343INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email','メール');
344INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email_mobile','携帯メール');
345INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel01','電話番号1');
346INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel02','電話番号2');
347INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel03','電話番号3');
348INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax01','FAX1');
349INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax02','FAX2');
350INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax03','FAX3');
351INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','sex','1:男　2:女');
352INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','job','職業');
353INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','birth','誕生日');
354INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','password','パスワード');
355INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder','パスワード質問');
356INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder_answer','パスワード答え');
357INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','secret_key','暗号化顧客ID');
358INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','first_buy_date','初回購入');
359INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','last_buy_date','最終購入');
360INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_times','購入回数');
361INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_total','購入累計金額');
362INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','point','ポイント');
363INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','note','SHOPメモ');
364INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','status','1:仮登録 2:登録 3:停止 4:非会員');
365INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','create_date','作成日時');
366INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','update_date','更新日時');
367INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','del_flg ','0:既定、1:削除');
368INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell01','携帯電話番号1');
369INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell02','携帯電話番号2');
370INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell03','携帯電話番号3');
371INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','mobile_phone_id','携帯端末ID');
372INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','email','メールアドレス');
373INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','mail_flag','1:HTML 2:TEXT 3:希望しない(停止)');
374INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','temp_id','一時ＩＤ');
375INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','end_flag','0:未処理 1:処理済');
376INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','update_date','更新日');
377INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','create_data','作成日');
378INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_id','注文ID');
379INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_temp_id','注文一時ID');
380INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','customer_id','顧客ID(非会員の場合は、0)');
381INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','message','要望等');
382INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name01','顧客名');
383INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name02','顧客名');
384INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana01','顧客名カナ');
385INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana02','顧客名カナ');
386INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_email','受注時のメールアドレス');
387INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel01','電話番号1');
388INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel02','電話番号2');
389INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel03','電話番号3');
390INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax01','FAX1');
391INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax02','FAX2');
392INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax03','FAX3');
393INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip01','郵便番号1');
394INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip02','郵便番号2');
395INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_pref','都道府県');
396INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr01','住所1');
397INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr02','住所2');
398INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_sex','性別(1:男性、2:女性)');
399INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日');
400INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種');
401INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','配送先名前');
402INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','配送先名前');
403INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','配送先カナ');
404INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','配送先カナ');
405INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1');
406INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2');
407INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel03','電話番号3');
408INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax01','FAX1');
409INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax02','FAX2');
410INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax03','FAX3');
411INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip01','郵便番号1');
412INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip02','郵便番号2');
413INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_pref','都道府県');
414INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr01','住所1');
415INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr02','住所2');
416INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','subtotal','小計');
417INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','discount','値引き');
418INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fee','送料');
419INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','charge','手数料');
420INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','use_point','使用ポイント');
421INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','add_point','加算ポイント');
422INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','birth_point','お誕生日ポイント');
423INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','tax','税金');
424INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','total','合計');
425INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_total','お支払い合計(ポイント差し引き合計)');
426INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_id','支払い方法ID');
427INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法');
428INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID');
429INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','配送時間ID');
430INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','配送時間');
431INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号');
432INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ');
433INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
434INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','create_date','作成日時');
435INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','loan_result','ローン受付結果');
436INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_result','クレジット受付結果');
437INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_msg','クレジット受付メッセージ');
438INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','update_date','更新日時');
439INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日');
440INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除');
441INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','配達日');
442INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報');
443INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1');
444INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell02','携帯電話番号2');
445INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell03','携帯電話番号3');
446INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_temp_id','注文一時ID');
447INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','customer_id','顧客ID(非会員の場合は、0)');
448INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','message','要望等');
449INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name01','顧客名');
450INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name02','顧客名');
451INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana01','顧客名カナ');
452INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana02','顧客名カナ');
453INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_email','受注時のメールアドレス');
454INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel01','電話番号1');
455INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel02','電話番号2');
456INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel03','電話番号3');
457INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax01','FAX1');
458INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax02','FAX2');
459INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax03','FAX3');
460INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip01','郵便番号1');
461INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip02','郵便番号2');
462INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_pref','都道府県');
463INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr01','住所1');
464INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr02','住所2');
465INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_sex','性別(1:男性、2:女性)');
466INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日');
467INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種');
468INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','配送先名前');
469INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','配送先名前');
470INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','配送先カナ');
471INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','配送先カナ');
472INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1');
473INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2');
474INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel03','電話番号3');
475INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax01','FAX1');
476INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax02','FAX2');
477INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax03','FAX3');
478INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip01','郵便番号1');
479INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip02','郵便番号2');
480INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_pref','都道府県');
481INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr01','住所1');
482INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr02','住所2');
483INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','subtotal','小計');
484INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','discount','値引き');
485INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fee','送料');
486INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','charge','手数料');
487INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','use_point','使用ポイント');
488INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','add_point','加算ポイント');
489INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','birth_point','お誕生日ポイント');
490INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','tax','税金');
491INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','total','合計');
492INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_total','お支払い合計(ポイント差し引き合計)');
493INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_id','支払い方法ID');
494INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法（文字列）');
495INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID');
496INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','配送時間ID');
497INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','配送時間（文字列）');
498INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号');
499INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ');
500INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','mail_flag','メルマガ希望');
501INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
502INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_check','1:別のお届け先を指定している場合');
503INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','point_check','1:ポイントを使用する。2:ポイントを使用しない。');
504INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','loan_result','ローン受付結果');
505INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_result','クレジット受付結果');
506INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_msg','クレジット受付メッセージ');
507INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','create_date','作成日時');
508INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時');
509INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除');
510INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','配達日');
511INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報');
512INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1');
513INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell02','携帯電話番号2');
514INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell03','携帯電話番号3');
515INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID');
516INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID');
517INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','配送先名前');
518INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','配送先名前');
519INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','配送先カナ');
520INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','配送先カナ');
521INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1');
522INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2');
523INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','pref','都道府県');
524INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr01','住所1');
525INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr02','住所2');
526INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel01','電話番号1');
527INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel02','電話番号2');
528INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel03','電話番号3');
529INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','order_id','注文ID');
530INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_id','商品ID');
531INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id1','規格分類ID1');
532INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id2','規格分類ID2');
533INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_name','商品名');
534INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_code','商品コード');
535INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name1','規格名1');
536INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name2','規格名2');
537INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','price','価格');
538INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','quantity','個数');
539INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','point_rate','ポイント付与率');
540INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_id','都道府県ID');
541INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_name','都道府県名');
542INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','rank','表示順位');
543INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','member_id','管理者ID');
544INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','name','管理者名称');
545INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','department','部門');
546INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_id','ログインID');
547INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','password','パスワード');
548INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','authority','権限');
549INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','rank','順位');
550INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','work','稼働:1、非稼働:2');
551INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','del_flg','削除フラグ');
552INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','creator_id','作成者');
553INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','update_date','更新日');
554INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','create_date','作成日');
555INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_date','ログイン日');
556INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_id','質問ID');
557INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question_name','質問名');
558INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','question','質問内容');
559INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','create_date','作成日時');
560INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question','del_flg ','0:既定、1:削除');
561INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','result_id','結果ID');
562INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_id','質問ID');
563INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_date','質問日');
564INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question_name','質問名');
565INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name01','回答者名');
566INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','name02','回答者名');
567INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana01','回答者名');
568INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','kana02','回答者名');
569INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip01','郵便番号1');
570INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','zip02','郵便番号2');
571INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','pref','都道府県');
572INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr01','住所1');
573INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','addr02','住所2');
574INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel01','電話番号1');
575INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel02','電話番号2');
576INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','tel03','電話番号3');
577INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','mail01','メールアドレス');
578INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question01','回答内容');
579INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question02','回答内容');
580INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question03','回答内容');
581INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question04','回答内容');
582INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question05','回答内容');
583INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','question06','回答内容');
584INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','create_date','作成日時');
585INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_question_result','del_flg ','0:既定、1:削除');
586INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','product_id','この商品ID');
587INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','relate_product_id','こんな商品ID');
588INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','customer_id','顧客ID');
589INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','create_date','集計日時');
590INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_id','キャンペーンID');
591INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_name','キャンペーン名');
592INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_rate','キャンペーンポイント');
593INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','campaign_point_type','キャンペーンタイプ');
594INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','start_date','キャンペーン開始期間');
595INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','end_date','キャンペーン終了期間');
596INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','search_condition','検索条件');
597INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','del_flg','0:既定　1:削除');
598INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','create_date','作成日時');
599INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign','update_date','更新日時');
600INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_id','キャンペーンID');
601INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','product_id','キャンペーン名');
602INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_campaign_detail','campaign_point_rate','キャンペーンポイント');
603INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_id','ページID 0はプレビュー用データ');
604INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_name','ページ名称');
605INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','url','ページURL PKEY1');
606INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','php_dir','PHPファイル保存先');
607INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','tpl_dir','テンプレートファイル保存先');
608INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','filename','ファイル名（拡張子なし）');
609INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','header_chk','ヘッダー使用チェック　1：使用、2：未使用');
610INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','footer_chk','フッター使用チェック　1：使用、2：未使用');
611INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','edit_flg','削除、ページ名称、URL等を編集可能か否かのFLG　1：編集可、2：編集不可');
612INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','author','メタタグ(SEO管理用)');
613INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','description','メタタグ(SEO管理用)');
614INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','keyword','メタタグ(SEO管理用)');
615INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_url','このデータに対して更新を行ったページ');
616INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','create_date','作成日時');
617INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_date','更新日時');
618INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_id','ブロックID');
619INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_name','ブロック名称');
620INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','tpl_path','テンプレートファイルのパス');
621INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','filename','ファイル名称');
622INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','create_date','作成日時');
623INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','update_date','更新日時');
624INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','php_path','include PHPで使用する場合にはphpのパスも保存する');
625INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','page_id','ページID');
626INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','target_id','ターゲットID 1：レフトナビ 2：ライトナビ 3：イン画面上部 4：メイン画面下部');
627INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_id','ブロックID');
628INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_row','ブロックIDを配置する順番');
629INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','no','連番');
630INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','csv_id','CSVID　1.商品マスタ、2.顧客マスタ、3.受注');
631INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','col','出力カラム');
632INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','disp_name','出力名称');
633INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','rank','出力順序');
634INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','status','出力有無 1.出力、2.未出力');
635INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','create_date','作成日時');
636INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','update_date','更新日時');
637INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql_id','SQL番号');
638INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','name','名称');
639INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql','SQL文');
640INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','update_date','作成日時');
641INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','create_date','更新日時');
642INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_ext_session_id', 'セッションID管理');
643INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'session_id', 'セッションID');
644INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_key', 'パラメータ名');
645INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_value', 'パラメータ値');
646INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'url', 'URL');
647INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'create_date', '作成日時');
648INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_kara_mail', '空メール管理');
649INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'kara_mail_id', '空メール管理ID');
650INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'session_id', 'セッションID');
651INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'token', 'トークン');
652INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'next_url', '次ページURL');
653INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'create_date', '作成日時');
654INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'email', 'メールアドレス');
655INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'receive_date', '受信日時');
Note: See TracBrowser for help on using the repository browser.