| Physical name | STORE | ST |
| Logical name | Store | |
| Attributes | 4 | |
| Description | Detailed info about stores. | |
| PK | Physical name | Datatype | FK Ref. | Description |
| STORE_ID | INTEGER | |||
| REGION_ID | SMALLINT | REGION.REGION_ID [reg_store] | ||
| STORE_NAME | VARCHAR (30) | |||
| STREET | VARCHAR (30) |
| Indexes | |||
| xStoreID | UNIQUE | STORE_ID | |
| xStoreName | STORE_NAME | ||
| References | Referenced by |
| REGION [reg_store] | SALE [store_sale] |