SCMUSER_USERGROUP

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

SCMUSEROID

NUMBER

F

No

USERGROUPOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMUSER_USERGROUP_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCMUSEROID

Identifier for the SCMUSER table.

For more information, refer to the description of the foreign key SCMUSER_USERGROUP_FK_2.

See also: SCMUSER_USERGROUP_FK_2.

Key NULL Column Type (Size)

F

No

SCMUSEROID

NUMBER

USERGROUPOID

Identifier for the USERGROUP table.

For more information, refer to the description of the foreign key SCMUSER_USERGROUP_FK_1.

See also: SCMUSER_USERGROUP_FK_1.

Key NULL Column Type (Size)

F

No

USERGROUPOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

SCMUSER_USERGROUP_PK

Yes

Yes

OID

SCMUSER_USERGROUP_FK_1

No

No

USERGROUPOID

USERGROUP

SCMUSER_USERGROUP_FK_2

No

No

SCMUSEROID

SCMUSER

Relationships

Referenced Tables

SCMUSER

Refer to the chapter SCMUSER for a detailed description of the table.

Foreign Key Referenced Column(s)

SCMUSER_USERGROUP_FK_2

OID
USERGROUP

Refer to the chapter USERGROUP for a detailed description of the table.

Foreign Key Referenced Column(s)

SCMUSER_USERGROUP_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

SCMUSER_USERGROUP_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMUSER_USERGROUP_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMUSER_USERGROUP_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMUSER_USERGROUP_SCMUSEROID_LABEL

English:

OID

French:

OID

German:

OID

SCMUSER_USERGROUP_USERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SCMUSER_USERGROUP_VERSION_LABEL

English:

Version

French:

Version

German:

Version