DEVICE
Groups
DEVICE
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Â | Primary key |
2 | ASSIGNED_TO_SERVICE_ID | NUMBER | 22 | Y | Â | Â |
3 | STATUS_ID | NUMBER | 22 | Y | Â | Â |
4 | CREATE_DATE | DATE | 7 | Y | Â | Â |
5 | RESERV_TO_DATE | DATE | 7 | Y | Â | Â |
6 | COMMENTS | VARCHAR2 | 2000 | Y | Â | Â |
7 | USERCLIENT | VARCHAR2 | 400 | Y | Â | Â |
8 | DEVICE_IDENTIFIER | VARCHAR2 | 200 | Y | Â | Â |
9 | DESCRIPTION | VARCHAR2 | 800 | Y | Â | Â |
10 | CODE | VARCHAR2 | 20 | Y | Â | Â |
11 | STATUS | NUMBER | 22 | Y | Â | Â |
12 | DEVICE_TYPE_ID | NUMBER | 22 | Y | Â | Â |
13 | BRAND_ID | NUMBER | 22 | Y | Â | Â |
Â
Â