Stores records for different organizational branches or locations, allowing for data segmentation.
Column Definitions
| Column | Data Type | Description | Constraints |
|---|---|---|---|
| id | BIGINT | Primary key for the branch. | PK, Auto-Increment |
| branch_code | VARCHAR(255) | A unique code or identifier for the branch. | NOT NULL, UNIQUE |
| name | VARCHAR(255) | The full name of the branch. | NOT NULL |
| address | VARCHAR(255) | The physical address of the branch. | Nullable |
| city | VARCHAR(255) | The city where the branch is located. | Nullable |
| country | VARCHAR(255) | The country where the branch is located. | Nullable |
Relationships
- A branch can have many users assigned to it.