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