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