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