Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1065:7d87ddba5520
Validate against possible maxima.
Actual maxima being less are handled by the generation of Probe objects.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 29 Sep 2016 16:23:04 +0200 |
| parents | 7788a805a98d |
| children | daca5c62356f |
comparison
equal
deleted
inserted
replaced
| 1064:8ec6a2a31171 | 1065:7d87ddba5520 |
|---|---|
| 591 CHECK (probenintervall = 'J' | 591 CHECK (probenintervall = 'J' |
| 592 AND teilintervall_von BETWEEN 1 AND 365 | 592 AND teilintervall_von BETWEEN 1 AND 365 |
| 593 AND teilintervall_bis BETWEEN 1 AND 365 | 593 AND teilintervall_bis BETWEEN 1 AND 365 |
| 594 AND intervall_offset BETWEEN 0 AND 364 | 594 AND intervall_offset BETWEEN 0 AND 364 |
| 595 OR probenintervall = 'H' | 595 OR probenintervall = 'H' |
| 596 AND teilintervall_von BETWEEN 1 AND 183 | 596 AND teilintervall_von BETWEEN 1 AND 184 |
| 597 AND teilintervall_bis BETWEEN 1 AND 183 | 597 AND teilintervall_bis BETWEEN 1 AND 184 |
| 598 AND intervall_offset BETWEEN 0 AND 182 | 598 AND intervall_offset BETWEEN 0 AND 183 |
| 599 OR probenintervall = 'Q' | 599 OR probenintervall = 'Q' |
| 600 AND teilintervall_von BETWEEN 1 AND 91 | 600 AND teilintervall_von BETWEEN 1 AND 92 |
| 601 AND teilintervall_bis BETWEEN 1 AND 91 | 601 AND teilintervall_bis BETWEEN 1 AND 92 |
| 602 AND intervall_offset BETWEEN 0 AND 90 | 602 AND intervall_offset BETWEEN 0 AND 91 |
| 603 OR probenintervall = 'M' | 603 OR probenintervall = 'M' |
| 604 AND teilintervall_von BETWEEN 1 AND 31 | 604 AND teilintervall_von BETWEEN 1 AND 31 |
| 605 AND teilintervall_bis BETWEEN 1 AND 31 | 605 AND teilintervall_bis BETWEEN 1 AND 31 |
| 606 AND intervall_offset BETWEEN 0 AND 30 | 606 AND intervall_offset BETWEEN 0 AND 30 |
| 607 OR probenintervall = 'W4' | 607 OR probenintervall = 'W4' |