Schema "unit_tests"

Tables

# Table Name Owner Tablespace Description
1 test_details postgres DEFAULT
2 tests postgres DEFAULT

Sequences

# Sequence Name Owner Data Type Start Value Increment Description
1 test_details_id_seq postgres bigint 1 1
2 tests_test_id_seq postgres bigint 1 1

Views

# View Name Owner Tablespace Description

Materialized Views

# Matview Name Owner Tablespace Description

Functions

# Function Owner Description
1 auto_verify_journal_test1()
RETURNS test_result
postgres
2 auto_verify_journal_test2()
RETURNS test_result
postgres
3 auto_verify_purchase_test1()
RETURNS test_result
postgres
4 auto_verify_purchase_test2()
RETURNS test_result
postgres
5 auto_verify_sales_test1()
RETURNS test_result
postgres
6 auto_verify_sales_test2()
RETURNS test_result
postgres
7 begin(v integer DEFAULT 9)
RETURNS TABLE(message text, result character)
postgres
8 check_party_currency_code_mismatch()
RETURNS test_result
postgres
9 check_party_null_account_id()
RETURNS test_result
postgres
10 create_dummy_accounts()
RETURNS void
postgres
11 create_dummy_auto_verification_policy(_user_id integer, _verify_sales_transactions boolean, _sales_verification_limit money_strict2, _verify_purchase_transactions boolean, _purchase_verification_limit money_strict2, _verify_gl_transactions boolean, _gl_verification_limit money_strict2, _effective_from date, _ends_on date, _is_active boolean)
RETURNS void
postgres
12 create_dummy_brands()
RETURNS void
postgres
13 create_dummy_cash_repositories()
RETURNS void
postgres
14 create_dummy_cost_centers()
RETURNS void
postgres
15 create_dummy_countries()
RETURNS void
postgres
16 create_dummy_item_groups()
RETURNS void
postgres
17 create_dummy_item_types()
RETURNS void
postgres
18 create_dummy_items()
RETURNS void
postgres
19 create_dummy_late_fees()
RETURNS void
postgres
20 create_dummy_offices()
RETURNS void
postgres
21 create_dummy_parties()
RETURNS void
postgres
22 create_dummy_party_types()
RETURNS void
postgres
23 create_dummy_payment_terms()
RETURNS void
postgres
24 create_dummy_sales_taxes()
RETURNS void
postgres
25 create_dummy_sales_teams()
RETURNS void
postgres
26 create_dummy_salespersons()
RETURNS void
postgres
27 create_dummy_shippers()
RETURNS void
postgres
28 create_dummy_states()
RETURNS void
postgres
29 create_dummy_store_types()
RETURNS void
postgres
30 create_dummy_stores()
RETURNS void
postgres
31 create_dummy_units()
RETURNS void
postgres
32 create_dummy_users()
RETURNS void
postgres
33 create_mock()
RETURNS void
postgres
34 get_base_quantity_by_unit_id_test()
RETURNS test_result
postgres
35 if_functions_compile()
RETURNS test_result
postgres
36 if_views_compile()
RETURNS test_result
postgres
37 sign_in_test()
RETURNS test_result
postgres
38 test_transactions_post_receipt_function()
RETURNS test_result
postgres

Triggers

# Trigger Owner Description

Types

# Type Base Type Owner Collation Default Type StoreType NotNull Description