integrity constraints:
| abbreviation | integrity constraints |
|---|---|
| PK | primary key |
| FK | foreign key |
| UN | unique |
| NN | NOT NULL |
| CH | CHECK |
| 1* | > '1900-01-01' |
| 2* | ~ '^[\w.-]+@([\w-]+.)+[\w-]{2,4}$' |
| 3* | >0 |
| 4* | BETWEEN 0 AND 100 |
| 5* | char_length(contact_phone_num) =12 |
| 6* | >=0 |
integrity constraints:
| abbreviation | integrity constraints |
|---|---|
| PK | primary key |
| FK | foreign key |
| UN | unique |
| NN | NOT NULL |
| CH | CHECK |
| 1* | > '1900-01-01' |
| 2* | ~ '^[\w.-]+@([\w-]+.)+[\w-]{2,4}$' |
| 3* | >0 |
| 4* | BETWEEN 0 AND 100 |
| 5* | char_length(contact_phone_num) =12 |
| 6* | >=0 |