AUTHOR |
Logical Entity Name | Author |
Default Table Name | AUTHOR |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | PUBL |
Definition | Person: External and internal person using the ORNL ExperimentalFacilites systems. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE PUBL.AUTHOR(      AUTHOR_ID       NUMBER(38, 0)      NOT NULL,      LAST_NM         VARCHAR2(120),      FIRST_INIT      CHAR(1),      MID_INIT        CHAR(1),      THIRD_INIT      CHAR(1),      FIRST_NM        VARCHAR2(64),      ALIAS           VARCHAR2(120),      EMAIL_ADDR      VARCHAR2(100),      CNTRY_ID        VARCHAR2(10),      INST_ID         NUMBER(38, 0),      RESEARCH_ID     VARCHAR2(20),      ORCID_ID        VARCHAR2(255),      PERSON_ID       VARCHAR2(10),      CMNT            VARCHAR2(2000),      HFIR_IND        CHAR(1)            DEFAULT 'N' NOT NULL,      SNS_IND         CHAR(1)            DEFAULT 'N' NOT NULL,      NSCD_DIV_ID     VARCHAR2(10),      CONSTRAINT PK_AUTHOR PRIMARY KEY (AUTHOR_ID)      USING INDEX          LOGGING,      CONSTRAINT FK_AUTHOR_TO_PERSON FOREIGN KEY (PERSON_ID)      REFERENCES XF_ADMIN.PERSON(PERSON_ID) ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
AUTHOR Columns |
ColumnName | Domain | Datatype | NULL | Definition |
AUTHOR_ID | Identifier | NUMBER(38, 0) | NO | Person Identifier: Unique identifier for a person derived from XCAMS. |
LAST_NM | Name | VARCHAR2(120) | YES | Last Name: person last name. |
FIRST_INIT | CHAR(1) | YES | ||
MID_INIT | CHAR(1) | YES | ||
THIRD_INIT | CHAR(1) | YES | ||
FIRST_NM | VARCHAR2(64) | YES | First Name: Person first name. |
|
ALIAS | Name | VARCHAR2(120) | YES | Alias: Person sometimes publish under a name different than their legal name. |
EMAIL_ADDR | VARCHAR2(100) | YES | Email Address: Person email address. |
|
CNTRY_ID | VARCHAR2(10) | YES | Country Identifier: Abbreviated identrifier for a country. |
|
INST_ID | NUMBER(38, 0) | YES | Institute Identifer: Abbreviated identifier for a institute. |
|
RESEARCH_ID | Identifier | VARCHAR2(20) | YES | ResearcherID: A unique identifier assinged by Thomson Reuters to enable researchers to manage their publication lists, track their times cited counts and h-index, identify potential collaborators and avoid author misidentification. In addition, your ResearcherID information integrates with the Web of Science and is ORCID compliant, allowing you to claim and showcase your publications from a single one account. |
ORCID_ID | URI | VARCHAR2(255) | YES | ORCID Id: The ORCID iD is a URI with a 16-digit number that is compatible with the ISO Standard (ISO 27729), also known as the International Standard Name Identifier (ISNI). Initially ORCID iDs will be randomly assigned by the ORCID Registry from a block of numbers that will not conflict with ISNI-formatted numbers assigned in other ways. ORCID iDs always need all 16-digits; they can not be shortened to remove leading zeros if they exist. |
PERSON_ID | VARCHAR2(10) | YES | Person Identifier: Unique identifier for a person derived from XCAMS. |
|
CMNT | Comment | VARCHAR2(2000) | YES | Comment: General comments. |
HFIR_IND | Indicator | CHAR(1) | NO | |
SNS_IND | Indicator | CHAR(1) | NO | |
NSCD_DIV_ID | Identifier | VARCHAR2(10) | YES |
AUTHOR Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_AUTHOR | PrimaryKey | AUTHOR_ID |
AUTHOR Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
PERSON | Non-Identifying | Zero or One to Zero or More | FK_AUTHOR_TO_PERSON | PERSON_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
PUB_AUTHOR_ASSC | Identifying | One To Zero or More | FK_PUBL_AUTHOR_TO_AUTHOR | NO | NO | NO |
AUTHOR Check Constraints |
Check Constraint Name | CheckConstraint |
AUTHOR Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
AUTHOR Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
AUTHOR Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
AUTHOR Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
SIS_DEV | Role | DELETE | Grant | NO | NO |
SIS_DEV | Role | INSERT | Grant | NO | NO |
SIS_DEV | Role | SELECT | Grant | NO | NO |
SIS_DEV | Role | UPDATE | Grant | NO | NO |
AUTHOR Security Types |
Name | Current Value |
AUTHOR Bound Attachments |
Name | Current Value |
AUTHOR Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical PUBL.Author |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) PUBL.AUTHOR |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
AUTHOR Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Publication |
PUBL (Oracle) | Main Model |
AUTHOR Data Movement Rules |
Name | Type | Rule Text/Value |