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