|
DMONIX |
|
Table CUSTOMER |
| Info |
| Tablespace | DMDATA |
| Logging | YES |
| Temporary | N |
| Organization | HEAP |
| Comments |
| Columns |
| Name | Type | Nullable | Default | Comments |
| ID | NUMBER | N | ||
| NAME | VARCHAR2(512) | Y | ||
| ADDRESS | VARCHAR2(512) | Y | ||
| COUNTRY | VARCHAR2(512) | Y | ||
| EXPIREDATE | DATE | Y | SYSDATE+365 |
| Constraints |
| Name | Type | Column(s) | Referenced Constraint Name [Owner.Table.Constraint] |
| CUSTOMER_PK | PRIMARY KEY | ID | |
| oracle_internal_name | CHECK | ID |
| Indexes |
| Name | Column(s) | Uniqueness | Tablespace |
| CUSTOMER_PK | ID | UNIQUE | DMINDEX |