ir_sequence

28 rows


Description

Sequence

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_sequence_id_seq'::regclass)
account_journal.check_sequence_id account_journal_check_sequence_id_fkey N
account_journal.secure_sequence_id account_journal_secure_sequence_id_fkey N
ir_sequence_date_range.sequence_id ir_sequence_date_range_sequence_id_fkey C
stock_picking_type.sequence_id stock_picking_type_sequence_id_fkey N
number_next int4 10 null

Next Number
number_increment int4 10 null

Step
padding int4 10 null

Sequence Size
company_id int4 10 √ null
res_company.id ir_sequence_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id ir_sequence_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id ir_sequence_write_uid_fkey N

Last Updated by
name varchar 2147483647 null

Name
code varchar 2147483647 √ null

Sequence Code
implementation varchar 2147483647 null

Implementation
prefix varchar 2147483647 √ null

Prefix
suffix varchar 2147483647 √ null

Suffix
active bool 1 √ null

Active
use_date_range bool 1 √ null

Use subsequences per date_range
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
ir_sequence_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation