account_analytic_plan

-1 rows


Description

Analytic Plans

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_analytic_plan_id_seq'::regclass)
account_analytic_account.plan_id account_analytic_account_plan_id_fkey R
account_analytic_account.root_plan_id account_analytic_account_root_plan_id_fkey N
account_analytic_applicability.analytic_plan_id account_analytic_applicability_analytic_plan_id_fkey N
account_analytic_plan.parent_id account_analytic_plan_parent_id_fkey C
parent_id int4 10 √ null
account_analytic_plan.id account_analytic_plan_parent_id_fkey C

Parent
color int4 10 √ null

Color
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id account_analytic_plan_create_uid_fkey N

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

Last Updated by
parent_path varchar 2147483647 √ null

Parent Path
complete_name varchar 2147483647 √ null

Complete Name
name jsonb 2147483647 null

Name
description text 2147483647 √ null

Description
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
account_analytic_plan_pkey Primary key Asc id
account_analytic_plan__parent_path_index Performance Asc parent_path

Relationships

Close relationships within degrees of separation