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

Revision 19773, 81.1 KB checked in by Seasoft, 12 years ago (diff)

#829(mtb_pref を他の mtb_* と同等のテーブル定義に)

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