| 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
|