carrier


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
carrierservice.carrierId FKm2u4xd1q4q0enl031ucqqwg4p R
carrierservice_aud.carrierId Implied Constraint R
company.defaultCarrierId FKhavos48q5ekm1qha96h1u3eoy R
customer.defaultCarrierId FKstgsiyl5p2aqlpu6c4dnj9q5w R
po.carrierId FK79ybfw24fkkuhhx7t2ubq4swp R
po_aud.carrierId Implied Constraint R
receiptitem.carrierId FKgnpf1ucchpx48emkf1uy5ikwb R
receiptitem_aud.carrierId Implied Constraint R
ship.carrierId FK73bo2eirdgnov84twe2vognn5 R
ship_aud.carrierId Implied Constraint R
shipcarton.carrierId FK23q2knnra6kbmfenxh8a1y3kt R
shipcarton_aud.carrierId Implied Constraint R
so.carrierId FKk6i192qsul06clopj5ob27nt9 R
so_aud.carrierId Implied Constraint R
upsview.CARRIERID Implied Constraint R
vendor.defaultCarrierId FK1j3nbsjqg4lmst3gn7fbay8vm R
xo.carrierId FKip4a2jx987m76j5i4yi871umq R
xo_aud.carrierId Implied Constraint R
activeFlag BIT 1 √ null
description VARCHAR 256 √ null
name VARCHAR 60 √ null
readOnly BIT 1 √ null
scac VARCHAR 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UKlo6iwnp5yaur4pwxd1nlu4usj Must be unique Asc name

Relationships