Brand Schema
- File Name:
brand.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains reference data for all brands, including their relationship to manufacturers and clients.
Fields
📋 Includes Common Fields: Client Information
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| BrandId | int | NOT NULL | Unique identifier for the brand |
| BrandName | nvarchar(100) | NOT NULL | Name of the brand |
| ExternalBrandCode | nvarchar(100) | NULL | External system brand code |
| IsDeleted | tinyint | NOT NULL | Soft delete flag |
| ManufacturerId | int | NOT NULL | Manufacturer identifier |
| ManufacturerName | nvarchar(100) | NULL | Name of the manufacturer |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |