Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
obj_oid |
int8 |
19 |
|
|
|
|
|
name |
varchar |
2147483647 |
√ |
|
null |
|
|
description |
varchar |
2147483647 |
√ |
|
null |
|
|
organization_oid |
int8 |
19 |
√ |
|
null |
|
|
start_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
end_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
open_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
close_date |
timestamptz |
35,6 |
√ |
|
null |
|
|
auto_open |
bool |
1 |
√ |
|
false |
|
|
auto_close |
bool |
1 |
√ |
|
false |
|
|
inventory_on_checkout |
bool |
1 |
√ |
|
false |
|
|
inventory_on_return |
bool |
1 |
√ |
|
false |
|
|
update_resources |
bool |
1 |
√ |
|
false |
|
|
allow_manual |
varchar |
2147483647 |
|
|
|
|
|
require_location |
bool |
1 |
√ |
|
false |
|
|
allow_update_location |
bool |
1 |
√ |
|
false |
|
|
allow_add_unexpected |
bool |
1 |
√ |
|
false |
|
|
include_maint_notes |
bool |
1 |
√ |
|
false |
|
|
include_instructions |
bool |
1 |
√ |
|
false |
|
|
instructions |
varchar |
2147483647 |
√ |
|
null |
|
|
Table contained 1 rows at Thu Feb 14 09:20 CST 2019
|