Table almasdd.COMPIERE.AD_SEQUENCE

Generated by
SchemaSpy
Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
AD_SEQUENCE_ID number 10
AD_SEQUENCE_AUDIT AD_SEQUENCE_ID AD_SEQUENCE_SEQUENCEAUDIT
AD_SEQUENCE_NO AD_SEQUENCE_ID AD_SEQUENCE_SEQUENCENO
C_BP_EDI AD_SEQUENCE_ID ADSEQUENCE_CBPEDI
C_DOCTYPE DOCNOSEQUENCE_ID AD_SEQUENCE_DOCTYPEDOC
C_PAYMENTPROCESSOR AD_SEQUENCE_ID ADSEQUENCE_CPAYMENTPROCESSOR
AD_CLIENT_ID number 10
AD_CLIENT AD_CLIENT_ID SEQUENCECLIENT
AD_ORG_ID number 10
AD_ORG AD_ORG_ID SEQUENCEORG
ISACTIVE char 1  √  'Y'
CREATED date 7 now
CREATEDBY number 10
UPDATED date 7 now
UPDATEDBY number 10
NAME varchar2 60
DESCRIPTION nvarchar2 510  √  null
VFORMAT nvarchar2 80  √  null
ISAUTOSEQUENCE char 1 'Y'
INCREMENTNO number 10
STARTNO number 10
CURRENTNEXT number 10
CURRENTNEXTSYS number 10
ISAUDITED char 1  √  'N'
ISTABLEID char 1  √  'N'
PREFIX nvarchar2 20  √  null
SUFFIX nvarchar2 20  √  null
STARTNEWYEAR char 1  √  'N'

Table contained 811 rows at ‰Î 3 07 12:14 JST 2006

Indexes:
Column(s) Type Sort Constraint Name
AD_SEQUENCE_ID Primary key Asc AD_SEQUENCE_KEY
AD_CLIENT_ID + NAME Must be unique Asc/Asc AD_SEQUENCE_NAME


SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.