Editing Production.Document (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 171: | Line 171: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key for Document records. | + | | Primary key for Document records.PK_Document_DocumentID |
|- valign="top" | |- valign="top" | ||
| Title | | Title | ||
Line 177: | Line 177: | ||
| not null | | not null | ||
| | | | ||
− | | Title of the document. | + | | Title of the document. |
|- valign="top" | |- valign="top" | ||
| FileName | | FileName | ||
Line 183: | Line 183: | ||
| not null | | not null | ||
| | | | ||
− | | Directory path and file name of the | + | | Directory path and file name of the documentAK_Document_FileName_Revision |
|- valign="top" | |- valign="top" | ||
| FileExtension | | FileExtension | ||
Line 189: | Line 189: | ||
| not null | | not null | ||
| | | | ||
− | | File extension indicating the document type. For example, .doc or .txt. | + | | File extension indicating the document type. For example, .doc or .txt. |
|- valign="top" | |- valign="top" | ||
| Revision | | Revision | ||
Line 195: | Line 195: | ||
| not null | | not null | ||
| | | | ||
− | | Revision number of the document. | + | | Revision number of the document. AK_Document_FileName_Revision |
|- valign="top" | |- valign="top" | ||
| ChangeNumber | | ChangeNumber | ||
Line 201: | Line 201: | ||
| not null | | not null | ||
| (0) | | (0) | ||
− | | Engineering change approval number. | + | | Engineering change approval number. |
|- valign="top" | |- valign="top" | ||
| Status | | Status | ||
Line 207: | Line 207: | ||
| not null | | not null | ||
| | | | ||
− | | 1 = Pending approval, 2 = Approved, 3 = Obsolete | + | | 1 = Pending approval, 2 = Approved, 3 = Obsolete |
|- valign="top" | |- valign="top" | ||
| DocumentSummary | | DocumentSummary | ||
Line 213: | Line 213: | ||
| null | | null | ||
| | | | ||
− | | Document abstract. | + | | Document abstract. |
|- valign="top" | |- valign="top" | ||
| Document | | Document | ||
Line 219: | Line 219: | ||
| null | | null | ||
| | | | ||
− | | Complete document. | + | | Complete document. |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 225: | Line 225: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated. |
|} | |} | ||