common.card_connect_merchant_devices_map
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| ccmdm_id | int(11) | NO | PRI | auto_increment | Primary key | |
| ccmdm_cus_id | int(11) | NO | MUL | Customer ID | ||
| ccmdm_cli_id | int(11) | NO | MUL | Client ID | ||
| ccmdm_ccma_id | int(11) | NO | MUL | Refers to parent merchant | ||
| ccmdm_name | varchar(120) | NO | Device Name | |||
| ccmdm_hsn_number | varchar(30) | YES | 0 | Unique identifier for card reader device | ||
| ccmdm_loc_id | int(11) | NO | Location ID | |||
| ccmdm_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| ccmdm_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|