DIC_GENERIC_FILE_EXTENSION
Dictionary of file extensions of generic type, as related to files defined in the table MODEL_LOB_STORE_FILE. Egs: Drawing exchange file, Datafile, ESRI Shapefile etc.
| No. |
Column name |
Data type |
Notes |
| 1 |
EXTENSION_STRING |
Varchar(10) |
Primary key
|
| 2 |
EXTENSION_DESCRIPTION |
Varchar(50) |
|
| 3 |
DATA_STORAGE_TYPE_IND |
Char(1) |
|
| 4 |
GLOS_FILETYPE_CODE |
Varchar(2) |
|
| 5 |
STATUS |
Char(1) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 20 of 149)
| EXTENSION_STRING |
EXTENSION_DESCRIPTION |
DATA_STORAGE_TYPE_IND |
GLOS_FILETYPE_CODE |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| MID |
MIDI File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| MIDI |
MIDI File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| 3DM |
Rhino 3D Model |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| 3DMF |
QuickDraw 3D Metafile |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| INDD |
Adobe InDesign File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| PDF |
Portable Document Format File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| QXD |
QuarkXpress Document |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| QXP |
QuarkXpress 6 Project File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| AAC |
Advanced Audio Coding File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| AIF |
Audio Interchange File Format |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| IFF |
Interchange File Format |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| M3U |
Media Playlist File |
B |
OT |
C |
25-SEP-07 |
25-SEP-07 |
| DAT |
General Data |
A |
MS |
C |
01-SEP-03 |
|
| ME |
ReadMe |
A |
RE |
C |
01-SEP-03 |
|
| DXF |
Drawing exchange file |
A |
OT |
C |
01-SEP-03 |
|
| AVI |
Animation file |
B |
AV |
C |
07-NOV-03 |
|
| XML |
Extended Mark-up Language file |
A |
MS |
C |
11-NOV-03 |
08-NOV-05 |
| TIN |
Triangulation |
A |
TR |
C |
12-JAN-04 |
12-JAN-04 |
| SQL |
SQL Query Script |
A |
TX |
C |
12-JAN-04 |
26-SEP-07 |
| ASC |
ascii Data |
A |
OT |
C |
12-JAN-04 |
13-APR-04 |
