| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| USPS_ABBREV | CHAR(2.0) | N | ||
| STATE_NAME | VARCHAR2(25.0) | Y | ||
| FIPS_STATE_CODE | CHAR(2.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087049 | USPS_ABBREV |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087048 | "USPS_ABBREV" IS NOT NULL |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087049 | NORMAL | UNIQUE | USPS_ABBREV |
| Table | Constraint |
|---|---|
| CALENDAR | SYS_C002087485 |
| BBOARD | SYS_C002087541 |