HL Modern Development

HL Modern Development

erDiagram
    VENDOR ||--o{ INVOICE : "requests payments"
    VENDOR {
        int VendorID PK
        string VendorName
    }
    INVOICE ||--|{ DETAIL : contains
    INVOICE {
        int InvoiceID PK
        string VendorID FK
        string InvoiceNumber
    }
    DETAIL {
        int InvoiceID PK,FK "Part of compound primary key"
        int InvoiceSequence PK "Part of compound primary key"
        string ItemDescription
    }

SELECT *
FROM Company
WHERE
  CompanyID = 2;