| Name | SDS_Account |
|---|---|
| Entity Type | External |
| Description | Records all SDS database accounts |
| Submodel | System |
| Entity Scope | System |
| Primary Key | Account |
| Natural Key | Account |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Account | ORACLE_OBJECT_NAME | NA |
The identifier of the account, used as a login string to connect to a Seabed database. | Yes |
VARCHAR2(30) |
| Auto_GUID | boolean | NA |
A boolean flag that indicates if this account (Project) has GUIDs (Globally Unique IDentifiers) automatically generated. Acceptable values for this column are: FALSE (0) - GUID columns in a project are NOT generated automatically; and TRUE (1) - GUID columns in a project ARE generated automatically with the value from the Oracle function SYS_GUID(). | No 0 |
NUMBER(1) |
| Build | int | No_Unit |
SDS Build number | No |
NUMBER(10) |
| Coordinate_System | STRING64 | NA |
Name of the default coordinate system for this account | No |
VARCHAR2(64) |
| Create_Date | DATE | NA |
Date/Time the Account was created | No |
DATE |
| Default_Tablespace | ORACLE_OBJECT_NAME | NA |
Default tablespace for the account | No |
VARCHAR2(30) |
| Description | STRING2000 | NA |
Description of the account. | No |
VARCHAR2(2000) |
| Model_Version | STRING64 | NA |
The version of the Seabed model for this account. | No |
VARCHAR2(64) |
| Modify_Date | DATE | NA |
Date/Time the Account was last modified | No |
DATE |
| Owner | ORACLE_OBJECT_NAME | NA |
User who created the Account | No |
VARCHAR2(30) |
| Scope | ORACLE_OBJECT_NAME | NA |
A Project has a Scope of a Data Dictionary (DD). A Staging area has the scope of a DD or Project. | No |
VARCHAR2(30) |
| Security_Configuration | ORACLE_OBJECT_NAME | NA |
Name of the security configuration used when creating this account | No |
VARCHAR2(30) |
| Status | ORACLE_OBJECT_NAME | NA |
Current status of the account | No |
VARCHAR2(30) |
| Storage_Configuration | ORACLE_OBJECT_NAME | NA |
Name of the storage configuration used when creating this account | No |
VARCHAR2(30) |
| Temporary_Tablespace | ORACLE_OBJECT_NAME | NA |
Temporary tablespace for the account | No |
VARCHAR2(30) |
| Type | DB_TYPE_CODE | NA |
Type of account: DD, Project, Staging, Interface, User. | Yes |
VARCHAR2(10) |
| Unit_System | ORACLE_OBJECT_NAME | NA |
Default display unit system for the account | No |
VARCHAR2(30) |
| Version | int | No_Unit |
SDS Version number | No |
NUMBER(10) |
| Vertical_Reference | STRING64 | NA |
Name of the vertical reference. Used for project accounts | No |
VARCHAR2(64) |