Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Id | int | 4 | null |
|
|
Fee/discount primary key - Unique identifier for each fee or discount configuration |
||
| Name | nvarchar | 400 | √ | null |
|
|
Fee/discount name - Descriptive name for the fee or discount |
|
| Amount | decimal | 20,2 | √ | null |
|
|
Fee/discount amount - Monetary amount or percentage value |
|
| PayType | int | 4 | √ | null |
|
|
Payment type - Type of payment or billing method this applies to |
|
| Interval | int | 4 | √ | null |
|
|
Billing interval - Frequency or interval for applying this fee or discount |
|
| IsPercent | bit | 1 | √ | null |
|
|
Percentage flag - Indicates if the amount is a percentage rather than fixed amount |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FeesAndDiscounts_1 | Primary key | Asc | Id |
Relationships
Close relationships within degrees of separation
