source: branches/version-2_13-dev/html/install/sql/comment_set_pgsql_2.13.sql @ 23359

Revision 23359, 60.0 KB checked in by habu, 7 years ago (diff)

#2200 テーブル定義書の2.13対応

Line 
1COMMENT ON TABLE dtb_csv IS 'CSV情報';
2COMMENT ON COLUMN dtb_csv.no IS '番号';
3COMMENT ON COLUMN dtb_csv.csv_id IS 'CSVマスタ種別ID';
4COMMENT ON COLUMN dtb_csv.col IS 'カラム名';
5COMMENT ON COLUMN dtb_csv.disp_name IS '表示名';
6COMMENT ON COLUMN dtb_csv.rank IS '表示順';
7COMMENT ON COLUMN dtb_csv.status IS '状態';
8COMMENT ON COLUMN dtb_csv.create_date IS '作成日時';
9COMMENT ON COLUMN dtb_csv.update_date IS '更新日時';
10COMMENT ON COLUMN dtb_csv.mb_convert_kana_option IS 'mb_convert_kana オプション';
11COMMENT ON COLUMN dtb_csv.size_const_type IS '文字長タイプ';
12COMMENT ON COLUMN dtb_csv.error_check_types IS 'エラーチェックタイプ';
13COMMENT ON COLUMN dtb_csv.rw_flg IS '読み書きフラグ';
14
15COMMENT ON TABLE dtb_csv_sql IS 'CSV詳細設定SQL情報';
16COMMENT ON COLUMN dtb_csv_sql.sql_id IS 'SQLID';
17COMMENT ON COLUMN dtb_csv_sql.sql_name IS 'SQL名';
18COMMENT ON COLUMN dtb_csv_sql.csv_sql IS 'SQL詳細';
19COMMENT ON COLUMN dtb_csv_sql.update_date IS '更新日時';
20COMMENT ON COLUMN dtb_csv_sql.create_date IS '作成日時';
21
22COMMENT ON TABLE mtb_recommend IS 'おすすめレベル';
23COMMENT ON COLUMN mtb_recommend.id IS 'ID';
24COMMENT ON COLUMN mtb_recommend.name IS '名称';
25COMMENT ON COLUMN mtb_recommend.rank IS '表示順';
26
27COMMENT ON TABLE dtb_best_products IS 'おすすめ商品情報';
28COMMENT ON COLUMN dtb_best_products.best_id IS 'ベスト商品ID';
29COMMENT ON COLUMN dtb_best_products.category_id IS 'カテゴリID';
30COMMENT ON COLUMN dtb_best_products.product_id IS '商品ID';
31COMMENT ON COLUMN dtb_best_products.rank IS '表示順';
32COMMENT ON COLUMN dtb_best_products.title IS 'タイトル';
33COMMENT ON COLUMN dtb_best_products.comment IS 'コメント';
34COMMENT ON COLUMN dtb_best_products.creator_id IS '作成者ID';
35COMMENT ON COLUMN dtb_best_products.create_date IS '作成日時';
36COMMENT ON COLUMN dtb_best_products.update_date IS '更新日時';
37COMMENT ON COLUMN dtb_best_products.del_flg IS '削除フラグ';
38
39COMMENT ON TABLE dtb_customer_favorite_products IS 'お気に入り商品情報';
40COMMENT ON COLUMN dtb_customer_favorite_products.product_id IS '商品ID';
41COMMENT ON COLUMN dtb_customer_favorite_products.customer_id IS '顧客ID';
42COMMENT ON COLUMN dtb_customer_favorite_products.create_date IS '作成日時';
43COMMENT ON COLUMN dtb_customer_favorite_products.update_date IS '更新日時';
44
45COMMENT ON TABLE dtb_other_deliv IS 'その他の配送先情報';
46COMMENT ON COLUMN dtb_other_deliv.other_deliv_id IS 'その他の配送先ID';
47COMMENT ON COLUMN dtb_other_deliv.customer_id IS '顧客ID';
48COMMENT ON COLUMN dtb_other_deliv.name01 IS '姓';
49COMMENT ON COLUMN dtb_other_deliv.name02 IS '名';
50COMMENT ON COLUMN dtb_other_deliv.kana01 IS '姓(カナ)';
51COMMENT ON COLUMN dtb_other_deliv.kana02 IS '名(カナ)';
52COMMENT ON COLUMN dtb_other_deliv.company_name IS '【2.13】会社名';
53COMMENT ON COLUMN dtb_other_deliv.zip01 IS '郵便番号(4桁)';
54COMMENT ON COLUMN dtb_other_deliv.zip02 IS '郵便番号(3桁)';
55COMMENT ON COLUMN dtb_other_deliv.zipcode IS '【2.13】郵便番号(海外対応)';
56COMMENT ON COLUMN dtb_other_deliv.country_id IS '【2.13】国ID';
57COMMENT ON COLUMN dtb_other_deliv.pref IS '都道府県';
58COMMENT ON COLUMN dtb_other_deliv.addr01 IS '市区町村';
59COMMENT ON COLUMN dtb_other_deliv.addr02 IS '番地等';
60COMMENT ON COLUMN dtb_other_deliv.tel01 IS '電話(市外局番)';
61COMMENT ON COLUMN dtb_other_deliv.tel02 IS '電話(市内局番)';
62COMMENT ON COLUMN dtb_other_deliv.tel03 IS '電話(局番)';
63COMMENT ON COLUMN dtb_other_deliv.fax01 IS 'FAX(市外局番)';
64COMMENT ON COLUMN dtb_other_deliv.fax02 IS 'FAX(市内局番)';
65COMMENT ON COLUMN dtb_other_deliv.fax03 IS 'FAX(局番)';
66
67COMMENT ON TABLE mtb_ownersstore_ips IS 'オーナーズストアIPアドレス';
68COMMENT ON COLUMN mtb_ownersstore_ips.id IS 'ID';
69COMMENT ON COLUMN mtb_ownersstore_ips.name IS '名称';
70COMMENT ON COLUMN mtb_ownersstore_ips.rank IS '表示順';
71
72COMMENT ON TABLE mtb_ownersstore_err IS 'オーナーズストアエラー種別';
73COMMENT ON COLUMN mtb_ownersstore_err.id IS 'ID';
74COMMENT ON COLUMN mtb_ownersstore_err.name IS '名称';
75COMMENT ON COLUMN mtb_ownersstore_err.rank IS '表示順';
76
77COMMENT ON TABLE dtb_ownersstore_settings IS 'オーナーズストア設定';
78COMMENT ON COLUMN dtb_ownersstore_settings.public_key IS '認証キー';
79
80COMMENT ON TABLE dtb_category_total_count IS 'カテゴリ商品合計数情報';
81COMMENT ON COLUMN dtb_category_total_count.category_id IS 'カテゴリID';
82COMMENT ON COLUMN dtb_category_total_count.product_count IS '商品合計数';
83COMMENT ON COLUMN dtb_category_total_count.create_date IS '作成日時';
84
85COMMENT ON TABLE dtb_category_count IS 'カテゴリ商品数情報';
86COMMENT ON COLUMN dtb_category_count.category_id IS 'カテゴリID';
87COMMENT ON COLUMN dtb_category_count.product_count IS '商品数';
88COMMENT ON COLUMN dtb_category_count.create_date IS '作成日時';
89
90COMMENT ON TABLE dtb_category IS 'カテゴリ情報';
91COMMENT ON COLUMN dtb_category.category_id IS 'カテゴリID';
92COMMENT ON COLUMN dtb_category.category_name IS 'カテゴリ名';
93COMMENT ON COLUMN dtb_category.parent_category_id IS '親カテゴリID';
94COMMENT ON COLUMN dtb_category.level IS '階層';
95COMMENT ON COLUMN dtb_category.rank IS '表示順';
96COMMENT ON COLUMN dtb_category.creator_id IS '作成者ID';
97COMMENT ON COLUMN dtb_category.create_date IS '作成日時';
98COMMENT ON COLUMN dtb_category.update_date IS '更新日時';
99COMMENT ON COLUMN dtb_category.del_flg IS '削除フラグ';
100
101COMMENT ON TABLE mtb_status_image IS 'ステータス画像';
102COMMENT ON COLUMN mtb_status_image.id IS 'ID';
103COMMENT ON COLUMN mtb_status_image.name IS '名称';
104COMMENT ON COLUMN mtb_status_image.rank IS '表示順';
105
106COMMENT ON TABLE dtb_session IS 'セッション情報';
107COMMENT ON COLUMN dtb_session.sess_id IS 'セッションID';
108COMMENT ON COLUMN dtb_session.sess_data IS 'セッションデータ';
109COMMENT ON COLUMN dtb_session.create_date IS '作成日時';
110COMMENT ON COLUMN dtb_session.update_date IS '更新日時';
111
112COMMENT ON TABLE dtb_templates IS 'テンプレート情報';
113COMMENT ON COLUMN dtb_templates.template_code IS 'テンプレートコード';
114COMMENT ON COLUMN dtb_templates.template_name IS 'テンプレート名';
115COMMENT ON COLUMN dtb_templates.create_date IS '作成日時';
116COMMENT ON COLUMN dtb_templates.update_date IS '更新日時';
117COMMENT ON COLUMN dtb_templates.device_type_id IS '端末種別ID';
118
119COMMENT ON TABLE mtb_db IS 'データベース種別';
120COMMENT ON COLUMN mtb_db.id IS 'ID';
121COMMENT ON COLUMN mtb_db.name IS '名称';
122COMMENT ON COLUMN mtb_db.rank IS '表示順';
123
124COMMENT ON TABLE mtb_reminder IS 'パスワード質問マスタ';
125COMMENT ON COLUMN mtb_reminder.id IS 'ID';
126COMMENT ON COLUMN mtb_reminder.name IS '名称';
127COMMENT ON COLUMN mtb_reminder.rank IS '表示順';
128
129COMMENT ON TABLE mtb_target IS 'ブロックターゲット';
130COMMENT ON COLUMN mtb_target.id IS 'ID';
131COMMENT ON COLUMN mtb_target.name IS '名称';
132COMMENT ON COLUMN mtb_target.rank IS '表示順';
133
134COMMENT ON TABLE dtb_bloc IS 'ブロック情報';
135COMMENT ON COLUMN dtb_bloc.device_type_id IS '端末種別ID';
136COMMENT ON COLUMN dtb_bloc.bloc_id IS 'ブロックID';
137COMMENT ON COLUMN dtb_bloc.bloc_name IS 'ブロック名';
138COMMENT ON COLUMN dtb_bloc.tpl_path IS 'Smartyテンプレートパス';
139COMMENT ON COLUMN dtb_bloc.filename IS 'ファイル名';
140COMMENT ON COLUMN dtb_bloc.create_date IS '作成日時';
141COMMENT ON COLUMN dtb_bloc.update_date IS '更新日時';
142COMMENT ON COLUMN dtb_bloc.php_path IS 'PHPパス';
143COMMENT ON COLUMN dtb_bloc.deletable_flg IS '削除可能フラグ';
144COMMENT ON COLUMN dtb_bloc.plugin_id IS 'プラグインID';
145
146COMMENT ON TABLE dtb_blocposition IS 'ブロック配置情報';
147COMMENT ON COLUMN dtb_blocposition.device_type_id IS '端末種別ID';
148COMMENT ON COLUMN dtb_blocposition.page_id IS 'ページID';
149COMMENT ON COLUMN dtb_blocposition.target_id IS '配置ID';
150COMMENT ON COLUMN dtb_blocposition.bloc_id IS 'ブロックID';
151COMMENT ON COLUMN dtb_blocposition.bloc_row IS 'ブロック配置順序';
152COMMENT ON COLUMN dtb_blocposition.anywhere IS '全ページに配置するフラグ';
153
154COMMENT ON TABLE dtb_plugin IS 'プラグイン情報';
155COMMENT ON COLUMN dtb_plugin.plugin_id IS 'プラグインID';
156COMMENT ON COLUMN dtb_plugin.plugin_name IS 'プラグイン名';
157COMMENT ON COLUMN dtb_plugin.plugin_code IS 'プラグインコード';
158COMMENT ON COLUMN dtb_plugin.author IS '作成者';
159COMMENT ON COLUMN dtb_plugin.plugin_site_url IS 'サイトURL';
160COMMENT ON COLUMN dtb_plugin.plugin_version IS 'バージョン';
161COMMENT ON COLUMN dtb_plugin.plugin_description IS '詳細説明';
162COMMENT ON COLUMN dtb_plugin.class_name IS 'クラス名';
163COMMENT ON COLUMN dtb_plugin.enable IS '有効';
164COMMENT ON COLUMN dtb_plugin.create_date IS '作成日時';
165COMMENT ON COLUMN dtb_plugin.update_date IS '更新日時';
166COMMENT ON COLUMN dtb_plugin.author_site_url IS '作成者サイトURL';
167COMMENT ON COLUMN dtb_plugin.compliant_version IS '本体対応バージョン';
168COMMENT ON COLUMN dtb_plugin.priority IS '優先度';
169COMMENT ON COLUMN dtb_plugin.free_field1 IS '任意項目1';
170COMMENT ON COLUMN dtb_plugin.free_field2 IS '任意項目2';
171COMMENT ON COLUMN dtb_plugin.free_field3 IS '任意項目3';
172COMMENT ON COLUMN dtb_plugin.free_field4 IS '任意項目4';
173
174COMMENT ON TABLE dtb_pagelayout IS 'ページレイアウト情報';
175COMMENT ON COLUMN dtb_pagelayout.device_type_id IS '端末種別ID';
176COMMENT ON COLUMN dtb_pagelayout.page_id IS 'ページID';
177COMMENT ON COLUMN dtb_pagelayout.page_name IS 'ページ名';
178COMMENT ON COLUMN dtb_pagelayout.url IS 'ページURL';
179COMMENT ON COLUMN dtb_pagelayout.filename IS 'ファイル名';
180COMMENT ON COLUMN dtb_pagelayout.header_chk IS 'ヘッダチェックフラグ';
181COMMENT ON COLUMN dtb_pagelayout.footer_chk IS 'フッタチェックフラグ';
182COMMENT ON COLUMN dtb_pagelayout.edit_flg IS '修正フラグ';
183COMMENT ON COLUMN dtb_pagelayout.author IS 'meta タグ(Author)';
184COMMENT ON COLUMN dtb_pagelayout.description IS 'meta タグ(Description)';
185COMMENT ON COLUMN dtb_pagelayout.keyword IS 'meta タグ(keyword)';
186COMMENT ON COLUMN dtb_pagelayout.meta_robots IS '【2.13】meta タグ(robots)';
187COMMENT ON COLUMN dtb_pagelayout.update_url IS '更新実施URL';
188COMMENT ON COLUMN dtb_pagelayout.create_date IS '作成日時';
189COMMENT ON COLUMN dtb_pagelayout.update_date IS '更新日時';
190
191COMMENT ON TABLE mtb_page_max IS 'ページ最大表示数';
192COMMENT ON COLUMN mtb_page_max.id IS 'ID';
193COMMENT ON COLUMN mtb_page_max.name IS '名称';
194COMMENT ON COLUMN mtb_page_max.rank IS '表示順';
195
196COMMENT ON TABLE dtb_mailmaga_template IS 'メルマガテンプレート情報';
197COMMENT ON COLUMN dtb_mailmaga_template.template_id IS 'テンプレートID';
198COMMENT ON COLUMN dtb_mailmaga_template.subject IS '件名';
199COMMENT ON COLUMN dtb_mailmaga_template.mail_method IS 'メール送信方法';
200COMMENT ON COLUMN dtb_mailmaga_template.body IS '本文';
201COMMENT ON COLUMN dtb_mailmaga_template.del_flg IS '削除フラグ';
202COMMENT ON COLUMN dtb_mailmaga_template.creator_id IS '作成者ID';
203COMMENT ON COLUMN dtb_mailmaga_template.create_date IS '作成日時';
204COMMENT ON COLUMN dtb_mailmaga_template.update_date IS '更新日時';
205
206COMMENT ON TABLE mtb_magazine_type IS 'メルマガ種別';
207COMMENT ON COLUMN mtb_magazine_type.id IS 'ID';
208COMMENT ON COLUMN mtb_magazine_type.name IS '名称';
209COMMENT ON COLUMN mtb_magazine_type.rank IS '表示順';
210
211COMMENT ON TABLE mtb_mail_template IS 'メールテンプレート';
212COMMENT ON COLUMN mtb_mail_template.id IS 'ID';
213COMMENT ON COLUMN mtb_mail_template.name IS '名称';
214COMMENT ON COLUMN mtb_mail_template.rank IS '表示順';
215
216COMMENT ON TABLE mtb_mail_tpl_path IS 'メールテンプレートパス';
217COMMENT ON COLUMN mtb_mail_tpl_path.id IS 'ID';
218COMMENT ON COLUMN mtb_mail_tpl_path.name IS '名称';
219COMMENT ON COLUMN mtb_mail_tpl_path.rank IS '表示順';
220
221COMMENT ON TABLE dtb_mailtemplate IS 'メールテンプレート情報';
222COMMENT ON COLUMN dtb_mailtemplate.template_id IS 'テンプレートID';
223COMMENT ON COLUMN dtb_mailtemplate.subject IS '件名';
224COMMENT ON COLUMN dtb_mailtemplate.header IS 'ヘッダ';
225COMMENT ON COLUMN dtb_mailtemplate.footer IS 'フッタ';
226COMMENT ON COLUMN dtb_mailtemplate.creator_id IS '作成者ID';
227COMMENT ON COLUMN dtb_mailtemplate.del_flg IS '削除フラグ';
228COMMENT ON COLUMN dtb_mailtemplate.create_date IS '作成日時';
229COMMENT ON COLUMN dtb_mailtemplate.update_date IS '更新日時';
230
231COMMENT ON TABLE mtb_mail_magazine_type IS 'メールマガジン種別';
232COMMENT ON COLUMN mtb_mail_magazine_type.id IS 'ID';
233COMMENT ON COLUMN mtb_mail_magazine_type.name IS '名称';
234COMMENT ON COLUMN mtb_mail_magazine_type.rank IS '表示順';
235
236COMMENT ON TABLE mtb_mail_type IS 'メール種別';
237COMMENT ON COLUMN mtb_mail_type.id IS 'ID';
238COMMENT ON COLUMN mtb_mail_type.name IS '名称';
239COMMENT ON COLUMN mtb_mail_type.rank IS '表示順';
240
241COMMENT ON TABLE dtb_send_history IS 'メール送信履歴';
242COMMENT ON COLUMN dtb_send_history.send_id IS '送信ID';
243COMMENT ON COLUMN dtb_send_history.mail_method IS 'メール送信方法';
244COMMENT ON COLUMN dtb_send_history.subject IS '件名';
245COMMENT ON COLUMN dtb_send_history.body IS '本文';
246COMMENT ON COLUMN dtb_send_history.send_count IS '送信数';
247COMMENT ON COLUMN dtb_send_history.complete_count IS '送信完了数';
248COMMENT ON COLUMN dtb_send_history.start_date IS '送信開始日時';
249COMMENT ON COLUMN dtb_send_history.end_date IS '送信完了日時';
250COMMENT ON COLUMN dtb_send_history.search_data IS '検索データ';
251COMMENT ON COLUMN dtb_send_history.del_flg IS '削除フラグ';
252COMMENT ON COLUMN dtb_send_history.creator_id IS '作成者ID';
253COMMENT ON COLUMN dtb_send_history.create_date IS '作成日時';
254COMMENT ON COLUMN dtb_send_history.update_date IS '更新日時';
255
256COMMENT ON TABLE dtb_module IS 'モジュール情報';
257COMMENT ON COLUMN dtb_module.module_id IS 'モジュールID';
258COMMENT ON COLUMN dtb_module.module_code IS 'モジュールコード';
259COMMENT ON COLUMN dtb_module.module_name IS 'モジュール名';
260COMMENT ON COLUMN dtb_module.sub_data IS 'データ';
261COMMENT ON COLUMN dtb_module.auto_update_flg IS '自動更新フラグ';
262COMMENT ON COLUMN dtb_module.del_flg IS '削除フラグ';
263COMMENT ON COLUMN dtb_module.create_date IS '作成日時';
264COMMENT ON COLUMN dtb_module.update_date IS '更新日時';
265
266COMMENT ON TABLE dtb_module_update_logs IS 'モジュール更新ログ情報';
267COMMENT ON COLUMN dtb_module_update_logs.log_id IS 'ログID';
268COMMENT ON COLUMN dtb_module_update_logs.module_id IS 'モジュールID';
269COMMENT ON COLUMN dtb_module_update_logs.buckup_path IS 'バックアップパス';
270COMMENT ON COLUMN dtb_module_update_logs.error_flg IS 'エラーフラグ';
271COMMENT ON COLUMN dtb_module_update_logs.error IS 'エラーメッセージ';
272COMMENT ON COLUMN dtb_module_update_logs.ok IS '正常終了メッセージ';
273COMMENT ON COLUMN dtb_module_update_logs.create_date IS '作成日時';
274COMMENT ON COLUMN dtb_module_update_logs.update_date IS '更新日時';
275
276COMMENT ON TABLE dtb_update IS 'モジュール更新情報';
277COMMENT ON COLUMN dtb_update.module_id IS 'モジュールID';
278COMMENT ON COLUMN dtb_update.module_name IS 'モジュール名';
279COMMENT ON COLUMN dtb_update.now_version IS 'インストールバージョン';
280COMMENT ON COLUMN dtb_update.latest_version IS '最新バージョン';
281COMMENT ON COLUMN dtb_update.module_explain IS '機能説明';
282COMMENT ON COLUMN dtb_update.main_php IS '更新対象パス';
283COMMENT ON COLUMN dtb_update.extern_php IS '拡張対象パス';
284COMMENT ON COLUMN dtb_update.install_sql IS 'インストールSQL';
285COMMENT ON COLUMN dtb_update.uninstall_sql IS 'アンインストールSQL';
286COMMENT ON COLUMN dtb_update.other_files IS 'その他拡張ファイル名';
287COMMENT ON COLUMN dtb_update.del_flg IS '削除フラグ';
288COMMENT ON COLUMN dtb_update.create_date IS '作成日時';
289COMMENT ON COLUMN dtb_update.update_date IS '更新日時';
290COMMENT ON COLUMN dtb_update.release_date IS 'リリース日時';
291
292COMMENT ON TABLE dtb_mobile_ext_session_id IS 'モバイルセッション情報';
293COMMENT ON COLUMN dtb_mobile_ext_session_id.session_id IS 'セッションID';
294COMMENT ON COLUMN dtb_mobile_ext_session_id.param_key IS 'パラメータキー';
295COMMENT ON COLUMN dtb_mobile_ext_session_id.param_value IS 'パラメータ値';
296COMMENT ON COLUMN dtb_mobile_ext_session_id.url IS 'URL';
297COMMENT ON COLUMN dtb_mobile_ext_session_id.create_date IS '作成日時';
298
299COMMENT ON TABLE mtb_mobile_domain IS 'モバイルドメイン名';
300COMMENT ON COLUMN mtb_mobile_domain.id IS 'ID';
301COMMENT ON COLUMN mtb_mobile_domain.name IS '名称';
302COMMENT ON COLUMN mtb_mobile_domain.rank IS '表示順';
303
304COMMENT ON TABLE dtb_review IS 'レビュー情報';
305COMMENT ON COLUMN dtb_review.review_id IS 'レビューID';
306COMMENT ON COLUMN dtb_review.product_id IS '商品ID';
307COMMENT ON COLUMN dtb_review.reviewer_name IS 'レビューア名';
308COMMENT ON COLUMN dtb_review.reviewer_url IS 'レビューアURL';
309COMMENT ON COLUMN dtb_review.sex IS '性別';
310COMMENT ON COLUMN dtb_review.customer_id IS '顧客lID';
311COMMENT ON COLUMN dtb_review.recommend_level IS 'おすすめレベル';
312COMMENT ON COLUMN dtb_review.title IS 'タイトル';
313COMMENT ON COLUMN dtb_review.comment IS 'コメント';
314COMMENT ON COLUMN dtb_review.status IS '状態';
315COMMENT ON COLUMN dtb_review.creator_id IS '作成者ID';
316COMMENT ON COLUMN dtb_review.create_date IS '作成日時';
317COMMENT ON COLUMN dtb_review.update_date IS '更新日時';
318COMMENT ON COLUMN dtb_review.del_flg IS '削除フラグ';
319
320COMMENT ON TABLE mtb_review_deny_url IS 'レビュー拒否URL';
321COMMENT ON COLUMN mtb_review_deny_url.id IS 'ID';
322COMMENT ON COLUMN mtb_review_deny_url.name IS '名称';
323COMMENT ON COLUMN mtb_review_deny_url.rank IS '表示順';
324
325COMMENT ON TABLE mtb_disable_logout IS 'ログアウト無効ページ';
326COMMENT ON COLUMN mtb_disable_logout.id IS 'ID';
327COMMENT ON COLUMN mtb_disable_logout.name IS '名称';
328COMMENT ON COLUMN mtb_disable_logout.rank IS '表示順';
329
330COMMENT ON TABLE dtb_holiday IS '休日情報';
331COMMENT ON COLUMN dtb_holiday.holiday_id IS '休日ID';
332COMMENT ON COLUMN dtb_holiday.title IS 'タイトル';
333COMMENT ON COLUMN dtb_holiday.month IS '月';
334COMMENT ON COLUMN dtb_holiday.day IS '日';
335COMMENT ON COLUMN dtb_holiday.rank IS '表示順';
336COMMENT ON COLUMN dtb_holiday.creator_id IS '作成者ID';
337COMMENT ON COLUMN dtb_holiday.create_date IS '作成日時';
338COMMENT ON COLUMN dtb_holiday.update_date IS '更新日時';
339COMMENT ON COLUMN dtb_holiday.del_flg IS '削除フラグ';
340
341COMMENT ON TABLE mtb_disp IS '公開フラグ';
342COMMENT ON COLUMN mtb_disp.id IS 'ID';
343COMMENT ON COLUMN mtb_disp.name IS '名称';
344COMMENT ON COLUMN mtb_disp.rank IS '表示順';
345
346COMMENT ON TABLE mtb_order_status_color IS '受注ステータス色';
347COMMENT ON COLUMN mtb_order_status_color.id IS 'ID';
348COMMENT ON COLUMN mtb_order_status_color.name IS '名称';
349COMMENT ON COLUMN mtb_order_status_color.rank IS '表示順';
350
351COMMENT ON TABLE dtb_mail_history IS '受注メール送信履歴';
352COMMENT ON COLUMN dtb_mail_history.send_id IS '送信ID';
353COMMENT ON COLUMN dtb_mail_history.send_date IS '送信日時';
354COMMENT ON COLUMN dtb_mail_history.template_id IS 'テンプレートID';
355COMMENT ON COLUMN dtb_mail_history.creator_id IS '作成者ID';
356COMMENT ON COLUMN dtb_mail_history.subject IS '件名';
357COMMENT ON COLUMN dtb_mail_history.mail_body IS 'メール本文';
358COMMENT ON COLUMN dtb_mail_history.order_id IS '受注ID';
359
360COMMENT ON TABLE dtb_order_temp IS '受注一時情報';
361COMMENT ON COLUMN dtb_order_temp.order_temp_id IS '受注一時情報ID';
362COMMENT ON COLUMN dtb_order_temp.customer_id IS '顧客ID';
363COMMENT ON COLUMN dtb_order_temp.message IS '要望等';
364COMMENT ON COLUMN dtb_order_temp.order_name01 IS '顧客名(姓)';
365COMMENT ON COLUMN dtb_order_temp.order_name02 IS '顧客名(名)';
366COMMENT ON COLUMN dtb_order_temp.order_kana01 IS '顧客カナ(姓)';
367COMMENT ON COLUMN dtb_order_temp.order_kana02 IS '顧客カナ(名)';
368COMMENT ON COLUMN dtb_order_temp.order_company_name IS '【2.13】会社名';
369COMMENT ON COLUMN dtb_order_temp.order_email IS '顧客メールアドレス';
370COMMENT ON COLUMN dtb_order_temp.order_tel01 IS '顧客電話番号(市外局番)';
371COMMENT ON COLUMN dtb_order_temp.order_tel02 IS '顧客電話番号(市内局番)';
372COMMENT ON COLUMN dtb_order_temp.order_tel03 IS '顧客電話番号(局番)';
373COMMENT ON COLUMN dtb_order_temp.order_fax01 IS '顧客FAX(市外局番)';
374COMMENT ON COLUMN dtb_order_temp.order_fax02 IS '顧客FAX(市内局番)';
375COMMENT ON COLUMN dtb_order_temp.order_fax03 IS '顧客FAX(局番)';
376COMMENT ON COLUMN dtb_order_temp.order_zip01 IS '顧客郵便番号(4桁)';
377COMMENT ON COLUMN dtb_order_temp.order_zip02 IS '顧客郵便番号(3桁)';
378COMMENT ON COLUMN dtb_order_temp.order_zipcode IS '【2.13】顧客郵便番号(海外対応)';
379COMMENT ON COLUMN dtb_order_temp.order_country_id IS '【2.13】顧客国ID';
380COMMENT ON COLUMN dtb_order_temp.order_pref IS '都道府県ID';
381COMMENT ON COLUMN dtb_order_temp.order_addr01 IS '顧客住所1';
382COMMENT ON COLUMN dtb_order_temp.order_addr02 IS '顧客住所2';
383COMMENT ON COLUMN dtb_order_temp.order_sex IS '顧客性別';
384COMMENT ON COLUMN dtb_order_temp.order_birth IS '顧客生年月日';
385COMMENT ON COLUMN dtb_order_temp.order_job IS '顧客職業';
386COMMENT ON COLUMN dtb_order_temp.subtotal IS '小計';
387COMMENT ON COLUMN dtb_order_temp.discount IS '値引き';
388COMMENT ON COLUMN dtb_order_temp.deliv_id IS '配送業者ID';
389COMMENT ON COLUMN dtb_order_temp.deliv_fee IS '送料';
390COMMENT ON COLUMN dtb_order_temp.charge IS '手数料';
391COMMENT ON COLUMN dtb_order_temp.use_point IS '使用ポイント';
392COMMENT ON COLUMN dtb_order_temp.add_point IS '加算ポイント';
393COMMENT ON COLUMN dtb_order_temp.birth_point IS 'お誕生日ポイント';
394COMMENT ON COLUMN dtb_order_temp.tax IS '税金';
395COMMENT ON COLUMN dtb_order_temp.total IS '合計';
396COMMENT ON COLUMN dtb_order_temp.payment_total IS '支払い合計';
397COMMENT ON COLUMN dtb_order_temp.payment_id IS '支払方法ID';
398COMMENT ON COLUMN dtb_order_temp.payment_method IS '支払方法';
399COMMENT ON COLUMN dtb_order_temp.note IS '備考';
400COMMENT ON COLUMN dtb_order_temp.mail_flag IS 'メルマガ希望フラグ';
401COMMENT ON COLUMN dtb_order_temp.status IS '受注状態';
402COMMENT ON COLUMN dtb_order_temp.deliv_check IS '属性0';
403COMMENT ON COLUMN dtb_order_temp.point_check IS 'ポイント使用フラグ';
404COMMENT ON COLUMN dtb_order_temp.create_date IS '作成日時';
405COMMENT ON COLUMN dtb_order_temp.update_date IS '更新日時';
406COMMENT ON COLUMN dtb_order_temp.device_type_id IS '端末種別ID';
407COMMENT ON COLUMN dtb_order_temp.del_flg IS '削除フラグ';
408COMMENT ON COLUMN dtb_order_temp.order_id IS '受注ID';
409COMMENT ON COLUMN dtb_order_temp.memo01 IS '汎用項目1';
410COMMENT ON COLUMN dtb_order_temp.memo02 IS '汎用項目2';
411COMMENT ON COLUMN dtb_order_temp.memo03 IS '汎用項目3';
412COMMENT ON COLUMN dtb_order_temp.memo04 IS '汎用項目4';
413COMMENT ON COLUMN dtb_order_temp.memo05 IS '汎用項目5';
414COMMENT ON COLUMN dtb_order_temp.memo06 IS '汎用項目6';
415COMMENT ON COLUMN dtb_order_temp.memo07 IS '汎用項目7';
416COMMENT ON COLUMN dtb_order_temp.memo08 IS '汎用項目8';
417COMMENT ON COLUMN dtb_order_temp.memo09 IS '汎用項目9';
418COMMENT ON COLUMN dtb_order_temp.memo10 IS '汎用項目10';
419COMMENT ON COLUMN dtb_order_temp.session IS 'セッション情報';
420
421COMMENT ON TABLE dtb_order IS '受注情報';
422COMMENT ON COLUMN dtb_order.order_id IS '受注ID';
423COMMENT ON COLUMN dtb_order.customer_id IS '顧客ID';
424COMMENT ON COLUMN dtb_order.order_temp_id IS '受注一時情報ID';
425COMMENT ON COLUMN dtb_order.message IS '要望等';
426COMMENT ON COLUMN dtb_order.order_name01 IS '顧客名(姓)';
427COMMENT ON COLUMN dtb_order.order_name02 IS '顧客名(名)';
428COMMENT ON COLUMN dtb_order.order_kana01 IS '顧客カナ(姓)';
429COMMENT ON COLUMN dtb_order.order_kana02 IS '顧客カナ(名)';
430COMMENT ON COLUMN dtb_order.order_company_name IS '【2.13】会社名';
431COMMENT ON COLUMN dtb_order.order_email IS '顧客メールアドレス';
432COMMENT ON COLUMN dtb_order.order_tel01 IS '顧客電話番号(市外局番)';
433COMMENT ON COLUMN dtb_order.order_tel02 IS '顧客電話番号(市内局番)';
434COMMENT ON COLUMN dtb_order.order_tel03 IS '顧客電話番号(局番)';
435COMMENT ON COLUMN dtb_order.order_fax01 IS '顧客FAX(市外局番)';
436COMMENT ON COLUMN dtb_order.order_fax02 IS '顧客FAX(市内局番)';
437COMMENT ON COLUMN dtb_order.order_fax03 IS '顧客FAX(局番)';
438COMMENT ON COLUMN dtb_order.order_zip01 IS '顧客郵便番号(4桁)';
439COMMENT ON COLUMN dtb_order.order_zip02 IS '顧客郵便番号(3桁)';
440COMMENT ON COLUMN dtb_order.order_zipcode IS '【2.13】顧客郵便番号(海外対応)';
441COMMENT ON COLUMN dtb_order.order_country_id IS '【2.13】顧客国ID';
442COMMENT ON COLUMN dtb_order.order_pref IS '都道府県ID';
443COMMENT ON COLUMN dtb_order.order_addr01 IS '顧客住所1';
444COMMENT ON COLUMN dtb_order.order_addr02 IS '顧客住所2';
445COMMENT ON COLUMN dtb_order.order_sex IS '顧客性別';
446COMMENT ON COLUMN dtb_order.order_birth IS '顧客生年月日';
447COMMENT ON COLUMN dtb_order.order_job IS '顧客職業';
448COMMENT ON COLUMN dtb_order.subtotal IS '小計';
449COMMENT ON COLUMN dtb_order.discount IS '値引き';
450COMMENT ON COLUMN dtb_order.deliv_id IS '配送業者ID';
451COMMENT ON COLUMN dtb_order.deliv_fee IS '送料';
452COMMENT ON COLUMN dtb_order.charge IS '手数料';
453COMMENT ON COLUMN dtb_order.use_point IS '使用ポイント';
454COMMENT ON COLUMN dtb_order.add_point IS '加算ポイント';
455COMMENT ON COLUMN dtb_order.birth_point IS 'お誕生日ポイント';
456COMMENT ON COLUMN dtb_order.tax IS '税金';
457COMMENT ON COLUMN dtb_order.total IS '合計';
458COMMENT ON COLUMN dtb_order.payment_total IS '支払い合計';
459COMMENT ON COLUMN dtb_order.payment_id IS '支払方法ID';
460COMMENT ON COLUMN dtb_order.payment_method IS '支払方法';
461COMMENT ON COLUMN dtb_order.note IS '備考';
462COMMENT ON COLUMN dtb_order.status IS '受注状態';
463COMMENT ON COLUMN dtb_order.create_date IS '作成日時';
464COMMENT ON COLUMN dtb_order.update_date IS '更新日時';
465COMMENT ON COLUMN dtb_order.payment_date IS '入金日時';
466COMMENT ON COLUMN dtb_order.commit_date IS '発送済み日時';
467COMMENT ON COLUMN dtb_order.device_type_id IS '端末種別ID';
468COMMENT ON COLUMN dtb_order.del_flg IS '削除フラグ';
469COMMENT ON COLUMN dtb_order.memo01 IS '汎用項目1';
470COMMENT ON COLUMN dtb_order.memo02 IS '汎用項目2';
471COMMENT ON COLUMN dtb_order.memo03 IS '汎用項目3';
472COMMENT ON COLUMN dtb_order.memo04 IS '汎用項目4';
473COMMENT ON COLUMN dtb_order.memo05 IS '汎用項目5';
474COMMENT ON COLUMN dtb_order.memo06 IS '汎用項目6';
475COMMENT ON COLUMN dtb_order.memo07 IS '汎用項目7';
476COMMENT ON COLUMN dtb_order.memo08 IS '汎用項目8';
477COMMENT ON COLUMN dtb_order.memo09 IS '汎用項目9';
478COMMENT ON COLUMN dtb_order.memo10 IS '汎用項目10';
479
480COMMENT ON TABLE mtb_order_status IS '受注状態';
481COMMENT ON COLUMN mtb_order_status.id IS 'ID';
482COMMENT ON COLUMN mtb_order_status.name IS '名称';
483COMMENT ON COLUMN mtb_order_status.rank IS '表示順';
484
485COMMENT ON TABLE dtb_order_detail IS '受注詳細情報';
486COMMENT ON COLUMN dtb_order_detail.order_detail_id IS '受注詳細ID';
487COMMENT ON COLUMN dtb_order_detail.order_id IS '受注ID';
488COMMENT ON COLUMN dtb_order_detail.product_id IS '商品ID';
489COMMENT ON COLUMN dtb_order_detail.product_class_id IS '商品規格ID';
490COMMENT ON COLUMN dtb_order_detail.product_name IS '商品名';
491COMMENT ON COLUMN dtb_order_detail.product_code IS '商品コード';
492COMMENT ON COLUMN dtb_order_detail.classcategory_name1 IS '商品規格名1';
493COMMENT ON COLUMN dtb_order_detail.classcategory_name2 IS '商品規格名2';
494COMMENT ON COLUMN dtb_order_detail.price IS '価格';
495COMMENT ON COLUMN dtb_order_detail.quantity IS '個数';
496COMMENT ON COLUMN dtb_order_detail.point_rate IS 'ポイント付与率';
497COMMENT ON COLUMN dtb_order_detail.tax_rate IS '【2.13】消費税率';
498COMMENT ON COLUMN dtb_order_detail.tax_rule IS '【2.13】課税規則';
499
500COMMENT ON TABLE dtb_product_categories IS '商品カテゴリ関連';
501COMMENT ON COLUMN dtb_product_categories.category_id IS 'カテゴリID';
502COMMENT ON COLUMN dtb_product_categories.product_id IS '商品ID';
503COMMENT ON COLUMN dtb_product_categories.rank IS '表示順';
504
505COMMENT ON TABLE mtb_status IS '商品ステータス';
506COMMENT ON COLUMN mtb_status.id IS 'ID';
507COMMENT ON COLUMN mtb_status.name IS '名称';
508COMMENT ON COLUMN mtb_status.rank IS '表示順';
509
510COMMENT ON TABLE dtb_product_status IS '商品ステータス情報';
511COMMENT ON COLUMN dtb_product_status.product_id IS '商品ID';
512COMMENT ON COLUMN dtb_product_status.product_status_id IS '商品ステータスID';
513COMMENT ON COLUMN dtb_product_status.creator_id IS '作成者ID';
514COMMENT ON COLUMN dtb_product_status.create_date IS '作成日時';
515COMMENT ON COLUMN dtb_product_status.update_date IS '更新日時';
516COMMENT ON COLUMN dtb_product_status.del_flg IS '削除フラグ';
517
518COMMENT ON TABLE mtb_product_status_color IS '商品ステータス色';
519COMMENT ON COLUMN mtb_product_status_color.id IS 'ID';
520COMMENT ON COLUMN mtb_product_status_color.name IS '名称';
521COMMENT ON COLUMN mtb_product_status_color.rank IS '表示順';
522
523COMMENT ON TABLE mtb_product_list_max IS '商品一覧最大表示数';
524COMMENT ON COLUMN mtb_product_list_max.id IS 'ID';
525COMMENT ON COLUMN mtb_product_list_max.name IS '名称';
526COMMENT ON COLUMN mtb_product_list_max.rank IS '表示順';
527
528COMMENT ON TABLE dtb_products IS '商品情報';
529COMMENT ON COLUMN dtb_products.product_id IS '商品ID';
530COMMENT ON COLUMN dtb_products.name IS '商品名';
531COMMENT ON COLUMN dtb_products.maker_id IS 'メーカーID';
532COMMENT ON COLUMN dtb_products.status IS '表示ステータス';
533COMMENT ON COLUMN dtb_products.comment1 IS 'コメント1(メーカーURL)';
534COMMENT ON COLUMN dtb_products.comment2 IS 'コメント2';
535COMMENT ON COLUMN dtb_products.comment3 IS 'コメント3(検索ワード)';
536COMMENT ON COLUMN dtb_products.comment4 IS 'コメント4';
537COMMENT ON COLUMN dtb_products.comment5 IS 'コメント5';
538COMMENT ON COLUMN dtb_products.comment6 IS 'コメント6';
539COMMENT ON COLUMN dtb_products.note IS '備考';
540COMMENT ON COLUMN dtb_products.main_list_comment IS 'メイン一覧コメント';
541COMMENT ON COLUMN dtb_products.main_list_image IS 'メイン一覧画像';
542COMMENT ON COLUMN dtb_products.main_comment IS 'メインコメント';
543COMMENT ON COLUMN dtb_products.main_image IS 'メイン画像';
544COMMENT ON COLUMN dtb_products.main_large_image IS 'メイン拡大画像';
545COMMENT ON COLUMN dtb_products.sub_title1 IS 'サブタイトル1';
546COMMENT ON COLUMN dtb_products.sub_comment1 IS 'サブコメント1';
547COMMENT ON COLUMN dtb_products.sub_image1 IS 'サブ画像1';
548COMMENT ON COLUMN dtb_products.sub_large_image1 IS 'サブ拡大画像1';
549COMMENT ON COLUMN dtb_products.sub_title2 IS 'サブタイトル2';
550COMMENT ON COLUMN dtb_products.sub_comment2 IS 'サブコメント2';
551COMMENT ON COLUMN dtb_products.sub_image2 IS 'サブ画像2';
552COMMENT ON COLUMN dtb_products.sub_large_image2 IS 'サブ拡大画像2';
553COMMENT ON COLUMN dtb_products.sub_title3 IS 'サブタイトル3';
554COMMENT ON COLUMN dtb_products.sub_comment3 IS 'サブコメント3';
555COMMENT ON COLUMN dtb_products.sub_image3 IS 'サブ画像3';
556COMMENT ON COLUMN dtb_products.sub_large_image3 IS 'サブ拡大画像3';
557COMMENT ON COLUMN dtb_products.sub_title4 IS 'サブタイトル4';
558COMMENT ON COLUMN dtb_products.sub_comment4 IS 'サブコメント4';
559COMMENT ON COLUMN dtb_products.sub_image4 IS 'サブ画像4';
560COMMENT ON COLUMN dtb_products.sub_large_image4 IS 'サブ拡大画像4';
561COMMENT ON COLUMN dtb_products.sub_title5 IS 'サブタイトル5';
562COMMENT ON COLUMN dtb_products.sub_comment5 IS 'サブコメント5';
563COMMENT ON COLUMN dtb_products.sub_image5 IS 'サブ画像5';
564COMMENT ON COLUMN dtb_products.sub_large_image5 IS 'サブ拡大画像5';
565COMMENT ON COLUMN dtb_products.sub_title6 IS 'サブタイトル6';
566COMMENT ON COLUMN dtb_products.sub_comment6 IS 'サブコメント6';
567COMMENT ON COLUMN dtb_products.sub_image6 IS 'サブ画像6';
568COMMENT ON COLUMN dtb_products.sub_large_image6 IS 'サブ拡大画像6';
569COMMENT ON COLUMN dtb_products.del_flg IS '削除フラグ';
570COMMENT ON COLUMN dtb_products.creator_id IS '作成者ID';
571COMMENT ON COLUMN dtb_products.create_date IS '作成日時';
572COMMENT ON COLUMN dtb_products.update_date IS '更新日時';
573COMMENT ON COLUMN dtb_products.deliv_date_id IS '発送日目安';
574
575COMMENT ON TABLE mtb_delivery_date IS '商品発送日';
576COMMENT ON COLUMN mtb_delivery_date.id IS 'ID';
577COMMENT ON COLUMN mtb_delivery_date.name IS '名称';
578COMMENT ON COLUMN mtb_delivery_date.rank IS '表示順';
579
580COMMENT ON TABLE mtb_product_type IS '商品種別マスタ';
581COMMENT ON COLUMN mtb_product_type.id IS 'ID';
582COMMENT ON COLUMN mtb_product_type.name IS '名称';
583COMMENT ON COLUMN mtb_product_type.rank IS '表示順';
584
585COMMENT ON TABLE dtb_products_class IS '商品規格情報';
586COMMENT ON COLUMN dtb_products_class.product_class_id IS '商品規格ID';
587COMMENT ON COLUMN dtb_products_class.product_id IS '商品ID';
588COMMENT ON COLUMN dtb_products_class.product_code IS '商品コード';
589COMMENT ON COLUMN dtb_products_class.stock IS '在庫数';
590COMMENT ON COLUMN dtb_products_class.stock_unlimited IS '在庫制限';
591COMMENT ON COLUMN dtb_products_class.sale_limit IS '販売制限数';
592COMMENT ON COLUMN dtb_products_class.price01 IS '価格';
593COMMENT ON COLUMN dtb_products_class.price02 IS '特別価格';
594COMMENT ON COLUMN dtb_products_class.deliv_fee IS '商品送料';
595COMMENT ON COLUMN dtb_products_class.point_rate IS 'ポイント付与率';
596COMMENT ON COLUMN dtb_products_class.creator_id IS '作成者ID';
597COMMENT ON COLUMN dtb_products_class.create_date IS '作成日時';
598COMMENT ON COLUMN dtb_products_class.update_date IS '更新日時';
599COMMENT ON COLUMN dtb_products_class.del_flg IS '削除フラグ';
600COMMENT ON COLUMN dtb_products_class.classcategory_id1 IS '規格分類ID1';
601COMMENT ON COLUMN dtb_products_class.classcategory_id2 IS '規格分類ID2';
602COMMENT ON COLUMN dtb_products_class.product_type_id IS '商品種別ID';
603COMMENT ON COLUMN dtb_products_class.down_filename IS 'ダウンロードファイル名';
604COMMENT ON COLUMN dtb_products_class.down_realfilename IS 'ダウンロード実ファイル名';
605
606COMMENT ON TABLE mtb_constants IS '定数マスタ';
607COMMENT ON COLUMN mtb_constants.id IS 'ID';
608COMMENT ON COLUMN mtb_constants.name IS '定数名';
609COMMENT ON COLUMN mtb_constants.rank IS '表示順';
610COMMENT ON COLUMN mtb_constants.remarks IS '定数コメント';
611
612COMMENT ON TABLE dtb_baseinfo IS '店舗基本情報';
613COMMENT ON COLUMN dtb_baseinfo.id IS '店舗基本情報ID';
614COMMENT ON COLUMN dtb_baseinfo.company_name IS '会社名';
615COMMENT ON COLUMN dtb_baseinfo.company_kana IS '会社名(カナ)';
616COMMENT ON COLUMN dtb_baseinfo.zip01 IS '郵便番号(4桁)';
617COMMENT ON COLUMN dtb_baseinfo.zip02 IS '郵便番号(3桁)';
618COMMENT ON COLUMN dtb_baseinfo.zipcode IS '【2.13】郵便番号(海外対応)';
619COMMENT ON COLUMN dtb_baseinfo.country_id IS '【2.13】国ID';
620COMMENT ON COLUMN dtb_baseinfo.pref IS '都道府県';
621COMMENT ON COLUMN dtb_baseinfo.addr01 IS '住所1';
622COMMENT ON COLUMN dtb_baseinfo.addr02 IS '住所2';
623COMMENT ON COLUMN dtb_baseinfo.tel01 IS '電話番号(市外局番)';
624COMMENT ON COLUMN dtb_baseinfo.tel02 IS '電話番号(市内局番)';
625COMMENT ON COLUMN dtb_baseinfo.tel03 IS '電話番号(局番)';
626COMMENT ON COLUMN dtb_baseinfo.fax01 IS 'FAX番号(市外局番)';
627COMMENT ON COLUMN dtb_baseinfo.fax02 IS 'FAX番号(市内局番)';
628COMMENT ON COLUMN dtb_baseinfo.fax03 IS 'FAX番号(局番)';
629COMMENT ON COLUMN dtb_baseinfo.business_hour IS '営業時間';
630COMMENT ON COLUMN dtb_baseinfo.law_company IS '販売業者(特定商取引)';
631COMMENT ON COLUMN dtb_baseinfo.law_manager IS '販売責任者(特定商取引)';
632COMMENT ON COLUMN dtb_baseinfo.law_zip01 IS '郵便番号4桁(特定商取引)';
633COMMENT ON COLUMN dtb_baseinfo.law_zip02 IS '郵便番号3桁(特定商取引)';
634COMMENT ON COLUMN dtb_baseinfo.law_zipcode IS '【2.13】郵便番号(海外対応)(特定商取引)';
635COMMENT ON COLUMN dtb_baseinfo.law_country_id IS '【2.13】国ID(特定商取引)';
636COMMENT ON COLUMN dtb_baseinfo.law_pref IS '都道府県(特定商取引)';
637COMMENT ON COLUMN dtb_baseinfo.law_addr01 IS '住所1(特定商取引)';
638COMMENT ON COLUMN dtb_baseinfo.law_addr02 IS '住所2(特定商取引)';
639COMMENT ON COLUMN dtb_baseinfo.law_tel01 IS '電話番号(市外局番)(特定商取引)';
640COMMENT ON COLUMN dtb_baseinfo.law_tel02 IS '電話番号(市内局番)(特定商取引)';
641COMMENT ON COLUMN dtb_baseinfo.law_tel03 IS '電話番号(局番)(特定商取引)';
642COMMENT ON COLUMN dtb_baseinfo.law_fax01 IS 'FAX番号(市外局番)(特定商取引)';
643COMMENT ON COLUMN dtb_baseinfo.law_fax02 IS 'FAX番号(市内局番)(特定商取引)';
644COMMENT ON COLUMN dtb_baseinfo.law_fax03 IS 'FAX番号(局番)(特定商取引)';
645COMMENT ON COLUMN dtb_baseinfo.law_email IS 'メールアドレス(特定商取引)';
646COMMENT ON COLUMN dtb_baseinfo.law_url IS 'URL(特定商取引)';
647COMMENT ON COLUMN dtb_baseinfo.law_term01 IS '商品代金以外の必要料金(特定商取引)';
648COMMENT ON COLUMN dtb_baseinfo.law_term02 IS '注文方法(特定商取引)';
649COMMENT ON COLUMN dtb_baseinfo.law_term03 IS '支払方法(特定商取引)';
650COMMENT ON COLUMN dtb_baseinfo.law_term04 IS '支払期限(特定商取引)';
651COMMENT ON COLUMN dtb_baseinfo.law_term05 IS '引き渡し時期(特定商取引)';
652COMMENT ON COLUMN dtb_baseinfo.law_term06 IS '返品・交換について(特定商取引)';
653COMMENT ON COLUMN dtb_baseinfo.law_term07 IS '予備1(特定商取引)';
654COMMENT ON COLUMN dtb_baseinfo.law_term08 IS '予備2(特定商取引)';
655COMMENT ON COLUMN dtb_baseinfo.law_term09 IS '予備3(特定商取引)';
656COMMENT ON COLUMN dtb_baseinfo.law_term10 IS '予備4(特定商取引)';
657COMMENT ON COLUMN dtb_baseinfo.email01 IS '受注情報受付メールアドレス';
658COMMENT ON COLUMN dtb_baseinfo.email02 IS '問い合わせ受付メールアドレス';
659COMMENT ON COLUMN dtb_baseinfo.email03 IS '送信エラー受付メールアドレス';
660COMMENT ON COLUMN dtb_baseinfo.email04 IS 'メール送信元メールアドレス';
661COMMENT ON COLUMN dtb_baseinfo.free_rule IS '送料・手数料無料条件(円以上)';
662COMMENT ON COLUMN dtb_baseinfo.shop_name IS '店舗名';
663COMMENT ON COLUMN dtb_baseinfo.shop_kana IS '店舗名(カナ)';
664COMMENT ON COLUMN dtb_baseinfo.point_rate IS 'ポイント付与率';
665COMMENT ON COLUMN dtb_baseinfo.welcome_point IS '会員登録時付与ポイント';
666COMMENT ON COLUMN dtb_baseinfo.update_date IS '更新日時';
667COMMENT ON COLUMN dtb_baseinfo.top_tpl IS 'トップページテンプレート';
668COMMENT ON COLUMN dtb_baseinfo.product_tpl IS '商品一覧テンプレート';
669COMMENT ON COLUMN dtb_baseinfo.detail_tpl IS '商品詳細テンプレート';
670COMMENT ON COLUMN dtb_baseinfo.mypage_tpl IS 'Myページテンプレート';
671COMMENT ON COLUMN dtb_baseinfo.good_traded IS '取扱商品';
672COMMENT ON COLUMN dtb_baseinfo.message IS 'メッセージ';
673COMMENT ON COLUMN dtb_baseinfo.regular_holiday_ids IS '定休日の曜日';
674COMMENT ON COLUMN dtb_baseinfo.latitude IS '緯度';
675COMMENT ON COLUMN dtb_baseinfo.longitude IS '経度';
676COMMENT ON COLUMN dtb_baseinfo.downloadable_days IS 'ダウンロード可能日数';
677COMMENT ON COLUMN dtb_baseinfo.downloadable_days_unlimited IS 'ダウンロード可能日数無制限フラグ';
678COMMENT ON COLUMN dtb_baseinfo.shop_name_eng IS '店舗名(英語)';
679
680COMMENT ON TABLE mtb_sex IS '性別マスタ';
681COMMENT ON COLUMN mtb_sex.id IS 'ID';
682COMMENT ON COLUMN mtb_sex.name IS '名称';
683COMMENT ON COLUMN mtb_sex.rank IS '表示順';
684
685COMMENT ON TABLE dtb_payment IS '支払方法情報';
686COMMENT ON COLUMN dtb_payment.payment_id IS '支払方法ID';
687COMMENT ON COLUMN dtb_payment.payment_method IS '支払方法';
688COMMENT ON COLUMN dtb_payment.charge IS '手数料';
689COMMENT ON COLUMN dtb_payment.rule_max IS '利用条件(円以上)';
690COMMENT ON COLUMN dtb_payment.rank IS '表示順';
691COMMENT ON COLUMN dtb_payment.note IS '備考';
692COMMENT ON COLUMN dtb_payment.fix IS '固定:1 自由設定:2';
693COMMENT ON COLUMN dtb_payment.status IS '状態';
694COMMENT ON COLUMN dtb_payment.del_flg IS '削除フラグ';
695COMMENT ON COLUMN dtb_payment.creator_id IS '作成者ID';
696COMMENT ON COLUMN dtb_payment.create_date IS '作成日時';
697COMMENT ON COLUMN dtb_payment.update_date IS '更新日時';
698COMMENT ON COLUMN dtb_payment.payment_image IS '支払方法ロゴ';
699COMMENT ON COLUMN dtb_payment.upper_rule IS '利用条件(円以下)';
700COMMENT ON COLUMN dtb_payment.charge_flg IS '手数料設定フラグ';
701COMMENT ON COLUMN dtb_payment.rule_min IS '利用条件(円以上)の下限';
702COMMENT ON COLUMN dtb_payment.upper_rule_max IS '利用条件(円以下)の上限';
703COMMENT ON COLUMN dtb_payment.module_id IS '追加モジュールID';
704COMMENT ON COLUMN dtb_payment.module_path IS '追加モジュールパス';
705COMMENT ON COLUMN dtb_payment.memo01 IS '汎用項目1';
706COMMENT ON COLUMN dtb_payment.memo02 IS '汎用項目2';
707COMMENT ON COLUMN dtb_payment.memo03 IS '汎用項目3';
708COMMENT ON COLUMN dtb_payment.memo04 IS '汎用項目4';
709COMMENT ON COLUMN dtb_payment.memo05 IS '汎用項目5';
710COMMENT ON COLUMN dtb_payment.memo06 IS '汎用項目6';
711COMMENT ON COLUMN dtb_payment.memo07 IS '汎用項目7';
712COMMENT ON COLUMN dtb_payment.memo08 IS '汎用項目8';
713COMMENT ON COLUMN dtb_payment.memo09 IS '汎用項目9';
714COMMENT ON COLUMN dtb_payment.memo10 IS '汎用項目10';
715
716COMMENT ON TABLE dtb_payment_options IS '支払選択肢情報';
717COMMENT ON COLUMN dtb_payment_options.payment_id IS '支払方法ID';
718COMMENT ON COLUMN dtb_payment_options.deliv_id IS '配送業者ID';
719COMMENT ON COLUMN dtb_payment_options.rank IS '表示順';
720
721COMMENT ON TABLE dtb_news IS '新着情報';
722COMMENT ON COLUMN dtb_news.news_id IS '新着情報ID';
723COMMENT ON COLUMN dtb_news.news_date IS '新着情報日付';
724COMMENT ON COLUMN dtb_news.rank IS '表示順';
725COMMENT ON COLUMN dtb_news.news_title IS '新着情報タイトル';
726COMMENT ON COLUMN dtb_news.news_comment IS '新着情報コメント';
727COMMENT ON COLUMN dtb_news.news_url IS '新着情報URL';
728COMMENT ON COLUMN dtb_news.news_select IS '不明(未使用?)';
729COMMENT ON COLUMN dtb_news.link_method IS '別ウィンドウで開くフラグ';
730COMMENT ON COLUMN dtb_news.creator_id IS '作成者ID';
731COMMENT ON COLUMN dtb_news.create_date IS '作成日時';
732COMMENT ON COLUMN dtb_news.update_date IS '更新日時';
733COMMENT ON COLUMN dtb_news.del_flg IS '削除フラグ';
734
735COMMENT ON TABLE mtb_wday IS '曜日';
736COMMENT ON COLUMN mtb_wday.id IS 'ID';
737COMMENT ON COLUMN mtb_wday.name IS '名称';
738COMMENT ON COLUMN mtb_wday.rank IS '表示順';
739
740COMMENT ON TABLE mtb_work IS '稼動状態';
741COMMENT ON COLUMN mtb_work.id IS 'ID';
742COMMENT ON COLUMN mtb_work.name IS '名称';
743COMMENT ON COLUMN mtb_work.rank IS '表示順';
744
745COMMENT ON TABLE mtb_device_type IS '端末種別';
746COMMENT ON COLUMN mtb_device_type.id IS 'ID';
747COMMENT ON COLUMN mtb_device_type.name IS '名称';
748COMMENT ON COLUMN mtb_device_type.rank IS '表示順';
749
750COMMENT ON TABLE mtb_permission IS '管理画面アクセス権限';
751COMMENT ON COLUMN mtb_permission.id IS 'ID';
752COMMENT ON COLUMN mtb_permission.name IS '名称';
753COMMENT ON COLUMN mtb_permission.rank IS '表示順';
754
755COMMENT ON TABLE dtb_member IS '管理画面メンバー情報';
756COMMENT ON COLUMN dtb_member.member_id IS 'メンバーID';
757COMMENT ON COLUMN dtb_member.name IS '名前';
758COMMENT ON COLUMN dtb_member.department IS '部門';
759COMMENT ON COLUMN dtb_member.login_id IS 'ログインID';
760COMMENT ON COLUMN dtb_member.password IS 'パスワード';
761COMMENT ON COLUMN dtb_member.authority IS '権限';
762COMMENT ON COLUMN dtb_member.rank IS '表示順';
763COMMENT ON COLUMN dtb_member.work IS '稼動フラグ';
764COMMENT ON COLUMN dtb_member.del_flg IS '削除フラグ';
765COMMENT ON COLUMN dtb_member.creator_id IS '作成者ID';
766COMMENT ON COLUMN dtb_member.update_date IS '更新日付';
767COMMENT ON COLUMN dtb_member.create_date IS '作成日時';
768COMMENT ON COLUMN dtb_member.login_date IS '最終ログイン日時';
769COMMENT ON COLUMN dtb_member.salt IS '暗号化付与文字列';
770
771COMMENT ON TABLE mtb_authority IS '管理者マスタ';
772COMMENT ON COLUMN mtb_authority.id IS 'ID';
773COMMENT ON COLUMN mtb_authority.name IS '名称';
774COMMENT ON COLUMN mtb_authority.rank IS '表示順';
775
776COMMENT ON TABLE mtb_job IS '職業マスタ';
777COMMENT ON COLUMN mtb_job.id IS 'ID';
778COMMENT ON COLUMN mtb_job.name IS '名称';
779COMMENT ON COLUMN mtb_job.rank IS '表示順';
780
781COMMENT ON TABLE dtb_classcategory IS '規格分類情報';
782COMMENT ON COLUMN dtb_classcategory.classcategory_id IS '規格分類情報ID';
783COMMENT ON COLUMN dtb_classcategory.class_id IS '規格ID';
784COMMENT ON COLUMN dtb_classcategory.name IS '規格分類名';
785COMMENT ON COLUMN dtb_classcategory.rank IS '表示順';
786COMMENT ON COLUMN dtb_classcategory.creator_id IS '作成者ID';
787COMMENT ON COLUMN dtb_classcategory.create_date IS '作成日時';
788COMMENT ON COLUMN dtb_classcategory.update_date IS '更新日時';
789COMMENT ON COLUMN dtb_classcategory.del_flg IS '削除フラグ';
790
791COMMENT ON TABLE dtb_class IS '規格情報';
792COMMENT ON COLUMN dtb_class.class_id IS '規格ID';
793COMMENT ON COLUMN dtb_class.name IS '規格名';
794COMMENT ON COLUMN dtb_class.creator_id IS '作成者ID';
795COMMENT ON COLUMN dtb_class.create_date IS '作成日時';
796COMMENT ON COLUMN dtb_class.update_date IS '更新日時';
797COMMENT ON COLUMN dtb_class.del_flg IS '削除フラグ';
798COMMENT ON COLUMN dtb_class.rank IS '表示順';
799
800COMMENT ON TABLE dtb_kiyaku IS '規約情報';
801COMMENT ON COLUMN dtb_kiyaku.kiyaku_id IS '規約ID';
802COMMENT ON COLUMN dtb_kiyaku.kiyaku_title IS '規約タイトル';
803COMMENT ON COLUMN dtb_kiyaku.kiyaku_text IS '規約本文';
804COMMENT ON COLUMN dtb_kiyaku.rank IS '表示順';
805COMMENT ON COLUMN dtb_kiyaku.creator_id IS '作成者ID';
806COMMENT ON COLUMN dtb_kiyaku.create_date IS '作成日時';
807COMMENT ON COLUMN dtb_kiyaku.update_date IS '更新日時';
808COMMENT ON COLUMN dtb_kiyaku.del_flg IS '削除フラグ';
809
810COMMENT ON TABLE mtb_allowed_tag IS '許可タグ';
811COMMENT ON COLUMN mtb_allowed_tag.id IS 'ID';
812COMMENT ON COLUMN mtb_allowed_tag.name IS '名称';
813COMMENT ON COLUMN mtb_allowed_tag.rank IS '表示順';
814
815COMMENT ON TABLE mtb_taxrule IS '課税規則マスタ';
816COMMENT ON COLUMN mtb_taxrule.id IS 'ID';
817COMMENT ON COLUMN mtb_taxrule.name IS '名称';
818COMMENT ON COLUMN mtb_taxrule.rank IS '表示順';
819
820COMMENT ON TABLE dtb_delivfee IS '送料情報';
821COMMENT ON COLUMN dtb_delivfee.fee_id IS '送料ID';
822COMMENT ON COLUMN dtb_delivfee.deliv_id IS '配送業者ID';
823COMMENT ON COLUMN dtb_delivfee.fee IS '送料';
824COMMENT ON COLUMN dtb_delivfee.pref IS '都道府県名';
825
826COMMENT ON TABLE mtb_zip IS '郵便番号';
827COMMENT ON COLUMN mtb_zip.zip_id IS '郵便番号ID';
828COMMENT ON COLUMN mtb_zip.zipcode IS '郵便番号(7桁)';
829COMMENT ON COLUMN mtb_zip.state IS '都道府県';
830COMMENT ON COLUMN mtb_zip.city IS '市区町村';
831COMMENT ON COLUMN mtb_zip.town IS '町域';
832
833COMMENT ON TABLE mtb_pref IS '都道府県マスタ';
834COMMENT ON COLUMN mtb_pref.id IS 'ID';
835COMMENT ON COLUMN mtb_pref.name IS '名称';
836COMMENT ON COLUMN mtb_pref.rank IS '表示順';
837
838COMMENT ON TABLE dtb_shipping IS '配送先情報';
839COMMENT ON COLUMN dtb_shipping.shipping_id IS '配送先ID';
840COMMENT ON COLUMN dtb_shipping.order_id IS '受注ID';
841COMMENT ON COLUMN dtb_shipping.shipping_name01 IS '配送先名前(姓)';
842COMMENT ON COLUMN dtb_shipping.shipping_name02 IS '配送先名前(名)';
843COMMENT ON COLUMN dtb_shipping.shipping_kana01 IS '配送先カナ(姓)';
844COMMENT ON COLUMN dtb_shipping.shipping_kana02 IS '配送先カナ(名)';
845COMMENT ON COLUMN dtb_shipping.shipping_company_name IS '【2.13】配送先会社名';
846COMMENT ON COLUMN dtb_shipping.shipping_tel01 IS '配送先電話番号(市外局番)';
847COMMENT ON COLUMN dtb_shipping.shipping_tel02 IS '配送先電話番号(市内局番)';
848COMMENT ON COLUMN dtb_shipping.shipping_tel03 IS '配送先電話番号(局番)';
849COMMENT ON COLUMN dtb_shipping.shipping_fax01 IS '配送先FAX(市外局番)';
850COMMENT ON COLUMN dtb_shipping.shipping_fax02 IS '配送先FAX(市内局番)';
851COMMENT ON COLUMN dtb_shipping.shipping_fax03 IS '配送先FAX(局番)';
852COMMENT ON COLUMN dtb_shipping.shipping_country_id IS '【2.13】配送先国ID';
853COMMENT ON COLUMN dtb_shipping.shipping_pref IS '都道府県ID';
854COMMENT ON COLUMN dtb_shipping.shipping_zip01 IS '配送先郵便番号(3桁)';
855COMMENT ON COLUMN dtb_shipping.shipping_zip02 IS '配送先郵便番号(4桁)';
856COMMENT ON COLUMN dtb_shipping.shipping_zipcode IS '【2.13】配送先郵便番号(海外対応)';
857COMMENT ON COLUMN dtb_shipping.shipping_addr01 IS '配送先住所1';
858COMMENT ON COLUMN dtb_shipping.shipping_addr02 IS '配送先住所2';
859COMMENT ON COLUMN dtb_shipping.time_id IS '配送時間ID';
860COMMENT ON COLUMN dtb_shipping.shipping_time IS '配送時間';
861COMMENT ON COLUMN dtb_shipping.shipping_num IS '配送伝票番号';
862COMMENT ON COLUMN dtb_shipping.shipping_date IS '配達予定日';
863COMMENT ON COLUMN dtb_shipping.shipping_commit_date IS '発送日時';
864COMMENT ON COLUMN dtb_shipping.rank IS '表示順';
865COMMENT ON COLUMN dtb_shipping.create_date IS '作成日時';
866COMMENT ON COLUMN dtb_shipping.update_date IS '更新日時';
867COMMENT ON COLUMN dtb_shipping.del_flg IS '削除フラグ';
868
869COMMENT ON TABLE dtb_shipment_item IS '配送商品情報';
870COMMENT ON COLUMN dtb_shipment_item.product_class_id IS '商品規格ID';
871COMMENT ON COLUMN dtb_shipment_item.shipping_id IS '配送先ID';
872COMMENT ON COLUMN dtb_shipment_item.order_id IS '受注ID';
873COMMENT ON COLUMN dtb_shipment_item.product_name IS '商品名';
874COMMENT ON COLUMN dtb_shipment_item.product_code IS '商品コード';
875COMMENT ON COLUMN dtb_shipment_item.classcategory_name1 IS '商品規格名1';
876COMMENT ON COLUMN dtb_shipment_item.classcategory_name2 IS '商品規格名2';
877COMMENT ON COLUMN dtb_shipment_item.price IS '価格';
878COMMENT ON COLUMN dtb_shipment_item.quantity IS '個数';
879
880COMMENT ON TABLE dtb_delivtime IS '配送時間情報';
881COMMENT ON COLUMN dtb_delivtime.time_id IS '配送時間ID';
882COMMENT ON COLUMN dtb_delivtime.deliv_id IS '配送業者ID';
883COMMENT ON COLUMN dtb_delivtime.deliv_time IS '配送時間';
884
885COMMENT ON TABLE dtb_deliv IS '配送業者情報';
886COMMENT ON COLUMN dtb_deliv.deliv_id IS '配送業者ID';
887COMMENT ON COLUMN dtb_deliv.product_type_id IS '商品種別ID';
888COMMENT ON COLUMN dtb_deliv.name IS '配送業者名';
889COMMENT ON COLUMN dtb_deliv.service_name IS '配送サービス名';
890COMMENT ON COLUMN dtb_deliv.remark IS '説明';
891COMMENT ON COLUMN dtb_deliv.confirm_url IS '伝票確認URL';
892COMMENT ON COLUMN dtb_deliv.rank IS '表示順';
893COMMENT ON COLUMN dtb_deliv.status IS '状態';
894COMMENT ON COLUMN dtb_deliv.del_flg IS '削除フラグ';
895COMMENT ON COLUMN dtb_deliv.creator_id IS '作成者ID';
896COMMENT ON COLUMN dtb_deliv.create_date IS '作成日時';
897COMMENT ON COLUMN dtb_deliv.update_date IS '更新日時';
898
899COMMENT ON TABLE dtb_recommend_products IS '関連商品情報';
900COMMENT ON COLUMN dtb_recommend_products.recommend_product_id IS '関連商品ID';
901COMMENT ON COLUMN dtb_recommend_products.product_id IS '商品ID';
902COMMENT ON COLUMN dtb_recommend_products.rank IS '表示順';
903COMMENT ON COLUMN dtb_recommend_products.comment IS 'コメント';
904COMMENT ON COLUMN dtb_recommend_products.status IS '状態';
905COMMENT ON COLUMN dtb_recommend_products.creator_id IS '作成者ID';
906COMMENT ON COLUMN dtb_recommend_products.create_date IS '作成日時';
907COMMENT ON COLUMN dtb_recommend_products.update_date IS '更新日時';
908
909COMMENT ON TABLE dtb_send_customer IS '顧客メール送信履歴';
910COMMENT ON COLUMN dtb_send_customer.send_id IS '送信ID';
911COMMENT ON COLUMN dtb_send_customer.customer_id IS '顧客ID';
912COMMENT ON COLUMN dtb_send_customer.email IS 'メールアドレス';
913COMMENT ON COLUMN dtb_send_customer.name IS '名前';
914COMMENT ON COLUMN dtb_send_customer.send_flag IS '送信フラグ';
915
916COMMENT ON TABLE dtb_customer IS '顧客情報';
917COMMENT ON COLUMN dtb_customer.customer_id IS '顧客ID';
918COMMENT ON COLUMN dtb_customer.name01 IS '姓';
919COMMENT ON COLUMN dtb_customer.name02 IS '名';
920COMMENT ON COLUMN dtb_customer.kana01 IS '姓(カナ)';
921COMMENT ON COLUMN dtb_customer.kana02 IS '名(カナ)';
922COMMENT ON COLUMN dtb_customer.company_name IS '【2.13】国名';
923COMMENT ON COLUMN dtb_customer.zip01 IS '郵便番号(4桁)';
924COMMENT ON COLUMN dtb_customer.zip02 IS '郵便番号(3桁)';
925COMMENT ON COLUMN dtb_customer.zipcode IS '【2.13】郵便番号(海外対応)';
926COMMENT ON COLUMN dtb_customer.country_id IS '【2.13】国ID';
927COMMENT ON COLUMN dtb_customer.pref IS '都道府県';
928COMMENT ON COLUMN dtb_customer.addr01 IS '市区町村';
929COMMENT ON COLUMN dtb_customer.addr02 IS '番地等';
930COMMENT ON COLUMN dtb_customer.email IS 'メールアドレス';
931COMMENT ON COLUMN dtb_customer.email_mobile IS '携帯メールアドレス';
932COMMENT ON COLUMN dtb_customer.tel01 IS '電話(市外局番)';
933COMMENT ON COLUMN dtb_customer.tel02 IS '電話(市内局番)';
934COMMENT ON COLUMN dtb_customer.tel03 IS '電話(局番)';
935COMMENT ON COLUMN dtb_customer.fax01 IS 'FAX(市外局番)';
936COMMENT ON COLUMN dtb_customer.fax02 IS 'FAX(市内局番)';
937COMMENT ON COLUMN dtb_customer.fax03 IS 'FAX(局番)';
938COMMENT ON COLUMN dtb_customer.sex IS '性別';
939COMMENT ON COLUMN dtb_customer.job IS '職業';
940COMMENT ON COLUMN dtb_customer.birth IS '生年月日';
941COMMENT ON COLUMN dtb_customer.password IS 'パスワード';
942COMMENT ON COLUMN dtb_customer.reminder IS 'パスワードの質問';
943COMMENT ON COLUMN dtb_customer.reminder_answer IS 'パスワードの質問の答え';
944COMMENT ON COLUMN dtb_customer.salt IS '暗号化付与文字列';
945COMMENT ON COLUMN dtb_customer.secret_key IS '暗号化キー';
946COMMENT ON COLUMN dtb_customer.first_buy_date IS '初回購入日時';
947COMMENT ON COLUMN dtb_customer.last_buy_date IS '最終購入日時';
948COMMENT ON COLUMN dtb_customer.buy_times IS '購入回数';
949COMMENT ON COLUMN dtb_customer.buy_total IS '購入累計金額';
950COMMENT ON COLUMN dtb_customer.point IS '保持ポイント';
951COMMENT ON COLUMN dtb_customer.note IS '備考';
952COMMENT ON COLUMN dtb_customer.status IS '状態';
953COMMENT ON COLUMN dtb_customer.create_date IS '作成日時';
954COMMENT ON COLUMN dtb_customer.update_date IS '更新日時';
955COMMENT ON COLUMN dtb_customer.del_flg IS '削除フラグ';
956COMMENT ON COLUMN dtb_customer.mobile_phone_id IS '携帯端末ID';
957COMMENT ON COLUMN dtb_customer.mailmaga_flg IS 'メールマガジン種別フラグ';
958
959COMMENT ON TABLE dtb_maker IS 'メーカー';
960COMMENT ON COLUMN dtb_maker.maker_id IS 'メーカーID';
961COMMENT ON COLUMN dtb_maker.name IS 'メーカー名';
962COMMENT ON COLUMN dtb_maker.rank IS '表示順';
963COMMENT ON COLUMN dtb_maker.creator_id IS '作成者ID';
964COMMENT ON COLUMN dtb_maker.create_date IS '作成日時';
965COMMENT ON COLUMN dtb_maker.update_date IS '更新日時';
966COMMENT ON COLUMN dtb_maker.del_flg IS '削除フラグ';
967
968COMMENT ON TABLE dtb_maker_count IS 'メーカーカウント';
969COMMENT ON COLUMN dtb_maker_count.maker_id IS 'メーカーID';
970COMMENT ON COLUMN dtb_maker_count.product_count IS '登録商品数';
971COMMENT ON COLUMN dtb_maker_count.create_date IS '作成日時';
972
973COMMENT ON TABLE mtb_auth_excludes IS '管理画面認証除外';
974COMMENT ON COLUMN mtb_auth_excludes.id IS 'ID';
975COMMENT ON COLUMN mtb_auth_excludes.name IS '名称';
976COMMENT ON COLUMN mtb_auth_excludes.rank IS '表示順';
977
978COMMENT ON TABLE mtb_customer_status IS '顧客ステータス';
979COMMENT ON COLUMN mtb_customer_status.id IS 'ID';
980COMMENT ON COLUMN mtb_customer_status.name IS '名称';
981COMMENT ON COLUMN mtb_customer_status.rank IS '表示順';
982
983COMMENT ON TABLE mtb_customer_order_status IS '顧客表示用受注ステータス';
984COMMENT ON COLUMN mtb_customer_order_status.id IS 'ID';
985COMMENT ON COLUMN mtb_customer_order_status.name IS '名称';
986COMMENT ON COLUMN mtb_customer_order_status.rank IS '表示順';
987
988COMMENT ON TABLE dtb_bkup IS 'バックアップ';
989COMMENT ON COLUMN dtb_bkup.bkup_name IS 'バックアップ名';
990COMMENT ON COLUMN dtb_bkup.bkup_memo IS 'バックアップメモ';
991COMMENT ON COLUMN dtb_bkup.create_date IS '作成日時';
992
993COMMENT ON TABLE dtb_plugin_hookpoint IS 'プラグインフックポイント';
994COMMENT ON COLUMN dtb_plugin_hookpoint.plugin_hookpoint_id IS 'プラグインフックポイントID';
995COMMENT ON COLUMN dtb_plugin_hookpoint.plugin_id IS 'プラグインID';
996COMMENT ON COLUMN dtb_plugin_hookpoint.hook_point IS 'フックポイント';
997COMMENT ON COLUMN dtb_plugin_hookpoint.callback IS 'コールバック関数';
998COMMENT ON COLUMN dtb_plugin_hookpoint.use_flg IS '【2.13】利用フラグ';
999COMMENT ON COLUMN dtb_plugin_hookpoint.create_date IS '作成日時';
1000COMMENT ON COLUMN dtb_plugin_hookpoint.update_date IS '更新日時';
1001
1002COMMENT ON TABLE dtb_index_list IS 'インデックス一覧';
1003COMMENT ON COLUMN dtb_index_list.table_name IS 'テーブル名';
1004COMMENT ON COLUMN dtb_index_list.column_name IS 'カラム名';
1005COMMENT ON COLUMN dtb_index_list.recommend_flg IS 'レコメンドフラグ';
1006COMMENT ON COLUMN dtb_index_list.recommend_comment IS 'レコメンドフラグコメント';
1007
1008COMMENT ON TABLE dtb_api_config IS 'API設定';
1009COMMENT ON COLUMN dtb_api_config.api_config_id IS 'API設定ID';
1010COMMENT ON COLUMN dtb_api_config.operation_name IS 'オペレーション名';
1011COMMENT ON COLUMN dtb_api_config.operation_description IS '説明';
1012COMMENT ON COLUMN dtb_api_config.auth_types IS '認証タイプ';
1013COMMENT ON COLUMN dtb_api_config.enable IS '有効フラグ';
1014COMMENT ON COLUMN dtb_api_config.is_log IS 'ログ出力フラグ';
1015COMMENT ON COLUMN dtb_api_config.sub_data IS '追加の設定情報';
1016COMMENT ON COLUMN dtb_api_config.del_flg IS '削除フラグ';
1017COMMENT ON COLUMN dtb_api_config.create_date IS '作成日時';
1018COMMENT ON COLUMN dtb_api_config.update_date IS '更新日時';
1019
1020COMMENT ON TABLE dtb_api_account IS 'APIアカウント';
1021COMMENT ON COLUMN dtb_api_account.api_account_id IS 'APIアカウントID';
1022COMMENT ON COLUMN dtb_api_account.api_access_key IS 'アクセスキー';
1023COMMENT ON COLUMN dtb_api_account.api_secret_key IS 'シークレットキー';
1024COMMENT ON COLUMN dtb_api_account.enable IS '有効';
1025COMMENT ON COLUMN dtb_api_account.del_flg IS '削除フラグ';
1026COMMENT ON COLUMN dtb_api_account.create_date IS '作成日時';
1027COMMENT ON COLUMN dtb_api_account.update_date IS '更新日時';
1028
1029COMMENT ON TABLE dtb_tax_rule IS '【2.13】消費税ルール';
1030COMMENT ON COLUMN dtb_tax_rule.tax_rule_id IS '税率ID';
1031COMMENT ON COLUMN dtb_tax_rule.country_id IS '国ID';
1032COMMENT ON COLUMN dtb_tax_rule.pref_id IS '地域ID';
1033COMMENT ON COLUMN dtb_tax_rule.product_id IS '商品ID';
1034COMMENT ON COLUMN dtb_tax_rule.product_class_id IS '商品規格ID';
1035COMMENT ON COLUMN dtb_tax_rule.calc_rule IS '課税規則(四捨五入、切り上げ、切り捨て)';
1036COMMENT ON COLUMN dtb_tax_rule.tax_rate IS '消費税率';
1037COMMENT ON COLUMN dtb_tax_rule.tax_adjust IS '固定金額';
1038COMMENT ON COLUMN dtb_tax_rule.apply_date IS '適用日';
1039COMMENT ON COLUMN dtb_tax_rule.member_id IS '作成者ID';
1040COMMENT ON COLUMN dtb_tax_rule.del_flg IS '削除フラグ';
1041COMMENT ON COLUMN dtb_tax_rule.create_date IS '作成日時';
1042COMMENT ON COLUMN dtb_tax_rule.update_date IS '更新日時';
1043
1044COMMENT ON TABLE mtb_country IS '【2.13】国マスタ';
1045COMMENT ON COLUMN mtb_country.id IS 'ID';
1046COMMENT ON COLUMN mtb_country.name IS '名称';
1047COMMENT ON COLUMN mtb_country.rank IS '表示順';
Note: See TracBrowser for help on using the repository browser.