trades

410 rows


Description

Master table for trades

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
mqops_activity_tracker_trade.trade_id trade_mqops_activity_tracker_ibfk_1 R
ple_career_paths.trade_id job_types_trade_id_foreign R
ple_job_cards.trade_id job_cards_trade_id_foreign R
ple_skill_trade.trade_id ple_skill_trade_trade_id_foreign R
ple_user_onboardings.trade_id ple_user_onboardings_trade_id_foreign R
name VARCHAR 125 null
type enum('iti', 'ngo') 3 null

iti,ngo
tenant_id VARCHAR 36 null
old_data_id VARCHAR 100 √ null
updated_at DATETIME 19 null
created_at DATETIME 19 null
status BIT 1 √ 1

0:Inactive,1:Active
duration TINYINT 3 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_trades_1_idx Performance Asc tenant_id
trades_tenant_id_IDX Performance Asc/Asc/Asc tenant_id + type + status

Relationships

Close relationships within degrees of separation