INSPECTION_TEAM

267 rows


Description

This is a table for Inspection with Team. Stores wich Team makes the Inspection.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
INSPECTION_TEAM_ID NUMBER 18 null

Field Inspection Team ID. Stores primary key for this table.

INSPECTION_ID NUMBER 18 null
INSPECTION.INSPECTION_ID INSPECTION_TEAM_INSPECTIO_FK1R

Field Inspection ID. Stores foreign key to table inspection.

TEAM_ID NUMBER 18 null
TEAM.TEAM_ID Implied ConstraintR

Field Team ID. Stores foreign key to table team.

VERSION_ID NUMBER 18 0

Field Version. Stores the version of the record.

CUSER VARCHAR2 75 null

Field Create User. Stores who create the record.

CDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Create Date. Stores when the record was created.

MUSER VARCHAR2 75 null

Field Modified User. Stores who modified the record.

MDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Modified Date. Stores when the record was modified.

Indexes

Constraint Name Type Sort Column(s)
INSPECTION_TEAM_PK Primary key Asc INSPECTION_TEAM_ID

Relationships