# Column Name Nullable Data Type Max Length Description
1specific_cataloginformation_schema.sql_identifier0
1routine_idinteger0The primary key of this table, which is also a serial field.
2specific_schemainformation_schema.sql_identifier0
2orderinteger0
3specific_nameinformation_schema.sql_identifier0
3routine_codecharacter varying12
4routine_nameregproc0
4routine_cataloginformation_schema.sql_identifier0
5statusboolean0
5routine_schemainformation_schema.sql_identifier0
6routine_nameinformation_schema.sql_identifier0
7routine_typeinformation_schema.character_data0
8module_cataloginformation_schema.sql_identifier0
9module_schemainformation_schema.sql_identifier0
10module_nameinformation_schema.sql_identifier0
11udt_cataloginformation_schema.sql_identifier0
12udt_schemainformation_schema.sql_identifier0
13udt_nameinformation_schema.sql_identifier0
14data_typeinformation_schema.character_data0
15character_maximum_lengthinformation_schema.cardinal_number0
16character_octet_lengthinformation_schema.cardinal_number0
17character_set_cataloginformation_schema.sql_identifier0
18character_set_schemainformation_schema.sql_identifier0
19character_set_nameinformation_schema.sql_identifier0
20collation_cataloginformation_schema.sql_identifier0
21collation_schemainformation_schema.sql_identifier0
22collation_nameinformation_schema.sql_identifier0
23numeric_precisioninformation_schema.cardinal_number0
24numeric_precision_radixinformation_schema.cardinal_number0
25numeric_scaleinformation_schema.cardinal_number0
26datetime_precisioninformation_schema.cardinal_number0
27interval_typeinformation_schema.character_data0
28interval_precisioninformation_schema.cardinal_number0
29type_udt_cataloginformation_schema.sql_identifier0
30type_udt_schemainformation_schema.sql_identifier0
31type_udt_nameinformation_schema.sql_identifier0
32scope_cataloginformation_schema.sql_identifier0
33scope_schemainformation_schema.sql_identifier0
34scope_nameinformation_schema.sql_identifier0
35maximum_cardinalityinformation_schema.cardinal_number0
36dtd_identifierinformation_schema.sql_identifier0
37routine_bodyinformation_schema.character_data0
38routine_definitioninformation_schema.character_data0
39external_nameinformation_schema.character_data0
40external_languageinformation_schema.character_data0
41parameter_styleinformation_schema.character_data0
42is_deterministicinformation_schema.yes_or_no0
43sql_data_accessinformation_schema.character_data0
44is_null_callinformation_schema.yes_or_no0
45sql_pathinformation_schema.character_data0
46schema_level_routineinformation_schema.yes_or_no0
47max_dynamic_result_setsinformation_schema.cardinal_number0
48is_user_defined_castinformation_schema.yes_or_no0
49is_implicitly_invocableinformation_schema.yes_or_no0
50security_typeinformation_schema.character_data0
51to_sql_specific_cataloginformation_schema.sql_identifier0
52to_sql_specific_schemainformation_schema.sql_identifier0
53to_sql_specific_nameinformation_schema.sql_identifier0
54as_locatorinformation_schema.yes_or_no0
55createdinformation_schema.time_stamp0
56last_alteredinformation_schema.time_stamp0
57new_savepoint_levelinformation_schema.yes_or_no0
58is_udt_dependentinformation_schema.yes_or_no0
59result_cast_from_data_typeinformation_schema.character_data0
60result_cast_as_locatorinformation_schema.yes_or_no0
61result_cast_char_max_lengthinformation_schema.cardinal_number0
62result_cast_char_octet_lengthinformation_schema.cardinal_number0
63result_cast_char_set_cataloginformation_schema.sql_identifier0
64result_cast_char_set_schemainformation_schema.sql_identifier0
65result_cast_character_set_nameinformation_schema.sql_identifier0
66result_cast_collation_cataloginformation_schema.sql_identifier0
67result_cast_collation_schemainformation_schema.sql_identifier0
68result_cast_collation_nameinformation_schema.sql_identifier0
69result_cast_numeric_precisioninformation_schema.cardinal_number0
70result_cast_numeric_precision_radixinformation_schema.cardinal_number0
71result_cast_numeric_scaleinformation_schema.cardinal_number0
72result_cast_datetime_precisioninformation_schema.cardinal_number0
73result_cast_interval_typeinformation_schema.character_data0
74result_cast_interval_precisioninformation_schema.cardinal_number0
75result_cast_type_udt_cataloginformation_schema.sql_identifier0
76result_cast_type_udt_schemainformation_schema.sql_identifier0
77result_cast_type_udt_nameinformation_schema.sql_identifier0
78result_cast_scope_cataloginformation_schema.sql_identifier0
79result_cast_scope_schemainformation_schema.sql_identifier0
80result_cast_scope_nameinformation_schema.sql_identifier0
81result_cast_maximum_cardinalityinformation_schema.cardinal_number0
82result_cast_dtd_identifierinformation_schema.sql_identifier0

Foreign Keys

# Column Name Key Name References

Indices

Index Name Owner Access Method Definition Description
routines_pkey postgres btree routine_id
routines_routine_code_uix postgres btree lower(routine_code::text)
routines_routine_name_key postgres btree routine_name

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 routine_id nextval('transactions.routines_routine_id_seq'::regclass)
5 status true

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description