| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| SUBSCRIBER_CLASS | VARCHAR2(30.0) | N | ||
| RATE | NUMBER(38) | N | ||
| CURRENCY | CHAR(3.0) | Y | 'USD' |
| Constraint Name | Columns |
|---|---|
| SYS_C002087813 | SUBSCRIBER_CLASS |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087811 | "SUBSCRIBER_CLASS" IS NOT NULL |
| SYS_C002087812 | "RATE" IS NOT NULL |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087813 | NORMAL | UNIQUE | SUBSCRIBER_CLASS |
| Table | Constraint |
|---|---|
| USERS_PAYMENT | SYS_C002087817 |