asset_schedule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset.schedule_id FK_asset_asset_schedule R
asset_log.schedule_id FK4E6AC5752BBA482A R
project.asset_schedule_id FK_ltw1rmihusannpbphu728rtdb R
site.asset_schedule_id FK_ek7j9lif1jxhl6cpow03wslu5 R
version INT 10 √ 0
canceled_date DATE 10 √ null
complete_date DATE 10 √ null
cad_update_required BIT 1 √ b'0'
name VARCHAR 50 √ null
notes LONGTEXT 2147483647 √ null
site_id INT 10 null
site.id FK7A00270692D2B99F R
template_id BIGINT 19 null
asset_template.id FK7A002706658AD94A R
status_id BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK7A002706658AD94A Performance Asc template_id
FK7A00270692D2B99F Performance Asc site_id

Relationships

Close relationships within degrees of separation