Model Answer A Survey
| Object Name | Object Type | Layer Name |
|---|---|---|
| GLBEXTR | TABLE | Default |
| GLVEXTR | VIEW | Default |
| GOBSRVR | TABLE | Default |
| GORSRVR | TABLE | Default |
| GUBSRVY | TABLE | Default |
| GURSRVQ | TABLE | Default |
| GURSVRL | TABLE | Default |
| SPRIDEN | TABLE | Default |
| SPRIDEN link | User Object | Default |

Table GLBEXTR
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GLBEXTR_APPLICATION | GLBEXTR_APPLICATION | VARCHAR2(30) | No | * | * |
| GLBEXTR_SELECTION | GLBEXTR_SELECTION | VARCHAR2(30) | No | * | * |
| GLBEXTR_CREATOR_ID | GLBEXTR_CREATOR_ID | VARCHAR2(30) | No | * | * |
| GLBEXTR_USER_ID | GLBEXTR_USER_ID | VARCHAR2(30) | No | * | |
| GLBEXTR_KEY | GLBEXTR_KEY | VARCHAR2(80) | No | * | |
| GLBEXTR_ACTIVITY_DATE | GLBEXTR_ACTIVITY_DATE | DATE | No | ||
| GLBEXTR_SYS_IND | GLBEXTR_SYS_IND | VARCHAR2(1) | No | ||
| GLBEXTR_SLCT_IND | GLBEXTR_SLCT_IND | VARCHAR2(1) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GLBEXTR_APPLICATION | GLBSLCT_APPLICATION | GLBSLCT |
| GLBEXTR_SELECTION | GLBSLCT_SELECTION | GLBSLCT |
| GLBEXTR_CREATOR_ID | GLBSLCT_CREATOR_ID | GLBSLCT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GLBEXTR | Unique | GLBEXTR_APPLICATION |
| PK_GLBEXTR | Unique | GLBEXTR_SELECTION |
| PK_GLBEXTR | Unique | GLBEXTR_CREATOR_ID |
| PK_GLBEXTR | Unique | GLBEXTR_USER_ID |
| PK_GLBEXTR | Unique | GLBEXTR_KEY |