Ignore:
Timestamp:
2009/07/25 09:49:37 (15 years ago)
Author:
Seasoft
Message:
  • #516(受注管理の編集画面でお届け日を編集可能に)を実装
  • 語句統一(フロント機能PCサイトを基準とした)
    • お届け日 ← 配達日、配送日
    • お届け時間 ← 配送時間、配達時間
    • お届け先 ← 配送先
  • コメントの誤りを修正
File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/comu-ver2/html/install/sql/column_comment.sql

    r17994 r18235  
    6666INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時'); 
    6767INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID'); 
    68 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','配送時間ID'); 
    69 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','配送時間'); 
     68INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','お届け時間ID'); 
     69INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','お届け時間'); 
    7070INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID'); 
    7171INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID'); 
    … …  
    398398INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日'); 
    399399INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種'); 
    400 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','配送先名前'); 
    401 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','配送先名前'); 
    402 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','配送先カナ'); 
    403 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','配送先カナ'); 
     400INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','お届け先名前'); 
     401INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','お届け先名前'); 
     402INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','お届け先カナ'); 
     403INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','お届け先カナ'); 
    404404INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1'); 
    405405INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2'); 
    … …  
    426426INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法'); 
    427427INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID'); 
    428 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','配送時間ID'); 
    429 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','配送時間'); 
     428INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','お届け時間ID'); 
     429INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','お届け時間'); 
    430430INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号'); 
    431431INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ'); 
    … …  
    438438INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日'); 
    439439INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除'); 
    440 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','配達日'); 
     440INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','お届け日'); 
    441441INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報'); 
    442442INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1'); 
    … …  
    465465INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日'); 
    466466INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種'); 
    467 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','配送先名前'); 
    468 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','配送先名前'); 
    469 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','配送先カナ'); 
    470 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','配送先カナ'); 
     467INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','お届け先名前'); 
     468INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','お届け先名前'); 
     469INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','お届け先カナ'); 
     470INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','お届け先カナ'); 
    471471INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1'); 
    472472INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2'); 
    … …  
    493493INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法（文字列）'); 
    494494INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID'); 
    495 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','配送時間ID'); 
    496 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','配送時間（文字列）'); 
     495INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','お届け時間ID'); 
     496INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','お届け時間（文字列）'); 
    497497INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号'); 
    498498INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ'); 
    … …  
    507507INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時'); 
    508508INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除'); 
    509 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','配達日'); 
     509INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','お届け日'); 
    510510INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報'); 
    511511INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1'); 
    … …  
    514514INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID'); 
    515515INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID'); 
    516 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','配送先名前'); 
    517 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','配送先名前'); 
    518 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','配送先カナ'); 
    519 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','配送先カナ'); 
     516INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','お届け先名前'); 
     517INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','お届け先名前'); 
     518INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','お届け先カナ'); 
     519INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','お届け先カナ'); 
    520520INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1'); 
    521521INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2'); 
Note: See TracChangeset for help on using the changeset viewer.