| id |
bigint(20)
|
|
|
|
| component_uid |
char(64)
|
utf8mb4_general_ci
|
|
|
| kenderaan_id |
int(11)
|
|
|
 Browse foreign values
|
| component_category_id |
int(11)
|
|
|
|
| component_key |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| component_name |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| position_label |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| specification |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| quantity |
decimal(12,2)
|
|
|
|
| unit_label |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| source_table |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| source_id |
int(11)
|
|
|
|
| metadata_json |
longtext
|
utf8mb4_general_ci
|
|
|
| source_mode |
enum('LEGACY', 'NATIVE')
|
utf8mb4_general_ci
|
|
|
| legacy_identity_key |
char(64)
|
utf8mb4_general_ci
|
|
|
| component_status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| installed_at |
date
|
|
|
|
| removed_at |
date
|
|
|
|
| replaced_component_id |
bigint(20)
|
|
|
Browse foreign values
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| version_no |
int(10)
|
|
|
|
| created_by |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| updated_by |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| deleted_at |
datetime
|
|
|
|
| deleted_by |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
