Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PackageID | INT | 10 | √ | null |
|
|
||
| PackageName | VARCHAR | 50 | null |
|
|
|||
| PackageDescription | VARCHAR | 255 | null |
|
|
|||
| PackageMonthlyCostAUD | INT | 10 | √ | null |
|
|
||
| PackageAnnualCostAUD | INT | 10 | √ | null |
|
|
||
| PackageOneTimeCostAUD | INT | 10 | √ | null |
|
|
||
| PackageMonthlyCostEUR | INT | 10 | √ | null |
|
|
||
| PackageAnnualCostEUR | INT | 10 | √ | null |
|
|
||
| PackageOneTimeCostEUR | INT | 10 | √ | null |
|
|
||
| PackageMonthlyCostUSD | INT | 10 | √ | null |
|
|
||
| PackageAnnualCostUSD | INT | 10 | √ | null |
|
|
||
| PackageOneTimeCostUSD | INT | 10 | √ | null |
|
|
||
| AdditionalMonthlyProductCostAUD | DECIMAL | 10,3 | null |
|
|
|||
| AdditionalMonthlyProductCostEUR | DECIMAL | 10,3 | √ | null |
|
|
||
| AdditionalMonthlyProductCostUSD | DECIMAL | 10,3 | √ | null |
|
|
||
| PackageStartDateTime | DATETIME | 19 | null |
|
|
|||
| PackageEndDateTime | DATETIME | 19 | null |
|
|
|||
| PackageIncludedProducts | INT | 10 | null |
|
|
|||
| PackageMaximumProducts | INT | 10 | null |
|
|
|||
| PackagePlanAUDID | VARCHAR | 255 | null |
|
|
|||
| PackagePlanEURID | VARCHAR | 255 | null |
|
|
|||
| PackagePlanUSDID | VARCHAR | 255 | null |
|
|
|||
| AnnualPlanAUDID | VARCHAR | 255 | null |
|
|
|||
| AnnualPlanEURID | VARCHAR | 255 | null |
|
|
|||
| AnnualPlanUSDID | VARCHAR | 255 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | PackageID |
Relationships
Close relationships within degrees of separation
