COMMENT ON column dtb_baseinfo.company_name IS '会社名'; COMMENT ON column dtb_baseinfo.company_kana IS '会社名（カナ）'; COMMENT ON column dtb_baseinfo.zip01 IS '郵便番号1'; COMMENT ON column dtb_baseinfo.zip02 IS '郵便番号2'; COMMENT ON column dtb_baseinfo.pref IS '都道府県'; COMMENT ON column dtb_baseinfo.addr01 IS '住所1'; COMMENT ON column dtb_baseinfo.addr02 IS '住所2'; COMMENT ON column dtb_baseinfo.tel01 IS '電話番号1'; COMMENT ON column dtb_baseinfo.tel02 IS '電話番号2'; COMMENT ON column dtb_baseinfo.tel03 IS '電話番号3'; COMMENT ON column dtb_baseinfo.fax01 IS 'FAX番号1'; COMMENT ON column dtb_baseinfo.fax02 IS 'FAX番号2'; COMMENT ON column dtb_baseinfo.fax03 IS 'FAX番号3'; COMMENT ON column dtb_baseinfo.business_hour IS '店舗営業時間'; COMMENT ON column dtb_baseinfo.law_company IS '販売業者(特定商取引)'; COMMENT ON column dtb_baseinfo.law_manager IS '運営責任者(特定商取引)'; COMMENT ON column dtb_baseinfo.law_zip01 IS '郵便番号1(特定商取引)'; COMMENT ON column dtb_baseinfo.law_zip02 IS '郵便番号2(特定商取引)'; COMMENT ON column dtb_baseinfo.law_pref IS '都道府県(特定商取引)'; COMMENT ON column dtb_baseinfo.law_addr01 IS '住所1(特定商取引)'; COMMENT ON column dtb_baseinfo.law_addr02 IS '住所2(特定商取引)'; COMMENT ON column dtb_baseinfo.law_tel01 IS '電話番号1(特定商取引)'; COMMENT ON column dtb_baseinfo.law_tel02 IS '電話番号2(特定商取引)'; COMMENT ON column dtb_baseinfo.law_tel03 IS '電話番号3(特定商取引)'; COMMENT ON column dtb_baseinfo.law_fax01 IS 'FAX番号1(特定商取引)'; COMMENT ON column dtb_baseinfo.law_fax02 IS 'FAX番号2(特定商取引)'; COMMENT ON column dtb_baseinfo.law_fax03 IS 'FAX番号3(特定商取引)'; COMMENT ON column dtb_baseinfo.law_email IS 'メールアドレス(特定商取引)'; COMMENT ON column dtb_baseinfo.law_url IS 'URL(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term01 IS '商品代金以外の必要料金(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term02 IS '注文方法(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term03 IS '支払方法(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term04 IS '支払期限(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term05 IS '引き渡し時期(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term06 IS '返品・交換について(特定商取引)'; COMMENT ON column dtb_baseinfo.law_term07 IS '予備'; COMMENT ON column dtb_baseinfo.law_term08 IS '予備'; COMMENT ON column dtb_baseinfo.law_term09 IS '予備'; COMMENT ON column dtb_baseinfo.law_term10 IS '予備'; COMMENT ON column dtb_baseinfo.tax IS '消費税'; COMMENT ON column dtb_baseinfo.tax_rule IS '1:四捨五入　2：切捨て　3:切り上げ'; COMMENT ON column dtb_baseinfo.email01 IS '受注情報受付メールアドレス'; COMMENT ON column dtb_baseinfo.email02 IS '問い合わせ受付メールアドレス'; COMMENT ON column dtb_baseinfo.email03 IS '送信エラー受付メールアドレス'; COMMENT ON column dtb_baseinfo.email04 IS 'メール送信元メールアドレス'; COMMENT ON column dtb_baseinfo.email05 IS 'メルマガ送信元メールアドレス'; COMMENT ON column dtb_baseinfo.free_rule IS '送料・手数料無料条件(円以上)'; COMMENT ON column dtb_baseinfo.shop_name IS '店名'; COMMENT ON column dtb_baseinfo.shop_kana IS '店名(カナ)'; COMMENT ON column dtb_baseinfo.point_rate IS 'ポイント付与率'; COMMENT ON column dtb_baseinfo.welcome_point IS '会員登録時付与ポイント'; COMMENT ON column dtb_baseinfo.update_date IS '更新日時'; COMMENT ON column dtb_baseinfo.top_tpl IS 'topのテンプレートファイル番号'; COMMENT ON column dtb_baseinfo.product_tpl IS '商品一覧のテンプレートファイル番号'; COMMENT ON column dtb_baseinfo.detail_tpl IS '商品詳細のテンプレートファイル番号'; COMMENT ON column dtb_baseinfo.mypage_tpl IS 'MYページのテンプレートファイル番号'; COMMENT ON column dtb_deliv.deliv_id IS '配送業者ID'; COMMENT ON column dtb_deliv.name IS '配送業者名（ヤマト運輸）'; COMMENT ON column dtb_deliv.service_name IS '名称（クロネコヤマト）'; COMMENT ON column dtb_deliv.confirm_url IS '伝票確認URL'; COMMENT ON column dtb_deliv.rank IS '表示順位'; COMMENT ON column dtb_deliv.status IS '1:有効 2:無効'; COMMENT ON column dtb_deliv.del_flg IS '0:既定 1:削除'; COMMENT ON column dtb_deliv.creator_id IS '作成者の管理者ID'; COMMENT ON column dtb_deliv.create_date IS '作成日時'; COMMENT ON column dtb_deliv.update_date IS '更新日時'; COMMENT ON column dtb_delivtime.deliv_id IS '配送ID'; COMMENT ON column dtb_delivtime.time_id IS '配送時間ID'; COMMENT ON column dtb_delivtime.time IS '配送時間'; COMMENT ON column dtb_delivfee.deliv_id IS '配送ID'; COMMENT ON column dtb_delivfee.fee_id IS '配送料金ID'; COMMENT ON column dtb_delivfee.fee IS '配送料金'; COMMENT ON column dtb_payment.payment_id IS '支払いID'; COMMENT ON column dtb_payment.payment_method IS '支払い方法'; COMMENT ON column dtb_payment.charge IS '手数料'; COMMENT ON column dtb_payment.rule IS '利用条件(円以上)'; COMMENT ON column dtb_payment.deliv_id IS '指定無しの場合:0(配送業者）'; COMMENT ON column dtb_payment.rank IS '表示順位'; COMMENT ON column dtb_payment.note IS '備考'; COMMENT ON column dtb_payment.fix IS '固定:1　自由設定:2'; COMMENT ON column dtb_payment.status IS '1:有効 2:無効'; COMMENT ON column dtb_payment.del_flg IS '0:既定 1:削除'; COMMENT ON column dtb_payment.creator_id IS '作成者ID'; COMMENT ON column dtb_payment.create_date IS '作成日時'; COMMENT ON column dtb_payment.update_date IS '更新日時'; COMMENT ON column dtb_payment.payment_image IS '支払い方法表示用ロゴ'; COMMENT ON column dtb_payment.upper_rule IS '利用条件(円以下)'; COMMENT ON column dtb_mailtemplate.template_id IS 'テンプレートID'; COMMENT ON column dtb_mailtemplate.subject IS 'メールタイトル'; COMMENT ON column dtb_mailtemplate.header IS 'ヘッダー文書'; COMMENT ON column dtb_mailtemplate.footer IS 'フッター文書'; COMMENT ON column dtb_mailtemplate.creator_id IS '作成した管理者ID'; COMMENT ON column dtb_mailtemplate.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_mailtemplate.create_date IS '作成日時'; COMMENT ON column dtb_mailtemplate.update_date IS '更新日時'; COMMENT ON column dtb_mailmaga_template.template_id IS 'テンプレートID'; COMMENT ON column dtb_mailmaga_template.subject IS '件名'; COMMENT ON column dtb_mailmaga_template.charge_image IS '担当者の写真'; COMMENT ON column dtb_mailmaga_template.mail_method IS '1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE'; COMMENT ON column dtb_mailmaga_template.header IS 'ヘッダーテキスト'; COMMENT ON column dtb_mailmaga_template.body IS '本文（テキスト登録用）'; COMMENT ON column dtb_mailmaga_template.main_title IS 'メインのタイトル（HTMLメール専用）'; COMMENT ON column dtb_mailmaga_template.main_comment IS 'メインのコメント（HTMLメール専用）'; COMMENT ON column dtb_mailmaga_template.main_product_id IS 'メインの商品ID（HTMLメール専用）'; COMMENT ON column dtb_mailmaga_template.sub_title IS 'サブタイトル'; COMMENT ON column dtb_mailmaga_template.sub_comment IS 'サブコメント'; COMMENT ON column dtb_mailmaga_template.sub_product_id01 IS 'サブ商品ID1'; COMMENT ON column dtb_mailmaga_template.sub_product_id02 IS 'サブ商品ID2'; COMMENT ON column dtb_mailmaga_template.sub_product_id03 IS 'サブ商品ID3'; COMMENT ON column dtb_mailmaga_template.sub_product_id04 IS 'サブ商品ID4'; COMMENT ON column dtb_mailmaga_template.sub_product_id05 IS 'サブ商品ID5'; COMMENT ON column dtb_mailmaga_template.sub_product_id06 IS 'サブ商品ID6'; COMMENT ON column dtb_mailmaga_template.sub_product_id07 IS 'サブ商品ID7'; COMMENT ON column dtb_mailmaga_template.sub_product_id08 IS 'サブ商品ID8'; COMMENT ON column dtb_mailmaga_template.sub_product_id09 IS 'サブ商品ID9'; COMMENT ON column dtb_mailmaga_template.sub_product_id10 IS 'サブ商品ID10'; COMMENT ON column dtb_mailmaga_template.sub_product_id11 IS 'サブ商品ID11'; COMMENT ON column dtb_mailmaga_template.sub_product_id12 IS 'サブ商品ID12'; COMMENT ON column dtb_mailmaga_template.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_mailmaga_template.creator_id IS '作成者ID'; COMMENT ON column dtb_mailmaga_template.create_date IS '作成日時'; COMMENT ON column dtb_mailmaga_template.update_date IS '更新日時'; COMMENT ON column dtb_send_history.send_id IS '配信ID'; COMMENT ON column dtb_send_history.mail_method IS '1:テキスト 2:HTML'; COMMENT ON column dtb_send_history.subject IS 'メール件名'; COMMENT ON column dtb_send_history.body IS 'メール内容'; COMMENT ON column dtb_send_history.send_count IS '送信数'; COMMENT ON column dtb_send_history.complete_count IS '送信完了数'; COMMENT ON column dtb_send_history.start_date IS '送信開始'; COMMENT ON column dtb_send_history.end_date IS '送信停止'; COMMENT ON column dtb_send_history.search_data IS '検索条件'; COMMENT ON column dtb_send_history.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_send_history.creator_id IS '作成者ID'; COMMENT ON column dtb_send_history.create_date IS '作成日時'; COMMENT ON column dtb_send_history.update_date IS '更新日時'; COMMENT ON column dtb_send_customer.customer_id IS '顧客ID'; COMMENT ON column dtb_send_customer.send_id IS '配信履歴ID'; COMMENT ON column dtb_send_customer.email IS '送信先メールアドレス'; COMMENT ON column dtb_send_customer.name IS '名前'; COMMENT ON column dtb_send_customer.send_flag IS '1:送信済み　2:送信失敗'; COMMENT ON column dtb_products.product_id IS '商品ID'; COMMENT ON column dtb_products.name IS '商品名'; COMMENT ON column dtb_products.deliv_fee IS '商品送料'; COMMENT ON column dtb_products.sale_limit IS '購入制限数'; COMMENT ON column dtb_products.sale_unlimited IS '購入制限（1:購入制限無し)'; COMMENT ON column dtb_products.category_id IS '商品カテゴリー'; COMMENT ON column dtb_products.rank IS '表示ランク'; COMMENT ON column dtb_products.status IS '1:表示、2:非表示、3:削除'; COMMENT ON column dtb_products.product_flag IS '"1:NEW 2:お勧め 3:注目 4:限定"'; COMMENT ON column dtb_products.point_rate IS 'ポイント付与率'; COMMENT ON column dtb_products.comment1 IS 'コメント1'; COMMENT ON column dtb_products.comment2 IS 'コメント2'; COMMENT ON column dtb_products.comment3 IS 'コメント3'; COMMENT ON column dtb_products.comment4 IS 'コメント4'; COMMENT ON column dtb_products.comment5 IS 'コメント5'; COMMENT ON column dtb_products.comment6 IS 'コメント6'; COMMENT ON column dtb_products.file1 IS 'アップロードファイル1'; COMMENT ON column dtb_products.file2 IS 'アップロードファイル2'; COMMENT ON column dtb_products.file3 IS 'アップロードファイル3'; COMMENT ON column dtb_products.file4 IS 'アップロードファイル4'; COMMENT ON column dtb_products.file5 IS 'アップロードファイル5'; COMMENT ON column dtb_products.file6 IS 'アップロードファイル6'; COMMENT ON column dtb_products.main_list_comment IS 'メイン一覧コメント'; COMMENT ON column dtb_products.main_list_image IS 'メイン一覧画像'; COMMENT ON column dtb_products.main_comment IS 'メインコメント'; COMMENT ON column dtb_products.main_image IS 'メイン画像'; COMMENT ON column dtb_products.main_large_image IS 'メイン拡大画像'; COMMENT ON column dtb_products.sub_title1 IS 'サブタイトル1'; COMMENT ON column dtb_products.sub_comment1 IS 'サブコメント1'; COMMENT ON column dtb_products.sub_image1 IS 'サブ通常画像1'; COMMENT ON column dtb_products.sub_large_image1 IS 'サブ拡大画像1'; COMMENT ON column dtb_products.sub_title2 IS 'サブタイトル2'; COMMENT ON column dtb_products.sub_comment2 IS 'サブコメント2'; COMMENT ON column dtb_products.sub_image2 IS 'サブ通常画像2'; COMMENT ON column dtb_products.sub_large_image2 IS 'サブ拡大画像2'; COMMENT ON column dtb_products.sub_title3 IS 'サブタイトル3'; COMMENT ON column dtb_products.sub_comment3 IS 'サブコメント3'; COMMENT ON column dtb_products.sub_image3 IS 'サブ通常画像3'; COMMENT ON column dtb_products.sub_large_image3 IS 'サブ拡大画像3'; COMMENT ON column dtb_products.sub_title4 IS 'サブタイトル4'; COMMENT ON column dtb_products.sub_comment4 IS 'サブコメント4'; COMMENT ON column dtb_products.sub_image4 IS 'サブ通常画像4'; COMMENT ON column dtb_products.sub_large_image4 IS 'サブ拡大画像4'; COMMENT ON column dtb_products.sub_title5 IS 'サブタイトル5'; COMMENT ON column dtb_products.sub_comment5 IS 'サブコメント5'; COMMENT ON column dtb_products.sub_image5 IS 'サブ通常画像5'; COMMENT ON column dtb_products.sub_large_image5 IS 'サブ拡大画像5'; COMMENT ON column dtb_products.sub_title6 IS 'サブタイトル6'; COMMENT ON column dtb_products.sub_comment6 IS 'サブコメント6'; COMMENT ON column dtb_products.sub_image6 IS 'サブ通常画像6'; COMMENT ON column dtb_products.sub_large_image6 IS 'サブ拡大画像6'; COMMENT ON column dtb_products.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_products.creator_id IS '作成者ID'; COMMENT ON column dtb_products.create_date IS '作成日時'; COMMENT ON column dtb_products.update_date IS '更新日時'; COMMENT ON column dtb_products.deliv_date_id IS '発送日目安(conf.php参照)'; COMMENT ON column dtb_products_class.product_class_id IS '商品規格ID'; COMMENT ON column dtb_products_class.product_id IS '商品ID'; COMMENT ON column dtb_products_class.classcategory_id1 IS '規格分類ID1(規格なしの場合0)'; COMMENT ON column dtb_products_class.classcategory_id2 IS '規格分類ID2（規格なしの場合:0)'; COMMENT ON column dtb_products_class.product_code IS '商品コード'; COMMENT ON column dtb_products_class.stock IS '在庫数'; COMMENT ON column dtb_products_class.stock_unlimited IS '在庫制限（1:無制限)'; COMMENT ON column dtb_products_class.sale_limit IS '販売制限'; COMMENT ON column dtb_products_class.price01 IS '価格'; COMMENT ON column dtb_products_class.price02 IS '商品価格'; COMMENT ON column dtb_products_class.status IS '状態（表示:1、非表示:2）'; COMMENT ON column dtb_products_class.creator_id IS '作成者ID'; COMMENT ON column dtb_products_class.create_date IS '作成日時'; COMMENT ON column dtb_products_class.update_date IS '更新日時'; COMMENT ON column dtb_class.class_id IS '規格ID'; COMMENT ON column dtb_class.name IS '規格名'; COMMENT ON column dtb_class.status IS '状態'; COMMENT ON column dtb_class.rank IS '表示順位'; COMMENT ON column dtb_class.creator_id IS '作成者ID'; COMMENT ON column dtb_class.create_date IS '作成日時'; COMMENT ON column dtb_class.update_date IS '更新日時'; COMMENT ON column dtb_class.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_class.product_id IS 'null：マスタ登録データ'; COMMENT ON column dtb_classcategory.classcategory_id IS '規格分類ID'; COMMENT ON column dtb_classcategory.name IS '規格分類名'; COMMENT ON column dtb_classcategory.class_id IS '規格ID'; COMMENT ON column dtb_classcategory.status IS '状態'; COMMENT ON column dtb_classcategory.rank IS '表示順位'; COMMENT ON column dtb_classcategory.creator_id IS '作成者ID'; COMMENT ON column dtb_classcategory.create_date IS '作成日時'; COMMENT ON column dtb_classcategory.update_date IS '更新日時'; COMMENT ON column dtb_classcategory.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_category.category_id IS '分類ID'; COMMENT ON column dtb_category.category_name IS '分類名'; COMMENT ON column dtb_category.parent_category_id IS 'rootの場合:0'; COMMENT ON column dtb_category.level IS '階層'; COMMENT ON column dtb_category.rank IS '表示順位'; COMMENT ON column dtb_category.creator_id IS '作成者の管理者ID'; COMMENT ON column dtb_category.create_date IS '作成日時'; COMMENT ON column dtb_category.update_date IS '更新日時'; COMMENT ON column dtb_category.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_bat_order_daily.total_order IS '購入件数'; COMMENT ON column dtb_bat_order_daily.member IS '会員'; COMMENT ON column dtb_bat_order_daily.nonmember IS '非会員'; COMMENT ON column dtb_bat_order_daily.men IS '男性'; COMMENT ON column dtb_bat_order_daily.women IS '女性'; COMMENT ON column dtb_bat_order_daily.men_member IS '男性会員'; COMMENT ON column dtb_bat_order_daily.men_nonmember IS '男性非会員'; COMMENT ON column dtb_bat_order_daily.women_member IS '女性会員'; COMMENT ON column dtb_bat_order_daily.women_nonmember IS '女性非会員'; COMMENT ON column dtb_bat_order_daily.total IS '購入合計'; COMMENT ON column dtb_bat_order_daily.total_average IS '購入平均'; COMMENT ON column dtb_bat_order_daily.order_date IS '購入日'; COMMENT ON column dtb_bat_order_daily.create_date IS '集計日'; COMMENT ON column dtb_bat_order_daily.year IS '年'; COMMENT ON column dtb_bat_order_daily.month IS '月'; COMMENT ON column dtb_bat_order_daily.day IS '日'; COMMENT ON column dtb_bat_order_daily.wday IS '曜日'; COMMENT ON column dtb_bat_order_daily.key_day IS '日別用キー'; COMMENT ON column dtb_bat_order_daily.key_month IS '月別用キー'; COMMENT ON column dtb_bat_order_daily.key_year IS '年別用キー'; COMMENT ON column dtb_bat_order_daily.key_wday IS '曜日別用キー'; COMMENT ON column dtb_bat_order_daily_hour.total_order IS '購入件数'; COMMENT ON column dtb_bat_order_daily_hour.member IS '会員'; COMMENT ON column dtb_bat_order_daily_hour.nonmember IS '非会員'; COMMENT ON column dtb_bat_order_daily_hour.men IS '男性'; COMMENT ON column dtb_bat_order_daily_hour.women IS '女性'; COMMENT ON column dtb_bat_order_daily_hour.men_member IS '男性会員'; COMMENT ON column dtb_bat_order_daily_hour.men_nonmember IS '男性非会員'; COMMENT ON column dtb_bat_order_daily_hour.women_member IS '女性会員'; COMMENT ON column dtb_bat_order_daily_hour.women_nonmember IS '女性非会員'; COMMENT ON column dtb_bat_order_daily_hour.total IS '購入合計'; COMMENT ON column dtb_bat_order_daily_hour.total_average IS '購入平均'; COMMENT ON column dtb_bat_order_daily_hour.hour IS '購入時間'; COMMENT ON column dtb_bat_order_daily_hour.order_date IS '購入日'; COMMENT ON column dtb_bat_order_daily_hour.create_date IS '集計日'; COMMENT ON column dtb_recommend_products.product_id IS '商品ID'; COMMENT ON column dtb_recommend_products.recommend_product_id IS 'リコメンド商品ID'; COMMENT ON column dtb_recommend_products.rank IS '表示順位'; COMMENT ON column dtb_recommend_products.comment IS 'コメント'; COMMENT ON column dtb_recommend_products.status IS '0:手動登録、1:自動登録'; COMMENT ON column dtb_recommend_products.creator_id IS '作成者ID'; COMMENT ON column dtb_recommend_products.create_date IS '作成日時'; COMMENT ON column dtb_recommend_products.update_date IS '更新日時'; COMMENT ON column dtb_review.review_id IS 'レビューID'; COMMENT ON column dtb_review.product_id IS '商品ID'; COMMENT ON column dtb_review.reviewer_name IS '投稿者名'; COMMENT ON column dtb_review.reviewer_url IS '投稿者URL'; COMMENT ON column dtb_review.sex IS '男性:1、女性:2'; COMMENT ON column dtb_review.customer_id IS '会員ID'; COMMENT ON column dtb_review.recommend_level IS 'おすすめレベル'; COMMENT ON column dtb_review.title IS '題名'; COMMENT ON column dtb_review.comment IS 'コメント'; COMMENT ON column dtb_review.status IS '1:表示 2:非表示 3:削除'; COMMENT ON column dtb_review.creator_id IS '作成者の管理者ID'; COMMENT ON column dtb_review.create_date IS '作成日時'; COMMENT ON column dtb_review.update_date IS '更新日時'; COMMENT ON column dtb_review.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_customer_reading.reading_product_id IS '閲覧商品ID'; COMMENT ON column dtb_customer_reading.customer_id IS '会員ID'; COMMENT ON column dtb_customer_reading.create_date IS '作成日時'; COMMENT ON column dtb_customer_reading.update_date IS '更新日時'; COMMENT ON column dtb_category_count.category_id IS '分類ID'; COMMENT ON column dtb_category_count.product_count IS '商品数'; COMMENT ON column dtb_category_count.create_date IS '作成日時'; COMMENT ON column dtb_category_total_count.category_id IS '分類ID'; COMMENT ON column dtb_category_total_count.product_count IS '商品数'; COMMENT ON column dtb_category_total_count.create_date IS '作成日時'; COMMENT ON column dtb_news.news_id IS '新着ID'; COMMENT ON column dtb_news.news_date IS '表示日'; COMMENT ON column dtb_news.rank IS '表示順位'; COMMENT ON column dtb_news.news_comment IS 'コメント'; COMMENT ON column dtb_news.news_url IS 'URL'; COMMENT ON column dtb_news.link_method IS '1:内部リンク 2:外部リンク（別ウィンドウで）'; COMMENT ON column dtb_news.creator_id IS '作成者ID'; COMMENT ON column dtb_news.create_date IS '作成日時'; COMMENT ON column dtb_news.update_date IS '更新日時'; COMMENT ON column dtb_news.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_best_products.best_id IS '注文ID'; COMMENT ON column dtb_best_products.category_id IS 'カテゴリID'; COMMENT ON column dtb_best_products.rank IS '順位'; COMMENT ON column dtb_best_products.product_id IS '商品ID'; COMMENT ON column dtb_best_products.title IS '見出し'; COMMENT ON column dtb_best_products.comment IS 'コメント'; COMMENT ON column dtb_best_products.creator_id IS '作成者ID'; COMMENT ON column dtb_best_products.create_date IS '作成日時'; COMMENT ON column dtb_best_products.update_date IS '更新日時'; COMMENT ON column dtb_best_products.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_mail_history.send_id IS '送信ID'; COMMENT ON column dtb_mail_history.order_id IS '注文ID'; COMMENT ON column dtb_mail_history.send_date IS '送信日時'; COMMENT ON column dtb_mail_history.template_id IS 'メールテンプレートID'; COMMENT ON column dtb_mail_history.creator_id IS '管理者ID'; COMMENT ON column dtb_mail_history.subject IS '件名'; COMMENT ON column dtb_mail_history.mail_body IS '本文'; COMMENT ON column dtb_customer.customer_id IS '顧客ID'; COMMENT ON column dtb_customer.name01 IS '顧客名'; COMMENT ON column dtb_customer.name02 IS '顧客名'; COMMENT ON column dtb_customer.kana01 IS '顧客名カナ'; COMMENT ON column dtb_customer.kana02 IS '顧客名カナ'; COMMENT ON column dtb_customer.zip01 IS '郵便番号1'; COMMENT ON column dtb_customer.zip02 IS '郵便番号2'; COMMENT ON column dtb_customer.pref IS '都道府県'; COMMENT ON column dtb_customer.addr01 IS '住所1'; COMMENT ON column dtb_customer.addr02 IS '住所2'; COMMENT ON column dtb_customer.email IS 'メール'; COMMENT ON column dtb_customer.email_mobile IS '携帯メール'; COMMENT ON column dtb_customer.tel01 IS '電話番号1'; COMMENT ON column dtb_customer.tel02 IS '電話番号2'; COMMENT ON column dtb_customer.tel03 IS '電話番号3'; COMMENT ON column dtb_customer.fax01 IS 'FAX1'; COMMENT ON column dtb_customer.fax02 IS 'FAX2'; COMMENT ON column dtb_customer.fax03 IS 'FAX3'; COMMENT ON column dtb_customer.sex IS '1:男　2:女'; COMMENT ON column dtb_customer.job IS '職業'; COMMENT ON column dtb_customer.birth IS '誕生日'; COMMENT ON column dtb_customer.password IS 'パスワード'; COMMENT ON column dtb_customer.reminder IS 'パスワード質問'; COMMENT ON column dtb_customer.reminder_answer IS 'パスワード答え'; COMMENT ON column dtb_customer.secret_key IS '暗号化顧客ID'; COMMENT ON column dtb_customer.first_buy_date IS '初回購入'; COMMENT ON column dtb_customer.last_buy_date IS '最終購入'; COMMENT ON column dtb_customer.buy_times IS '購入回数'; COMMENT ON column dtb_customer.buy_total IS '購入累計金額'; COMMENT ON column dtb_customer.point IS 'ポイント'; COMMENT ON column dtb_customer.note IS 'SHOPメモ'; COMMENT ON column dtb_customer.status IS '1:仮登録 2:登録 3:停止 4:非会員'; COMMENT ON column dtb_customer.create_date IS '作成日時'; COMMENT ON column dtb_customer.update_date IS '更新日時'; COMMENT ON column dtb_customer.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_customer.cell01 IS '携帯電話番号1'; COMMENT ON column dtb_customer.cell02 IS '携帯電話番号2'; COMMENT ON column dtb_customer.cell03 IS '携帯電話番号3'; COMMENT ON column dtb_customer_mail.email IS 'メールアドレス'; COMMENT ON column dtb_customer_mail.mail_flag IS '1:HTML 2:TEXT 3:希望しない 4:仮登録（HTML） 5:仮登録(TEXT) 6:仮登録(希望しない)'; COMMENT ON column dtb_customer_mail_temp.email IS 'メールアドレス'; COMMENT ON column dtb_customer_mail_temp.mail_flag IS '1:HTML 2:TEXT 3:希望しない(停止)'; COMMENT ON column dtb_customer_mail_temp.temp_id IS '一時ＩＤ'; COMMENT ON column dtb_customer_mail_temp.end_flag IS '0:未処理 1:処理済'; COMMENT ON column dtb_customer_mail_temp.update_date IS '更新日'; COMMENT ON column dtb_customer_mail_temp.create_data IS '作成日'; COMMENT ON column dtb_order.order_id IS '注文ID'; COMMENT ON column dtb_order.order_temp_id IS '注文一時ID'; COMMENT ON column dtb_order.customer_id IS '顧客ID(非会員の場合は、0)'; COMMENT ON column dtb_order.message IS '要望等'; COMMENT ON column dtb_order.order_name01 IS '顧客名'; COMMENT ON column dtb_order.order_name02 IS '顧客名'; COMMENT ON column dtb_order.order_kana01 IS '顧客名カナ'; COMMENT ON column dtb_order.order_kana02 IS '顧客名カナ'; COMMENT ON column dtb_order.order_email IS '受注時のメールアドレス'; COMMENT ON column dtb_order.order_tel01 IS '電話番号1'; COMMENT ON column dtb_order.order_tel02 IS '電話番号2'; COMMENT ON column dtb_order.order_tel03 IS '電話番号3'; COMMENT ON column dtb_order.order_fax01 IS 'FAX1'; COMMENT ON column dtb_order.order_fax02 IS 'FAX2'; COMMENT ON column dtb_order.order_fax03 IS 'FAX3'; COMMENT ON column dtb_order.order_zip01 IS '郵便番号1'; COMMENT ON column dtb_order.order_zip02 IS '郵便番号2'; COMMENT ON column dtb_order.order_pref IS '都道府県'; COMMENT ON column dtb_order.order_addr01 IS '住所1'; COMMENT ON column dtb_order.order_addr02 IS '住所2'; COMMENT ON column dtb_order.order_sex IS '性別(1:男性、2:女性)'; COMMENT ON column dtb_order.order_birth IS '生年月日'; COMMENT ON column dtb_order.order_job IS '職種'; COMMENT ON column dtb_order.deliv_name01 IS '配送先名前'; COMMENT ON column dtb_order.deliv_name02 IS '配送先名前'; COMMENT ON column dtb_order.deliv_kana01 IS '配送先カナ'; COMMENT ON column dtb_order.deliv_kana02 IS '配送先カナ'; COMMENT ON column dtb_order.deliv_tel01 IS '電話番号1'; COMMENT ON column dtb_order.deliv_tel02 IS '電話番号2'; COMMENT ON column dtb_order.deliv_tel03 IS '電話番号3'; COMMENT ON column dtb_order.deliv_fax01 IS 'FAX1'; COMMENT ON column dtb_order.deliv_fax02 IS 'FAX2'; COMMENT ON column dtb_order.deliv_fax03 IS 'FAX3'; COMMENT ON column dtb_order.deliv_zip01 IS '郵便番号1'; COMMENT ON column dtb_order.deliv_zip02 IS '郵便番号2'; COMMENT ON column dtb_order.deliv_pref IS '都道府県'; COMMENT ON column dtb_order.deliv_addr01 IS '住所1'; COMMENT ON column dtb_order.deliv_addr02 IS '住所2'; COMMENT ON column dtb_order.subtotal IS '小計'; COMMENT ON column dtb_order.discount IS '値引き'; COMMENT ON column dtb_order.deliv_fee IS '送料'; COMMENT ON column dtb_order.charge IS '手数料'; COMMENT ON column dtb_order.use_point IS '使用ポイント'; COMMENT ON column dtb_order.add_point IS '加算ポイント'; COMMENT ON column dtb_order.birth_point IS 'お誕生日ポイント'; COMMENT ON column dtb_order.tax IS '税金'; COMMENT ON column dtb_order.total IS '合計'; COMMENT ON column dtb_order.payment_total IS 'お支払い合計(ポイント差し引き合計)'; COMMENT ON column dtb_order.payment_id IS '支払い方法ID'; COMMENT ON column dtb_order.payment_method IS '支払い方法'; COMMENT ON column dtb_order.deliv_id IS '配送業者ID'; COMMENT ON column dtb_order.deliv_time_id IS '配送時間ID'; COMMENT ON column dtb_order.deliv_time IS '配送時間'; COMMENT ON column dtb_order.deliv_no IS '配送伝票番号'; COMMENT ON column dtb_order.note IS 'SHOPメモ'; COMMENT ON column dtb_order.status IS '1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み'; COMMENT ON column dtb_order.create_date IS '作成日時'; COMMENT ON column dtb_order.loan_result IS 'ローン受付結果'; COMMENT ON column dtb_order.credit_result IS 'クレジット受付結果'; COMMENT ON column dtb_order.credit_msg IS 'クレジット受付メッセージ'; COMMENT ON column dtb_order.update_date IS '更新日時'; COMMENT ON column dtb_order.commit_date IS '発送済みステータスに変更した日'; COMMENT ON column dtb_order.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_order.deliv_date IS '配達日'; COMMENT ON column dtb_order.conveni_data IS 'コンビニ決済情報'; COMMENT ON column dtb_order.cell01 IS '携帯電話番号1'; COMMENT ON column dtb_order.cell02 IS '携帯電話番号2'; COMMENT ON column dtb_order.cell03 IS '携帯電話番号3'; COMMENT ON column dtb_order_temp.order_temp_id IS '注文一時ID'; COMMENT ON column dtb_order_temp.customer_id IS '顧客ID(非会員の場合は、0)'; COMMENT ON column dtb_order_temp.message IS '要望等'; COMMENT ON column dtb_order_temp.order_name01 IS '顧客名'; COMMENT ON column dtb_order_temp.order_name02 IS '顧客名'; COMMENT ON column dtb_order_temp.order_kana01 IS '顧客名カナ'; COMMENT ON column dtb_order_temp.order_kana02 IS '顧客名カナ'; COMMENT ON column dtb_order_temp.order_email IS '受注時のメールアドレス'; COMMENT ON column dtb_order_temp.order_tel01 IS '電話番号1'; COMMENT ON column dtb_order_temp.order_tel02 IS '電話番号2'; COMMENT ON column dtb_order_temp.order_tel03 IS '電話番号3'; COMMENT ON column dtb_order_temp.order_fax01 IS 'FAX1'; COMMENT ON column dtb_order_temp.order_fax02 IS 'FAX2'; COMMENT ON column dtb_order_temp.order_fax03 IS 'FAX3'; COMMENT ON column dtb_order_temp.order_zip01 IS '郵便番号1'; COMMENT ON column dtb_order_temp.order_zip02 IS '郵便番号2'; COMMENT ON column dtb_order_temp.order_pref IS '都道府県'; COMMENT ON column dtb_order_temp.order_addr01 IS '住所1'; COMMENT ON column dtb_order_temp.order_addr02 IS '住所2'; COMMENT ON column dtb_order_temp.order_sex IS '性別(1:男性、2:女性)'; COMMENT ON column dtb_order_temp.order_birth IS '生年月日'; COMMENT ON column dtb_order_temp.order_job IS '職種'; COMMENT ON column dtb_order_temp.deliv_name01 IS '配送先名前'; COMMENT ON column dtb_order_temp.deliv_name02 IS '配送先名前'; COMMENT ON column dtb_order_temp.deliv_kana01 IS '配送先カナ'; COMMENT ON column dtb_order_temp.deliv_kana02 IS '配送先カナ'; COMMENT ON column dtb_order_temp.deliv_tel01 IS '電話番号1'; COMMENT ON column dtb_order_temp.deliv_tel02 IS '電話番号2'; COMMENT ON column dtb_order_temp.deliv_tel03 IS '電話番号3'; COMMENT ON column dtb_order_temp.deliv_fax01 IS 'FAX1'; COMMENT ON column dtb_order_temp.deliv_fax02 IS 'FAX2'; COMMENT ON column dtb_order_temp.deliv_fax03 IS 'FAX3'; COMMENT ON column dtb_order_temp.deliv_zip01 IS '郵便番号1'; COMMENT ON column dtb_order_temp.deliv_zip02 IS '郵便番号2'; COMMENT ON column dtb_order_temp.deliv_pref IS '都道府県'; COMMENT ON column dtb_order_temp.deliv_addr01 IS '住所1'; COMMENT ON column dtb_order_temp.deliv_addr02 IS '住所2'; COMMENT ON column dtb_order_temp.subtotal IS '小計'; COMMENT ON column dtb_order_temp.discount IS '値引き'; COMMENT ON column dtb_order_temp.deliv_fee IS '送料'; COMMENT ON column dtb_order_temp.charge IS '手数料'; COMMENT ON column dtb_order_temp.use_point IS '使用ポイント'; COMMENT ON column dtb_order_temp.add_point IS '加算ポイント'; COMMENT ON column dtb_order_temp.birth_point IS 'お誕生日ポイント'; COMMENT ON column dtb_order_temp.tax IS '税金'; COMMENT ON column dtb_order_temp.total IS '合計'; COMMENT ON column dtb_order_temp.payment_total IS 'お支払い合計(ポイント差し引き合計)'; COMMENT ON column dtb_order_temp.payment_id IS '支払い方法ID'; COMMENT ON column dtb_order_temp.payment_method IS '支払い方法（文字列）'; COMMENT ON column dtb_order_temp.deliv_id IS '配送業者ID'; COMMENT ON column dtb_order_temp.deliv_time_id IS '配送時間ID'; COMMENT ON column dtb_order_temp.deliv_time IS '配送時間（文字列）'; COMMENT ON column dtb_order_temp.deliv_no IS '配送伝票番号'; COMMENT ON column dtb_order_temp.note IS 'SHOPメモ'; COMMENT ON column dtb_order_temp.mail_flag IS 'メルマガ希望'; COMMENT ON column dtb_order_temp.status IS '1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み'; COMMENT ON column dtb_order_temp.deliv_check IS '1:別のお届け先を指定している場合'; COMMENT ON column dtb_order_temp.point_check IS '1:ポイントを使用する。2:ポイントを使用しない。'; COMMENT ON column dtb_order_temp.loan_result IS 'ローン受付結果'; COMMENT ON column dtb_order_temp.credit_result IS 'クレジット受付結果'; COMMENT ON column dtb_order_temp.credit_msg IS 'クレジット受付メッセージ'; COMMENT ON column dtb_order_temp.create_date IS '作成日時'; COMMENT ON column dtb_order_temp.update_date IS '更新日時'; COMMENT ON column dtb_order_temp.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_order_temp.deliv_date IS '配達日'; COMMENT ON column dtb_order_temp.conveni_data IS 'コンビニ決済情報'; COMMENT ON column dtb_order_temp.cell01 IS '携帯電話番号1'; COMMENT ON column dtb_order_temp.cell02 IS '携帯電話番号2'; COMMENT ON column dtb_order_temp.cell03 IS '携帯電話番号3'; COMMENT ON column dtb_other_deliv.other_deliv_id IS '別のお届け先ID'; COMMENT ON column dtb_other_deliv.customer_id IS '顧客ID'; COMMENT ON column dtb_other_deliv.name01 IS '配送先名前'; COMMENT ON column dtb_other_deliv.name02 IS '配送先名前'; COMMENT ON column dtb_other_deliv.kana01 IS '配送先カナ'; COMMENT ON column dtb_other_deliv.kana02 IS '配送先カナ'; COMMENT ON column dtb_other_deliv.zip01 IS '郵便番号1'; COMMENT ON column dtb_other_deliv.zip02 IS '郵便番号2'; COMMENT ON column dtb_other_deliv.pref IS '都道府県'; COMMENT ON column dtb_other_deliv.addr01 IS '住所1'; COMMENT ON column dtb_other_deliv.addr02 IS '住所2'; COMMENT ON column dtb_other_deliv.tel01 IS '電話番号1'; COMMENT ON column dtb_other_deliv.tel02 IS '電話番号2'; COMMENT ON column dtb_other_deliv.tel03 IS '電話番号3'; COMMENT ON column dtb_order_detail.order_id IS '注文ID'; COMMENT ON column dtb_order_detail.product_id IS '商品ID'; COMMENT ON column dtb_order_detail.classcategory_id1 IS '規格分類ID1'; COMMENT ON column dtb_order_detail.classcategory_id2 IS '規格分類ID2'; COMMENT ON column dtb_order_detail.product_name IS '商品名'; COMMENT ON column dtb_order_detail.product_code IS '商品コード'; COMMENT ON column dtb_order_detail.classcategory_name1 IS '規格名1'; COMMENT ON column dtb_order_detail.classcategory_name2 IS '規格名2'; COMMENT ON column dtb_order_detail.price IS '価格'; COMMENT ON column dtb_order_detail.quantity IS '個数'; COMMENT ON column dtb_order_detail.point_rate IS 'ポイント付与率'; COMMENT ON column mtb_pref.pref_id IS '都道府県ID'; COMMENT ON column mtb_pref.pref_name IS '都道府県名'; COMMENT ON column mtb_pref.rank IS '表示順位'; COMMENT ON column dtb_member.member_id IS '管理者ID'; COMMENT ON column dtb_member.name IS '管理者名称'; COMMENT ON column dtb_member.department IS '部門'; COMMENT ON column dtb_member.login_id IS 'ログインID'; COMMENT ON column dtb_member.password IS 'パスワード'; COMMENT ON column dtb_member.authority IS '権限'; COMMENT ON column dtb_member.rank IS '順位'; COMMENT ON column dtb_member.work IS '稼働:1、非稼働:2'; COMMENT ON column dtb_member.del_flg IS '削除フラグ'; COMMENT ON column dtb_member.creator_id IS '作成者'; COMMENT ON column dtb_member.update_date IS '更新日'; COMMENT ON column dtb_member.create_date IS '作成日'; COMMENT ON column dtb_member.login_date IS 'ログイン日'; COMMENT ON column dtb_question.question_id IS '質問ID'; COMMENT ON column dtb_question.question_name IS '質問名'; COMMENT ON column dtb_question.question IS '質問内容'; COMMENT ON column dtb_question.create_date IS '作成日時'; COMMENT ON column dtb_question.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_question_result.result_id IS '結果ID'; COMMENT ON column dtb_question_result.question_id IS '質問ID'; COMMENT ON column dtb_question_result.question_date IS '質問日'; COMMENT ON column dtb_question_result.question_name IS '質問名'; COMMENT ON column dtb_question_result.name01 IS '回答者名'; COMMENT ON column dtb_question_result.name02 IS '回答者名'; COMMENT ON column dtb_question_result.kana01 IS '回答者名'; COMMENT ON column dtb_question_result.kana02 IS '回答者名'; COMMENT ON column dtb_question_result.zip01 IS '郵便番号1'; COMMENT ON column dtb_question_result.zip02 IS '郵便番号2'; COMMENT ON column dtb_question_result.pref IS '都道府県'; COMMENT ON column dtb_question_result.addr01 IS '住所1'; COMMENT ON column dtb_question_result.addr02 IS '住所2'; COMMENT ON column dtb_question_result.tel01 IS '電話番号1'; COMMENT ON column dtb_question_result.tel02 IS '電話番号2'; COMMENT ON column dtb_question_result.tel03 IS '電話番号3'; COMMENT ON column dtb_question_result.mail01 IS 'メールアドレス'; COMMENT ON column dtb_question_result.question01 IS '回答内容'; COMMENT ON column dtb_question_result.question02 IS '回答内容'; COMMENT ON column dtb_question_result.question03 IS '回答内容'; COMMENT ON column dtb_question_result.question04 IS '回答内容'; COMMENT ON column dtb_question_result.question05 IS '回答内容'; COMMENT ON column dtb_question_result.question06 IS '回答内容'; COMMENT ON column dtb_question_result.create_date IS '作成日時'; COMMENT ON column dtb_question_result.del_flg IS '0:既定、1:削除'; COMMENT ON column dtb_bat_relate_products.product_id IS 'この商品ID'; COMMENT ON column dtb_bat_relate_products.relate_product_id IS 'こんな商品ID'; COMMENT ON column dtb_bat_relate_products.customer_id IS '顧客ID'; COMMENT ON column dtb_bat_relate_products.create_date IS '集計日時'; COMMENT ON column dtb_campaign.campaign_id IS 'キャンペーンID'; COMMENT ON column dtb_campaign.campaign_name IS 'キャンペーン名'; COMMENT ON column dtb_campaign.campaign_point_rate IS 'キャンペーンポイント'; COMMENT ON column dtb_campaign.campaign_point_type IS 'キャンペーンタイプ'; COMMENT ON column dtb_campaign.start_date IS 'キャンペーン開始期間'; COMMENT ON column dtb_campaign.end_date IS 'キャンペーン終了期間'; COMMENT ON column dtb_campaign.search_condition IS '検索条件'; COMMENT ON column dtb_campaign.del_flg IS '0:既定　1:削除'; COMMENT ON column dtb_campaign.create_date IS '作成日時'; COMMENT ON column dtb_campaign.update_date IS '更新日時'; COMMENT ON column dtb_campaign_detail.campaign_id IS 'キャンペーンID'; COMMENT ON column dtb_campaign_detail.product_id IS 'キャンペーン名'; COMMENT ON column dtb_campaign_detail.campaign_point_rate IS 'キャンペーンポイント'; COMMENT ON column dtb_pagelayout.page_id IS 'ページID 0はプレビュー用データ'; COMMENT ON column dtb_pagelayout.page_name IS 'ページ名称'; COMMENT ON column dtb_pagelayout.url IS 'ページURL PKEY1'; COMMENT ON column dtb_pagelayout.php_dir IS 'PHPファイル保存先'; COMMENT ON column dtb_pagelayout.tpl_dir IS 'テンプレートファイル保存先'; COMMENT ON column dtb_pagelayout.filename IS 'ファイル名（拡張子なし）'; COMMENT ON column dtb_pagelayout.header_chk IS 'ヘッダー使用チェック　1：使用、2：未使用'; COMMENT ON column dtb_pagelayout.footer_chk IS 'フッター使用チェック　1：使用、2：未使用'; COMMENT ON column dtb_pagelayout.edit_flg IS '削除、ページ名称、URL等を編集可能か否かのFLG　1：編集可、2：編集不可'; COMMENT ON column dtb_pagelayout.author IS 'メタタグ(SEO管理用)'; COMMENT ON column dtb_pagelayout.description IS 'メタタグ(SEO管理用)'; COMMENT ON column dtb_pagelayout.keyword IS 'メタタグ(SEO管理用)'; COMMENT ON column dtb_pagelayout.update_url IS 'このデータに対して更新を行ったページ'; COMMENT ON column dtb_pagelayout.create_date IS '作成日時'; COMMENT ON column dtb_pagelayout.update_date IS '更新日時'; COMMENT ON column dtb_bloc.bloc_id IS 'ブロックID'; COMMENT ON column dtb_bloc.bloc_name IS 'ブロック名称'; COMMENT ON column dtb_bloc.tpl_path IS 'テンプレートファイルのパス'; COMMENT ON column dtb_bloc.filename IS 'ファイル名称'; COMMENT ON column dtb_bloc.create_date IS '作成日時'; COMMENT ON column dtb_bloc.update_date IS '更新日時'; COMMENT ON column dtb_bloc.php_path IS 'include PHPで使用する場合にはphpのパスも保存する'; COMMENT ON column dtb_blocposition.page_id IS 'ページID'; COMMENT ON column dtb_blocposition.target_id IS 'ターゲットID 1：レフトナビ 2：ライトナビ 3：イン画面上部 4：メイン画面下部'; COMMENT ON column dtb_blocposition.bloc_id IS 'ブロックID'; COMMENT ON column dtb_blocposition.bloc_row IS 'ブロックIDを配置する順番'; COMMENT ON column dtb_csv.no IS '連番'; COMMENT ON column dtb_csv.csv_id IS 'CSVID　1.商品マスタ、2.顧客マスタ、3.受注'; COMMENT ON column dtb_csv.col IS '出力カラム'; COMMENT ON column dtb_csv.disp_name IS '出力名称'; COMMENT ON column dtb_csv.rank IS '出力順序'; COMMENT ON column dtb_csv.status IS '出力有無 1.出力、2.未出力'; COMMENT ON column dtb_csv.create_date IS '作成日時'; COMMENT ON column dtb_csv.update_date IS '更新日時'; COMMENT ON column dtb_csv_sql.sql_id IS 'SQL番号'; COMMENT ON column dtb_csv_sql.name IS '名称'; COMMENT ON column dtb_csv_sql.sql IS 'SQL文'; COMMENT ON column dtb_csv_sql.update_date IS '作成日時'; COMMENT ON column dtb_csv_sql.create_date IS '更新日時';