OrganizationalPerson
Contains organizational details about a user, such as employee number, department, manager, job title, office address, and more. This class is commonly used for directory information systems.
Table Specific Information
Select
All columns support server-side processing for the operators =, >= , <=, !=, LIKE, AND, and OR. Other filters are executed client side within the 本製品. For example, the following query is processed by LDAP:
SELECT * FROM OrganizationalPerson WHERE CN != 'NewUser' AND BaseDN = 'CN=Users,DC=MyDC' LIMIT 5
Insert
To add a OrganizationalPerson, all fields can be specified except Id, DN, and BaseDN. Required fields that should be provided are RDN and ObjectClass. For example:
INSERT INTO OrganizationalPerson (RDN, ObjectClass) VALUES ('CN=NewUser', 'top;person;organizationalPerson;user;inetOrgPerson')
Update
All columns except Id, DN, and BaseDN can be updated by providing the Id in the WHERE clause. For example:
UPDATE OrganizationalPerson SET Description = 'desc' WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Delete
OrganizationalPersons can be deleted by providing the Id of the OrganizationalPerson in a DELETE statement. For example:
DELETE FROM OrganizationalPerson WHERE Id = '1|CN=NewUser,CN=Users,DC=MyDC'
Columns
| Name | Type | ReadOnly | References | DataFormat | Description |
| Id [KEY] | String | True |
A combined index and Distinguished Name (DN). Multiple indices are allowed if the column is set to 'SplitDataByRow'. | ||
| DN | String | True |
The full Distinguished Name (DN) representing the unique LDAP path of the object. | ||
| RDN | String | False |
The Relative Distinguished Name (RDN), which is the unique portion of the DN within its parent container. | ||
| BaseDN | String | True |
The base Distinguished Name (BaseDN) that specifies the starting point for LDAP operations. | ||
| ObjectClass | String | False | DelimitedData |
The hierarchical list of LDAP object classes from which this object is derived. | |
| SN | String | False | DelimitedData |
Contains the user's surname or family name, such as 'Smith'. | |
| CN | String | False | DelimitedData |
Represents the common name of the object, used in LDAP searches. For example, 'John Doe'. | |
| UserPassword | String | False | DelimitedData |
Stores the user's password in UTF-8 format. This is a write-only attribute and cannot be retrieved for security reasons. | |
| TelephoneNumber | String | False | DelimitedData |
The primary telephone number associated with the user or object. | |
| SeeAlso | String | False | DelimitedData |
A list of Distinguished Names (DNs) that are related or linked to this object. | |
| Description | String | False | DelimitedData |
Contains a textual description of the object. It is typically single-valued but may be multi-valued depending on LDAP schema settings. | |
| Title | String | False | DelimitedData |
The user's formal job title, such as 'Senior Programmer', rather than occupational class, such as programmer. It does not include suffix titles like 'Esq.' or 'DDS'. | |
| X121Address | String | False | DelimitedData |
Specifies the X.121 address associated with the object, often used in telecommunications. | |
| RegisteredAddress | String | False | DelimitedData |
A mnemonic address associated with the object, registered in the relevant country or region for Public Telegram Service. | |
| DestinationIndicator | String | False | DelimitedData |
Part of the X.500 specification but not used in NTDS. | |
| PreferredDeliveryMethod | String | False | DelimitedData |
Defines the preferred method of delivery for communication with this object, as specified by the X.500 standard. | |
| TelexNumber | String | False | DelimitedData |
A list of alternate telex numbers associated with the object. | |
| TeletexTerminalIdentifier | String | False | DelimitedData |
Specifies the Teletex terminal identifier and optional parameters for a teletex terminal linked to the object. | |
| InternationalISDNNumber | String | False | DelimitedData |
Specifies an International ISDN (Integrated Services Digital Network) number associated with the object. | |
| FacsimileTelephoneNumber | String | False | DelimitedData |
Contains the fax machine telephone number associated with the user or organization. | |
| Street | String | False | DelimitedData |
Specifies the street address for the user or object. | |
| PostOfficeBox | String | False | DelimitedData |
Specifies the post office box number associated with the object. | |
| PostalCode | String | False | DelimitedData |
The postal or ZIP code used for mail delivery to the object. | |
| PostalAddress | String | False | DelimitedData |
The complete mailing address associated with the object. | |
| PhysicalDeliveryOfficeName | String | False | DelimitedData |
Specifies the office location within the user's place of business. | |
| OU | String | False | DelimitedData |
The name of the Organizational Unit (OU) to which the object belongs. | |
| ST | String | False | DelimitedData |
The name of the state or province associated with the user or object. | |
| L | String | False | DelimitedData |
Represents the name of a locality, such as a town or city, associated with the object. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Filter | String |
Defines an explicit LDAP filter, overriding other filters defined in the WHERE clause of the query. |