source: branches/version-2_5-dev/html/install/sql/column_comment.sql @ 20211

Revision 20211, 80.6 KB checked in by fukuda, 12 years ago (diff)

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