com_location_group

42 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_pk int8 19 null
com_location.c_location_group fk_loc_lg R
com_location_group.c_in_locker fk_lg_lg_inlocker R
com_location_group.c_out_locker fk_lg_lg_outlocker R
com_location_group.c_parent fk_lg_lg_parent R
c_created timestamp 29,6 √ null
c_created_by varchar 255 √ null
c_updated_by varchar 255 √ null
c_updated timestamp 29,6 √ null
c_ol int8 19 √ null
c_pid varchar 255 null
c_description varchar 255 √ null
c_group_state_in varchar 255 null
c_group_state_out varchar 255 null
c_group_type varchar 255 √ null
c_group_counting_active bool 1 √ null
c_max_fill_level float4 8,8 √ null
c_name varchar 255 null
c_op_mode varchar 255 null
c_system_code varchar 255 √ null
c_system_name varchar 255 √ null
c_account varchar 255 √ null
com_account.c_identifier fk_lg_acc R
c_parent int8 19 √ null
com_location_group.c_pk fk_lg_lg_parent R
c_in_locker int8 19 √ null
com_location_group.c_pk fk_lg_lg_inlocker R
c_out_locker int8 19 √ null
com_location_group.c_pk fk_lg_lg_outlocker R

Indexes

Constraint Name Type Sort Column(s)
com_location_group_pkey Primary key Asc c_pk
uc_lg_name Must be unique Asc c_name
uk9a9we4uv0famk8k7878pqh710 Must be unique Asc c_pid

Check Constraints

Constraint Name Constraint
com_location_group_c_group_state_in_check ((c_group_state_in)::text = ANY ((ARRAY['AVAILABLE'::character varying, 'NOT_AVAILABLE'::character varying])::text[]))
com_location_group_c_group_state_out_check ((c_group_state_out)::text = ANY ((ARRAY['AVAILABLE'::character varying, 'NOT_AVAILABLE'::character varying])::text[]))

Relationships

Close relationships within degrees of separation