Reserved for IBM internal use.
Column Name | Column Type | Column Description |
---|---|---|
BUADDR1 | VARCHAR (50) NULL |
Reserved for IBM internal use. |
BUADDR2 | VARCHAR (50) NULL |
Reserved for IBM internal use. |
BUADDR3 | VARCHAR (50) NULL |
Reserved for IBM internal use. |
BUCITY | VARCHAR (30) NULL |
Reserved for IBM internal use. |
BUCNTRY | VARCHAR (30) NULL |
Reserved for IBM internal use. |
BUEMAIL | VARCHAR (80) NULL |
Reserved for IBM internal use. |
BUFAX | VARCHAR (80) NULL |
Reserved for IBM internal use. |
BUFIELD1 | VARCHAR (30) NULL |
Reserved for IBM internal use. |
BUFIELD2 | VARCHAR (30) NULL |
Reserved for IBM internal use. |
BUFIELD3 | VARCHAR (30) NULL |
Reserved for IBM internal use. |
BUNAME | VARCHAR (80) NOT NULL |
Reserved for IBM internal use. |
BUPHONE | VARCHAR (80) NULL |
Reserved for IBM internal use. |
BURFNBR | INTEGER NOT NULL |
Reserved for IBM internal use. |
BUSHRFNBR | INTEGER NOT NULL |
Reserved for IBM internal use. |
BUSTATE | VARCHAR (20) NULL |
Reserved for IBM internal use. |
BUZIPC | VARCHAR (20) NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034847030 | BURFNBR | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_130 | BURFNBR | BUADDR | BABURFNBR | Cascade |
F_131 | BURFNBR | BUCONT | BCBURFNBR | Cascade |
F_437 | BURFNBR | MBINFO | MBBURFNBR | Cascade |
F_744 | BURFNBR | SHBTB | SBBURFNBR | Cascade |