{
  "name": "manager/travel_expense/travel_expense.json",
  "table_name": "travel_expense",
  "table_prefix": "travelexp",
  "save_script": [],
  "field_change": [
   {
     "name": "person_id",
     "old_name": ["employee_id"],
     "info": "2017-11-07"
   }
  ],
  "extra_field": [
   {
     "name": "json_data.travel_expense_row",
     "type": "jsonb"
   }
  ],
  "field":[
    {
      "name":"travel_expense_id",
      "type":"varchar",
      "length":40,
      "constraint":["primary key", "unique"]
    },
    {
      "name":"person_id",
      "type":"varchar",
      "length":40,
      "foreign_key": {"table": "person", "field": "person_id", "link_type": "prevent delete"}
    },
    {
      "name":"co_traveller",
      "type":"text"
    },
    {
      "name":"travel_target",
      "type":"text"
    },
    {
      "name":"travel_purpose",
      "type":"text"
    },
    {
      "name":"start_time",
      "type":"datetime"
    },
    {
      "name":"end_time",
      "type":"datetime"
    },
    {
      "name":"attachment",
      "type":"text"
    },
    {
      "name":"payment_bank_account",
      "type":"text"
    },
    {
      "name":"voucher_number",
      "type":"varchar",
      "length":40
    },
    {
      "name":"bill_date",
      "type":"date"
    },
    {
      "name":"bill_arrival_date",
      "type":"date"
    },
    {
      "name":"approver_id",
      "type":"varchar",
      "length":40,
      "foreign_key": {"table": "person", "field": "person_id", "link_type": "prevent delete"}
    },
    {
      "name":"approval_state",
      "type":"varchar",
      "length":40
    },
    {
      "name":"approved_date",
      "type":"date"
    },
    {
      "name":"total_price",
      "type":"double"
    }
  ]
}
