Table : dealUrls

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

category

{
  "name": "category",
  "type": "text",
  "maxLength": 80
}

isPublished bit

{
  "name": "isPublished",
  "type": "bit"
}

isBundleItem bit

{
  "name": "isBundleItem",
  "type": "bit"
}

displayName

{
  "name": "displayName",
  "type": "text",
  "maxLength": 80
}

url M

{
  "name": "url",
  "type": "text",
  "maxLength": 200,
  "mandatory": "true"
}

description

{
  "name": "description",
  "type": "text"
}

displayOrder

{
  "name": "displayOrder",
  "type": "int"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}

Referenced by

dealDocumentBundleDocuments as dealUrlId