| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |
| Table : FileType |
See Also:
File
| Field Summary | ||
| Name | Type | Description |
|---|---|---|
| FileTypeID | Serial | |
| FileType | Name | |
| CreationDate | date | |
| CreatedBy | Person(PersonID) | |
| LastModificationDate | date | |
| LastModifiedBy | Person(PersonID) | |
| Sql Summary | |||||||
| Name | Type | PrKey | Unq | NotN | MUnq | Def | Idx1 |
|---|---|---|---|---|---|---|---|
| FileTypeID | int | |
|
|
|
|
|
| FileType | varchar(80) | |
|
|
|
|
|
| CreationDate | date | |
|
|
|
|
|
| CreatedBy | int | |
|
|
|
|
|
| LastModificationDate | date | |
|
|
|
|
|
| LastModifiedBy | int | |
|
|
|
|
|
| Foreign Keys | |||
| Field | Import | On Update | On Delete |
|---|---|---|---|
| CreatedBy | Person(PersonID) | NO ACTION | NO ACTION |
| LastModifiedBy | Person(PersonID) | NO ACTION | NO ACTION |
| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |