Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- advertur=# \dt billing.*
- billing | accounts | table | homestead
- billing | accounts_balances | table | homestead
- billing | accounts_owners | table | homestead
- billing | accounts_owners_types | table | homestead
- billing | currencies | table | homestead
- billing | operations | table | homestead
- billing | operations_types | table | homestead
- billing | transactions | table | homestead
- billing | transactions_types | table | homestead
- advertur=# \d+ billing.accounts
- id | bigint | not null default nextval('billing.accounts_id_seq'::regclass) | plain | |
- owner_type_id | bigint | not null | plain | |
- owner_id | bigint | not null | plain | |
- currency_id | bigint | not null | plain | |
- created_at | timestamp without time zone | not null default now() | plain | |
- updated_at | timestamp without time zone | not null default now() | plain | |
- advertur=# \d+ billing.accounts_balances
- account_id | bigint | not null | plain | |
- total | numeric(15,6) | not null default 0 | main | |
- created_at | timestamp without time zone | not null default now() | plain | |
- updated_at | timestamp without time zone | not null default now() | plain | |
- advertur=# \d+ billing.accounts_owners
- id | bigint | not null | plain | |
- type_id | bigint | not null | plain | |
- index | character varying(255) | not null | extended | |
- description | character varying(255) | not null | extended | |
- advertur=# \d+ billing.accounts_owners_types
- id | bigint | not null | plain | |
- index | character varying(255) | not null | extended | |
- description | character varying(255) | not null | extended | |
- advertur=# \d+ billing.currencies
- id | bigint | not null | plain | |
- code | character varying(10) | not null | extended | |
- name | character varying(255) | not null | extended | |
- advertur=# \d+ billing.operations
- id | bigint | not null default nextval('billing.operations_id_seq'::regclass) | plain | |
- transaction_id | bigint | not null | plain | |
- type_id | bigint | not null | plain | |
- account_id | bigint | not null | plain | |
- currency_id | bigint | not null | plain | |
- amount | numeric(15,6) | not null | main | |
- created_at | timestamp without time zone | not null default now() | plain | |
- advertur=# \d+ billing.operations_types
- id | bigint | not null | plain | |
- index | character varying(255) | not null | extended | |
- description | character varying(255) | not null | extended | |
- advertur=# \d+ billing.transactions
- id | bigint | not null default nextval('billing.transactions_id_seq'::regclass) | plain | |
- type_id | bigint | not null | plain | |
- sender_account_id | bigint | not null | plain | |
- receiver_account_id | bigint | not null | plain | |
- amount | numeric(15,6) | not null | main | |
- comment | text | | extended | |
- created_at | timestamp without time zone | not null default now() | plain | |
- advertur=# \d+ billing.transactions_types
- id | bigint | not null | plain | |
- index | character varying(255) | not null | extended | |
- description | character varying(255) | not null | extended | |
- advertur=#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement