Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
NEIGHBORHOOD_ID | NUMBER(38) | N | ||
NEIGHBORHOOD_NAME | VARCHAR2(500.0) | N | ||
DESCRIPTION | VARCHAR2(4000.0) | Y | ||
PARENT_ID | NUMBER(38) | Y |
Constraint Name | Columns |
---|---|
SYS_C002088294 | NEIGHBORHOOD_ID |
Constraint Name | Check Condition |
---|---|
SYS_C002088293 | "NEIGHBORHOOD_NAME" IS NOT NULL |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
SYS_C002088295 | PARENT_ID | USERS_NEIGHBORHOODS | SYS_C002088294 | CASCADE |
Option | Settings |
---|---|
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns |
---|---|---|---|
SYS_C002088294 | NORMAL | UNIQUE | NEIGHBORHOOD_ID |
Table | Constraint |
---|---|
USERS_NEIGHBORHOODS | SYS_C002088295 |
USERS_HOMEPAGES | SYS_C002088298 |