PPPL_Control

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int identity 4 √ null
PPPL_InvoiceDetail.file_id FK_PPPL_InvoiceDetail_file_idR
PPPL_Unbilled.file_id FK_PPPL_Unbilled_file_idR
VW_PPPL_InvoiceDetail.file_id Implied ConstraintR
file_name varchar 200 null
file_path varchar 500 null
file_type varchar 50 null
retrieval_date datetime2 16,3 (getdate())
load_date datetime2 16,3 √ null
row_count int 4 √ null
file_asof_date date 6 √ null
file_target_inv_date date 6 √ null
file_invoice_yearmon int 4 √ null
error_msg varchar 1000 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_PPPL_Control Primary key Asc file_id

Relationships

Close relationships within degrees of separation