asset_warranty


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset_warranty_note.warranty_id FK7B5B7E464529720A R
asset_warranty_unit_protection.warranty_id FK9B17F1A04529720A R
warranty_log.warranty_id FK_6n92j8m4nreo47fj2m10u69cs R
version BIGINT 19 null
asset_id BIGINT 19 √ null
asset.id FKC17E956BE6BD1E7A R
business_owner VARCHAR 10 √ null
contract_number VARCHAR 50 √ null
equipment_name VARCHAR 50 √ null
installation_vendor_name VARCHAR 50 √ null
ip_address VARCHAR 45 √ null
last_updated DATETIME 19 √ null
manufacturer_name VARCHAR 50 √ null
model_number VARCHAR 150 √ null
purchase_date DATE 10 √ null
serial_number VARCHAR 50 √ null
warranty_activation DATE 10 √ null
warranty_duration INT 10 √ null
warranty_expiration DATE 10 √ null
warranty_manager_email VARCHAR 100 √ null
warranty_owner VARCHAR 50 √ null
warranty_vendor_name VARCHAR 50 √ null
cable_lock VARCHAR 50 √ null
mac_address VARCHAR 50 √ null
asset_type_id BIGINT 19 √ null
asset_type.id FKC17E956B198EEAFB R
capacity VARCHAR 50 √ null
jacs_coding VARCHAR 100 √ null
manufacturing_date DATETIME 19 √ null
site_id INT 10 √ null
site.id FKC17E956B92D2B99F R
landlord_owned BIT 1 √ null
asset_manufacturer_id INT 10 √ null
asset_manufacturer.id FK_1q8evv8iwoi8bycnqoggk4qxi R
asset_refrigerant_id INT 10 √ null
asset_refrigerant.id FK_d1s957m27hnyn4ci40ac4rklj R
installation_vendor_id INT 10 √ null
asset_manufacturer.id FK_itgpxw183hn7bhhe2cpkjai7i R
warranty_in_service_status_id INT 10 √ null
warranty_in_service.id FK_33k7o3rvqjgac5h6jwlgxhyp R
warranty_manager_id BIGINT 19 √ null
asset_warranty_manager.id FK_3ck5une1un4y3tyihwdtoe7i4 R
warranty_status_id INT 10 √ null
warranty_status.id FK_4r7do0t017iubwalrpcuu4fq7 R
warranty_vendor_id INT 10 √ null
asset_manufacturer.id FK_8wc9p3scj2mgcc3302pd745wq R
installation_vendor_contractor_name VARCHAR 50 √ null
vendor_product_code_id INT 10 √ null
vendor_product_code.id FK_5k13dkf08w998wr90dadyw2h6 R
area_impacted_id INT 10 √ null
area_impacted.id FK_6bv90fggo5hnk059i3pxlndqg R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1q8evv8iwoi8bycnqoggk4qxi Performance Asc asset_manufacturer_id
FK_33k7o3rvqjgac5h6jwlgxhyp Performance Asc warranty_in_service_status_id
FK_3ck5une1un4y3tyihwdtoe7i4 Performance Asc warranty_manager_id
FK_4r7do0t017iubwalrpcuu4fq7 Performance Asc warranty_status_id
FK_5k13dkf08w998wr90dadyw2h6 Performance Asc vendor_product_code_id
FK_6bv90fggo5hnk059i3pxlndqg Performance Asc area_impacted_id
FK_8wc9p3scj2mgcc3302pd745wq Performance Asc warranty_vendor_id
FK_d1s957m27hnyn4ci40ac4rklj Performance Asc asset_refrigerant_id
FK_itgpxw183hn7bhhe2cpkjai7i Performance Asc installation_vendor_id
FKC17E956B198EEAFB Performance Asc asset_type_id
FKC17E956B92D2B99F Performance Asc site_id
FKC17E956BE6BD1E7A Performance Asc asset_id

Relationships

Close relationships within degrees of separation