MIXERP Database Documentation Database Schemas Tables Sequences Triggers Views MatViews Functions Types

Schema "public"

Tables

# Table Name Owner Tablespace Description

Sequences

# Sequence Name Owner Data Type Start Value Increment Description

Views

# View Name Owner Tablespace Description
1 db_stat postgres DEFAULT

Materialized Views

# Matview Name Owner Tablespace Description

Functions

# Function Owner Description
1 add_office(_office_code character varying, _office_name character varying, _nick_name character varying, _registration_date date, _currency_code character varying, _currency_symbol character varying, _currency_name character varying, _hundredth_name character varying, _admin_name character varying, _user_name character varying, _password character varying)
RETURNS void 		postgres
2 explode_array(in_array anyarray)
RETURNS SETOF anyelement 		postgres
3 poco_get_table_function_definition(_schema text, _name text)
RETURNS TABLE(column_name text, is_nullable text, udt_name text, column_default text) 		postgres

Triggers

# Trigger Owner Description

Types

# Type Base Type Owner Collation Default Type StoreType NotNull Description
1 color text postgres default Domain Compressed Inline/Seconary False
2 decimal_strict numeric postgres Domain Compressed Inline False
3 decimal_strict2 numeric postgres Domain Compressed Inline False
4 ghstore - postgres Base Type Plain False
5 hstore - postgres Base Type Compressed Inline/Seconary False
6 integer_strict integer postgres Domain Plain False
7 integer_strict2 integer postgres Domain Plain False
8 money_strict numeric postgres Domain Compressed Inline False
9 money_strict2 numeric postgres Domain Compressed Inline False
10 smallint_strict smallint postgres Domain Plain False
11 smallint_strict2 smallint postgres Domain Plain False
12 tablefunc_crosstab_2 - postgres Composite Type Compressed Inline/Seconary False
13 tablefunc_crosstab_3 - postgres Composite Type Compressed Inline/Seconary False
14 tablefunc_crosstab_4 - postgres Composite Type Compressed Inline/Seconary False
15 test_result text postgres default Domain Compressed Inline/Seconary False
16 transaction_type character postgres default Domain Compressed Inline/Seconary False This domain should not be localized.