| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ROBOT_ID | VARCHAR2(100.0) | N | ||
| ROBOT_NAME | VARCHAR2(100.0) | N | ||
| ROBOT_DETAILS_URL | VARCHAR2(200.0) | Y | ||
| ROBOT_COVER_URL | VARCHAR2(200.0) | Y | ||
| ROBOT_STATUS | CHAR(12.0) | Y | ||
| ROBOT_PURPOSE | VARCHAR2(50.0) | Y | ||
| ROBOT_TYPE | CHAR(12.0) | Y | ||
| ROBOT_PLATFORM | VARCHAR2(50.0) | Y | ||
| ROBOT_AVAILABILITY | CHAR(10.0) | Y | ||
| ROBOT_EXCLUSION_P | CHAR(1.0) | Y | ||
| ROBOT_EXCLUSION_USERAGENT | VARCHAR2(100.0) | Y | ||
| ROBOT_NOINDEX_P | CHAR(1.0) | Y | ||
| ROBOT_HOST | VARCHAR2(100.0) | Y | ||
| ROBOT_FROM_P | CHAR(1.0) | Y | ||
| ROBOT_USERAGENT | VARCHAR2(100.0) | N | ||
| ROBOT_LANGUAGE | VARCHAR2(100.0) | Y | ||
| ROBOT_DESCRIPTION | VARCHAR2(1000.0) | Y | ||
| ROBOT_HISTORY | VARCHAR2(1000.0) | Y | ||
| ROBOT_ENVIRONMENT | VARCHAR2(1000.0) | Y | ||
| MODIFIED_DATE | DATE | Y | ||
| MODIFIED_BY | VARCHAR2(50.0) | Y | ||
| INSERTION_DATE | DATE | N | sysdate |
| Constraint Name | Columns |
|---|---|
| SYS_C002087835 | ROBOT_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087832 | "ROBOT_NAME" IS NOT NULL |
| SYS_C002087833 | "ROBOT_USERAGENT" IS NOT NULL |
| SYS_C002087834 | "INSERTION_DATE" IS NOT NULL |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087835 | NORMAL | UNIQUE | ROBOT_ID |
| Table | Constraint |
|---|---|
| ROBOT_OWNERS | SYS_C002087837 |
| Name: ROBOTS_MODIFIED_DATE |
|---|
CREATE TRIGGER robots_modified_date before insert or update on robots for each row REFERENCING NEW AS NEW OLD AS OLD When new.modified_date is null begin :new.modified_date := SYSDATE; end; |