Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| state_abbr | VARCHAR | 2 | null |
|
|
Optional state abbreviation (US is 2 capital letters) |
||
| state_name | VARCHAR | 32 | null |
|
|
State name with first letter capital |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | state_abbr |
Relationships
Close relationships within degrees of separation
