Method: QuickETL::DBO#create_transactions_ddl

Defined in:
lib/quick_etl_dbo.rb

#create_transactions_ddl ⇒ Object 



51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'lib/quick_etl_dbo.rb', line 51

def create_transactions_ddl      
  s =  "create table transactions ( \n" 
  s << "  id              INTEGER PRIMARY KEY, \n" 
  s << "  account_owner   TEXT, \n"       
  s << "  account_name    TEXT, \n"  
  s << "  account_type    TEXT, \n"  
  s << "  tran_date       TEXT, \n"  
  s << "  cleared_status  TEXT, \n"  
  s << "  item_number     INTEGER, \n"  
  s << "  amount          REAL, \n" 
  s << "  payee           TEXT, \n"  
  s << "  category        TEXT, \n"         
  s << "  memo            TEXT, \n"  
  s << "  line_number     INTEGER \n" 
  s << ");" 
  s
end