Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
jvx:server:storage:dbcheck_constraints [2020/06/15 12:09] cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
jvx:server:storage:dbcheck_constraints [2020/06/29 13:32] (current) cduncan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~Title: Considering Check Constraints From the Database~~ | ~~Title: Considering Check Constraints From the Database~~ | ||
| - | In addition to the use of [[jvx:server:storage:dbdefault_values|Default Values]], the restriction to **"allowed values"** is another advantage of JVx. | + | In addition to the use of [[jvx:server:storage:dbdefault_values|default values]], the restriction to **"allowed values"** is another advantage of JVx. |
| The "allowed values" for columns are usually defined in the database using check constraints. These are evaluated by JVx and assumed as allowed values. | The "allowed values" for columns are usually defined in the database using check constraints. These are evaluated by JVx and assumed as allowed values. | ||
| Line 9: | Line 9: | ||
| == Example == | == Example == | ||
| - | Based on the example for [[jvx:server:storage:dbdefault_values|Default Values]], we define the following check constraints (Oracle Syntax): | + | Based on the example for [[jvx:server:storage:dbdefault_values|default values]], we define the following check constraints (Oracle Syntax): |
| <file sql> | <file sql> | ||