@startuml

!include ./schemes_setup.wsd

$table("CiscoFTDRuleModel", "CiscoFTDRuleModel") {
    $pk("id") INTEGER NOT NULL
    $column("action") VARCHAR
    $column("name") VARCHAR
    $column("position") VARCHAR
    $column("rule_hits") VARCHAR
    $column("safe_search") VARCHAR
    $column("variable_set") VARCHAR
}

$table("CiscoFTDApplicationModel","CiscoFTDApplicationModel")   {
    $pk("id") INTEGER NOT NULL
    $fk("rule_id") INTEGER NOT NULL
    $column("name") VARCHAR
    $column("port") VARCHAR
}
CiscoFTDApplicationModel::rule_id }o--|| CiscoFTDRuleModel::id

$table("CiscoFTDLoggingModel","CiscoFTDLoggingModel")   {
    $pk("id") INTEGER NOT NULL
    $fk("rule_id") INTEGER NOT NULL
    $column("device_connector_beginning") BOOLEAN
    $column("device_connector_end") BOOLEAN
    $column("device_connector_files") BOOLEAN
    $column("enabled") BOOLEAN
}
CiscoFTDLoggingModel::rule_id }o--|| CiscoFTDRuleModel::id

@enduml