TEAM_MEMBER 
Logical Entity Name  TEAM_MEMBER 
Default Table Name  TEAM_MEMBER 
Physical Only  NO 
Do Not Generate  False 
Owner  BARD_CAP_PROD 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE BARD_CAP_PROD.TEAM_MEMBER(
     TEAM_MEMBER_ID        NUMBER(19, 0)     NOT NULL,
     TEAM_ID               NUMBER(19, 0)     NOT NULL,
     PERSON_ROLE_ID        NUMBER(19, 0)     NOT NULL,
     MEMBERSHIP_STATUS     VARCHAR2(20)      DEFAULT 'Active',
     VERSION               NUMBER(5, 0)      DEFAULT 0 NOT NULL,
     DATE_CREATED          DATE              DEFAULT sysdate,
     LAST_UPDATED          DATE,
     MODIFIED_BY           VARCHAR2(40),
     CONSTRAINT CK_TEAM_MEMBER_STATUS CHECK (Membership_Status IN ('Active', 'Suspended', 'Inactive')),
     CONSTRAINT PK_TEAM_MEMBER PRIMARY KEY (TEAM_MEMBER_ID)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE BARD_CAP_PROD
         LOGGING
         STORAGE(PCTINCREASE 0
                 BUFFER_POOL DEFAULT
                 ),
     CONSTRAINT FK_TEAM_MEMBER_MEMBER_ROLE FOREIGN KEY (PERSON_ROLE_ID)
     REFERENCES BARD_CAP_PROD.PERSON_ROLE(PERSON_ROLE_ID),
     CONSTRAINT FK_TEAM_MEMBER_TEAM FOREIGN KEY (TEAM_ID)
     REFERENCES BARD_CAP_PROD.TEAM(TEAM_ID)
)
PCTFREE 10
INITRANS 1
MAXTRANS 255
TABLESPACE BARD_CAP_PROD
LOGGING
STORAGE(PCTINCREASE 0
         BUFFER_POOL DEFAULT
         )
;



CREATE UNIQUE INDEX BARD_CAP_PROD.AK_TEAM_MEMBER ON BARD_CAP_PROD.TEAM_MEMBER(TEAM_ID, PERSON_ROLE_ID)
     PCTFREE 10
     INITRANS 2
     MAXTRANS 255
     TABLESPACE BARD_CAP_PROD
     LOGGING
     STORAGE(PCTINCREASE 0
             BUFFER_POOL DEFAULT
             )
;
 
PostSQL   

TEAM_MEMBER Columns 
ColumnName  Domain  Datatype  NULL  Definition 
TEAM_MEMBER_ID(PK)    NUMBER(19, 0)  NO 
 
TEAM_ID(FK)    NUMBER(19, 0)  NO 
 
PERSON_ROLE_ID(FK)    NUMBER(19, 0)  NO 
 
MEMBERSHIP_STATUS    VARCHAR2(20)  YES 
 
VERSION    NUMBER(5, 0)  NO 
 
DATE_CREATED    DATE  YES 
 
LAST_UPDATED    DATE  YES 
 
MODIFIED_BY    VARCHAR2(40)  YES 
 

TEAM_MEMBER Primary and Unique Keys 
Key Name  Key Type  Keys 
AK_TEAM_MEMBER  Index  TEAM_ID, PERSON_ROLE_ID 
PK_TEAM_MEMBER  PrimaryKey  TEAM_MEMBER_ID 

TEAM_MEMBER Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
PERSON_ROLE  Non-Identifying  One To Zero or More  FK_TEAM_MEMBER_MEMBER_ROLE      PERSON_ROLE_ID  NO  NO  NO 
TEAM  Non-Identifying  One To Zero or More  FK_TEAM_MEMBER_TEAM      TEAM_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

TEAM_MEMBER Check Constraints 
Check Constraint Name  CheckConstraint 

TEAM_MEMBER Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  BARD_CAP_PROD 
PctFree  10 
PCTUSED   0 
MinExtents  0 
MaxExtents  0 
Initial  0 
Next  0 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS  FreeLists 
FREELIST GROUPS  FreeList Groups 
Buffer Pool  DEFAULT 
Table Compression  NO 
Row Movement  Disabled 

TEAM_MEMBER Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

TEAM_MEMBER Security Types 
Name  Current Value 

TEAM_MEMBER Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
Does Not Exist 		 NO       
BARD - MySQL (MySQL)
Does Not Exist 		 NO       
BARD_Dev (Oracle)
TEAM_MEMBER 		 NO       
Current Production (Oracle)
BARD_CAP_PROD.TEAM_MEMBER 		 NO       

TEAM_MEMBER Where Used - Submodel Usage 
Model  Submodel Usage 
BARD_Dev (Oracle)  Main Model 
BARD_Dev (Oracle)  RI hierarchy 
BARD_Dev (Oracle)  Security 
Current Production (Oracle)  Main Model 
Current Production (Oracle)  Security