Advertisement
Guest User

Untitled

a guest
Oct 9th, 2015
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.27 KB | None | 0 0
  1. advertur=# \dt billing.*
  2. billing | accounts | table | homestead
  3. billing | accounts_balances | table | homestead
  4. billing | accounts_owners | table | homestead
  5. billing | accounts_owners_types | table | homestead
  6. billing | currencies | table | homestead
  7. billing | operations | table | homestead
  8. billing | operations_types | table | homestead
  9. billing | transactions | table | homestead
  10. billing | transactions_types | table | homestead
  11.  
  12. advertur=# \d+ billing.accounts
  13. id | bigint | not null default nextval('billing.accounts_id_seq'::regclass) | plain | |
  14. owner_type_id | bigint | not null | plain | |
  15. owner_id | bigint | not null | plain | |
  16. currency_id | bigint | not null | plain | |
  17. created_at | timestamp without time zone | not null default now() | plain | |
  18. updated_at | timestamp without time zone | not null default now() | plain | |
  19.  
  20. advertur=# \d+ billing.accounts_balances
  21. account_id | bigint | not null | plain | |
  22. total | numeric(15,6) | not null default 0 | main | |
  23. created_at | timestamp without time zone | not null default now() | plain | |
  24. updated_at | timestamp without time zone | not null default now() | plain | |
  25.  
  26. advertur=# \d+ billing.accounts_owners
  27. id | bigint | not null | plain | |
  28. type_id | bigint | not null | plain | |
  29. index | character varying(255) | not null | extended | |
  30. description | character varying(255) | not null | extended | |
  31.  
  32. advertur=# \d+ billing.accounts_owners_types
  33. id | bigint | not null | plain | |
  34. index | character varying(255) | not null | extended | |
  35. description | character varying(255) | not null | extended | |
  36.  
  37. advertur=# \d+ billing.currencies
  38. id | bigint | not null | plain | |
  39. code | character varying(10) | not null | extended | |
  40. name | character varying(255) | not null | extended | |
  41.  
  42. advertur=# \d+ billing.operations
  43. id | bigint | not null default nextval('billing.operations_id_seq'::regclass) | plain | |
  44. transaction_id | bigint | not null | plain | |
  45. type_id | bigint | not null | plain | |
  46. account_id | bigint | not null | plain | |
  47. currency_id | bigint | not null | plain | |
  48. amount | numeric(15,6) | not null | main | |
  49. created_at | timestamp without time zone | not null default now() | plain | |
  50.  
  51. advertur=# \d+ billing.operations_types
  52. id | bigint | not null | plain | |
  53. index | character varying(255) | not null | extended | |
  54. description | character varying(255) | not null | extended | |
  55.  
  56. advertur=# \d+ billing.transactions
  57. id | bigint | not null default nextval('billing.transactions_id_seq'::regclass) | plain | |
  58. type_id | bigint | not null | plain | |
  59. sender_account_id | bigint | not null | plain | |
  60. receiver_account_id | bigint | not null | plain | |
  61. amount | numeric(15,6) | not null | main | |
  62. comment | text | | extended | |
  63. created_at | timestamp without time zone | not null default now() | plain | |
  64.  
  65. advertur=# \d+ billing.transactions_types
  66. id | bigint | not null | plain | |
  67. index | character varying(255) | not null | extended | |
  68. description | character varying(255) | not null | extended | |
  69.  
  70. advertur=#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement