| EXTERNAL_KEY** |
VARCHAR (255) |
Yes* |
No |
ALCO_EXTERNAL_KEY.EXTERNAL_KEY |
External key - primary key |
| GUEST_EKEY |
VARCHAR (255)T |
No |
No |
ALCO_LICENSE.GUEST_ID |
The guest for which the license was issued. |
| LICENSE_TYPE_EKEY_EKEY |
VARCHAR (255) |
No |
No |
ALCO_LICENSE.LICENSE_TYPE_ID |
The type of license |
| ADDRESS_EKEY |
VARCHAR (255) |
No |
No |
ALCO_LICENSE.ADDRESS_ID |
The address of agency that issued the license. |
| LICENSE_NUMBER |
VARCHAR (255) |
Yes* |
No |
ALCO_LICENSE.LICENSE_NUMBER |
The license number |
| DETAIL |
VARCHAR (255) |
No |
No |
ALCO_LICENSE.DETAIL |
Additional details of the license |
| START_DATE |
DATETIME |
No |
No |
ALCO_LICENSE.START_DATE |
The start date for which the license is valid. |
| END_DATE |
DATETIME |
No |
No |
ALCO_LICENSE.END_DATE |
The end date for which the license is valid. |
| ACTIVE_STATUS |
SMALLINT |
Yes |
No |
ALCO_LICENSE.ACTIVE_STATUS |
The active status |